LinkBack URL
About LinkBacks
Hi There,
May I know if anyone can suggest me a formula for following scenario?
Untitled.jpg
If there is 1 "X" in column E = "ABC"
If there is 2 "X" in column E = "1. ABC"
"2. QRS"
and so on....
Really appreciate your help on this.
Thank in advance
Hi There,
May I know if anyone can suggest me a formula for following scenario?
Untitled.jpg
If there is 1 "X" in column E = "ABC"
If there is 2 "X" in column E = "1. ABC"
"2. QRS"
and so on....
Really appreciate your help on this.
Thank in advance
Try this arrayed formula
Formula:
Please Login or Register to view this content.
...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.
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
WOW... thank you very much!!! Appreciate it.
However, possible to add serial no before "F"?
If only 1 "X", serial no will not required.
Once again, thank in advance
This Arrayed Formula in I10
Formula:Please Login or Register to view this content.
Your formula are working, however when only 1 selection, it will show 1. abc
Can do without serial no when only 1 selected?
Attachment 620712
ARRAYED, of courseFormula:Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks