I have a forecast file in complete numbers, for example $2,000,000; $15,400,000, etc. How can I format the number into $2,000; $15,400 without manually divide...

Hi, I have a column with powers in it another column with light levels in it like: col A colB 23 742 23 674 22 430 22 ...

I have a if formula that looks to see if a referenced cell is blank (empty cell). If its not, it returns my calculation. If it is blank, I want it to return a...

Hi, maybe someone can help me with a simple "sort" question. I'm using excel 2000, how do I sort in the order that the data was...

Hi all, I have a worksheet that has a few vlookups that go on. In the main, there isn't a problem. BUT, every so often, the vlookup returns an error ( i.e....

Am trying to do a comprehensive cash book, and would like to transfer monthly subtotals to a cash flow planner. Which function is best to subtotal data by...

I have a situation where I want cells to total up each week. I'll try to set it up as best as possible: For my explaination, I will use 1 of 4 people...

I want to have the pointer in the next new cell each time I open the workbook. is there a way to do this? Thanks

I want to setup monthly summary sheets that uses data from another page i have a formula that works however to make it work i have to select cells on the ther...

I am creating a master budget. I have worksheets and the first is my input page. On one of the pages I have situation where if I have a large amount left in my...

I need help building a macro that would take the # of hours worked and compare it to the list below to determine cost of for Ind and Family. # of...

Dear Friends, I need a small information. Recently, I appeared for Financail Executive post in a leading private bank. And, in that interview, I am asked to...

Hi , Can anyone tell me what is the use of unary operator + in formulas(like =+B4) .What does it mean? . Thanks in advance Xcelion

Hi One of the cells( of sheet2) of my excel has formula as =Sheet1!C2 I want the next (say 30 ) cells to have the same formula =Sheet1!C2. I dont want excel...

clash Wrote: Please help. I have to check 30 Lotto tickets ever week and have tried (and failed) to come up with a way over putting all the selected...

I have 2 Columns A & B Column B contains all of the data in Column A and then some. I need a function that will show all of the extra items in Column B.

I have attempted to use the PROPER function in an adjacent column to my data. I entered =proper(e1) and the cell only display the function not the result. Help!

Hi all, I have a bit of a proble, I want to perform a rate calculation on the results of a sumif i.e. Customer Currency Rate value 1 USD ...

I have 4 cells, A-D. Cell D is the "sum" cell. Cell D will show a "0" on the spreadsheet if nothing is inputed into any of the 3 other cells. How do i write...