Actual worksheet has 12 Data sheets and 1 Results sheet, in this example I have used only one Data sheet & Results, I show what are the results that I expect and few of the formulas that I have tried, ALL failed
Each Data sheet has two corresponding ranges, F3:AN16 and BF3:CN16, column F corresponds to BF, column G corresponds to BG and ends with column AN corresponding to CN.
Using excel 2019, formula to create a dynamic list of names from F3:AN16, based on corresponding cells in BF3:CN16 which have formulas that have NO VALUE, ie, it is blank.
Example:
O3 & BO3 are corresponding cells and BO3 is blank (Each corresponding cell is on the same row)
P6 & BP6 are corresponding cells and BP6 is blank
so both would be included in the new list in Results!D5:D20
I don't mind creating 12 different lists and then manually combining them, if we cannot have all lists from all 12 Data sheets cannot be created in one list.
Any help is very much appreciated.
RJK
Bookmarks