Re: question about using the offset function

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: GS Brown (browng_at_pac.dfo-mpo.gc.ca)
Date: 03/05/04 

Date: 05 Mar 2004 16:34:22 GMT

Hi Earl,

Thanks for your suggestion about simpler organization of data. I will
put some thought toward that. You're absolutely right in that
organizing data to take advantage of pivot tables and other Excel
'ready-made' summarizing capabilities is an intelligent way to go.
Please allow me one 'however' to plead my case. However, I have many
(many) small data sets, some of which group naturally on a ***, as in
my example of fish weights and sometimes, it does seem convenient to
have the data displayed in nciely formatted tables with formulas at the
base of columns or rows that summarize aspects of the data. I'd still
like to try to find a way to supply functions like 'average' with a
limited, defined but periodically expanding range of values. This
quest is also meant to improve my Excel skills.

You pointed out that the reason that offset was returning all of column
D in my example was that I had specifed $D:$D. I figured that was the
reason but I couldn't figure out a way to change to column reference to
restrict what offset returned. Any suggestions?

***** Posted via: http://www.ozgrid.com
Excel Templates, Training & Add-ins.
Free Excel Forum http://www.ozgrid.com/forum *****

Quantcast