Can I type info in 1 cell and have it automatically put different info in the next cell? Kinda like autofill but not that exact option. This would be...

Seems simple, but I'm not figuring it out. I have a one-page sheet on which others will periodically add information to some columns. At the bottom, I want a...

Why does Friday, April 1, 2005 in a date formated cell generate a wrong data type error when using the WEEKDAY formula?

I have a formula in the form: =G1*'Producer 1'!B1+G2*'Producer 1'!B2+G3*'Producer 1'!B3+G4*'Producer 1'!B5 I would like to be able to replace 'Producer 1'!...

I have a column which contains the date of every Monday. I would like the Monday of this week to be highlighted. Any assistance would be greatly appreciated.

I've created 2 sheets with data that have to be plotted on different charts. I then created 1 sheet just for those charts to appear. On the first data sheet,...

I have the following columns that are a result of a pivot table. I would like to delete the folllowing occurences. I tried using the range function but got a...

I have the following columns Va2 177 V3 216.37 V3/rootT3 11.984 Q3 ? V3/rootT3=11.984 which is not in the table I need to retrieve the Q3 from a long...

I am trying to write an IF statement in a cell for a calculation based on whether a cell is blank or not. This is what I have started with but I know it isn't...

Hello there, I am working with an excel sheets that has over 3000 products in our inventory The first column contains the part number. Each part number has...

I am trying to do conditional formatting on cells in Excel 2007 such that if they contain numeric data, they will be formatted in one font, style, and size,...

anyone know how I can use excel to track time played by player in a sport during te length of game? I need to create players on row line and then have app...

I have a huge column of address info. All the info is only seperated by spaces not comas. Each address is a different length so i cant even split by using...

Excel Help says enter 10-5 and it will read the answer as 5 in the cell. I tried it, but it just read 10-5. So I then tried clicking Enter, but it then...

Can columns be sorted alphabetically? If so, how?

I am having a problem with the formula below. I have a chart of certifications listed by date which are due annually. I have a column dedicated to list the...

What feature allows you to show the differences between two colums of numbers? Item by item, not just column sub-totals or totals. Thanks, Albert

I'm trying to use the HLOOKUP formula for the following scenario: Lookup value is a reference cell (B8) Table_Array is the range of cells (B15:E15) Row Index...

Can someone tell me how to correct the formula to count the days across a year? This formula is returning 25 days, which is wrong. =DATEDIF(I5,D5,"yd") & "...