Array Formula for multiple criteria
I am setting up a work form and want to use an array forumla to match a column of the page and show it only once (when duplicates).
I enclosed an example. I want to match the work code based on two criteria and show the unique matches.
Thanks for the help
Work Code Array.xlsx
Hi,
Array formula in I4 and copy down:
=IFERROR(INDEX($C$2:$C$15,SMALL(IF(FREQUENCY(MATCH($C$2:$C$15,$C$2:$C$15,0),ROW($C$2:$C$15)-MIN(ROW($C$2:$C$15))+1),ROW($C$2:$C$15)-MIN(ROW($C$2:$C$15))+1),ROWS($1:1))),"")
Regards
I appreciate it sir. That worked great.
A quick follow up sir, this formula gives me the total for all divisions and ranks. What if I want to limit the results to one division and one rank? All "West" Division ranks?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks