# Finding data within an array.

1. ## Finding data within an array.

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.

2. ## Re: Finding data within an array.

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.``

3. ## Re: Finding data within an array.

I did this example with more mangeable numbers:
3 steps with 5 data points per step.
It looks like this:

gannon_w.png

The data points are in B2 on down.
In C3 copied down:
Formula:
`Please Login or Register  to view this content.`
StartRow is set to 2. Change it per your needs.
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.`

4. ## Re: Finding data within an array.

Suppose your data is in column A, drag under the formula B1

HTML Code:
``=MAX(OFFSET(A\$1,(ROW(1:1)-1)*1000,,1000,))``

5. ## Re: Finding data within an array.

That's it wk9128....Thanks!!

6. ## Re: Finding data within an array.

That also works Geoff! Thanks!

7. ## Re: Finding data within an array.

Both Geoff and wk9128 got it...I can never remember the OFFSET function!

8. ## Re: Finding data within an array.

No problem, glad to help. Thanks for the rep

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1