Hello,
Looking for help with this.
If I do not have a value in column B or C I would like the corresponding cell in column D to be blank.
How do I do that?
Work book attached.
Thank you,
Rich
Hello,
Looking for help with this.
If I do not have a value in column B or C I would like the corresponding cell in column D to be blank.
How do I do that?
Work book attached.
Thank you,
Rich
Last edited by RVT; 11-07-2013 at 03:13 AM.
Hi,
a first attempt using a condition
in D1
=IF(OR(B1="",C1=""),"",SUMPRODUCT((C1>C$1:C$10)/(COUNTIF(C$1:C$10,C$1:C$10&"")))+1)
or if you'd need a blank cell when B and C are blank
=IF(AND(B1="",C1=""),"",SUMPRODUCT((C1>C$1:C$10)/(COUNTIF(C$1:C$10,C$1:C$10&"")))+1)
Regards
-----------------------------------------------------
At Excelforum, you can say "Thank you!" by clicking the star icon ("Add Reputation") below the post.
Please, mark your thread [SOLVED] if you received your answer.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks