LinkBack URL
About LinkBacks
Thanks!
A2, copied across and down:
=IFERROR(INDEX(Sheet1!A:A,AGGREGATE(15,6,ROW(Sheet1!$C$2:$C$270)/((COUNTIF(Sheet2!$C$1:$C1,Sheet1!$C$2:$C$270)=0)),1)),"")
Thanks!
A2, copied across and down:
=IFERROR(INDEX(Sheet1!A:A,AGGREGATE(15,6,ROW(Sheet1!$C$2:$C$270)/((COUNTIF(Sheet2!$C$1:$C1,Sheet1!$C$2:$C$270)=0)),1)),"")
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU
Dear Glenn;
Thanks for the wonderful work this formula is working 80% fine but it's missing values like mentioned below district formula just shows the " Hassan BiBi" rest 3 of entries got
missed out and this goes for other districts as well. Can you please update the formula so that it could display all unique entries?
Day District Facility Name
Dec-21 Sheikhan Hassan BiBi
Jan-22 Sheikhan FP Ibrahim
Jan-22 Sheikhan FP Shafia
Jan-22 Sheikhan Shazia
I must say you solve the maximum problem which I was facing for the last 3 days :S
waiting for your positive reply
Best
Jibran
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks