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

How to Create a Spreadsheet Dashboard?


Select your Google Sheets account, the dashboard spreadsheet, and the new sheet you created for this app's data. Then, click the + icon beside each row, and select the correct data from your original app. http://electronicshelponline.blogspot.com/

Oct 18, 2016 | Computers & Internet

1 Answer

My MS Excel vlookup function ASCII type table contains both upper case and lower case letters, characters like ( and % or *, and numbers. It seems to return the numerical equivalent of upper case letters...


Correct a #N/A error blueup_clv.gifShow All bluedrop_clv.gifHide All This error occurs when a value is not available to a function or formula.
  1. Optionally, click the cell that displays the error, click the button that appears ooui1_za06043871.gif, and then click Show Calculation Steps if it appears.
  2. Review the following possible causes and solutions. blueup_clv.gifMissing data, and #N/A or NA() has been entered in its place
    Replace #N/A with new data.
    Note You can enter #N/A in those cells where data is not yet available. Formulas that refer to those cells will then return #N/A instead of attempting to calculate a value.
    blueup_clv.gifGiving an inappropriate value for the lookup_value argument in the HLOOKUP, LOOKUP, MATCH, or VLOOKUP worksheet function
    Make sure that the lookup_value argument (argument: The values that a function uses to perform operations or calculations. The type of argument a function uses is specific to the function. Common arguments that are used within functions include numbers, text, cell references, and names.) is the correct type of value — for example, a value or a cell reference, but not a range reference. blueup_clv.gifUsing the VLOOKUP, HLOOKUP, or MATCH worksheet function to locate a value in an unsorted table
    By default, functions that look up information in tables must be sorted in ascending order. However, the VLOOKUP and HLOOKUP worksheet functions contain a range_lookup argument (argument: The values that a function uses to perform operations or calculations. The type of argument a function uses is specific to the function. Common arguments that are used within functions include numbers, text, cell references, and names.) that instructs the function to find an exact match even if the table is not sorted. To find an exact match, set the range_lookup argument to FALSE. The MATCH worksheet function contains a match_type argument that specifies the order the list must be sorted in to find a match. If the function cannot find a match, try changing the match_type argument. To find an exact match, set the match_type argument to 0.
    blueup_clv.gifUsing an argument in an array formula that is not the same number of rows or columns as the range that contains the array formula
    If the array formula (array formula: A formula that performs multiple calculations on one or more sets of values, and then returns either a single result or multiple results. Array formulas are enclosed between braces { } and are entered by pressing CTRL+SHIFT+ENTER.) has been entered into multiple cells, make sure that the ranges referenced by the formula have the same number of rows and columns, or enter the array formula into fewer cells. For example, if the array formula has been entered into a range 15 rows high (C1:C15) and the formula refers to a range 10 rows high (A1:A10), the range C11:C15 will display #N/A. To correct this error, enter the formula into a smaller range (for example, C1:C10), or change the range to which the formula refers to the same number of rows (for example, A1:A15).
    blueup_clv.gifOmitting one or more required arguments from a built-in or custom worksheet function
    Enter all arguments (argument: The values that a function uses to perform operations or calculations. The type of argument a function uses is specific to the function. Common arguments that are used within functions include numbers, text, cell references, and names.) in the function.
    blueup_clv.gifUsing a custom worksheet function that is not available
    Make sure that the workbook that contains the worksheet function is open and the function is working properly.
    blueup_clv.gifRunning a macro that enters a function that returns #N/A
    Make sure that the arguments (argument: The values that a function uses to perform operations or calculations. The type of argument a function uses is specific to the function. Common arguments that are used within functions include numbers, text, cell references, and names.) in the function are correct and in the correct position.

Oct 31, 2008 | Computers & Internet

Tip

Free Alternative to Microsoft Word or Office


Ok – so you have just bought your new computer and your trial of Microsoft Office has expired or you have no Office type application on your computer.

You have no choice but to pay up for the full version or purchase the software because you need Microsoft Word or PowerPoint or one or other of these applications. These are essential to your use of the computer and there is no real alternative - right?

Well, this Tip points to a very good reliable and completely free alternative. Open Office includes powerful applications for making text documents, spreadsheets, presentations, diagrams, and databases, as well as PDF, HTML and XML documents


Open Office is a software package that has been around and under constant development and improvement for over 20 years. If you are familiar with Microsoft Word or other similar Office applications then you will take to this software straight away.

It is designed to be user friendly and despite the fact that it is free, it emulates the look and feel of other expensive software packages.

Most impressively – it is Completely Free to use!


Main Points.
OpenOffice.org contains all the software you will need in one single package.
  • User friendly - uses familiar screens and menus which are easy to adapt to.

  • The software has extensive compatibility with Windows, Mac, Solaris and Linux OS.

  • This software contains absolutely no 'nags', Adware or Spyware.

  • Updates to the software are available several times per year at no cost.

  • Is 'Open Source' Programming – i.e. contains no hidden codes.

  • Can be reported on by any user for suggestions to improve the overall interface or functionality.

  • Files can be saved in several different file formats including the .doc format used by Microsoft Word. This ensures extensive compatibility for documents which for example, may need to be opened by Microsoft Word on another computer.

  • The program even has capability to export documents into the PDF format which allows compatibility with Adobe software and the ability to create PDF documents.

  • Open Office has the capability to read existing documents which were created in another software program. It has even been known to open old Word version documents or corrupted documents that MS Word itself could not open.

  • Best of all, OpenOffice.org 3 can be downloaded and used entirely free of any licence fees.

  • OpenOffice.org 3 is released under the LGPL licence. This means you may use it for any purpose - domestic, commercial, educational, public administration. You may install it on as many computers as you like.

  • Provides support for multiple languages and text formats.



What Does the Package Consist Of?

1) WriterA fully equipped word processor similar to Microsoft Word.

2) CalcA comprehensive spreadsheet application similar to MS Excel.

3) ImpressA multimedia application similar in functionality to MS PowerPoint.

4) DrawGraphics and Diagrams to display anything from a simple sketch to a complex plan.

5) BaseA Data Base Application similar to MS Access.

Further information on the software listed in 1-5 is available to view here.

Open Office is a stable and extremely impressive alternative to expensive software packages. The total download requires around 150 MB of disk space.

Hope this Tip helps and may save you a few bucks! If so – please do leave a vote for it.

Thanks.

on Feb 11, 2010 | Computers & Internet

1 Answer

Need command prompt for Acer Aspire


The Windows Backup and Restore feature allows you to save files and system images to external backup devices such as hard drives and flash drives. However, backing up files become problematic if the directory your backing up files from isn't configured properly, or if you're having issues with the devices you're backing files to. There are ways to solve or work around backup problems quickly and safely.

Hard Drive b> A backup will not complete if the files you're backing up exceed the amount of space left on the external hard drive. If you're backing up large system files, Microsoft recommends saving the backup to an external hard drive that can hold at least 200 GB. If you're running out of space, you must delete content to create space for others or use another hard drive. Error Codes In some cases, Windows displays the following error codes when it's unable to complete a backup: "0x80070001 (Invalid Function)" or "0x81000037: Windows Backup failed while trying to read from the shadow copy on one of the volumes being backed up." These error messages usually appear if Windows is unable to backup a specific library or if you opt out of adjusting your backup settings and settle for the default settings in the Windows Backup and Restore Feature. Reparse Point b> If you're unable to backup a specific library and run into error code messages, removing the reparse point allows you to complete the backup. A reparse point is a file that contains information about the user on a computer. If it doesn't point to a location that contains some of the data you want to backup, error messages appear when you try to back up your files. Type "CMD" in the Start Search box to open the Command Prompt. In the Command Prompt, typing "DIR /AL /S" and pressing Enter lists the reparse points. Each entry says "JUNCTION," which also means reparse point. The entries also tell you the location of the reparse points in Windows Explorer. If you locate a specific reparse point in Windows Explorer, delete its mounted volume from the device's Properties. Once deleted, you should be able to back up your files. Discs b> If you're backing up files to a disc, you'll run into problems if the discs are non-rewritable and already contain data, or if they are severely scratched or damaged. Non-rewritable discs can only be used once, while rewritable discs can be used to read and write data several times. If the CD or DVD you're using is severely scratched, the optical disc drive spins harder than usual in an attempt to read it. If it's incapable of reading the disc, the backup feature may freeze or display an error.
Windows backup or restore errors 0x80070001, 0x81000037, or 0x80070003
http://support.microsoft.com/kb/973455 - workaroundissue12

Apr 20, 2013 | Computers & Internet

2 Answers

Super,super slow computer


Don't worry please just follow the easy steps and fix your problem
  • Use the defragmentation tool (defrag). A hard drive consists of hundreds of sectors which or broken up into clusters and then further into allocations. As a computer gets used the files that are accessed are sometimes not put back to the sector or allocation unit where they belong. The drive becomes “fragmented”. The defrag tool can be accessed by going to the start bar, to programs, accessories, system tools and defragmentation tool. It may take several hours to properly defrag a hard drive, but the resulting gain in speed will make this time well spent. Files will be more quickly accessed and all of the bad sectors on a disk will not contain any information on them. Hence, a user will not wait in vain for a file that is stuck on a bad part of the hard drive.
  • Use registry fix programs. The computer registry can be described as the database that contains all of the settings and options for 32 bit versions of Microsoft Windows (including Windows 95, 98, ME, NT, XP, and 2000.) It also contains all of the settings for the hardware, software, users, and preferences of the P.C. Whenever a user makes changes in the Control Panel settings, file associations, system policies, or installed software, the changes are reflected in the computers registry. Many times a registry error occurs and this causes files and data to be inaccessible. If there are numerous minor errors (which is usually the case) a registry fix program will get the data back in accessible sequence and a slow computer will be speeded up with this fix.
  • Adding more RAM (random access memory) to your system will almost always help speed up a slow computer and the act of multi-tasking will not bog down the computer as it would with a lower amount of RAM. RAM is hardware that needs to be physically added and tends to be somewhat costly. However if you plan on keeping your system for a while it is an excellent investment.
  • For faster browsing speed clear your Internet cache (temporary internet files) and delete your cookies. This causes the computer to gain speed on the Internet and the pop-ups from sites that you have been to will also be less frequent.
  • Remove unnecessary items from the start menu. To do this type “msconfig” in the “run” box and hit enter. Choose selective startup and uncheck all of the programs that you do not need to load every time you start your computer. This will make the computer start more quickly and efficiently. DO NOT uncheck items that you do not recognize. This could cause you computer to run improperly.
  • Use a browser with an integrated pop-up blocker (Firefox for example) to decrease the amount of pop-ups and increase browsing speed.
  • Constantly scan for viruses and Trojans. Trojans can be on a system for weeks even months unbeknownst to the user causing major slowdowns and file errors. Try using a specific Trojan scanner instead of the conventional virus all-purpose scanner. Many Trojans slip past the “big name” virus scanners and need to be sought out specifically to be removed.
Please rate me if this solution works for you

Thanks......Have a great time.

Jul 20, 2010 | Gateway GT5692 Desktop Computer

1 Answer

Can't copy dvd or cd , the cd rom drive would not recognize any cd's


it's possible that the CDROM drive is bad. Since it's an IDE device, it would be easy to replace. Simply get another DVD-RW device (might as well upgrade!) and open the case. Needless to say, you want the machine off for this process.

Open the case, disconnect the power and data cables from the back of the CDROM. Unscrew the holding screws and slide out the drive. Replace the drive with the DVD-RW, line it up and replace the screws. Then connect the data and power cables...be careful with the data cable to make sure that you don't "miss" a row of pins.

Put the case back together and turn on the machine. XP should automatically recognize the drive.

Mar 07, 2010 | Gateway 831GM PC Desktop

2 Answers

Cannot insert columns in excel spreadsheet. Comes up with error cannot shift object off sheet


This error message occurs if the following conditions are true:
  • The option Nothing (hide objects) is selected in the Display options for this workbook section in the Excel Options dialog box.
  • You create an object, such as a cell comment, in any cell in a column.
  • You try to hide the column to the left of the column that contains the object, the column that contains the object, or all the columns to the right side of the column that contains the object. Or, in some cases, you try to insert a row or column in the worksheet.
There are two ways to fix this problem.
Method 1:  Temporarily toggle the option from "Nothing (hide objects)" to All In Excel 2007, temporarily toggle the option from Nothing (hide objects) to All, and then insert the rows or columns as needed. To do this, follow these steps:
  1. In the upper-left corner of the Excel window, click the Microsoft Office button.
  2. At the bottom of the menu, click Excel Options.
  3. Click Advanced from list of options on the left.
  4. Scroll down to the Display options for this workbook section, and then click All under For objects, show:, and then click OK.
Notes To use the keyboard shortcut to toggle this selection, press CTRL+6. 
If these steps do not let you hide rows or columns or insert rows or columns in Excel 2007, try the steps in method 2.
Method 2: Change the position property of the object to Move and size with cells To work around this issue, Excel 2003, Excel 2002, and Excel 2000, change the position property of the object to Move and size with cells. To do this, follow these steps:
  1. If the object is a cell comment, select the cell that contains the comment, right-click the cell, and then click Show Comment or Show/Hide Comments. Note This makes the comment visible.
  2. Move the pointer to the edge of the object until the pointer changes into a white arrow with four small black arrows on the pointer. Then, click the object to select it.
  3. In Excel 2003 and earlier version of Excel, click <object name> on the Format menu. Note In this menu command, <object name> is the name of the object, such as "Comment" or "AutoShape."  In Excel 2007, click Format <object name>.
  4. In the Format dialog box, click the Properties tab.
  5. Click Move and size with cells, and then click OK.
  6. If you want to hide the cell comment again, right-click the cell that contains the comment, and then click Hide Comment.
  7. Follow these steps for each object in the affected column as described in the "Cause" section. When you hide the columns, you do not receive the error message.
For more information, visit the Microsoft Knowledge Base article: http://support.microsoft.com/kb/211769

Nov 06, 2008 | Computers & Internet

1 Answer

I get the following message when i try open an excel spreadsheet. i cannot see and info on the sheet. Compatibility Report for Info2008.xls Run on 10/17/2008 18:01 The following features in...


Either you need to upgrade your version of Excel or the person creating the spreadsheet needs to save it in a format for compatability. For example, the person who created the workbook simply needs to do File and Save As. Under type, one can choose a format for older versions of Excel.

Hope this helps!

Oct 18, 2008 | Computers & Internet

1 Answer

The license key to spreadsheet professional program is not being recognized. I typed in the number about 20 times, and all I get is a message saying that the number I entered is not correct


first make sure that you follow any letter casing(small/capital) exactly like it looks
second be careful with certain letter and numbers that look alike suchs as i,L,1. try each of these if you are not sure which one it is
third, try removing anything you have installed so far for the spreadsheet program and try to reinstall it

fourth, the only other legal option is to contact the manufacturer to obtain a valid license key

Jul 15, 2008 | Computers & Internet

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

Related Topics:

71 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

98796 Answers

David Payne
David Payne

Level 3 Expert

14071 Answers

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

Answer questions

Manuals & User Guides

Loading...