Hi All,
I have a worksheet where I want to keep duplicate entries and compare all duplicate entries.
all entries are in Column A. I have it set with conditional formatting so when I type in a new entry it highlights the duplicate red (the default color). then I can manually use the filter to search for the entry and compare both rows side by side.
but if I have several duplicates instead of filtering through each one at a time I would to select a group of duplicates and do one filter for all duplicates.
I left two images in the attachments
first image: column A, all the red entries are duplicates.
Second image: I filtered one of the entries (row 9981) to compare with the duplicate (which was in row # 7754)
but what if I select a group of duplicates (lets says from row 9981 to row 9985), is there anyway I can filter groups of duplicat6e entries instead of one by one.
I tried searching google, but I think I don't have the terminology right and cant seem to find what I need.
thanks
Eric Hansen100.jpg200.jpg
Bookmarks