LinkBack URL
About LinkBacks
ScreenHunter_012.jpg
What are the formula at H2:L2 which show the top most value at B2:F7 ?
ScreenHunter_012.jpg
What are the formula at H2:L2 which show the top most value at B2:F7 ?
Enter formula in H2 and copy across
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
In H2 copied across:
=INDEX(B2:B7,MATCH(TRUE,INDEX((B2:B7<>0),0),0))
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. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
First thing, make sure calculation is set to automatic. In your sample file it's set to manual.
This array formula** entered in H2 and copied across to L2:
=INDEX(B2:B7,MATCH(TRUE,B2:B7<>"",0))
** 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.
Yes, with thank.Originally Posted by AlKey
Enter formula in H2 and copy across
Formula:Please Login or Register to view this content.
That is, thanks.
Yeah~ Thank you very much....
You're welcome!
What he said!You're welcome!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks