Example 1:
excel1.png
Example 2:
excel2.png
I want to know the formula for change Example 1 to Example 2.
Please help me!
Thanks a lot!
Example 1:
excel1.png
Example 2:
excel2.png
I want to know the formula for change Example 1 to Example 2.
Please help me!
Thanks a lot!
Enter in C2 and copy down
Formula:Please Login or Register to view this content.
Enter array formula in D2 and drag formula across and down
***Array formula
...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.
Formula:Please Login or Register to view this content.
Unknown
A B C D E F G H I J K L M 1Name 1 Name 2 2NAME-A NAME-A-1 NAME-A NAME-A-1 NAME-A-2 NAME-A-3 NAME-A-4 NAME-A-5 NAME-A-6 NAME-A-7 NAME-A-8 NAME-A-9 NAME-A-10 3NAME-A NAME-A-2 NAME-B NAME-B-1 NAME-B-2 NAME-B-3 NAME-B-4 NAME-B-5 NAME-B-6 NAME-B-7 NAME-B-8 NAME-B-9 NAME-B-10 4NAME-A NAME-A-3 NAME-C NAME-C-1 NAME-C-2 NAME-C-3 NAME-C-4 NAME-C-5 NAME-C-6 5NAME-A NAME-A-4 6NAME-A NAME-A-5 7NAME-A NAME-A-6 8NAME-A NAME-A-7 9NAME-A NAME-A-8 10NAME-A NAME-A-9 11NAME-A NAME-A-10 12NAME-B NAME-B-1 13NAME-B NAME-B-2 14NAME-B NAME-B-3 15NAME-B NAME-B-4 16NAME-B NAME-B-5 17NAME-B NAME-B-6 18NAME-B NAME-B-7 19NAME-B NAME-B-8 20NAME-B NAME-B-9 21NAME-B NAME-B-10 22NAME-B NAME-B-11 23NAME-B NAME-B-12 24NAME-C NAME-C-1 25NAME-C NAME-C-2 26NAME-C NAME-C-3 27NAME-C NAME-C-4 28NAME-C NAME-C-5 29NAME-C NAME-C-6
Sheet: Sheet2
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks