partially

Hi I am looking for a code what fills the ranges of cells P1, S1, P2, S2, etc partially - entering the values in range cells C5 for P1, D5 for S1, etc - with the colours listed in cells C14:C20 - the colours are defines in the range C23:C36 result should look P1 15% filled and colour orange If I...

Hello! I've got a question about an array index match formula that's partially working. So the set up of the data is on sheet2 I have the raw data being downloaded. On sheet1 I have a table with the formulas pulling back only the relevant information from the data dump. The table set up is...

Hi I've got two columns of data (A and B) and I'd like to sum the data in column B that is either "Checked" or "Partially Checked" in column A - please see the small sample below. The sum should be 40, in this case. I've used this formula, but it's not returning the expected result. Can...

A B 4805 50.00 4805 45.00 4805 0.00 4900 0.00 4900 0.00 5010 48.00 5010 62.00 5010 58.00 In the above table column A has claim numbers, and column B amounts paid. A claim can be either partially paid (#4805); not paid at...

Hi, I need to put a formula in Column M which will search through column L and match it (partially or completely) with column O and display the value available in same row in column P. If VBA code will do it faster then provide VBA code please. e.g. in Column L, it is written as "Salary of...

Hi all, I am looking for a formula to highlight rows C:K if column H is blank? I have the following which partially works, not the whole range =H13<>"" Any help appreciated

Hi All, I am looking for a formula to extract data from a list dependent on what is in columns D ie the list on sheet 1 will be A1 : Parts B1 : Description C1 : Cost D1 : Status On sheet 2 I need A1 : Parts only with "Ordered","Partially Received" or "Pending" status B1 : Description with...

Hi All, I am looking for a formula to extract data from a list dependent on what is in columns D ie the list on sheet 1 will be A1 : Parts B1 : Description C1 : Cost D1 : Status On sheet 2 I need A1 : Parts only with "Ordered","Partially Received" or "Pending" status B1 : Description with...

Hi all, Really hoping you can help with this one. I have a range of cells (J2:AH2) which all have one of 4 options in: Yes, No, Partially, or N/A. I want cell I2 to generate a 'score' based on the contents of the cells in the range. So: If any cell in the range = Yes, count 1, if Partially...

Hi All, I am trying to add another IF to the following formula IF AH16 is not "" then print "Partially Returned" IF AF16 = AH16 then print "Returned" =IF(AV16="","",IF(B16='Order Status'!AF16,"Received",IF(OR('Order Status'!AF16="",'Order Status'!AF16=0),"Ordered",IF('Order...