| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Calculating Max, Min, Ave etc of a large region
Jim
Assuming for data, dates (Jan 1 etc) as text in column A beginning at row 3, and years in row 2 beginning at column B. For table, Jan, Feb etc in column G beginning row 3, years in row 2 begining column H, use the following. Expand/move to fit data as necessary. =MAX((LEFT($A$3:$A$368,3)=$G3)*($B$2:$E$2=I$2)*$B$ 3:$E$368) Enter as an array (CTRL+SHIFT+ENTER) and copy to remainder of table. Regards Murray |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculating hourly average from large data set | Excel Discussion (Misc queries) | |||
| Paste values all cells in a region which refers to out of region | Excel Worksheet Functions | |||
| Calculating the number of unique values within a large range | Excel Worksheet Functions | |||
| Calculating Median Value in a large array | Excel Discussion (Misc queries) | |||
| Working with a large file, calculating after every little change | Setting up and Configuration of Excel | |||
Threaded Mode
