Hello,
I'm having trouble converting two list into one. Attached is an example. A and B are supplied I would like to create a2 and b2. I appreciate any help.
Hello,
I'm having trouble converting two list into one. Attached is an example. A and B are supplied I would like to create a2 and b2. I appreciate any help.
Try:
Formula:Please Login or Register to view this content.
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
Or
Formula:Please Login or Register to view this content.
Note: you cannot put those formulae into a Structured Table.
Another solution:Formula:Please Login or Register to view this content.
Thanks a lot Trevor! Awesome work.
Thanks a lot HansDouwe, worked great.
Thanks for the feedback. Glad to have helped. .
Also, if you have not already done so, you may not be aware that you can thank anyone who offered you help towards a solution for your issue by clicking the small star icon (* Add Reputation) located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of each of those who offered help.
You're welcome. Thanks for the rep.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks