General

Excel 2007 - Consolidation question
Hi, I have three worksheets, set up identically. I created a fourth worksheet which was to capture the totals of the other three. To do this, I used Data>Consolidation and then put in the references to the sheets and ranges. No problem there. Now I am changing figures in the first three worksheets, but t... 23 Jul 2008 19:29

Excel limitations
Is there a limitation to Excel to perform well or become corrupt in terms of: Size of the file Columns & rows used in teh file Number of worksheets used in the file Any other limitations. Thank you ... 8 Jul 2008 11:03

how do i get rs format in excel? or is there any chance to add ou.
can any one please tell me how to add rs format currency in excel? ... 10 Jul 2008 04:09

How do I round up the answer an iferror formula?
... 8 Jul 2008 00:49

Another Parsing address question
I was able to figure out how to parse out the house no. from an address but am stuck on how to treat those addresses that are missing a house no. For example, if the address shows up as 123 Main Street, then the formula results in 123 - just as I want it. however, if the address shows up as just "Main Stree... 8 Jul 2008 19:16

Text match from web query
Hi, My spreadsheet grabs data through web query to display the following table: 16/5 Engine Nut 22.5 11.2 32.5 16/5 Exhaust SCREW 33.1 5.8 12.3 16/5 Radiator Bolt 14.6 12.2 23.2 21/5 Screw ENGINE 8.6 11.4 21.8 21/5 NUT Bolt 26.5 17.9 11.4 21/5 Exhaust Radiator 9.2 12.5 18.8 How do i formulate in a differen... 7 Jul 2008 22:47

Custom format numbers
I did ask this question before, but did not get an answer. How can I display 0.01 as 1 0r 10 or 100 i.e. how can I custom format numbers to display them as higher numbers i.e. shift decimal to the right? Would appreciate a solution a lot! ... 9 Jul 2008 20:56

sequence of input
I have trouble with changing the sequence of my input into a cell. I am using a scanner to put in numbers into the cells and it goes from one row to the other, however I need it to go from one column to the other and stop at a certain point e.g it needs to go from a2 to b2 c2 d2 a3 b3 d3 a4 and so on . How do ... 7 Jul 2008 23:48

Turn off grey background in picture
I have an Excel 2003 file that has a transparent picture embedded in a worksheet. In most of my machines, the transparency looks fine. In one machine, however, the picture has this grey background that obscures the cells behind it. This grey background even shows up in Print Preview and on hardcopy printouts. I... 7 Jul 2008 21:46

Johnranges function.
Its my first time using Excel 2007. In the old versions a function called "Johnranges" - This doesnt exist in the 2007 version. Does anyone know whether this has been replaced with another function in the newer version? ... 7 Jul 2008 22:47