Formula to Skip Blank Rows and Pull the Next Non-Blank
Hi Guys,
I have a source table that will get updated manually and needs to feed through to a final table (on a hidden sheet).
There will be some rows however that are blank (do not have totals) - for these incidences, I need for the that row to be skipped and the following row with a total to be fed to the hidden table.
Please see the example attached
Thanks a million
KR
Enter array formula in F21 and copy down
Formula:
Please Login or Register to view this content.
For the IDs change INDEX(H:H, to INDEX(B:B
***Array formula
...confirmed by pressing CTRL+SHIFT+ENTER to activate the array, not just ENTER.
You will know the array is active when you see curly braces { } appear around your formula.
If you do not CTRL+SHIFT+ENTER you will get an error or a clearly incorrect answer.
Last edited by AlKey; 06-19-2017 at 12:58 PM.
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
Perfect!! - guru!!!! -
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks