Hello, I'm trying to count unique values in a row and have a filter at the same time. I'm using the formula =SUM(IF(FREQUENCY(I1:I255,I1:I255)0,1)) When...

I have a spread sheet that calculates a range of cells but would like to have it return blank if less than 0. The formula I have is =SUM(F5:R5)-C5-D5+B5,...

Is it possible to use more than one summary function on the same data field in a pivot table? For example, I want the total as well as the average on a...

Attention smarter people: I am taking an Excel class and they are calling for a Nested IF, AND, and OR functions. This is the basic premise Fulltime...

I have text within a cell that I need to replace with differenct text so I can so a vlookup. Example: FDA1510 needs to become CA1510, there are about 160+...

I have a workbook containing 14 sheets all structured the same. Cells E8:E39 may contain the text "PS Rep". When that text appears I need to extract the text...

I am creating an audit workbook with a number of worksheets. The primary worksheet includes questions and a column for the auditor to select Yes, No or N/A....

Hi everybody , and a good day ! A B C D E row 1 1 2 3 4 5 row 2 2 4 7 1 88 row 3 row 4 I...

I have a worksheet that uses named ranges in it's formulas. Is there a way to set the named range to be realative to the curent sheet? Example currently one...

A column in an excel file was formatted in CUSTOM format like 00-00-0000. Whenever I changed the format to DATE (ex. 01-01-1901), it is changing to...

I'm trying to use this spread sheet for purchasing fuel and to subtract the fuel tax from the pump price when I purchase fuel so if I type in cell B2 IL I...

In microsoft Excell.... The Number Format. The General tab shows 24 - a 2 digit number... sometimes it shows something else...how do I get it to always...

Dear Experts: I have a work book than contains around 10 worksheet, each sheet linked with simple hyperlink. I am looking for professional assistance to a...

Ok, this problem has been driving me nuts and I wanted to elicit some advice from the experts. I will try to explain it the best that I can and hopefully with...

I have a refreshable spreadsheet with data imported from Access. When the data imports, I get Access formatting codes like div, &nbsp and font codes (see...

Any way the spreadsheet can display the last save date time of the spreadsheet?

Hours worked is 11pm to 7am. Need a formula to calculate total hours worked minus the 30 minute break if worked over 6 hours over the midnight hours. Used...

Ok, this problem has been driving me nuts and I wanted to elicit some advice from the experts. I will try to explain it the best that I can and hopefully with...

Ok, this problem has been driving me nuts and I wanted to elicit some advice from the experts. I will try to explain it the best that I can and hopefully with...

hi expert, how can i use vlook in looking up a similar or equal number of a "look up value" from another table of array and returning the corresponding...