Duplication

P

Problems

I am trying to do the following things in a spreadsheet...

1) If the same date was to appear in a list of dates - how could I arrange
it for Excel to flag this up?

2) If I wanted to check that the day and date is the correct day against the
date. How would I do this? I assume I would need to set up a calendar to
compare this against, but then which formula would I need so that these two
sets of data can be compared with each other and any false entries i.e.
Thursday 1st is in fact Thursday 2nd? This probably doesn't make sense but I
know what I mean! :)
 
G

Gordon

Problems said:
I am trying to do the following things in a spreadsheet...
Click to expand...

Firstly this group is about TEMPLATES. As in the title. For excel questions
post to microsoft.public.excel.newusers
1) If the same date was to appear in a list of dates - how could I arrange
it for Excel to flag this up?
Click to expand...

Take a look here:
http://www.cpearson.com/excel/Duplicates.aspx
2) If I wanted to check that the day and date is the correct day against
the
date. How would I do this? I assume I would need to set up a calendar to
compare this against, but then which formula would I need so that these
two
sets of data can be compared with each other and any false entries i.e.
Thursday 1st is in fact Thursday 2nd? This probably doesn't make sense
but I
know what I mean! :)
Click to expand...

use the "NOW" function as in "IF (date in list) is not equal to NOW, False"
or whatever value you want to put in.
 
Top