About 5 months ago, I posted a mini-article entiteled "Improving the InStr Function". Here is the link to that article (which I also posted to some Excel groups as well)... https://lnkd.in/eCAnVKXR ...

When you want to aggregate values in a table where a single field contains multiple values, you can use the InStr function in a select query to separate them, and then perform aggregation using an ...

The INSTR function searches for the first occurence of a search STRING within a base string and returns the position it was found. The start% position had to be at ...

VBAを使っていると、「あのコード、また書くのか…」という場面はよくあります。 本記事では、私が実務や趣味で繰り返し使っている便利コードを、備忘録＋コピペ用としてまとめました。 使用頻度の高いものは★5、ほとんど使わないけど覚えておくと ...