How to delete data

  • Thread starter AdministratorCapnGator
  • Start date
A

AdministratorCapnGator

Hi,

I have thousands of daily data and I don't know how to
automatically delete all the other data and just leave
the end of the month data without doing it manually. Or
just choose the end of the month data to create a chart.

Note, that each date has a respective number, 45%.

Please advise.

A
1/1/02
1/2/02....
.....
.....
1/31/02
2/1/02....
.....
.....
2/28/02
.....
etc.
 
D

Debra Dalgleish

You could extract the month end data with an Advanced Filter. For
example, with a heading in cell A1, and your dates starting in cell A2--

In cell D2, enter the formula:
=A2=DATE(YEAR(A2),MONTH(A2)+1,0)

Select a cell in the list of dates
Choose Data>Filter>Advanced Filter
Select 'Copy to another location'
The list range should be automatically entered
For the Criteria range, select cells D1 (blank) and D2
Select a cell as the start of the "Copy to" location
Click OK
 
Top