Date range selecting

[Christopher lee]

Hi all,

I facing a problem with i want to select a range of data from the last 4 week / last month of data from few years of data.....any 1 have idea to do with it??

Thank and appreciate it for help~~

 

[Chris Mack]

How much data? Is the data sorted by date? Could you just sort the data by date and then click and drag to select?

 

[Christopher lee]

the data will not fix....it will keep changing once the data uploaded....ya i hv 1 column is date for the product...so i need to sort it 1st then only can find out the last 4 week of date of data?

 

[Chris Mack]

Yes, you can sort it by date. That would be a fairly simple way of doing it.

It depends on what you're ultimately trying to do with this data as to how complex the solution needs to be.

 

[RonB1111]

Use Auto Filters. You won't need to sort. Here's a link explaining it:
http://www.contextures.com/xlautofilter01.html