LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #13   Report Post  
Geo
 
Posts: n/a
Default

Hi,
Nothing you or Aladin said came across poorly. A comment that was said in a
different post made me feel that I had somehow abused the discussion group
which was not my intention. Im sure that Ill need more help at a later
time. Thanks again!

€œJust to make sure he posted again a third time and wasted Ken Wright's time
as well as

--
Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)


"Ken Wright" wrote:

LOL - If that's how it came across then my apologies as it wasn't meant to.
If Aladin's solution works then good stuff and go with it. Almost anything
can be catered for, but we have to know the rules of engagement with the
data :-)

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------

"Geo" wrote in message
...
Hi,
First off I would like to apologize for wasting peoples time. That is that
last thing that I want to do. I feel that this is a great thing going on

and
that the more knowledgable people are providing a great service to people
like me. So again I apologize.
Now that I have that off my chest.....What I am donig is a handicap
worksheet. Yes some of the cells in the rows could possibly have zeros in
them (But my score won't reflect that). I didn't want to use them if the
column didn't have data in them (Zeros in the row after my last column of
data). So far everything offer to me as far as help has been fantastic,

and I
think that I am in good shape. I am probably asking the worksheet to do

to
much. I think that I am trying to get to complex with this and should

stick
with simplicity. Thank you so much for everyones time.

Also, I think that the last formula give by Aladin did the trick for me,
Thanks!!


"Ken Wright" wrote:

Hi Aladin, given the OPs last reply to me

Yes, There is a possibility that a number in the 34 row may be less

than
zero
in the future.

I'd now be dubious about relying on anything other than manually telling

it
how many data points to cater for. If the value can be greater than 0

and
less than 0 then I have to believe it is possible to actually be 0. If

he's
100% sure it can't then that should do him though :-)

That having been said, in this type of scenario there is usually some

kind
of flag on the sheet that denotes a date or something that can be used

to
calculate how many date periods and hence data points should be

analysed,
even if it's just using something like MATCH/HLOOKUP etc to marry up the
current month and year with the dates that i assume sit on top of this

data.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03


--------------------------------------------------------------------------

--
It's easier to beg forgiveness than ask permission :-)


--------------------------------------------------------------------------

--

"Aladin Akyurek" wrote in message
...
Ken,

Maybe...

=AVERAGE(OFFSET(G34,,MATCH(2,1/(G34:Z34<0))-1,,-5))

is what Geo is looking for.

The formula must be confirmed with control+shift+enter.

Note also that the formula does not check whether there is a sufficent
amount of data points in the range of interest.

<snip






 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
EXcluding Zeros from the average in a row Geo Excel Discussion (Misc queries) 4 December 31st 04 04:07 PM
IF Statement with Average Function results in #Value! Paul Excel Discussion (Misc queries) 5 December 28th 04 08:11 AM
Average Macro Christopher Anderson Excel Discussion (Misc queries) 2 December 22nd 04 06:43 PM
Zero Filling Excel Discussion (Misc queries) 4 December 17th 04 08:46 PM
average on rows justamailman Excel Discussion (Misc queries) 5 December 13th 04 01:51 AM


All times are GMT +1. The time now is 12:19 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"