Hi,
I have a list of data and want to pickup only one data.Below function I am trying to use but failed.
=ifs(B2="", C2="",D2="",E2="",B2,C2,E2)
How this can be resolved
Hi,
I have a list of data and want to pickup only one data.Below function I am trying to use but failed.
=ifs(B2="", C2="",D2="",E2="",B2,C2,E2)
How this can be resolved
Welcome to the forum.
It's impossible to say because you have not said what result you are expecting.
More detail, please.
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.
Anyone a single data that doesn't contain space
ok find file in attached
Where does F4 come from???
Otherwise, try this:
=INDEX($C2:$E2,MATCH("*",$C2:$E2,0))
Thank it worked
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks