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