Adding date ranges Unique Function

%3CLINGO-SUB%20id%3D%22lingo-sub-1574952%22%20slang%3D%22en-US%22%3EAdding%20date%20ranges%20Unique%20Function%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1574952%22%20slang%3D%22en-US%22%3E%3CP%3EI've%20only%20started%20exploring%20the%20Unique%20function%20and%20wanted%20guidance%20on%20one%20aspect.%20I%20want%20to%20create%20an%20inventory%20list%20with%20a%20date%20range%20for%20when%20each%20item%20will%20be%20used.%20Most%20items%20will%20be%20used%20at%20multiple%20locations%20and%20across%20multiple%20dates%20so%20the%20initial%20list%20has%20a%20bunch%20of%20redundancy.%20I%20was%20trying%20to%20use%20the%20Unique%20function%20to%20identify%20each%20individual%20item%20but%20I%20wanted%20to%20have%20a%20second%20column%20that%20ties%20either%20the%20locations%20or%20date%20range%20that%20those%20items%20work%20at%20to%20the%20unique%20list.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EExmaple%3A%3C%2FP%3E%3CP%3EOriginal%20List%3A%3C%2FP%3E%3CP%3EApples%26nbsp%3B%20%26nbsp%3BShed%26nbsp%3B%2010%2F15%2F19%3C%2FP%3E%3CP%3EBananas%20House%2010%2F12%2F19%3C%2FP%3E%3CP%3EOranges%20Shed%2010%2F20%2F19%3C%2FP%3E%3CP%3EApples%20House%2010%2F25%2F19%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhat%20I%20want%20the%20Unique%20list%20to%20show%3A%3C%2FP%3E%3CP%3EApples%20Shed%2C%20House%2010%2F15%2F19-10%2F25%2F19%3C%2FP%3E%3CP%3EBananas%20House%2010%2F12%2F19%3C%2FP%3E%3CP%3EOranges%20Shed%2010%2F20%2F19%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1574952%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1575168%22%20slang%3D%22en-US%22%3ERe%3A%20Adding%20date%20ranges%20Unique%20Function%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1575168%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F753512%22%20target%3D%22_blank%22%3E%40Chris1805%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThat%20may%20not%20be%20the%20best%20example%20to%20test%20UNIQUE%2C%20since%20EVERY%20item%20on%20the%20initial%20list%20ends%20up%20being%20included%20on%20your%20desired%20outcome%20list.%26nbsp%3B%20You've%20just%20rearranged%20the%20Apple%20items%2C%20and%20in%20a%20way%20that's%20confusing%20--%20the%20original%20dates%20are%20discrete%20dates%2C%20not%20a%20range%2C%20but%20your%20result%20shows%20them%20as%20a%20range.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20that%20%22second%20column%22%20is%20what%20you're%20wanting%20help%20with%2C%20then%20make%20that%20clear.%20It%20probably%20would%20be%20generated%20in%20some%20way%20other%20than%20via%20UNIQUE.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EDo%20you%20have%20a%20spreadsheet%20already%3F%20Post%20it%2C%20so%20I%20or%20somebody%20else%20here%20can%20work%20with%20your%20actual%20data%20rather%20than%20having%20to%20create%20it.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1575198%22%20slang%3D%22en-US%22%3ERe%3A%20Adding%20date%20ranges%20Unique%20Function%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1575198%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F425987%22%20target%3D%22_blank%22%3E%40mathetes%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20was%20actually%20able%20to%20accomplish%20with%20a%20pivot%20table.%20I%20can't%20share%20my%20doc%20because%20it's%20work%20related%20but%20thank%20you%20for%20responding!%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

I've only started exploring the Unique function and wanted guidance on one aspect. I want to create an inventory list with a date range for when each item will be used. Most items will be used at multiple locations and across multiple dates so the initial list has a bunch of redundancy. I was trying to use the Unique function to identify each individual item but I wanted to have a second column that ties either the locations or date range that those items work at to the unique list.

 

Exmaple:

Original List:

Apples   Shed  10/15/19

Bananas House 10/12/19

Oranges Shed 10/20/19

Apples House 10/25/19

 

What I want the Unique list to show:

Apples Shed, House 10/15/19-10/25/19

Bananas House 10/12/19

Oranges Shed 10/20/19

2 Replies

@Chris1805 

 

That may not be the best example to test UNIQUE, since EVERY item on the initial list ends up being included on your desired outcome list.  You've just rearranged the Apple items, and in a way that's confusing -- the original dates are discrete dates, not a range, but your result shows them as a range.

 

If that "second column" is what you're wanting help with, then make that clear. It probably would be generated in some way other than via UNIQUE.

 

Do you have a spreadsheet already? Post it, so I or somebody else here can work with your actual data rather than having to create it.

@mathetes 

 

I was actually able to accomplish with a pivot table. I can't share my doc because it's work related but thank you for responding!