Question about Computers & Internet

7 Answers

I am trying to run a spreadsheet where sheet1 contains hundreds of rows of data. I want sheet3 to recognize several of the cols as the data changes from row to row, process the calculations, and show the results at the end of each row of sheet1. When I define the relative cell references in sheet 3 to the cells in the first row of sheet1, only that row’s data is recognized and processed. Every row shows the same result from row 1’s data. How do I get sheet 3 to vary the data row by row from sheet1? Thanks.

Posted by on

  • 3 more comments 
  • grippy Jun 30, 2008

    It appears to me that excel tries to resolve the calculation results of every cell in every connected spreadsheet immediately. There must be a way you can use the same calculation sheet exactly as it is with variable data passed row by row from the main sheet without causing circular reference errors. That's my problem.

  • grippy Jun 30, 2008

    vlookup requires that you have data to look up to retrieve other data. My calc sheet3 doesn't have lookup data. Sheet1 contains 100 rows of stock data. The rows contain price and a few other numbers I need in the calc sheet3. So I need to retrieve row 1's data from sheet1, process in sheet3, print results in same row of sheet1, and do it for every row of sheet1.

  • grippy Jun 30, 2008

    Thanks, but I don't believe it's the same situation. I don't have a lookup field. I tried using sequential numbers from 1 to 100 on each of my rows, but can't figure out how to keep the result on the calc sheet3 for each row long enough to show it on sheet1. Excel processes quickly through and shows the row 100 result on every sheet1 row.

  • grippy Jun 30, 2008

    My "expert" advice so far hasn't been very "expert". The suggestions show me that the "experts" aren't very "expert", or aren't understanding my stated problem. Before answering, please read it carefully. Thanks.

  • grippy Jun 30, 2008

    The last suggestion of restructuring to 1 worksheet may be what I have to do. I'll take another look. Hopefully I won't have to do this. Thanks.

×

7 Answers

  • Level 3:

    An expert who has achieved level 3 by getting 1000 points

    All-Star:

    An expert that got 10 achievements.

    MVP:

    An expert that got 5 achievements.

    Master:

    An expert who has achieved Level 3.

  • Master
  • 638 Answers

Marked is given u a proper guidance.it should help u.

Posted on Jun 30, 2008

  • Level 3:

    An expert who has achieved level 3 by getting 1000 points

    Superstar:

    An expert that got 20 achievements.

    All-Star:

    An expert that got 10 achievements.

    MVP:

    An expert that got 5 achievements.

  • Master
  • 4,889 Answers

Pls upload the copy of the excel file somewhere and get us the link so that we can see you through this..

Posted on Jun 30, 2008

  • eagle338
    eagle338 Jul 06, 2008

    Hi grippy! Did marked's solution work or you need more help.. Let us know..

×

  • Level 3:

    An expert who has achieved level 3 by getting 1000 points

    All-Star:

    An expert that got 10 achievements.

    MVP:

    An expert that got 5 achievements.

    Brigadier General:

    An expert that has over 10,000 points.

  • Master
  • 6,966 Answers

Hi,

Would it be possible for your to post a copy of said Excel file?

Pls post back as requested or should you need additional information.

Good luck and kind regards.

Thank you for using FixYa.

Posted on Jun 30, 2008

  • Level 3:

    An expert who has achieved level 3 by getting 1000 points

    Superstar:

    An expert that got 20 achievements.

    All-Star:

    An expert that got 10 achievements.

    MVP:

    An expert that got 5 achievements.

  • Master
  • 4,472 Answers

Couldn't you do this all from one sheet if you restructured it?
thanks,
Lee

Posted on Jun 30, 2008

  • Level 2:

    An expert who has achieved level 2 by getting 100 points

    Hot-Shot:

    An expert who has answered 20 questions.

    Corporal:

    An expert that has over 10 points.

    Mayor:

    An expert whose answer got voted for 2 times.

  • Expert
  • 92 Answers

Highlight, copy paste?

Posted on Jun 30, 2008

  • Level 3:

    An expert who has achieved level 3 by getting 1000 points

    All-Star:

    An expert that got 10 achievements.

    MVP:

    An expert that got 5 achievements.

    Brigadier General:

    An expert that has over 10,000 points.

  • Master
  • 3,614 Answers

Like MARKED say's; you should use a VLOOKUP, that's also the formula i used when i input & compute the grades of my students in every Exam period.

Posted on Jun 30, 2008

  • Level 3:

    An expert who has achieved level 3 by getting 1000 points

    Superstar:

    An expert that got 20 achievements.

    All-Star:

    An expert that got 10 achievements.

    MVP:

    An expert that got 5 achievements.

  • Master
  • 6,487 Answers

Try using VLOOKUP if you're not familiar with that check this link :
http://www.timeatlas.com/mos/5_Minute_Tips/General/Learning_VLOOKUP_in_Excel/

Hope that helps........

Posted on Jun 30, 2008

  • Mark Gil
    Mark Gil Jun 30, 2008

    Yup VLOOKUP is really the one so better try understanding it first so you can use very well for that concern....

×

1 Suggested Answer

6ya6ya
  • 2 Answers

SOURCE: I have freestanding Series 8 dishwasher. Lately during the filling cycle water hammer is occurring. How can this be resolved

Hi,
a 6ya expert can help you resolve that issue over the phone in a minute or two.
best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
the service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (for users in the US for now) and get all the help you need.
goodluck!

Posted on Jan 02, 2017

Add Your Answer

Uploading: 0%

my-video-file.mp4

Complete. Click "Add" to insert your video. Add

×

Loading...
Loading...

Related Questions:

1 Answer

Excel Spreadsheet question


cells are referenced by column and row. columns use a letter reference and rows use a number reference. to reference pages use the page name. For example if you are entering a formula in a cell on a page named sheet2 and part of the information is located on the page named sheet1, you would use a reference as follows:

sheet1!C3 This reference is for the cell on the page named sheet1 in the third column and the third row.

Hope this helps

Apr 09, 2014 | Microsoft Excel for PC

2 Answers

How to make a 7 row and a 7 coloum in a spreadsheet


Creating a table in Microsoft Excel 2007 allows you to work with that data independently of the rest of the worksheet. First you must define your table, though, which you can do either from scratch or from data already in the worksheet. The process is a simple one. Read on to learn how to define a table in Excel 2007
  • Start off by doing one of the following: Select the range of cells that you want to make into a table within your worksheet then proceed to Step 2 OR Start immediately with Step 2.

  • Click on the "Insert" tab at the top of the document.

  • Find the "Tables" group, then click on "Table." The "Create Table" dialog box will appear.

  • Type in a range for your table if you did not select a range in Step 1. If you did already select a range then that range will automatically appear in the dialog box.

  • Check the "My Table Has Headers" box if the data set you selected already contains the headers you want to use. If you don't check this box, the table will display default header names, which you can then go in and change.

  • Hit the "OK" button at the bottom of the Create Table dialog box to create your table.

  • Thanks for choosing Fixya............ Sandeep

    Mar 18, 2011 | Computers & Internet

    1 Answer

    Excel formulas


    Below is the formula for "2". The logic should be obvious from this so you can adapt for "1" or a combination of 1 and 2. This need to be written as one long formula so I have pasted it in to this reply so you can do a copy and paste into your spreadsheet. Sorry its not very readable in this form but you could paste into word so you can break it down and examine structure.

    =IF(OR((AND(Sheet3!A12="WA",OR(Sheet3!AH2="Lewis",Sheet3!AH2="Pacific",Sheet3!AH2="Wahkiakum"))),(AND(Sheet3!A12="OR",OR(Sheet3!AH2="Clackmas",Sheet3!AH2="Multnomah",Sheet3!AH2="Washington")))),"X"," ")

    Aug 18, 2009 | Microsoft Office Excel 2007 Full Version...

    1 Answer

    Autofilter ceases to work on large Excel 2003 spreadsheet


    Sounds like there is a gap between the filter heading and the column data. That's the only time I've seen suggested data missing from the drop-down.

    Jun 16, 2009 | Microsoft Computers & Internet

    1 Answer

    Need an excel formula.


    The crude solution is:
    =IF(Sheet3!I2="WA",IF(Sheet3!H2="Vancouver","X",IF(Sheet3!H2="Camas","X",IF(Sheet3!H2="Ridgefield","X",IF(Sheet3!H2="Washougal","X",IF(Sheet3!H2="Stevenson","X",IF(Sheet3!H2="Hockinson","X","?City?")))))),"?State?")

    Where ?City? appears when the city referenced in H2 is not part of the lookup
    and ?State? appears when something other than WA appears in I2.

    But there is probably a better way to do this using an array of valid values like the one below:

    AL NY TX WA Birmingham Albany Abilene Camas Huntsville Buffalo Galvaston Hockinson Russell New York Houston Ridgefield Stevenson Vancouver Washougal

    In the scenario you could stuff the array in another worksheet and use the HLookup function to find the "Sheet3!I2" value in the first row of this array to determine which column to look in, then VLookup "Sheet3!H2" in the column of that array to see if the city referenced exists. Of course this is a much more complex formula, but it would be easily extendible without changing the formula every time.

    For mor info, see "Lookup and Reference Functions" in the Excel Help.

    Jun 11, 2009 | Microsoft Excel for PC

    1 Answer

    Unable to complete merge process.


    Make sure you have closed the "data source" your excel file before trying to merge. This has been throwing different errors but not allowing the merge process to continue.

    Is your Excel data in various worksheets or in the same worksheet - And does your Excel source data contain headers in the first row. Once you have selected this from the range you will

    At what stage are you failing in the merge now?

    May 15, 2009 | Microsoft Office Professional 2007 Full...

    2 Answers

    Duplicacy in excel sheet


    Since you are searching the data by the phone number , first select all the data in the spreadsheet and sort it in ascending order by the phone number.
    Then, assuming you have 5 columns of data A through E, and the phone numbers are in column E, with row 1 occupied by column headings, use the following formula in cell F2=IF(E2=E1,"Duplicate",1)

    Drag this formula down column F till the end of your data
    Select the entire data and do an auto filter
    In column F filter the data by Duplicate and delete all these rows
    What remains should be unique data

    Dec 19, 2007 | Computers & Internet

    1 Answer

    Consolidate few sheets under 1 excel


    It is actually very simple on the new worksheet in the first row just type:
    in cell - A1: =[Book1]Sheet1!A1
    in cell - B1: =[Book1]Sheet1!B1
    in cell - C1: =[Book1]Sheet1!C1
    etc.

    Where Book1 is the worksheet(filename) and Sheet1 is the sheet with the data, just drag down the results with the magic square and continue to do so on all of your data worksheets.

    Let me know if you need more help

    and Please use our community and not emails

    Good luck

    Daniel

    Dec 18, 2007 | Microsoft Excel for PC

    5 Answers

    Formula required


    at first select the 1st page data and select data-subtotal from the upper menu list.
    then enter the formula as =sum(1stpageSubTotal,2ndpageSubTotal,3rdpageSubTotal) then Press Enter.

    If not solved pls get me that data as to reference.

    thanks

    Dec 04, 2007 | Microsoft Excel for PC

    1 Answer

    Excel Sort Across Sheets


    Hi Raymond, I have a solution for you. Asuming your 'main' sheet is Sheet1. On Sheet2, in the same line as your data on sheet1 (i.e. A5 on sheet1 is JIM), then on A5 on sheet2, enter a link ( the = ) and enter. copy this formula down. Do the same with Sheet3 linking to Sheet1. When you sort Sheet1, Sheet 2 and 3 will follow. Hope this helps. Regards DeltaC

    Sep 11, 2007 | Microsoft Office Standard for PC

    Not finding what you are looking for?
    Computers & Internet Logo

    Related Topics:

    73 people viewed this question

    Ask a Question

    Usually answered in minutes!

    Top Computers & Internet Experts

    Brian Sullivan
    Brian Sullivan

    Level 3 Expert

    27725 Answers

    kakima

    Level 3 Expert

    102366 Answers

    David Payne
    David Payne

    Level 3 Expert

    14161 Answers

    Are you a Computer and Internet Expert? Answer questions, earn points and help others

    Answer questions

    Manuals & User Guides

    Loading...