General

Seperate text and numbers in a column?
Hi, could anyone help me out with the following: I've got a column which contains addresses (e.g. A1 = mountainroad 17 , A2 = mainstreet 168a , etc.) In order to work with this data I will need to seperate the streetnames from the housenumbers. Would anyone have a suggestion on how to do this? As there... 10 Feb 2010 14:34

optimum method to print rows as columns
looking to convert each spreadsheet row to print as a column per page -- Concord ... 10 Feb 2010 16:50

ASAP bout pivot table
Hi all... simple question about pivot table i have 2 column names fruit reza apple reza orange reza apple what i want to do, create pivot table with results reza apple 1 orange 1 but when i created that, the result is: reza apple 2 orange 1 th... 10 Feb 2010 08:53

Help with lookup and formulas
Im having some issues with some formulas Im trying to put together. Here is the starting project: Sheet 1 contains a list of all equipment available arranged by equipment type and includes all of the equipment I might be interested in. Sheet 2 contains a rollup of all equipment with company possessing such ... 10 Feb 2010 02:20

Unique Random Numbers
How can a series of unique, whole number, random numbers be generated so that no two numbers are alike? ... 10 Feb 2010 04:30

Can RGB fill color be automated based on 3 cell values?
Is there any way to automatically adjust the fill color of a cell based on 3 values entered into 3 cells? Specifically, if I have entered the values 100, 120, and 50 into cells A1, A2, and A3, respectively, is there a way to automatically fill cell A4 with the RGB color Red=100, Green=120, Blue=50? ... 10 Feb 2010 06:42

Fill Series
Hi The sheet isn't protected. The Series command is available but Excel doesn't allow me to click on it. Why is that so? Thanks ----------------------------------------------------------------------------- Invalid or "unavailable"? Is the sheet protected? Gord Dibben MS Excel MVP On Mon, 8 F... 10 Feb 2010 11:09

Need help with a formula
Here is my problem. I have to enter apt # on a spreadsheet for tracking material used. The problem is I am always finding duplicates. What I would like to be able to do is this. Enter the unit number ain a single cell. That will then move to a specific row in numeric order. If i enter a number that already been ... 10 Feb 2010 03:25

Oracle Extract in Excel 2007 causes processor to run at 100%
I receive an excel file from our invtentory group that is an extract from Oracle. The file has two tabs, if I navigate to a particular one my machine is basically locked up for many minutes. The tab in question only has 5 columns and less than 50 rows. There must be something there I can't see. Anyone have any ... 9 Feb 2010 21:56

help please what am i doing wrong?
Hi Again folks, Got yet another stupid question here. I have a worksheet on which I am adding up a coloumn. Simple right lol =sum(a1,a9) when I do this I only get the formula not the answer. I know I am missing something stupid but what. ... 9 Feb 2010 18:35