Hello, I'm trying to figure out a function that counts how many times a string appears in an array. Any ideas?
An example is in the array below; "2" appears three times. The function would search for "2" and output three.
112
211
12
111
Regards,
Mike
Hi,
Welcome to the forum.
Do you want to search for specific strings or alphabets in the array elements?
If my assistance has helped, there is a reputation icon * on the left hand corner below the post - you can show your appreciation to the user who has helped in resolving your requirement.
If your requirement has been solved please mark your thread as Solved.
In the menu bar above the very first post, select Thread Tools, then select "Mark this thread as Solved".
Kindly use [FORMULA] or [CODE] tags when posting your code.
Regards,
Sarang
A specific string of numbers within a larger number. The larger number will have random trailing and leading numbers.Originally Posted by Saarang84
With your given example.
Assuming that your numbers are in the range A2:A5, then try this Array Formula. Since this is an array formula so you need to confirm this with Ctrl + Shift + Enter instead of just Enter. (i.e. Select the cell where you want to put this formula --> press F2 --> paste the formula in the cell --> now hold down the Ctrl+Shift and then press Enter)
Does this help?
Please Login or Register to view this content.
Regards
sktneer
Treat people the way you want to be treated. Talk to people the way you want to be talked to.
Respect is earned NOT given.
Can u post a workbook with sample data, showing your input and the output you want to get?
That's it. Thanks!With your given example.
Assuming that your numbers are in the range A2:A5, then try this Array Formula. Since this is an array formula so you need to confirm this with Ctrl + Shift + Enter instead of just Enter. (i.e. Select the cell where you want to put this formula --> press F2 --> paste the formula in the cell --> now hold down the Ctrl+Shift and then press Enter)
Does this help?Please Login or Register to view this content.
You're welcome. Thanks for the feedback.
Since you are new to the forum, so just to tell you that, if that takes care of your question, please mark your thread as solved by selecting Thread Tools (just above your first post) --> Mark thread as solved.
Moreover you may also click on * (star) to Add Reputation to those who have put their time and efforts to help you in this forum. This is another way to say thanks to them.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks