Hi,
I have a list of students (by ID#) with Ds,D+, and Fs. I need a formula to organize them into 3 categories: Only 1 D or D+, >1D or D+, 1 or more Fs. Students can only be in one of the categories and I need their student ID returned.
Since I work mostly in Google Sheets, I was able to get the right formulas but for security reasons I need to move it over to Excel. And I just realized Excel and Sheets formulas are not all from the same world.
Any help would be much appreciated!
attaching a sample
Bookmarks