So I'm close on this one. I have data in an array...walking 10 steps. I need the max value for each step so let's say a step takes 1000 data points. I need the max of the first 1k, 2nd 1k etc. I think I use a row reference for the row I'm in and as I drag down it needs to jump every 1000 finding the max for each step.
what you need is not clear. here's why:
=> you may be confused regarding the definition of "array". you talking about a coding object or an actual worksheet in excel?
=> you say you need a max value for each step and a step takes 1000 data points. sooooo....what does your table look like? like this?
Please Login or Register to view this content.
I did this example with more mangeable numbers:
3 steps with 5 data points per step.
It should be readily adaptable to your larger data set.
It looks like this:
gannon_w.png
The data points are in B2 on down.
In C3 copied down:
StartRow is set to 2. Change it per your needs.Formula:
Please Login or Register to view this content.
Change the 5's to 1000 for your data set.
I provided a second approach in G1:H4 if you want to collect the maxima in a separate table. In H2 copied down:
Formula:Please Login or Register to view this content.
If I have guessed wrong here then please upload a workbook.
Geoff
Did I help significantly? If you wish, click on * Add Reputation to say thanks.
If your problem has been resolved please select ?Solved? from the Thread Tools menu
Suppose your data is in column A, drag under the formula B1
HTML Code:
That's it wk9128....Thanks!!
That also works Geoff! Thanks!
Both Geoff and wk9128 got it...I can never remember the OFFSET function!
No problem, glad to help. Thanks for the rep
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks