Hello Andy i shall try this and see how it goes if not i shall send
you the sheet and see what you think.
Thankyou once again for your assitance
On May 9, 7:49 pm, Aindril De aind...@gmail.com wrote:
Considering, if you want the average of the top 7 sales and the lowest 7
sales
For highest
Hi Sabby,
Sorry for the delay in responce. Could you please attach a sample sheet so
that it is easy to understand the organization of the data in your
worksheets.
Regards,
Andy
On Fri, May 8, 2009 at 4:38 PM, Sabbycat dancoo...@googlemail.com wrote:
hi Aindril
as i am trying to calculate
hi Aindril
as i am trying to calculate the lowest average sale week and the
average highest week, there is sporadical data in there, usually just
one to 2 weeks worth of sales that his rock bottom but these are not
at the beginning or the end of the year so in order for me to get this
info would
Hi Sabby,
Could you explain , how many of the highest numbers and lowest numbers you
want to consider to calculate the averages.
Regards,
Andy
On Fri, May 8, 2009 at 12:30 AM, Sabbycat dancoo...@googlemail.com wrote:
This is fairly simple question just dont know how to approach it
I have
If you meant the maximum and minimum numbers you can use max() and min()
functions.
On Thu, May 7, 2009 at 10:30 PM, Sabbycat dancoo...@googlemail.com wrote:
This is fairly simple question just dont know how to approach it
I have 52 columns of data i need to work out the average highest