Hello all,
I have a file in which A2:A11 has the due date and B2:B11 has the paying date.
This range is if C2 is 10. 10 Rows.
In D2 I need to find compare A2:B11 and should find the blank cells in that.
The range should be changed automatically if the value in cell C2 is changed. If C2 is 5 then the range should be A2:B6 and so on.
Can somebody help me please.
In D2:
=COUNTIF(A2:OFFSET(A2,C2-1,1),"")
Remember, saying thanks only takes a second or two. Click the star icon(*) below the post you liked, to give some Rep if you think an answer deserves it.
Please,mark your thread [SOLVED] if you received your answer.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks