Search results

Deb, Check out this thread, it may solve 50% of your problem http://chandoo.org/forums/topic/separate-number-from-text-thru-formula

hi Its working fine with me here, Try to change the format first and enter the date. mean time am using MS office2007 here.

Hi Ausikenoath Follow below procedure to get the date in required format 1. Right click on the cell where you have entered date. 2. Go to "Formats" and Select "Customs" 3. Below "Type" enter "dddd, dd-mm-yyyy" 4. Now enter date in this format "05/28/2012".

I got it, its total 132 ; Many Thanks Narayan for your time and effort. Ashwin S

Hi all Today I came across this issue, on my birthday, I wanted to invite my friends, I have made group and added all my friends there, added same group in TO list of email and expanded that group to know how many are there in group. As there are many in the list, I thought to copy info to...

Shermansee, Its better if you share sample sheet.

@Montrey Congratulations :)

Senthil, You can add your profile pic in http://gravatar.com/ In turn it you can see it in chandoos blog. PS: Use same email ID in gravatear which u used to create chandoo ID.

Thanks Faseeh, u r right, this was the repost....i could not able to fetch the detail last time so reposted. Many thanks for your time.

Friends I have two columns A and B. "A" carries Task Name, "B" with the Engineer name. Engineers name repeat in "B" column assuming same engineers handle different tasks. I am trying to capture task handled by each engineer in one cell separated by commas. Can anyone help me to get the right...

Many thanks Hui & Narayan. have good day ahead.

Can anyone help me to find the percentage of completion of task? I have task with "start date" and "end date". I want to calculate percentage of completion of task as on today’s date.

@ mrzoogle Many thanks for your time. Regards Ashwin S

Narayan Thanks for your time on this. I have posted old sheet over here with different requirement. My earlier requirement code given by Faseeh and its working fine. My other requirement is below,Request you to ignore my earlier need in this chain. Below is latest. "I am trying to capture...

Faseeh Many thanks. Will see how to present this. Have good weekend Regards Ashwin S

Faseeh, One more request. I am trying to capture task handled by each engineer in once cell separated by commas. Can u please help me to get the right functions? Sorry to bother you brother. I have copied Sample file in below path, the cells in green color will show the requirement...

Faseeh, Many thanks, code is working like black horse :) Thanks Ashwin S

Hui and Faseeh Thanks for your Quick response. I have uploaded the document in below link. I have pasted Current result and desired result in Sample sheet. I will try to explain briefly about the requirement Engineers in our company will be assigned to particular Tasks all the week on...

Hello all I am using below function to one my spread sheet, i almost got the solution but strucked in last bit, i need your help to solve this. I am copying data from Cell "G" if it match with value existing in "H & I" cells. Until here everything is fine. Match will stop once it gets first...

I have spread sheet with Name of player in Row and his career highlights in column. I wanted to fetch particular details of player in one click so I created the combo box from form control. Combo box will give list of player and respective position in input range. Using if statement the data...