I need some help or pointing in the right direction I'm using Excel 2003 I'm using "if statements" but the maximum i can use is 7. i need to use quite a...

in excel 2007 it seems to be a limit of 255 char. when I make a custom list. Is it possible to increase this?

Hello I need to compare a number in one cell to a date in another to see if they match (I am matching the day in the date). A ...

Hi, I have a master spreadsheet with column"A" 200 rows item# column "B" id name 200 rows. I receive a spreadsheet from my client with columns"A to G" ...

I need to round down the following formula to one of a group of specific numbers: (30, 27, 24, 21, 18, 15, 12, or 9) ActiveCell.FormulaR1C1 = "=(r6c3)-1...

how do I make a formula to work out gst

hi, i want to get the total price Total Price Black Ballpen 3 Box $7.00 $21.00 Blue...

This is my original file Col A Col B Col C Col D Name Jan Feb Mar Deepak 1 0 Deepak 2 1 3 Deepak 1 Tata ...

How do I change Phone: 8153381667 to Phone: 815-338-1667

i have fixed column widths that can't be changed; nor can any other columns be added to the worksheet ... i've got data in one column that represents...

Hello again, This forum is so hopeful to me, it sure gave me a boost in my position at work. Thank you all. I have now an urgent request for help. I have 2...

I would like to print the results of a search using the find feature. Is that possible?

Hello, I have a column (A) with a price from row 1 to 100. I would like to create in column B a formula that will add the total in each row. Example B2 will...

I know this is going to sound dumb but this really bugs me. When I copy a cell(s), the copied area is highlighted with "marching ants". Seems that after...

I have a workbook, with multiple (70) sheets , each with it's own name. Each sheet states in cell D2 "Yes", "No", or "Not sure". In a summary worksheet I...

Hi, I'm trying to produce a formula that will count the number of times a name appears in one column, but only when a number value in a second column is...

Hello, Is there a formula to calculate a break even point? Scenario: Rate ranges are 500 lbs at $10, 1000 lbs @ $5, 2000 lbs @ $2.5, etc. Eg: Shipper has...

I have a spreadsheet and the font is all one type and color. Now I want to add more data in in certain columns, but with all the new data i want in a...

Hello, Just started trying to use Excel 2007 Sure is diffewrent from the '97 version ! On one of the data workbooks that I created, I also did a graph of the...

Hi, Using Excel I'm building a simple spreadsheet database of all football results in a league each season, with a master 'Results' worksheet containing the...