Hello,
I need the simplest method to accomplish turning sheet 1 of the attached into sheet 2. A few things to keep in mind:
1. I have over 1,000 "cuisines" and about 20,000 "types of food."
2. On sheet two, we cannot have any repeats of cuisine. Each type of food matching to each cuisine needs to fit in one row with cuisine on the far left of each row and types of food in each cell going to the right.SAMPLE.xlsx
Any help would be great appreciated. Thank you so much!
Hi
Hope this what you looking for.
Sheet2 B2 =IF($A2="","",IFERROR(INDEX(Sheet1!$A:$A,SMALL(IF(Sheet1!$B$2:$B$200=$A2,ROW(Sheet1!$B$2:$B$200)),COLUMNS($B$2:B2))),"")) Control+Shift+Enter not Enter. Then copy down and cross.
Click on Attachment.
Cheers
To help you by my post? it would be nice to click onto say "Thank you".
If you are happy with a solution to your problem?
Click Thread Tools above your first post,
select "Mark your thread as Solved".
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks