•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
Our take
If you're looking to find the row number of a code that starts with specific characters, such as "ALB," you're on the right track with functions like MATCH and LEFT. However, to ensure MATCH checks only the first three characters, you can combine these functions effectively. This approach streamlines your search, allowing you to pinpoint the desired code without needing an exact match. By mastering this technique, you can enhance your data management process and unlock greater productivity in your spreadsheet tasks.
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]
Read on the original site
Open the publisher's page for the full experience