Hi, I know that some tryied to solve this but my case is little complicated:
Im finding LAST empty row in column B AND in column A this row is not empty.
I have hours of work on this and googling but no succes. Perhaps somebody else can help me.
thanks!
dJPiOQr.jpg
For Col A
Formula:
Please Login or Register to view this content.
For Col B
Formula:Please Login or Register to view this content.
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
One way...
Array entered**:
=MAX((A1:A20<>"")*(B1:B20="")*ROW(A1:A20))
** array formulas need to be entered using the key
combination of CTRL,SHIFT,ENTER (not just ENTER).
Hold down both the CTRL key and the SHIFT key
then hit ENTER.
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
Try
=LOOKUP(2,1/(($A$1:$A$100<>"")*($B$1:$B$100="")),ROW($A$1:$A$100))
Hi -
Use the following array formula:
=LARGE(IF(ISBLANK($A$4:$A$10),0,IF(ISBLANK($B$4:$B$10),ROW($A$4:$A$10),0)),1)
Paste this into the cell where you want the result, and press Ctrl-Shift-Enter to engage the array functionality. Excel will add curly braces to the formula that look like this: {}
Hope this helps.
____________________________________________
If this has solved your problem, please edit the thread title to add the word [SOLVED] at the beginning. You can do this by
-Go to the top of the first post
-Select Thread Tools
-Select Mark thread as Solved
If I have been particularly helpful, please "bump" my reputation by pressing the small star in the lower left corner of my post.
Great! Thank you!!
You're welcome!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks