Thank you for patiently waiting. I have completed it successfully. The formula I used is an array formula, so if you enter an array formula, while the cursor is in the formula bar, press CTRL+SHIFT+Enter instead of just pressing Enter. Doing that appends the curly braces in the formula itself to indicate it is an array.
The formula is:
When Ctrl+Shift+Enter is pressed, the formula will become:
You can then drag the formula down to copy it.
That formula will actually look for the LAST non-blank cell in the row range from left to right, that is exactly what you require.
Here is my sample file:http://www.filedropper.com/samplebookrev1
That page has a lot of ads, (wikisend.com is down temporarily) click on the gray button that says "Download This File". Enter the captcha code and you shall be able to download my sample Excel file where the formula is already added.
Please remember to rate my service positively (3-5 stars/faces)
once you have all the information you need. Tips
are always highly appreciated!
If you have any other questions, please ask me or reply to me
– I’ll be happy to respond.