Forum Discussion
Adding date ranges Unique Function
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 mul...
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.
