Been spending a lot of time on Google looking through different array type formulas with Index() / Match(), just can't seem to get the right combination... This doesn't seem like it should be as hard as i'm making it.
All i want is a formula or two that can turn this:
Into this:
Please Login or Register to view this content.
I'll be building off this so i'm not exactly looking for a pivot table.Please Login or Register to view this content.
The problem is how you've organized your desired output. Formulas don't really create separate tables of outputs. Why not just use the Remove Duplicates feature and then organize it however you want?
Well, the data source will change too frequently for me to want to manually produce the desired output.
The closest thing I've found so far is illustrated below. However it only has duplicate values in column A, while i have duplicate values in columns A, B, and C.
http://eimagine.com/how-to-return-mu...ch-or-vlookup/
Is it impossible?
*Edit: I'm assuming each column would need a slightly unique formula (A, B, C, D) if it is possible.
*Edit: I'm open to going about this with the "Remove Duplicates" feature via VBA/Macro but is less preferable if a formula will work
Last edited by Andrewjs; 02-10-2017 at 06:55 PM.
So far my only idea is by making a new hidden duplicate table that is appended and arrayed like
Then use INDEX(MATCH()) to help grab any pattern of cells ending in "ID1"Please Login or Register to view this content.
....But i can't really wrap my head around the syntax to do it.. And would not be at all surprised if there's a more efficient way to do it.
*Edit: A Pivot table almost seemed to help, but i still can't properly list which BatchNames each Person is making, with the SizeOfBatch as well.
Last edited by Andrewjs; 02-11-2017 at 10:34 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks