I have worksheet A with 5 columns of information and 10 rows. I have worksheet B with just one column of information and multiple rows. Column A in both...

In cell E2, I would like a formula which will generate a "Y" if the item in cell C2 is taxable, and a "N" if the item in cell C2 is not taxable . The items...

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...

I have two columns that I need to count up the values of. One column is a "Status" column that either have the values or "Live" or "Expired". The second...

I have this formula in L20 that works one place and not the other: =IF(F20=0,"",IF(F20=1,1,AVERAGE(IF(F15:F190,F15:F19)))) On one worksheet the number in...

I am trying to format cells that when you put a date in the dates prefill across. So if you type in 9-1-08 in A-10; B-10 would read 9-2-08, C-10 would read...

data A 1-41 2-19 3-12 4-80 5-36 numbers continue to be added in the column above. If I add another number, I want it to be placed in another column i.e. k50.

I am multiplying two cells to get a result in a third cell. the result comes out to be 18.525. I format the decimal to show only two numbers, like 18.53...

Hello, this is my excel problem. I have a table so structured (I add holiday column to explain my question, but originally there is not in the table)...

Here is a weird situation... I received a workbook for a project. In one worksheet I have data fin two different categories for each month of year for 1999...

I have a list of names with check boxes next to it. I want to create a list of the names on the same sheet of all checked boxes without blank rows. I can...

Hoping Dan is out there! I needed to make a couple of changes to my data set, and cannot get my equation to work correctly. Know that it took 8116 hrs to...

I am new, so bear with me. I have Excel 2003. I have started a spreadsheet with the following parameters: Rows 1-15 (clients) have monetary values for...

I am using an excel purchase order template. Each time I open a purchase order, the template changes the original date to the current date. How do I turn...

OK, I am a little hungover this morning after a party last night in downtown Denver after the DNC. Free drinks does not mean you have to drink EVERYTHING. ...

I am trying to copy a list file and change 2 columns around. When I copy and paste or cut and paste, I end up with less pages. The margins are the same and...

I AM HAVING A PROBLEM WITH THE SPEED OF SORTING A SPREADSHEET AS QUICKLY AS I USED TO. MY SPREADSHEET IS ABOUT 12,460 LINES LONG WITH THREE COLUMNS.IT IS A...

Hi Everyone, I have a file that has about 6727 rows. I need to count up how many times the addresses in a particular column (A) is repeated. I've already...

there seem to be a lot of postings to do with Named Range Copying ... but I have not found a simple answer to this... I have a set of named ranges (data1,...

Hi, I'm wanting to set certain cells on my worksheet to change colour if I enter text into a certain cell on the same row. For example I would cell B2 to...