•1 min read•from Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community
Find a cell with the same 3 first characters and return the row number
Lets say I have a list of codes in a column, I want to find the row number of the code that star with ALB, for example.
I tried to use MATCH and LEFT but im not sure how to make the fuction MATCH just check the first few characters, instead of the exact value.
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#rows.com