Removing duplicate rows from a report
I'd like to create a report from a sheet that has many duplicate rows. The point of the report is to list one example of every inventory item we have (some items we have singles, other items we have many). I'm already using a helper column "Duplicate Helper" with the following formula for another purpose:
=IF(COUNTIF([Full description]:[Full description], [Full description]@row) > 1, 1)
Is there another formula I should add in a separate column that indicates that it is the one from the many that needs to be pulled into the report?
I hope that makes sense! Thanks in advance!!!
Help Article Resources
Check out the Formula Handbook template!