Show repeat orders within fixed period of time?

[amysh]

Hello, I've been asked if I can pull the data from our customer order records to show which customers have placed repeat orders within a 2 month time frame. Example data below. Could anyone recommend the easiest way to show this? If not possible to show WHO has placed repeat orders is there a way to show HOW MANY customers have placed repeat orders? TIA

customer number	order date	reorder date
123456789​	20-Aug-22​	26-Sept-22​
234567891​	23-Aug-22​	21-Oct-22​
345678912​	08-May-22​	21-May-22​
456789123​	03-Aug-22​	03-Oct-22​
567891234​	18-Feb-22​	29-May-22​
678912345​	10-Oct-22​	12-Oct-22​

 

[James006]

Hello,
Have you tried to insert a Pivot Table ?

 

[amysh]

I have had a go but not been able find find something which works

 

[James006]

Hi,
Difficult to guess what you have tried ... and the obstacles you are confronted with ...
May be it is the Grouping of Dates ...?
see:

How to Group Excel Pivot Table Data Fix Problems

Group Excel pivot table dates, numbers, text. Fix date grouping problems, cannot group that selection, extra dates. Videos, written steps, Excel file

www.contextures.com