I have an IF formula to return column heading for FALSE
The formula determines if any of the dates in the range of H2:U2 are between
the dates in cells E2 and F2, and if not the cell remains blank. If there is
a date in that range that is between the dates in E2 and F2 the cell is given
the word Due. Rather than the word Due, I want an equation that will find
the date and then return to the cell the column header of that cell.
"Dave Peterson" wrote:
I don't see anything that describes how the result is obtained.
NN wrote:
The formula I currently have is
=IF((COUNTIF(H2:U2,"="&E2)-COUNTIF(H2:U2,"="&F2))=0," ","Due")
I wish to replace the word "Due" with whichever column heading is the result.
"Dave Peterson" wrote:
Is the column heading just a cell where you've typed the header?
If yes:
=if(something,"",A1)
Where A1 holds that header.
NN wrote:
I have an IF formula that returns " " when logic is TRUE, but I wish it to
return the column heading for the FALSE logic. What is the formula for the
FALSE logic, please?
--
Dave Peterson
--
Dave Peterson
|