•1 min read•from 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.
[link] [comments]
Want to read more?
Check out the full article on the original site
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