Good Afternoon,
I am looking for a code (formula or vba) that will recognize there is an account number assigned to different people. Then return just 1 of the account numbers but all of the people assigned to that account number horizontally. Short example below of what I mean with account number and people but I have attached an example of my dataset and the desired outcome.
Acct # People
1-123456 Jane
1-123456 Joe
3-854678 George
3-854678 Andrea
Thank you for your time,
Snikrs11
As long as you keep the first sheet sorted by column A so the rows that go together are adjacent, this can be done with some mostly simply formulas on the second sheet.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
And here's a VBA solution:
Please Login or Register to view this content.
Last edited by xladept; 10-16-2015 at 07:45 PM.
If I've helped you, please consider adding to my reputation - just click on the liitle star at the left.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~(Pride has no aftertaste.)
You can't do one thing. XLAdept
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~aka Orrin
Thank you very much to both of you. They both worked great.
To anyone reading this solved post as an FYI JBeaucaire's file works great you'll just have to change the formula in Region and Auditor 3 from +1 to +2. And if you go on to Region 4 you would do +3, +4, and so on.
You're welcome!
Thanks for the follow up on JB's formulae
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks