Help getting a Formula to get non ordered text in order

J

jbridges

I have a spreadsheet with information not formatted the way i need.
For example i want to get information 35 rows apart all the way down to

row 10000 in order on a seperate worksheet col. I have the
=ARCustomerListing.rpt!G9 which displays the correct value, but now I
need =ARCustomerListing.rpt!G44, =ARCustomerListing.rpt!G79, ect all
the way to =ARCustomerListing.rpt!G10000. Is there an easy way to do
this? I have to do this for alot of information. I was able to
concatenate "=ARCustomerListing.rpt!G" with the correct numbers, but
you have to double click each cell and hit enter for the formula to
display the correct information.


I know i am missing something, thanks in advance.
 
B

Biff

Hi!

Try this:

=OFFSET(ARCustomerListing.rpt!G$9,(ROWS($1:1)-1)*35,,)

Copy down as needed.

Biff
 
J

jbridges

Thanks a bunch, that worked perfect, i would have never found that
offset function, or thought to use a 1:1 array the way you did. You
are an excel guru
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formula to Display cell contents rows apart in order in a new col? 1
Formula to produced a Cumulative Delivered/Ordered figure 3
Compare two different workbook sheet to show the difference in text 0
Help with Time in formula 2
using a formula to create an ordered purchase order 5
Help with formula 3
Getting a formula to reflect added columns 10
Truly duplicating a sheet in a workbook? 0

Top