Search results

Hi, Try this. In cell B1 put a dropdown with values 1 to 5. I understand that the user will select one of these and depending uopn the selection the second dropdown should change. Put values 1 to 15 in a range say D1 to D15. In the next column put a formula =D1*$B$1 Now use this range...

Hi, If you have hundreds of different duplicated items, you will need hundreds of different colors to format them. bit tricky?? Maybe someone can help using VBA. Jai

Hi, Try this. Select the range -> Conditional Formatting -> New Rule -> Use Formula In the space for formula type =$A2="John" Format as per the requirement. Jai

Hi, Try, =SUMPRODUCT((Sheet1!$A$2:$A$257=Sheet2!B2:N2)*(Sheet1!$B$2:$B$257)) in sheet2 cell O2 and copy down. Jai

Hi, You can go to Conditional formatting -> Manage rules. You will find your rule and the range it applies to. You can change this range so that the rule will be available for new data as well if you add more. Jai

Hi, Try =SUMIF(H17:H21,H17,I17:I21)+SUMIF(H17:H21,H19,I17:I21)+SUMIF(H17:H21,H20,I17:I21) Range H17:H21 has designations. Range I17:I21 has wages. H17,H19,H20 are the designations for which you are looking to add wages. Jai

Hi, Try this. This uses a helper column I have numbers 1 to 10 in A29 to A38. I have =rand() in B29:B38.( Helper column ) In C29 =OFFSET($A$29,MATCH(LARGE($B$29:$B$38,ROW(A1)),$B$29:$B$38,0)-1,0) and copy down. Every time you recalculate the sheet, order changes. Jai

Hi, Conditional formatting > New rule > Use a formula Try this formula: =DATEDIF(A1,TODAY(),"m")>36 Jai

Hi eshwarhalaharvi, This might not be the best approach, but this is what I can think of. I have the data provided by you in range D1:K6. I have created a dropdown using form control and linked to F8. In D11, I have this formula...

Hi Russw, Try this. =VLOOKUP(A2,'Worksheet B'!$A$2:$B$1533,2,0) Put this in worksheet A cell D2 and copy down. You might want to adjust the range as I have tried using just 2 columns. Jai

You are welcome Griffin !! Jai

Try this formula in cell E2...