Search results

Hii I have long list of joint names which is seperated by a special character. Like John/Alia John & Alia John& Alia I want the list in two seperate columns John alia John alia John Alia

Dear All I have posted a sample file of which link is as under http://www54.zippyshare.com/v/29885659/file.html The sheet 1 contains the data and the sheet 2 contains the desired result. Actually aim is to repeat a invoice return reason for different invoices until the new return reason is...

Hey Narayan, It's working..thnx a ton. Luke thks a lot..it's working...my apologies that i didn't explain it properly...u excel ninja's are awesome..hats off...dream to be like you one day...i mean it..thnx

Dear Luke, thks for prompt response but it's working but not exactly the way i am looking for the result. I want the following sample data and the desired result:- RefRow Data delete row no. desired result row 1 a 2 a row 2 b 3 d row 3 c 5 f row 4 d...

Hii I have 500 rows containing data. But i have certain random row numbers viz 2, 25, 30, 82,85, 130...so on. I want data in these row numbers gets deleted and data get arranged without these rows. I am looking forward for a formula instead of VBA code. I tried Index, small, IF, Row and min...

Hii i have two Lists with me List 1 & List 2. In List 1 some numbers are there and list 2 persons are there and some persons are repeated in nature. List1 in Col A & List 2 in Col B. i am trying to get result that a person gets all the nos matching to his name and after all search pertaining...

Dear Sir I am trying to make areporting tree sought off. I have three long lists one is of "Heads', second is of "managers' and third for 'subordinates". In list 1 where there are heads there names are repeated as different heads reports the Head. same is with manager and subordinate relation...

Hi i am looking for a formula through which a time sheet of employee sign and sign out can be created. idea is when the employee enter the premises he will punch his employee code say 1101 and the current time of the system get punched automatically and further this time does not chage with the...

thnx will try the same and get back to u

Guys , I am going through large data and want to compare the data. One data contains manual entries and the other is generated through system. i want to compare automated data with manual entred data and locate the difference and find out the where the error was made. I am looking to find such...

Actually my major problem is that we have no excel and we are using dump and as soon as i made monthly detail it shows error that program is not compatible or so. How to overcome this problem?

Dear Sir I am trying to make a time sheet & leave tracker for 40 employees for the each month of the year. In which drop down ist for each employee is created for time sign in in office with other corresponding tabs whether he is on time, late, late but informed and similarly for leaves like...