Attachment 415155
The above document is just an example. The real document contains many equation that all use a very large data set. This is why I'm try to plug in each one of those sequences into the equation instead of just dragging the equations down. Is this possible in excel?
you have a table of data, and 1 formula off to the side, I dont really follow what you want?
Last edited by FDibbins; 08-23-2015 at 11:17 PM.
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Thank you for the reply!
Ok I tried my best to explain it in the document. Let me know if it is still unclear.
Attachment 415167
Last edited by WillFahmy; 08-23-2015 at 09:47 PM.
Array for INDEX(): Coefficients --> B5:D104
Please Login or Register to view this content.
data validation list: SequenceList -- > A5:A104
Ben Van Johnson
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks