Contact US

Log In

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Array Programming in Excel

Array Programming in Excel

Array Programming in Excel

I am trying to generate a list of results from a list of values by plugging each value into a formula to calculate the result. My list of values is quite extensive so I would like to have Excel increment through the list and produce a result for each, thus generating a respective list of results. Does anyone know how I might accomplish this using Excel? Any help I get will be greatly appreciated. Thanks.


RE: Array Programming in Excel


Not certain of how your tables are laid out, but this is what I did
A1 I enter 1
A2 I enter 2
A10 I enter 10

Then I run this code

Dim MY_RESULT(65536) As Variant
For MY_ROWS = 1 To Range("A65536").End(xlUp).Row
    MY_RESULT(MY_ROWS) = Range("A" & MY_ROWS) * 2
    Range("B" & MY_ROWS).Value = MY_RESULT(MY_ROWS)
End Sub

IS this of an use?

Hope this helps.

maybe only a drafter
but the best user at this company!

RE: Array Programming in Excel

Yes, Thanks. I will give it a try.

RE: Array Programming in Excel

i'd investigate the autofilter capabilities within excel.

from main menu, select Data - Autofilter.

the data must be in continuous rows or at least select teh entire range of data when activating this command.  would be helpful if each column had a title.

use xl's help system for further explanation of the autofilter command.

good luck!

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Eng-Tips Forums free from inappropriate posts.
The Eng-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members! Already a Member? Login


Close Box

Join Eng-Tips® Today!

Join your peers on the Internet's largest technical engineering professional community.
It's easy to join and it's free.

Here's Why Members Love Eng-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close