Search results

Thanks Mahaveer/Sudipto for your seggestion. I want formula to get the answer. Regards, Pavi

Hi All, I have 4500 row in one column (text and number) and I want to find all the row which Contain 30000.. (e.g. 30000278, 3000001,3000009). Thanks, Pavi

I think my avatar is change now.

Thanks shri... deb's formula also working... Regards, Pavi

Hi All, this formula working =REPLACE(A2,FIND(CHAR(160),A2),FIND(CHAR(160),A2),"") Regards, Pavi

yes i tried but not working... Regards, Pavi

Hi All, I have text file downloaded from oracle showing trailing space and I use Trim formula but still showing trailing space. I copy all trailing space and checked the code it showing 160. Please help.... Thanks Pavi

Kevin I want difference in row not in column. Regards, Pavi

Hi All, Can I add row difference in pivot like below. ITEM MODEL Sort Prod -Feb-13 Prod -Mar-13 Prod -Apr-13 Prod -May-13 Prod -Jun-13 111000111999 DBC265983 Rev02 400 400 650 650 650 Rev03 800 600...

Great shrivallabha thanks its working fine. Regards, Pavi

Hi All, I use below formula please tell me if have easy or other formula for this? =IF(DAY(D2)<=7,"1st Week",IF(DAY(D2)<=14,"2nd Week",IF(DAY(D2)<=21,"3rd Week",IF(DAY(D2)<=28,"4th Week","5th Week")))) Regards, Pavi

Hi Shri/Narayan, how can I divide month into week i.e. 1 to 7 1st week 8 to 14 2nd week and so on... Regards, Pavi

Shrivallabha you explain very well thanks alot... but your formula remind me my school days when any new chapter started in the class i look same like now i am looking your formula which bouncing from my head... u r great shri... Thanks Narayan for your short formula. Shri your last...

Dear it's working like charm... can you please explain the formula like what is the logic behind this (--( 'looking like sad face but giving correct answer. If I want to change the first week of the day then wat should i need to change. Regards, Pavi

shrivallabha thanks for your reply. yes you are correct. Regards, Pavi

Hui sir Saturday is the first day of the week. Regards, Pavi

Dear All, I have date from 1-jan-2013 to 31-Dec-2013. I want only week no. 1 to 5 then again in feb from 1 to 4 in march 1 to 4 so on.... I dont want all 52 week. every month 4 or 5 week Thanks Pavi

Thanks for your kind explaination next time i will remember dear oldchippy. once again thanks alot. Regards, Pavi

Thanks oldchippy... I used this one... also working. tell me if i made mistake on below formula. =IF(SUM($B$2:B$2)>$A$2,1,0) Thanks Pavi

Hi All, I have below table. i want to highlight data which overlap 7500 which is on hand value. On Hand Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec Total 7500 1000 500 600 2500 5000 1000 500 600 700 800 900 250 14350 i.e. jan to apr total is 4600 that means from may to dec should be...

Hi Narayan, Now it's working fine when i change Chart type. Thank you so much for your reply. Regards, Pavi

Sorry All i didn't change chart type. It's not working fine. Thanks Pavi

Hi All, I prepare thermo-meter chart for my personal todo list but chart showing full 100% if i Check 1 box but in chandoo's file if I check 1 box it showing correct size as per percentage. Tell me what setting I am missing in my chart. Thanks pavi

Thanks Narayan. Really very nice website.

Hi All, Please check below link. I have 2 question in excel file what i need. if still have any question please ask. https://www.dropbox.com/s/b1sqxht818hz0e5/Transportation%20Report.xlsx Thanks Pavi