Hi all,
I have the following data:
See attached xlsx...
As you can see I am trying to show the top 3 accounts that have the highest number of staff (note the duplicate value of 20 for rows 4 and 8), and IF the account is active.
I have tried many different methods of doing this, index/match/large/if..............Large(filter(if......... (CSE formulas), but I'm just not getting the desried results.
Any help would be extremely welcome...
Regards,
MBP
Last edited by Matt BP; 05-27-2021 at 10:13 AM.
Hello Matt BP. Welcome to the forum.
Please attach the workbook that pasted copy comes from. It saves retyping data you already have. The instructions for doing so are in a gold banner at the top of each page here.
Dave
Thanks for the welcome..., xlsx uploaded!!!
Last edited by Matt BP; 05-27-2021 at 10:22 AM.
Pls Select F2:F5 area, array formula
HTML Code:
Last edited by wk9128; 05-27-2021 at 11:31 AM.
Another optionFormula:
Please Login or Register to view this content.
Works perfectly - many thanks to you...Originally Posted by wk9128
Works perfectly - many thanks to you...Another optionFormula:Please Login or Register to view this content.
You're Welcome. Thank You for the feedback and for marking the thread as 'Solved'.
Glad to help & thanks for the feedback
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks