Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Unique Dates...
I have cells A1 through J1 populated with dates (some are the same dates, and
some are different). * In cell K1 I'd like to write a formula which tells me if the value in cell A1 is unique compared to all the dates in the A1-J1 range. * In cell L1 I'd like to write a formula which tells me if the value in cell B1 is unique compared to all the dates in the A1-J1 range repeat for 10 cells. What formula can I use to accomplish this? Thanks in advance. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Unique Dates...
enter in K1
=COUNTIF($A1:$J1,A1) extend it to the right using the right hand bottom corner left click and drag when the result is 1.......... it's unique you could highlight them with conditional format Greetings from NZ Bill K "cdavidson" wrote in message ... I have cells A1 through J1 populated with dates (some are the same dates, and some are different). * In cell K1 I'd like to write a formula which tells me if the value in cell A1 is unique compared to all the dates in the A1-J1 range. * In cell L1 I'd like to write a formula which tells me if the value in cell B1 is unique compared to all the dates in the A1-J1 range repeat for 10 cells. What formula can I use to accomplish this? Thanks in advance. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need to pull current dates from list w/many dates | Excel Discussion (Misc queries) | |||
Automatic shading of cells based on dates??? | Excel Worksheet Functions | |||
2 digit year in dates return 19xx not 20xx | Excel Discussion (Misc queries) | |||
how do I select unique dates from a database in Excel? | Excel Worksheet Functions | |||
Formating Dates for production schedule | Excel Discussion (Misc queries) |