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
Highlighted
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

@ram01 

A solution with data model and pivot.

 

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