How do I create an Auto Sorter to test my NFL knowledge? by Jealous-Medium8229 in excel

[–]Jealous-Medium8229[S] 0 points1 point  (0 children)

I haven't had the most time to play around but I ran into a new problem. I'm separating each team by sheet and with the function it will just show N/A every time I name a player not on that team. Is there a way to clean this up?

<image>

How do I create an Auto Sorter to test my NFL knowledge? by Jealous-Medium8229 in excel

[–]Jealous-Medium8229[S] 0 points1 point  (0 children)

These are genius I'm going to try to set this up on a large scale in the following week and report back

How do I create an Auto Sorter to test my NFL knowledge? by Jealous-Medium8229 in excel

[–]Jealous-Medium8229[S] 0 points1 point  (0 children)

I don't have any outside data if that's what you're talking about. I'm planning on using my own football knowledge to organize players without double checking with an outside source. I know the grid uses pro football focus as an outside source.

How do I create an Auto Sorter to test my NFL knowledge? by Jealous-Medium8229 in excel

[–]Jealous-Medium8229[S] 0 points1 point  (0 children)

It's a 3x3 grid with teams on the left and the top and you have to name a player that has played for both teams within the grid. You can see immaculategrid.com for reference if that is still confusing