LinkBack URL
About LinkBacks
Column F is exactly what I want
Thanks in advance
Column F is exactly what I want
Thanks in advance
Last edited by sgstevenlow; 04-15-2025 at 09:09 AM.
pls try this formula Cell F2 formula , Drag down
Formula:
Please Login or Register to view this content.
here, try this:
=INDEX(A2:E2,SMALL(IF(ISNUMBER(A2:E2),COLUMN(A2:E2)),1))
Never use Merged Cells in Excel
A non-volatile optionFormula:Please Login or Register to view this content.
WOW wk9128 , zbor and Fluff13, you are amazing, that's what it is, thanks for your quick reply
Are you still using Excel 2016?
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.
For Excel 2024 or 365, in H2 followed by ENTER:
=BYROW(B2:E10,LAMBDA(r,TAKE(FILTER(r,r<>"-"),,1)))
No @AliGW , it's Office 2024
OK - see my solution and please update your forum profile.
WOW AliGW , you are amazing Thank You very Much !
@sgstevenlow You're Welcome. Glad to help . Thank You for the feedback and rep.
non-volatile option
Formula:Please Login or Register to view this content.
OR OFFICE 365
Formula:Please Login or Register to view this content.
Last edited by wk9128; 04-15-2025 at 09:29 AM.
Glad to help & thanks for the feedback.
Another option for newer excel versions:
=LOOKUP(99^99,SORTBY(B2:E2,COLUMN(B2:E2),-1))
Another option for HLOOKUP Function
Formula:Please Login or Register to view this content.
With FILTER and TAKE combination:
For columns:
=TAKE(FILTER(B2:E2,ISNUMBER(B2:E2)),,1)
For rows:
=TAKE(FILTER(B2:B10,ISNUMBER(B2:B10)),1)
=BYROW(B2:E10,LAMBDA(x,TAKE(TOCOL(x+0,3),1)))
Hi Adtxc thanks
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks