ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Identifying unique dates within a range of cells containing dates (https://www.excelbanter.com/excel-discussion-misc-queries/114152-identifying-unique-dates-within-range-cells-containing-dates.html)

cdavidson

Identifying unique dates within a range of cells containing 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.


All times are GMT +1. The time now is 06:44 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com