Hello all! First post. Thanks in advance for replying.
I have included an example spreadsheet.
In it I have a list color orders in column A, and the dates those orders are due in column B.
There are multiple orders for the same color.
I want a way to count and list all the color orders, not including duplicate color matches, that are due in the next 7 days, and in the next 30 days.
I came up with a formula to count just the dates that fall between a start and finish date, but it's not smart enough to know of duplicate color entries.
Like in my example file, there should only be 15 unique colors with orders due in the next 7 days, but because of multiple same color orders, it lists 18. Likewise, there should only be 6 unique colors with orders in the next 30 days, but it lists 7.
I was thinking it would be better to just pull the unique colors with in the time period to a list, then have a separate formula count the resulting list.
But this is what I can not figure out how to do. Help me Gurus of the Excel formulas
P.S. The dates in column B are not in an Excel recognized date format, so I have a second column (column C) with formulas to convert the text into Excel recognized data values.
Bookmarks