I have a data dump from a system that I do daily and I am looking for a way to automate the elimination of data I don't want. Attached is a data sample and end result I am looking for with specific notes.
thx,
Busa
I have a data dump from a system that I do daily and I am looking for a way to automate the elimination of data I don't want. Attached is a data sample and end result I am looking for with specific notes.
thx,
Busa
Make a table of your data
Insert => table.
I2 =A2&F2
J2 =IF(COUNTIF($I$2:$I2,$I2)=$F2,"yes","")
After that filter on column J and select for "" (empty).
Delete the filtered data.
After that you get the result you posted.
See the attached file.
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks