Re: Calculating Max, Min, Ave etc of a large region
- From: "Murray" <myall_blues@xxxxxxxxxxx>
- Date: 22 Dec 2005 16:39:47 -0800
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
.
- Follow-Ups:
- Re: Calculating Max, Min, Ave etc of a large region
- From: postman Jim
- Re: Calculating Max, Min, Ave etc of a large region
- References:
- Calculating Max, Min, Ave etc of a large region
- From: Jim Brass
- Calculating Max, Min, Ave etc of a large region
- Prev by Date: Re: simple question
- Next by Date: exporting data from Workbooks in Folder
- Previous by thread: Calculating Max, Min, Ave etc of a large region
- Next by thread: Re: Calculating Max, Min, Ave etc of a large region
- Index(es):
Relevant Pages
|
