I am working with a model in which I am converting to a current scenerio. When I go into a specific cell to change the link it gives me a error that reads "No...

I have designed a time sheet for payroll purposes that automatically calculates all appropriate formulas. The only one I haven't figured out yet is this: in...

OK, need help with the following: Mod(10e+11;97) returns #NUM!, anything higher it blows. But if I use Mod(n;d)=n-d*INT(n/d) I can go until Mod(10e+15;97),...

How do we calculate equated monthly installment value for given int rate and period for a capital available and reverse of the same. Thanks

Dear expert, Is it possible to count "," in a cell please? I used this ... but does not work =COUNTIF(FO93,",") Say below ... can it be solved? 2,5,3

Hi Excel Forum, Hope you can help me..... Calculation on Filtered Visible Cells. Working with Filtered Visible Cells - need calculations to recognise "only"...

Dear Expert, I have got a file which have a system generated field below. (15 rows) First character must be either "T", "F", "U". Last character must be...

I select the text of a cell name (A1, for example), hit F4, an nothing happens. I have to go in and type my $. How do I reset F4 to work?

In Excel 97 there are two types of Text Boxes those that are created by the Draw toolbar and those that are created by the Control Box toolbar. One seems to...

How do I shorten this formula. It is missing information from the missing rows, but if I put those in, it tells me "The specified formula cannot be entered...

I have a spread sheet and in it i have data validation tables when i finish picking from them and email the sheet i then want to clear the info in the tables...

Hi, (looks like my previous posting was lost . . . . ?) thanks to the help from this forum (Roger G. !), ==for using the same graph, for various...

I was moving along very well gathering information form several other worksheets in my workbook by using the = sign to display text from the worksheets into...

I'm having problems with a schedule where if users nominate "Job start" on a row, they need to enter dates instead of general numbers into the schedule eg they...

My problem is the use of LINEST in Excel 2003, to which we have recently upgraded. Previously we used Excel 97 and I was able to produce realistic...

Hi, I am having an issue with comparing columns of values. Basically I have a table similar to the below except with a couple of thousand lines. Either the...

Before printing, I need to remove zero entries from two columns, but they are often different rows. Normal auto filter will not work, it hide positive...

I am printing alot of charts for one spreadsheet that contains many tabs. I would like each page printed to have the name of the tab, so I did the...

I am using this formula to enter text into a column of cells of the source worksheet and the corresponding column of cells in the destination worksheet;...

Is it possible to clean up a date field where someone was keeping an excel sheet but the date field is a mess For example he has 1998 2/2005 1/1/2010 We...