•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?
Our take
To efficiently identify the top four individuals who responded "yes" from your list of 80 names, you can leverage a formula that combines filtering and ranking by seniority. Start by filtering the names based on the checkbox in column F, indicating a "yes" response. Then, apply a formula that begins at person 78 and cycles back to the top, ensuring seniority is considered.
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]
Read on the original site
Open the publisher's page for the full experience
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