Hi,
Hope someone could help me on what formula to use under cell F30 of my attached spreadsheet.
What I need is a formula that will automatically reference the SQ No. of the last line with Job no. values.
Hope I makes sense. Thank you!
Hi,
Hope someone could help me on what formula to use under cell F30 of my attached spreadsheet.
What I need is a formula that will automatically reference the SQ No. of the last line with Job no. values.
Hope I makes sense. Thank you!
Try this...
=INDEX($B$9:$B$27,COUNT(C9:C27))
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Happy to help and thanks for the feedback
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks