+ Reply to Thread
Results 1 to 8 of 8

Excel 2007 : Output Data list based on multiple input data

  1. #1
    Registered User
    Join Date
    05-08-2012
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    4

    Output Data list based on multiple input data

    Hi All,

    My problem is:
    I have a data in sheet1 column A,B,C and D (all numbers and >10000rows).
    For analysis on this data, i put additional input data in cell e1 and e2 (both numbers).
    I uses columns F,g and h for my analysis formulas.
    Out put of Analyzed data is written in cell e3.

    On sheet2 i have a list of different combination of e1 and e2 s values in column A and B (around 1000 rows).

    Now problem is that, I need to populate Column C Sheet2 with corresponding values of e3 and I don't know how can i do this?
    One additional condition is that for each combination of e1 and e2, analysis takes around 5second to generate e3.


    Thanks in Advance

    agoelg

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    21,700

    Re: Output Data list based on multiple input data

    What is the relationship between e1, e2 and e3? How do these relate to your data in columns A to D ? It would be better if you could post an example workbook with a clearer explanation of what you want to achieve.

    Hope this helps.

    Pete

  3. #3
    Registered User
    Join Date
    05-08-2012
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    4

    Re: Output Data list based on multiple input data

    Hi Pete,

    I have created a sample workbook to explain my problem.

    You can see in attached workbook i manually do following things:
    1. enter input data in sheet1 cell e1 and e2, taken from sheet2 column A and B (row 1,2,....)
    2. when output come in sheet1 cell e3, i copy it and paste (by value) in sheet2 column C (corresponding row).

    What i want is to automate this procedure.


    agoelg
    Attached Files Attached Files

  4. #4
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    21,700

    Re: Output Data list based on multiple input data

    Put this formula in C2 of Sheet2:

    =SQRT((SUM(Sheet1!C$1:C$10000)+(SUM(Sheet1!B$1:B$10000)+SUM(Sheet1!A$1:A$10000))/A2)/B2)

    then copy down - an easy way to do this is with C2 selected, double-click the fill handle, which is the small black square in the bottom right corner of the cursor.

    Hope this helps.

    Pete

  5. #5
    Registered User
    Join Date
    05-08-2012
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    4

    Re: Output Data list based on multiple input data

    I have crated only a sample workbook for purpose of describe my problem.

    In actual workbook, it contains around 20MB of data and very complex multistage analysis.
    But as per my problem description final result or final smallest formula is written in Sheet1 cell e3.


    I can copy last e3 formula in sheet2 as suggested above but can not copy entire analysis.


    agoelg

  6. #6
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    21,700

    Re: Output Data list based on multiple input data

    So, what do you want me to do, then?

    Pete

  7. #7
    Registered User
    Join Date
    05-08-2012
    Location
    India
    MS-Off Ver
    Excel 2007
    Posts
    4

    Re: Output Data list based on multiple input data

    I requires to automate that
    1. take Input data for cell e1 and e2 (sheet1) from column A, B on sheet2 and row x (2,3,4,....); then wait for 10-15 second; then copy output data in cell e3 sheet1 to column C row x of sheet2.
    2. do step 1 one by one for each row in sheet2.



    agoelg

  8. #8
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    21,700

    Re: Output Data list based on multiple input data

    Well, that seems like a strange way of doing things.

    Anyway, I'm away later today for a few days, so I won't be able to help anymore on this.

    Pete

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Bookmarks

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