Please see attached worksheet. For each "nth" instance of a particular text string appearing in a range (a column), I'd like to return the value of the cell to it's left (in the same row).
Please see attached worksheet. For each "nth" instance of a particular text string appearing in a range (a column), I'd like to return the value of the cell to it's left (in the same row).
Hi excelroofing,
Welcome to the forum.
Try using below array formula:-
Formula:Please Login or Register to view this content.
Spreadsheet Problem.xlsx
Regards,
DILIPandey
<click on below 'star' if this helps>
DILIPandey, Excel rMVP
+919810929744 (India), +971528225509 (Dubai), [email protected]
That worked great, thanks!
you are welcome excelroofing... Cheers
Suggest you to mark this thread as SOLVED.. thanks.
Regards,
DILIPandey
<click on below 'star' if this helps>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks