index count problem.JPG
Appreciate tips on how to resolve this. Many thanks.
index count problem.JPG
Appreciate tips on how to resolve this. Many thanks.
Is this a VBA question?
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
here is a possible solution. It's an array formula so you need to use CTRL+SHIFT+ENTER to commit the formula.
=INDEX(F8:O8,MAX(IF(ISERROR(F8:O8),0,IF(F8:O8="",0,COLUMN(F8:O8))))-COLUMN(E8))
Hard to tell but if your last column always has a value then it may be better to use a single cell to locate that cell and then use that in the INDEX formula, rather than finding it multiple times
Many thanks!
Magic, it works!
Sorry, I am a starter on macro, don't understand your last sentence.
The last column is always #VALUE. If there is a simpler method, I am all eyes and ears!
Thanks.
My VBA knowledge is at beginner's level. I hope so.
As this is being solved with formulae, I am moving the thread to the appropriate section.
I see. You are right!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks