Forum Discussion
How to remove rows with single value (multiple value remains)
Greetings! I need to remove students who only have 1 failing grade...and leave those students with 2 or more failing grades. The last name & first name fields will show the duplicate names and can be...
MsV213 I would suggest not to remove data but just filter out what you don't want to see. If you are on a recent Excel version it perhaps supports the UNIQUE and FILTER functions. If not, a Pivot Table could do what you want. You'll find working examples for both in the attached workbook.
Brilliant!!! It's amazing how you overthink when you face a new challenge...but always good to be reminded of features to use in tough situations. Thanks so much for responding and providing the workbook to backup the tip you shared!!! I'm on my way!!!! I'm very grateful!!!