I have a column of dates that will be added to over time and include duplicates. I need to extract unique dates from that column to create a dynamic list.
To that end, I created a helper column (Column F) to display a 1 for when each date first occurs in the column; if not, then 0.
<tbody>
</tbody>
The formula in column F:
The COUNTIF uses an expanding range (A$2:A2, A$2:A3, etc.)) to determine whether or not the date in column A is the first one.
For some reason, Excel display one of those in-cell error tips (the ones with the green arrow) stating "formula omits adjacent cells." This always starts in the second cell in column F. If I select "Update Formula to Include Cells" from the pop-up tip, the error will the change to "Copy Formula from Above".
This will throw off my calculations for other columns.
Anyone know what's going on?
To that end, I created a helper column (Column F) to display a 1 for when each date first occurs in the column; if not, then 0.
A | F |
Tuesday, November 27, 2018 | 1 |
Monday, November 26, 20181 | 1 |
Friday, November 26, 2018 | 0 |
Friday, December 7, 2018 | 1 |
Friday, December 7, 2018 | 0 |
Friday, December 8, 2018 | 1 |
<tbody>
</tbody>
The formula in column F:
Code:
=IF(A2="","",(IF(COUNTIF(A$2:A2,A2)=1,1,0)))
The COUNTIF uses an expanding range (A$2:A2, A$2:A3, etc.)) to determine whether or not the date in column A is the first one.
For some reason, Excel display one of those in-cell error tips (the ones with the green arrow) stating "formula omits adjacent cells." This always starts in the second cell in column F. If I select "Update Formula to Include Cells" from the pop-up tip, the error will the change to "Copy Formula from Above".
This will throw off my calculations for other columns.
Anyone know what's going on?