A couple of suggestions... 1. Make sure you're using the right format for your time fields. I would have expected that starting at 06:30 a.m. and finishing...

If there is no "rule" to it as if the numbers of characters can differ where they are etc.. Then it is basically impossible using functions However if there...

I have Excel 2000 and created a standard data workbook with three worksheets. Cells are either general verbage (name, address, etc.) or $ amounts with certain...

Hi, There must be a standard way of doing this... I have a table of bank base rates and the day on which they came into effect - about 50 entries in two...

As soon as you say apr, you're using compound interest, not simple interest. Aren't you just asking for the payments on a $24700 loan for 60 months at 2.9%? If...

how do i stop some one from changing a formula in a specific cell

I'm using the countif function but want to check a number of variables, usually details in at least 2 separate columns of cells. How should I list the range...

Hi, I hope someone knows the answer to this. I have two workbooks which have linked columns of 157 rows and things are working fine except that when I enter...

HI ... I am doing a search for a word "Location" in the heading in a worksheet. My purpose if to find that column which contain s that string....and then ...

I am working in excel 2002 and want to round my calculations to a corner balance. My addidtion funciton is rounding down while my other...

One way =SUMPRODUCT(--(C2:C1000="E"),--(D2:D1000-1)) -- Regards, Peo Sjoblom

First off, awesome site, Im so glad I found it. I've already learned alot just surfing around, reading other posts. I had a situation today, and we handled...

Hi, Im planning to create a spreadsheet wherein the distribution charges (col.D,E,F,G) from their salary will be made upon entry of their employee no. A ...

I have about 2,500 records, and want to delete any duplicates there may be. I tried filtering, but it did not help. Any suggestions?

I need to know if it is possible to sort worksheet tabs wither numerically or alphabetically.

I have cells that read eg: 15cd, 06mx, 24ab and want to sort these cells by the numbers not the figures so that my end result is 06mx, 15cd adn 24ab - can...

I cannot figure out how to lock individual cells. I have formulas I wish to protect. Help - Thanks

Hi, Am looking for some help. And I do not even know if this is possible to do with formulas. Anyway, here is the senario. Example Data Worksheet: Item # ...

Hello... yesterday I posted a question regarding linking access and excel, and I was told I can do it via SQL.REQUEST. Everything works now, but one thing...

Hi Richard try =IF(A1="O",B1*C1,IF(A1="F",D1,IF(A1="D",B1+C1,"no solution"))) HTH Frank Richard wrote: I am trying to work out a formula for multiple...