ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   how can list data weekly,monthly yearly etc in ms excell (https://www.excelbanter.com/excel-programming/360199-how-can-list-data-weekly-monthly-yearly-etc-ms-excell.html)

Abdul Gaphoor

how can list data weekly,monthly yearly etc in ms excell
 
how can list data weekly,monthly yearly etc in ms excell

Jon Peltier

how can list data weekly,monthly yearly etc in ms excell
 
Describe what you want. Subtotals? Summary tables?

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______


"Abdul Gaphoor" wrote in message
...
how can list data weekly,monthly yearly etc in ms excell




Tom Ogilvy

how can list data weekly,monthly yearly etc in ms excell
 
Data can often be summarized over time intervals by using the Pivot Table
under the data menu.

Debra Dalgleish
http://www.contextures.com/tiptech.html

Look at articles on pivottables.

--
Regards,
Tom Ogilvy


"Abdul Gaphoor" wrote:

how can list data weekly,monthly yearly etc in ms excell


Ron de Bruin

how can list data weekly,monthly yearly etc in ms excell
 
If you want to filter on weeks/months/years you can try EasyFilter
http://www.rondebruin.nl/easyfilter.htm

On the Dates tab there are a lot of options

--
Regards Ron de Bruin
http://www.rondebruin.nl


"Abdul Gaphoor" wrote in message ...
how can list data weekly,monthly yearly etc in ms excell





All times are GMT +1. The time now is 02:37 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com