Hi there folks - wonder if someone can help me with something. I am not the greatest Excel user ever - after all these years! - so would appreciate any pointers with this. I have a spreadsheet where I am wanting to see if I can pick up trends within various categories of data. So, this is just a snippet of the data, but I am wanting to see if I can identify where a responsive visit took place within 5 days of a planned visit. Location Date Nature of Visit Within 5 Days Euston 01/04/2020 Responsive Euston 02/04/2020 Planned Manchester 26/04/2020 Responsive Manchester 12/05/2020 Planned BTW - Please excuse the UK date format. I wonder if there is a way of highlighting these, by way of capturing this in a graph, so I can then summarize within a pivot. Any help would be gratefully received. Thank you.

If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

Identifying Trends within a Date Range

Thread starter nortellini
Start date Oct 8, 2020

nortellini

New Member

Oct 8, 2020

Hi there folks - wonder if someone can help me with something. I am not the greatest Excel user ever - after all these years! - so would appreciate any pointers with this.

I have a spreadsheet where I am wanting to see if I can pick up trends within various categories of data.

So, this is just a snippet of the data, but I am wanting to see if I can identify where a responsive visit took place within 5 days of a planned visit.

Location	Date	Nature of Visit	Within 5 Days
Euston	01/04/2020	Responsive
Euston	02/04/2020	Planned
Manchester	26/04/2020	Responsive
Manchester	12/05/2020	Planned

BTW - Please excuse the UK date format.

I wonder if there is a way of highlighting these, by way of capturing this in a graph, so I can then summarize within a pivot. Any help would be gratefully received. Thank you.