Hi all,
I have been working on this logic and I know it's very much doable using FILTER and INDEX commands but I am unable to get a smart logic. Please check my screen shot below.
Clipboard01.jpg
I am looking to extract values of checked items, as per the numbers assigned to each and put those in another cell. [Red box is the solution I am looking for].
Any help will be appreciated. Thanks in advance.
Cheers,
XL Programmer
Bookmarks