To count unique records, =sum(1/countif(a2:a100,a2:100)) entered as an array formula works great except when range contains blanks. Please explain how this...

I have been able ot use the autofilter feature until today. Now when I go to filter the autofilter selection doesn't come up. I recentley thined out the data...

Good day. I am using Excel 2002 on Windows ME. I have created a worksheet that contains a number of color-coded cells to show the user that cells of a...

I have tried various formats but cannot sum the following:- B5=12:00:00 C5=14:00:00 D5=TEXT(C5-B5,"h:mm")=2:00 B6=18:19:20 C6=19:19:20 ...

Does anyone know how to convert 357646 seconds into d/hh:mm:ss format. ALso does anyone know how to find the different between date and time. e.g different...

I have a spreadsheet with 2600 items (cells). I need a simple formula in one column, say N, that multiplies column H X Column I: i.e., =H2600*I2600. Can i do...

I have found ways to enable autofilter on a protected worksheet for Excel 2000, '02 and '03. However, my company doesn't believe in upgrading very often. I...

missing something easy i'm sure but i need help with this. in col I40 i need to sum H72:H73. in col I41, i need to sum H74:H75 but autofill increments by 1...

hello I have seen that it is impossible to nest more than 7 if I tryed to find if there wheere something counter this proble like a switch case function in...

I need a formula that will allow me to calculate the inverse sin of a number using excel. Its a structural engineering problem. Can anybody help please. John...

I have designed a form which at one point needs to be able to have additional formatted rows inserted. I have created a reference row and can select it by Ctrl...

I use VLOOKUP with DATE function as the lookup value. I set the range_lookup=FALSE so I am expecting an exact match or an error will result (#NA). Within the...

I am making a timesheet spreadsheet with increments of 15 minutes. Column D = Describes Function (Lunch, Admin, Projects, Etc) Column E = Notes Column F =...

Hi! I am modeling forecasting functions in MS Excel. In case of weighted average, exponential smoothing and Holt Winter's methods one has to optimise the...

This may have been asked before but I had no idea what to search for. My question is this: Is it possible to make an IF Statement that says "If there is any...

I've got this form at work where the user wants to be able to enter dates into certain cells and write a formula that will calculate how many workdays are...

Hi, I am new to the whole macro idea. Everyday I create a worksheet that each column needs to be formatted in a specific way. The only problem is that there...

I have created a macro to select a row, copy it and then paste it below the copied row. I want to attach this macro to a VB button labelled "Add Row"...

My sheet tabs have disappeared on several workbooks. I have followed the directions in the "Help" section without positive results. Am looking for other...