I need to create a spreadsheet for Aged receivables. I need to know how to set up a formula to calculate if invoice is 0-30 days old, 31-60 days old, 61-90...

Hi, Somehow my Pivot table do not sums up by rows. Boxes are checked for both columns and rows for Grand total under options, Tools and Filter. Dinesh

Does anyone have an elegant way of concatenating a series of cells? I think the answer will be a user defined function which will be equivalent to...

Please post response as email is bogus to prevent spam. I have posted this query to the misc board also. I just need some direction. I am using Excel 2003. I...

I have a spread sheet that I'm running macro's in, and it keeps coming up with the error message "excel.exe has generated errors and will be shut down...

Anyone know of a function that calculates the bond premium amortization using the constant yield method? An example of a bond premium that would need...

I have a workbook and I would like to do the following: sheet 1 named “End Bal� has 8 columns. In 2 of the columns; cells B5:B22 and H5:H21 contain one...

Can somebody tell me how to look up a list of items in a column from an array and then return the information in a cell that is in a column which is the same...

I need to determine the maximum number of consecutive negative numbers in a column. The column contains formulas that evaluate to a positive number, a...

How do you add an asterisk to the begining of a excel cell? or replace the zeros with a asterisk? For example, data come in the cell as 01222 but I want it...

I have information in column A of a task sheet. The information goes from row 1 thru 35. Column B is where I place a "x" to say the task need to be completed....

Hello, I have an Excel sheet which has macro's written as well as Calendar control used. This sheet was developed in Excel 97 (windows 98) environment. It...

EVery time I open EXcel for a new worksheet, the columns are shown as numbers, the same as the rows. How do I change it so that they are letters? Makes it much...

In order to count the number of unique entries in a range of cells, a very complicated nested set of functions (SUM, IF, FREQUENCY, MATCH, LEN, etc.)...

Hi, i have the times in 12:00 PM in cel A1 and 9:30 AM in B1 and i just want to calculate the difference between B1-A1 which is -2.30 hrs, but in excel it is...

I've never seen this error before, and unfortunately, my Google searches keep bogging me down with the simple "Automatic/Manual" solution... I have Workbook...

Hi Can anyone help me find asymptote from a set of data in two column x and y that show the frequency responce of a say a freq. responce in Excel? Finding it...

I received a shared worksheet where certain features were unavailable (inserting being one of those). After saving and closing that spreadsheet and opening...

I'm trying to get the count of the number of cells that contain a multiple condition using dates. Count the number of instances in cells A1 to A300 which are...

Since indirect won't work with closed files, couldn't u use indirect to make the reference and then just copy/paste special values? -- Don Guillett SalesAid...