Assigning Order Number

[tbollo]

Hello,

I have a table containing customer order information.

Column A is their unique customer ID, Column B is their order date and column C is the product they purchased:

CUSTOMER ID	ORDER DATE	PRODUCT
B006-05963	30-Jan-19	PRODUCT A
B006-05963	30-Jan-19	PRODUCT B
B006-05963	28-Feb-19	PRODUCT A
B006-08463	10-May-18	PRODUCT A
B006-08463	10-May-18	PRODUCT A
B010-00502	31-May-19	PRODUCT B
B010-00502	31-May-19	PRODUCT B
B013-02386	1-Dec-19	PRODUCT C
B013-02386	2-Dec-19	PRODUCT D
B013-02386	2-Dec-19	PRODUCT D
B013-02386	12-Dec-19	PRODUCT A
B013-02386	12-Dec-19	PRODUCT D
B013-02386	3-Jan-20	PRODUCT E
B013-02386	3-Jan-20	PRODUCT A
B013-02386	3-Jan-20	PRODUCT C

I would like to populate column D with a number that shows whether the product was bought on the same day (using the date field in Column B) for each unique customer. So the finshed data looks like this:

CUSTOMER ID	ORDER DATE	PRODUCT	ORDER
B006-05963	30-Jan-19	PRODUCT A	1
B006-05963	30-Jan-19	PRODUCT B	1
B006-05963	28-Feb-19	PRODUCT A	2
B006-08463	10-May-18	PRODUCT A	1
B006-08463	10-May-18	PRODUCT A	1
B010-00502	31-May-19	PRODUCT B	1
B010-00502	31-May-19	PRODUCT B	1
B013-02386	1-Dec-19	PRODUCT C	1
B013-02386	2-Dec-19	PRODUCT D	2
B013-02386	2-Dec-19	PRODUCT D	2
B013-02386	12-Dec-19	PRODUCT A	3
B013-02386	12-Dec-19	PRODUCT D	3
B013-02386	3-Jan-20	PRODUCT E	4
B013-02386	3-Jan-20	PRODUCT A	4
B013-02386	3-Jan-20	PRODUCT C	4

Can anyone help?

Thanks,
Tim

 

[Fluff]

Duplicate Outputting Product + Order Reference

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread.
Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).