hello I have Functions and need search about people who work in table Q "office a" and Who in table D "working" ( DATA!D$2:D$495="WORKING" )
with my Functions
=IFERROR(INDEX(DATA!B:B,SMALL(IF(DATA!Q$2:Q$495="OFFICE A",ROW(DATA!Q$2:Q$495)),ROWS(B$4:B4))),"")
Please could someone help me out? Thank you very much.
Try like
=IFERROR(INDEX(data!B:B,SMALL(IF((data!Q$2:Q$495="OFFICE A")*(data!D$2:D$495="WORKING"),ROW(data!Q$2:Q$495)),ROWS(B$4:B4))),"")
This is an array formula confirm with Ctrl+Shift+Enter
Samba
Say thanks to those who have helped you by clicking Add Reputation star.
Thank you nflsales this works perfect. worked perfectly. Thanks so much!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks