Forum Discussion
Mighty_Al
Oct 26, 2023Copper Contributor
Input based on multiple conditions
Hello,
I'm trying to sort a large data set to based on city, race, and year. so far I've been using =IF($C2=J$2,$E2,NA()) to do so. but I'm adding other races within the data set so the values position would change. Also, some of the races aren't counted for a year or 2 in some cities. any idea how to have excel basically auto sort them?
This is what my sheet currently looks like:
- Good data for a pivot table I would say!
- JKPieterseSilver ContributorGood data for a pivot table I would say!
- Mighty_AlCopper Contributor
JKPieterse I'm embarrassed that I haven't thought of that. Thank you!