Open the Grade Verification Grade & % No Match and Highlight the Percent Column
2
Click on Decrease decimal places
3
Right click on Percent Column Heading & select Copy
4
Right click on Percent Column Heading & select Paste Special > Values
5
In the first empty column type in the formula =E2-F2 (Percent - Grade)
6
Copy down the whole column
7
Turn on the filter
8
Click on extract (56)…
9
Uncheck 0 & -1
10
The only ones remaining have a mismatch between grade and percent
Well done!
Create how-to guides like this in a snap. Get Tango now.
Press space bar to start a drag.
When dragging you can use the arrow keys to move the item around and escape to cancel.
Some screen readers may require you to be in focus mode or to use your pass through key