Hi all
I was helped previosuly with this array formula:
=IFERROR(IFERROR(IFERROR(INDEX(Data!$O$6:$O$187, MATCH(0, COUNTIF($C$4:C4, Data!$O$6:$O$187), 0)), INDEX('Data 2'!$M$19:$M$7259, MATCH(0, COUNTIF($C$4:C4, 'Data 2'!$M$19:$M$7259), 0))),INDEX('Data 2'!$N$19:$N$7259,MATCH(0,COUNTIF($C$4:C4,'Data 2'!$N$19:$N$7259),0))),"")
What it does is look in 3 data sources and returns a unique list to the Summary sheet.
I now need to add a 4th list to the above for the range H2:H316 on the sheet “Data 3”
How do I do this? I have tried without success
Paul
Bookmarks