Search results

Wow...Thats great. Many thanks. Regards, Ramesh

Hi, Is there any formula which can calculate the average of three minimum % out of six filled %. Regards, Ramesh

Hi Narayan, not sure how to upload the sheet. :( Regards, Ramesh

Hi waiting for the formula. :( Regards, Ramesh

Yes. you are right. AJ3 can take on the values : "L" , "C" , "LC" , "CL" , 0 , "O" or blank. It can't be blank. Also "L" will have seperate receiving & processing time and rest("C","LC","CL")for others. REgards, Ramesh

Ok. Narayan, Thanks for sugession. Please find the below conditions: Col(AJ)=L; Country(col Y)=Germany; Receiving Cut off in CET(col R)=4:45:00 pm; Processing Cut off in CET(col Q)= 5:00:00 PM (if any incident receive before receiving cut off time so that should be processed as per...

Hi Please help me to make a formula following the below conditions. Wave 2 Country Receiving Cut off (CET) Processing Cut off (CET) L Germany 4:45:00 PM 5:00:00 PM C Germany 5:45:00 PM 6:00:00 PM L Austria 4:00:00 PM...

Narayan, Wow Narayan,, that's awesome. great thanks. very very helpful. Best Regards, Ramesh

Hi Narayan, Thanks for the formula. But i don't want to print the entire line but i want to show only w1 or w2 whatever the value in the cell. Regards, Ramesh

Hi Team, I am facing an issue in the Search formula. I would like to seach a particular Alphanumeric in a cell any it can be (W1,W2,W3,W4 till w10). But only one alphanumeric(W1,W2 etc). I have used the below formula but it's not working. Please help me out in order to get the correct results...

Hi Hui, =COUNTIFS(M9:M219, "<1", P9:P219, "<1") your formula counts only the P9:P219 reference, it's not counting the reference M9:M219. =COUNTIF(M9:M219,"<"&0.999988)+COUNTIF(P9:P219,"<"&0.999988) - This fourmula is working fine and counts for both reference. Regards...

Hi Thank you for checking. i have used the other formula. I have used the below formula:- =COUNTIF(M9:M219,"<"&0.999988)+COUNTIF(P9:P219,"<"&0.999988) Regards, Ramesh

ok. Closed. Thanks Hui.

Excel 2007

Hi Dave, Note able to find the upload option. Try to Explain here only. There are two columns M & P so the formula should be used considered= countif M= less than 24 hours + P= less than 24 hours. Means formula should count the values in the both columns and add it in a seperate cell. Ex...

Hi Hui, Tried to use but not working. how should i attach the excel file. Regards, Ramesh

Thanks Hui.

Hi What formula should be used in order to see the ratio in two variable/cell value. Regards, Ramesh

Hi Dave, We have tried to use this formula, but unfortulantely it's not working. Regards, Ramesh

Hi can anybody help to put a formula wherein. it will count if the hours is less than 24:00:00. REgards, Ramesh

Hi Babu, This is really helpful. Best Regards, Ramesh

Hi Chandoo, I have a question regarding the excel formulas. we use networkdays() for aging calculation, i want some different formula to know the aging. Regards, Ramesh