Hi! I have a slightly strange request and it’s been a long time since I’ve really got deep into Excel formulae. Although this is specifically for Google Sheets so hopefully it’s possible on that too.
So I have a list of people and dates that will be added to from time to time. Once a persons name has appeared 3+ times it will appear in another sheet and has to be at the bottom of that sheet.
I’ve done this using Pivot Tables but that auto sorts alpabetially. It’s essential once someone has completed three courses that their name appears at the bottom.
Hope this makes sense!
So I have a list of people and dates that will be added to from time to time. Once a persons name has appeared 3+ times it will appear in another sheet and has to be at the bottom of that sheet.
I’ve done this using Pivot Tables but that auto sorts alpabetially. It’s essential once someone has completed three courses that their name appears at the bottom.
Hope this makes sense!
