Hello,
I have a giant payroll sheet I need to filter. It lists every paycheck for every employee within a calendar year. So it has over a million rows. It also has three columns for names, last, first and middle initial. I need to create a formula that will look over all three columns and display only once on a different sheet each unique name. For example, my name Robinson, Brent and blank in the middle initial column can occur 20 times, but I need it to only list me once on the other sheet.
Thank you,
Bookmarks