Hi Deanoz,
Welcome to the forum.
This is achievable using combination of few functions in array formula, please upload a sample workbook. Thanks.
Regards,
DILIPandey
<click on below 'star' if this helps>
Hi Deanoz,
Welcome to the forum.
This is achievable using combination of few functions in array formula, please upload a sample workbook. Thanks.
Regards,
DILIPandey
<click on below 'star' if this helps>
DILIPandey, Excel rMVP
+919810929744 (India), +971528225509 (Dubai), dilipandey@gmail.com
File attatched
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks