i feel like a complete idiot,, it has been some time since ive used exel, but i swear that i remember that this worked... i have a column of numbers that ive...

I am new and on a test at school, it had a sheet with overtime hrs. I can't find why it is adding the $ automatically. Thanks ckr

I am try to create a formula in excel. thats Looks at a line of cells i.e. a1, a2, a3, a4, a5 and find out if the cell contains “V� for vacation day in the...

i am wondering if it is possible to do a vlookup() type search for multiple instances of something, and then multiply the results together. for example, i...

Im Trying To Write A Simple Sheet That Basicly Lists All The Components In Stock With There Quantities, And Then Have A Cell Dedicated To Selecting A Component...

I want to extract each row from a range when one specifice value exists in that...

Since today I am facing some peculiar change in my excel files. When I drag a formula from one cell to another cell, result of the first cell itself are...

I have a workbook with 2 worksheets (Sheet1) and (Sheet2). I need to look at (Sheet1) cell (AL3) if this cell is blank I then need to look at Cells (F3) and...

Is there such a thing, or am I getting confused with Excel 2000 or even Lotus 123?

Hello. I had a similar thread that didn't really get the results I wanted, so I guess I'll start a new one over and clarify a few things this time. I have a...

If I protect the table I can still "stop" at any cell and get the message if trying to enter data to protected area. My Q here is. can you avoid this being...

Hi I'm trying to put an outside border of each cell that I select however I'm trying to do that it only puts the border on the highlight cells on...

How do I undo specific colums in an excel data base?

I have a workbook which a colleague uses to enter data. The data is then manipulated on the same worksheet, but if these columns arehidden they can easily be...

Hi all I have an IF statement: =IF(AND(A1="Draw",B1C1),"Error","OK") This works OK. I am having trouble adding the next two...

Why does outlook open when I edit a cell in Excel?

Could someone help please? I am looking for the Excel formula equivalent of the ?SQL command that will return true or false dependent on a text string being...

I have two file (p1.xls , p2,.xls). When I work in file (p2.xls) i need to find something in second file(p1.xls). Then write value from Cecha in the ActiveCell...

Hi, Im thinking of incorporating the Forecast function into my budget spreadsheet but I just cannot figure out how Excel calculates the forecast figure. I...