| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculating Values that have a common date
I am trying to do some summary tables with data that i have accumulated every
half hour for every day of the year, so yeah i have alot of data. What i am trying to do is if data falls on a certain date i want to find the average, max, and min values. Is there a formula i can use such as an IF formula or lookup of sum sort, that can help me. If you can help me i would appreciate it. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Calculating Values that have a common date
If desired, send your file to my address below along with this msg and
a clear explanation of what you want and before/after examples. -- Don Guillett Microsoft MVP Excel SalesAid Software "Soccerboy83" wrote in message ... I am trying to do some summary tables with data that i have accumulated every half hour for every day of the year, so yeah i have alot of data. What i am trying to do is if data falls on a certain date i want to find the average, max, and min values. Is there a formula i can use such as an IF formula or lookup of sum sort, that can help me. If you can help me i would appreciate it. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Comparing common values in either different worksheets or columns | Excel Discussion (Misc queries) | |||
| How to use date for calculating values in other cells | Excel Worksheet Functions | |||
| Scatter plot with two data series having common x-values | Charts and Charting in Excel | |||
| Display common values in first occurrence only | Excel Discussion (Misc queries) | |||
| How to Identify Values in Common Between 2 cells | Excel Discussion (Misc queries) | |||
Linear Mode
