The new forums will be named Coin Return (based on the most recent vote)! You can check on the status and timeline of the transition to the new forums here.
The Guiding Principles and New Rules document is now in effect.
Excel Help! Eliminating all duplicates
Kyougu
Registered User regular
Registered User regular
So I hit a snag working on an excel spreadshet for work.
A report gets outputted everyday that I clean up. The problem is that due to processing time, the cleaning up won't reflect on the next day's report, meaning that apart from any new data from that day, there's also all the old date from the day before.
Is there any way to eliminate the old date from the report? I have all the data from the previous day, so I thought pasting that into the new report and then filtering by unique data would do the trick, but that only does it so same data only appears once. I'm trying to completey eliminate off the report.
Thanks!
A report gets outputted everyday that I clean up. The problem is that due to processing time, the cleaning up won't reflect on the next day's report, meaning that apart from any new data from that day, there's also all the old date from the day before.
Is there any way to eliminate the old date from the report? I have all the data from the previous day, so I thought pasting that into the new report and then filtering by unique data would do the trick, but that only does it so same data only appears once. I'm trying to completey eliminate off the report.
Thanks!
Kyougu on
0
Posts
then filter
then Advanced Filter
click 'unique records only'
copy+paste into a new spreadsheet
edit: wait, wut?
these items have some sort of timestamp that is preventing a straight removal of dupes?
Have you tried Access? MAX out the timestamp and select distincts?
IF(logical test,[value if true],[value if false])