I have a cell (D6) that has text AV1 in it. Is it possible to have cell A20 check to see if B20 has a number greater than 0 in it, if it does return AV1-1. If...

=vlookup(indirect("a1"),d1:e2,2,0) should always point at A1--no matter what happens! camerons wrote: Lets say cell B1 is =SUM($A$1:$A$2) if I drag cell...

I would like to have the first two rows of my sheet remain fixed (always show) even when I scroll down lower parts of my sheet. How can I do this? Thanks

I retrieved from my sent box an Excel spreadsheet then updated it, saved it, and now cannot locate it. Please help.

Hi, In Word, it has Columns function that is very useful. When the column A is full in one page, the data automatically go to column B and then C.... ----- In...

I'm having trouble debugging a large piece of code. It would be awfully helpful if I could see the spreadsheet while I am stepping through the code to see what...

When I highlighted a cell, i want to quick jump to the formular bar and I don't know if there is any shorcut so that I don't have to use to mouse to click on...

i need help i have an interview today and i havent used excel in about 1 year i only use it for fax face sheets and general data entry i dont rember what...

I am using Excel 2003 but have been a user of 2000 for a long time. I 've worked through the creating of a drop down list and understand that but cannot find...

How to set custom paper size in Excel 2003.

I have caliculated the time worked for the day using the formula =TEXT(D2-C2, "hh:mm"") -where D2 is the time work closed and C2 is the time work begun. I got...

I have a fairly simple spreadsheet with 30-40 calculatrions. Some of the results appear to have a space on the right hand end. Most of these are calculations,...

This may sound like a trival question What are the Dollar sign around the column letter (ex. $a$1) that I see in some formulas on excel sheets I get from...

Harald Staff wrote: Hi Mike Sub test() Dim GivenColumn As Long GivenColumn = 1 Columns(GivenColumn).Find(What:="", _ After:=Cells(1,...

I am completely new to Excel and have created a spreadsheet which background should have no fill. Unfortunately, part of the spreadsheet has a gray tone and...

I have two Sheets (sheet1,sheet2), Sheet 1 has corridinate data imported from Autocad. On Sheet 2, cells B57 through B76 have IF statements in them...

Hi there. Using E02 on XP. Have a column (A) of dates of birth. What formula would I use in column B to calculate the date they will turn 65? I've put in...

I need to move every other row to match with the one above it but place it the info in the next column. Column A Column...

I have info in col A thru H, but I need to have info in e,f,g to replace b,c,d based on the answer in H which is yes. My next question is filtering, how do I...