Home

finding unique values then apply criteria

%3CLINGO-SUB%20id%3D%22lingo-sub-582932%22%20slang%3D%22en-US%22%3Efinding%20unique%20values%20then%20apply%20criteria%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-582932%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHope%20you%20guys%20can%20help%20me%2C%20please%20see%20the%20spreadsheet%20for%20details.%20let%20me%20explain%20give%20explain%20the%20request.%3C%2FP%3E%3CP%3EIn%20a%20party%20there%20are%20various%20food%20items%20served%2C%20the%20list%20of%20who%20ate%20which%20food%20is%20attached%2C%20now%20I%20want%20to%20identify%20the%20list%20of%20unique%20items%20that%20is%20been%20served%2C%20once%20the%20list%20of%20unique%20food%20items%20are%20identified%20then%20I%20want%20to%20list%20the%20unique%20items%20and%20under%20that%20I%20want%20to%20find%20out%20who%20all%20ate%20those%20items.%26nbsp%3B%3C%2FP%3E%3CP%3EI%20hope%20I%20am%20making%20sense.%20Please%20see%20the%20attached%20spreadsheet%2C%20where%20I%20have%20mentioned%20the%20result%20required.%3C%2FP%3E%3CP%3ECan%20this%20be%20done%20using%20excel%20function%20or%20does%20this%20require%20VBA%3F%3C%2FP%3E%3CP%3EThanks%20in%20advance%20guys%3C%2FP%3E%3CP%3ETa%2C%3C%2FP%3E%3CP%3ERS%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-582932%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-583409%22%20slang%3D%22en-US%22%3ERe%3A%20finding%20unique%20values%20then%20apply%20criteria%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-583409%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F343985%22%20target%3D%22_blank%22%3E%40ram01%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EA%20solution%20with%20data%20model%20and%20pivot.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
ram01
Occasional Visitor

Hi,

 

Hope you guys can help me, please see the spreadsheet for details. let me explain give explain the request.

In a party there are various food items served, the list of who ate which food is attached, now I want to identify the list of unique items that is been served, once the list of unique food items are identified then I want to list the unique items and under that I want to find out who all ate those items. 

I hope I am making sense. Please see the attached spreadsheet, where I have mentioned the result required.

Can this be done using excel function or does this require VBA?

Thanks in advance guys

Ta,

RS 

1 Reply
Highlighted

@ram01 

A solution with data model and pivot.

 

Related Conversations
Extentions Synchronization
Deleted in Discussions on
3 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
36 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
29 Replies