How do i extract duplicate data rows. For instance, rows 5 and 16 have the same date/amount/name. My ultimate purpose is to delete any duplicate rows from my spreadsheet (excluding the original data). Any help is appreciated.
Create a formula that concatenates the data you need to compare
say for example that column a, b, c are what you are looking at create formula
So say column E is empty put this formula and copy it down
Then do a formula in column F
copy that formula down
now whereever you have a count greater than 1 is duplicates.