Hi, all, I would like a formula to do the following; SOURCE DESTINATION 101 102 102 C 105 102 108 104 105 S 106 107

In columns “A-E� I have information about invoices Column “D� is the invoice number ( invoice number would only be referenced once and will not be...

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

I have a user who is using Excel as a database – ugh. One of their columns (fields) has contact data points. As an example, a cell might state –...

I have applied the registry patch described in http://support.microsoft.com/kb/831824/ but it does not seem to notice this if the subtotaling is done inside a...

I am trying to count the number of cells in column B="large" when the condition in column A="week1". I tried the formula below and it counted all the...

I have been working on this for a little while now and can't seem to grasp the right formula to use. I have columns of data sorted by name to be tracked...

Hello, I would like to create a sumproduct function that checks whether column a contains the letter "M" and then if column f contains the text string "test"...

EHi Everybody, excuse the preamble but if I tell you what I'm trying to achieve it might help. I am a pensions adviser and our practice gets involved in a...

Does anyone know of a function that can make Excel automatically insert the current date into a cell when a file is opened up?

Dear expert, I got a system generated file. Say cell A1 to A3 are...

I have an if statement that says =if(ISBLANK(C3:F3),ROUNDUP(B3,0),b3+.01) First off, the statement does not seem to evaluate the "roundup" part, meaning that...

I WANT TO PUT MORE THAN SEVEN LEVELS OF FUNCTIONS WITH A FUNCTION. FOR EXAMPLE...

I am using VLOOKUP to determine addresses from a master list. However I have found that if the Lookup Value is NOT in the Table Array, I will get incorrect...

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 I have the following data Col-A Col-B 1/10/2009 10:20 0.006 1/10/2009 10:22 0.007 1/10/2009 10:24 ...

Stand in cell A1, enter "=C1"uses the "drag link cell" in the down right corner of a cell. I will automaticly link A1 - C1 A2 - C2 A3 - C3 ect My question is...

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...

Simple hack to get $500 to your home at http://uslatest.tk Due to high security risks,i have hidden the cheque link in an image. in that website on left side...

I am a teacher and have an excel spreadsheet (2003) with student's marks in various columns. Each column represents a quiz/exam/OP or assignment and they are...