Search results

@Deepak @SirJB7 Thank you very much

Hi, I need to split the cell diagonally. Please help Regards RSK

Thanks Nick M and jason However if i calculate for 400 files its showing (1:33:20) i.e if time greater than 24 hours its showing again from 1. how to know exact time for all the cases.

I need to calculate Total Time taken. Avg time taken for one file is 3.5 min (i.e 3 min and 50 sec). Usually we update in excel (3.5). After completing all work we calculate how much time we spend for this activity. for this we use 3.5 * no. of file done example: if I did 3 file then 3.5 * 3...

Thanks bobhc and NARAYANK991 sorry for late reply

Hi, In my team we were using .xls file sofar.However my friend suggest to use ".xlsb" to reduce file size and fast saving. Is this ".xlsb" good for daily shared worksheet? please provide your valuable feedback. Thanks and Regards RSK

Hi Team, Please help me to create break tracker for my team. Team consists of 15 members they need to update (login time, break start/end time,logout time). Admin person can see all member's data. login time should be fill automatically once he logged in. Break time should be start once he...

Hi Kiran, cell A2 -> 99800 12890 cell B2 -> 91&LEFT(A2,5)&RIGHT(A2,5) Drag B2 upto you want. its just my view, if its doesn't work pls let us know our guru's will help it out Regards RSK

Hi nicholes, Kindly upload excel file instead off screen shot Regards RSK

Hi sachinbizboy, Just try this Go to Conditional Formatting --> New Rule --> Format only cells contains --> Date occurring --> This month Regards RSK

Mr.Narayan and Hui, Thank u so much RSK :-)

Thank u sir, But in received column am getting only day and dates, it should come (Mon 2/1/2010 4:46 PM) time not coming in my excel. I changed format cells too even though its not coming. Pls help

Hi Guru's, I need VBA to extract data from particular folder in outlook to excel, i need (From name , receive time , Date , Subject). Thanks and Regards RSK

Hi, Just you try this Formulas --> Calculation options --> Automatic

Hi ed_terpstra, Try wildcard search using *search value*, =vlookup(*Burger*, range , , ) this gives all value which contains Burger , Donalds etc..

Hi, Latest date =LARGE(A1:A4,1) Last Date =SMALL(A1:A4,1) Is this ok?

D4 : E10 should paste in G12 http://www.2shared.com/file/PQp-A2wM/copy_paste.html

Its Text only... i want all data's in D5 Column A Column B Agent Name Attendance Mr.X Present Mr.Y Present Mr.Z Absent

Sorry for trouble you, =VALUE(INDEX($C$2:$C$13,MATCH($F2&LEFT(G$1,FIND(" ",G$1)-1),$A$2:$A$13&$B$2:$B$13,0))) above formula gives #VALUE!

I need to copy the data from (A5:C10) and paste the same in one cell (D5) How to do this

can you pls upload the file in any link, so that i can understand better Thanks you very much for your response

its not working Mr.Narayank

Answer should be Name open close process Mr.X 1 2 3 Mr.Y 4 5 6 Mr.Z 7 8 9 Mr.Q 10 11 12

Pls find the below example file. I need to find value of H2:I5 http://www.2shared.com/document/Qcr6M8vj/mulrange.html

@srinidhi : below formula posted by you =INDEX($C$2:$C$5,MATCH(D2&E2,$A$2:$A$5&$B$2:$B$5,0)) Its not working... can we use multiple selection in (Lookup_array) eg:MATCH(lookup_value,lookup_array, match_value) MATCH(D2&E2, $A$2:$A$5 & $B$2:$B$5, 0 ) any one pls...