I am currently running formulas IF(COUNTBLANK) to self fill other cells corresponding to dates in another cell. However, what
I want to determine is how to take the column of data that has some cells filled with N/A where other are filled with dates,
but I don't want the cell that the formula is in to change to a Y until all the empty cells (those not N/A) have a date in
This is my current formula:
=If(COUNTBLANK( 'Special Vips'!K2:K20)=19,"N","Y")
If you like these VB formatting tags please consider sponsoring the author in support of injured Royal Marines
In the referenced cells, 17 have N/A but two will be populated with dates, I don't want the "Y" to show up until both
cells have dates.