1 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

How to return top X number of names who said yes?

I have a list of 80 names. I asked them if they wanted to do something and I have a checkbox next to their name that I check if they say yes, but I might only need 4 people that day.

Right now I have a filter function to return everyone who said yes, but I need it to only return top 4 names. It's also by seniority and I need it to say start at person 78 and circle back around to the top.

So this examples return would look like

Person 78

Person 79

Person 80

Person 1

Each name has a corresponding number for their seniority next to their name also, for use.

Also for reference seniority number is in column B, person name is in column D, and checkbox is in column F.

submitted by /u/taintosaurus_rex
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article

Tagged with

#Excel alternatives for data analysis
#natural language processing for spreadsheets
#generative AI for data analysis
#rows.com
#Excel compatibility
#Excel alternatives
#checkbox
#person
#said yes
#names
#seniority
#filter function
#top 4
#seniority number
#return
#list
#column B
#column D
#column F
#selection