I have two worksheets. SHEET1: A B 1.1 1.2 1.3 1.4 SHEET2:

good morning everybody........... i have 2 columns col C col D # in household income percent 2 50% 1 ...

I am trying to perform a task in excell. I have a list of names for products in col B. In col. C I have a list of prices. I need to know how when I use drop...

how to know the original creator of one excel?

Hello... I need some help... not sure how to do the following: I have a spreadsheet that contains a drop down list in column B (note only various rows in...

Hi I have a list of addresses some of the addresses have more lines in them than others see below. A B C D ...

I am setting up a Invoice and I want to be able to add a new row whenever the second last one is used. ( the last one contains the totals ) ie: if row 22 is...

I have some employee data from two different sources (on two separate tabs). On 3rd tab, I'd like to show if the data is on sheet A , but not on sheet B,...

I have a spreadsheet in which I keep track of expenditure. I need to be able to provide end of quarter balances. However there is a complication. In any...

Is there a way to use the fill handle to autofill, but do so without changing the formatting of the cells--adding data only? I'm trying to avoid having the...

I have a large data set that I'm copying from Access into Excel. There are blank rows between the data I want to analyze. Is there a way to quickly delete...

I would like to concatenate cells from a column based on the match in the preceding column with a defined value. Example: Col. A B Row1: ...

i have a column (column B) of cells with numbers in the cells. i want to count for. example, how many cells have a number between 12 and 29. i used...

When I want to use a list from a separate tab in Excel for drop down choices I'm not able to Ctrl / Page Down to another tab in the excel workbook to select...

In Excel 2007, I want a column (C) to conditional color fill a cell if the corresponding cell in (B) contains a certain word. I an't get the conditional...

I'm trying to create a 'check register' with budget worksheets where the amount entered in the check register will automatically populate the appropriate...

To: All pundits in Microsoft Excel From: Ken Spencer in Zimbabwe (Email: ) Subject: Kindly requests help on Microsoft Excel. Date: 8...

I have a tranpose issue. Current Data Display: 100 101 200 201 300 301 Needs to be displayed: 100 101 200 201 300 301

I HAVE A WORK BOOK WITH RAND VALUES AND I NEED TO SHOULD THESE VALUES IN WORDS AS WELL.

Can anyone help with a formula to separate a field containing numbers and letters into numbers per below? I only know how to use for eg =left(X,x) but that...