Hi Guys,
Struggling with this one. Have attached a workbook to help.
There are two columns of data. I need a formula that can identify the last max. value in column B (in this worksheet, it would be cell B16), and then I need the formula to count and return the number of non-blank cells up to that point in column C (in this case, I need the formula to count non-blank cells C3:C16). In this case, the result in the grey box should be 8.
Thanks for your help!
With 2 helpcolumn and after that a vlookup.
See the attached file.
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
c23 =COUNT(INDIRECT("C3:"&"C"&MATCH(MAX($B$1:$B$18),$B$1:$B$18)))
See the attached file.
Hi oeldere,Originally Posted by oeldere
That's amazing, I love the second solution you've provided. Thanks very much for your help!
Thanks for the rep.
You're welcome. We appreciate the feedback!
If your question has been solved please mark the thread as being solved.
In the menu bar above the very first post select Thread Tools, then select Mark this thread as solved.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks