Results 1 to 12 of 12

Do calculation in same coloumn for datas from various coloumns and save results

Threaded View

GMara Do calculation in same... 09-30-2008, 05:31 AM
StephenR Why do you have to use the... 09-30-2008, 08:15 AM
Mark@Work Keep the calculation streams... 09-30-2008, 08:36 AM
GMara Hi StephenR, I have 60... 09-30-2008, 08:36 AM
Mark@Work Attached is a spreadsheet... 09-30-2008, 08:51 AM
GMara Hi Mark, Thanks, but this... 09-30-2008, 09:19 AM
StephenR What's the objection to using... 09-30-2008, 10:10 AM
GMara The only objection is that my... 10-03-2008, 03:32 AM
StephenR Perhaps if you point out that... 10-03-2008, 05:45 AM
GMara It is more difficult to cange... 10-03-2008, 09:16 AM
StephenR Ho ho, I sympathise. If only... 10-03-2008, 02:05 PM
ChemistB As Stephen said, it is... 10-03-2008, 02:34 PM
  1. #1
    Registered User
    Join Date
    09-30-2008
    Location
    Armenia
    Posts
    7

    Do calculation in same coloumn for datas from various coloumns and save results

    Hi all,

    Could you please help me with following:

    I'm using Excel 2003.
    I have three worksheets in my workbook:
    1. "Data" - to insert datas
    2. "Calculation" - to do calculation with datas
    3. "Results" - to save results of calculation.

    There are two columns in "Data" with simple numbers: column "A" and "B".
    My issue is to do calculation in column "A" of worksheet "Calculation" for datas in column "A" of "Data" worksheet and save results in column "A" of worksheet "Results" then do same calculation in same column "A" of worksheet "Calculation" for datas in column "B" of "Data" worksheet and save results in column "B" of worksheet "Result".

    I know this could be done using VBA but my issue is to solve this using only Excel's features.

    Attached you can find .xls file with simple example.

    Thanks in advance
    GMara.
    Attached Files Attached Files
    Last edited by GMara; 09-30-2008 at 05:34 AM.

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