Related Posts
Chief
Chief
Posting as :
works at iEnergizer Pvt Ltd
Trafalgar is confused. Can't be trusted
Additional Posts in Excel Genius
New to Fishbowl?
Download the Fishbowl app to
unlock all discussions on Fishbowl.
unlock all discussions on Fishbowl.
Is this something pivoting out your data wouldn't be able to give you what you need? For instance one product name has multiple SKUs associated, pivot that data out and you'll see all SKUs associated to each product. Or identifying a unique concat to index match values to?
I usually create a new unique identifier when duplicates may exist. So make a new column and make it =a2&b2&c2
Use as many cells as you need to create all unique identifiers. The conditionally format for duplicates to make sure you have the desired result.
Yes what Consultant 2 said. You could do an array formula, {=INDEX(A:A,MATCH(B1&C1,D:D&E:E,0))} but it will be supppppeeeerrrr slow and bog your file down. So best to make new columns to concatenate it together to make a primary 🔑 and index/match that, or another method
Why not use countif and then you can filter out the ones for which its greater than 1
Definitely make a new identifier - there is a way to do this with index match without another identifier but it is super messy
I mean anything is possible but you will have to provide more detail. I'll make a burner email tonight and I can take a look but you'll have to send me the workbook and a description of what you're trying to do
Index match, yes but it will slow your file down.
Quickest method is definitely Pivot Tables. I’d make the pivots, then copy into new tables and create new IDs from there.
This will be an array formula and it will go slow
I have to do this all the time...just pivot on dat
You can add offset to your lookup if the duplicates are next to each other.