Recent content by pradeepthota

Hi Guys anybody help me my previous post

The excel looks like thisParticulars Jul-11 Aug-11 Sep-11 Resources Week1 Week2 Week3 Week4 Week1 Week2 Week3 Week4 Week5 Week1 Week2 Week3 Week4 Offshore Resource A0 [ <1 year] 4 5 6 A1 [ 1 to 2 yrs] 2 A2 [ 2 to 4 yrs] 6 5 8 A3 [ 4 to 6 yrs] 8 A4 [ 6 to 8 yrs] A5 [ 8 to 10 yrs] A6...

Hi Chandoo, Its been a long time I have posted anything. Please I have a problem with which formula to use. The excel looks like thisParticulars Jul-11 Aug-11 Sep-11 Resources Week1 Week2 Week3 Week4 Week1 Week2 Week3 Week4 Week5 Week1 Week2 Week3 Week4 Offshore Resource A0...

thanks a lot hui I have learnt much from you and this sheet doesn't work in xls format I guess

Hi Hui, Can you post the template link for the same please

Hi Hui, I was trying this way http://rapidshare.com/files/434018109/Pradeepthota123.xls as per the sheet but getting 0

No still D3 I am not getting a value it is showing as 0 it should show me the actual duration but no I have tried but it failed

in the columns now it is working but the problem is I am not getting the data for the formula =IFERROR(OFFSET('r2'!$G$1,SUMPRODUCT((Date='r1'!E$1)*(Employee_ID='r1'!$A3),ROW(Employee_ID))-1,0),0) where I need to get 610 the actual duration but its not showing

Yeah I have used but nothing is working it is showing an error #name

Hi Hui, The earlier one didnot work for rhis sheet. http://rapidshare.com/files/433209561/Empdetails1.xls can you please look at this and let me know why is not working

Hi Hui, What can i say wow!!!!!!!:) for your solution But can u please explain me how does this work for 10000 or more records. And also please explain the formula.

Thanks hui for that it will save me lot of time every day don't know how to thanks you for this.But then I need to have a extra row in the that int he rows 2,3,4 I need info of Emp id 1111, and in 5,6,7 th emp id of 2222 I need to insert a row for each employee id that is the emp id should be...

Hey Hui, Thanks a lot That wonderful it could be very much useful to me and you saved my day. I need to insert a row completely after each employee id till the end of it and insert the log value for each date of the respective employee id. can you please help me on this with VBA CODE

can any body help me on my previous question

HI Hui, the data will be done for every month and the records are higher. For every new month i will get a new set of data. I want to transfer the Shift data and Log details for the appropriate date back to R1 for each day according to the name. if you can help me with formula and a...