Prob 1:
I am getting a spreadsheet daily and by day 5 I have to make sure that all data from day 1 has been completed and no longer shows on the daily report.
Prob 2:
on a spreadsheet i have the date,address and device number. I only want one record of the device number. I have tried the unique values option but im still getting double ups because of the dates.
Your help would be much appreciated
I am getting a spreadsheet daily and by day 5 I have to make sure that all data from day 1 has been completed and no longer shows on the daily report.
Prob 2:
on a spreadsheet i have the date,address and device number. I only want one record of the device number. I have tried the unique values option but im still getting double ups because of the dates.
Your help would be much appreciated