hi try to use advance filter
go to data / filter / advance filter / click copy to another location /
answer the list range e.g. highlight the list / answer copy to e.g. b1 / and
check unique records only

you can chat me at

"Lauren" wrote:

I'm not totally new to Excel but I only use it to manipulate client data. I
need to delete duplicate clients. Not just the duplicate but the original
too. Is it possible without manually deleting? There's over 13,000 client
in this list and I don't have that kind of time.