05-07-2022, 12:26 PM
If people thing Declan is a nerd for sorting an excel list then I'm getting quiet about what I do.
...
...
...
I also use excel, but have the questions in Column A, my answers in Column B, use a formula to take the first letter of the answer and put it in Column C, and then I have A-Z running down Column D and a conditional format to highlight the unique letters that haven't been used yet...
...
...
...
I also use excel, but have the questions in Column A, my answers in Column B, use a formula to take the first letter of the answer and put it in Column C, and then I have A-Z running down Column D and a conditional format to highlight the unique letters that haven't been used yet...