Search results

I wish If I could get a formula as showed in the excel sheet When O7 is = C11 the P7 cell will show result of R11 When O7 is = C12 the P7 cell will show result of R12 When O7 is = C13 the P7 cell will show result of R13 & follows

Hi, Thanks for your response , file uploaded, so far I can remember I did it before (slided the selection cursor from the first cell to the other cell of the same pair of data) only using short cut key. is there really no short cut key to that ? I am confused with my weak memory. Thanks, you...

Hi ! I have got huge number of duplicate cells by applying duplicate value formula of conditional formating. now is there any shortcut key to jump exactly to the same duplicate cell of the first one among the all different duplicate cells. Thanks

Thanks for the info....

How to remove subtotals from specific value fields in pivot table In the attached file I need to remove the subtotals from the rates @ columns

Hi ! I am a first stage excel learner, Some how I have prepared a speed meter graph. I was thinking how to convert the needle reading into percentage.

:) Thanks Vletm. Yes you are right, there were some mistakes within the number of digits That I have rectified later, thanks for your notification.

:) Thanks David, It was so helpful.

:) Thanks for your advise, I didnt understand your point, may be because I am a not a expert user of excel, I am trying to understand,allow me some time.

Yes ! You are right, I changed some parameters.check this out

Thanks, My requirements were a little different but I reached there by following your path. pls. check the attachment

Hi! What should be the formula for a charge that decreases for the additional amount in different amount spreads with out escaping the previous conditions rates are given in attached file

I found it, thanks

Thanks again @Deepak & to you @Khalid NGO for your support.

Thanks Deepak, Its awesome.

=IF(C28=OR("20'","20'H"),1580,2040) for 20' or 20'H berth operator will charge 1580 & for 40' or 40'H they will charge 2040 My requirement is when C28=20' or 20'H then E28 will be 1580 & when C28=40' or 40'H then E28 will be 2040 any support will be appreciated.

Noted with thanks. "IF YOU CAME UPON A NAKED SWEDISH OR FRENCH OR AMERICAN WOMAN BY ACCIDENT,SHE WOULD FIRST COVER WITH HER HANDS HER PUBIC AREA. BUT AN ARAB WOMAN WILL FIRST COVER HER FACE BEFORE ALL ELSE AN LAOS WOMAN WOULD FIRST HIDE HER BREASTS AND A CELEBES WOMAN WOULD TRY TO HIDE HER...

OOOOOPS !!!! SORRY FOR THAT AGAIN. I am working with your supporting formula, I will show it to you when finished.

Boss, More than OK Let me express my joys:);):(:mad::confused::cool::p:DD:eek::oops::rolleyes:o_O:DD:DD:DD:DD:DD:DD:DD:DD:):):):):):):):):):):):):):):):):):):):):):):):):):):):):):):) I just love chandu.org Its some thing like the cave of of the forty thieves, full of precious things.

@r1c1 Hi !! you are using the avatar of chandu ? "TO.......TU......CHANDU HAYE ??" LOL. You know this was the first sentence that came to my mind when I first visited this site. You are so nice, & so helpful I have learned a lot from chandu.org & now in my office every one give me a...

I want to make a sheet for my import costing where I have to figure out the port & shipping line demurrage. First of all there are two type of charges from different authorities Shipping line & port shipping line charges in different spreads for different type of containers for example...

Hi Somendra I wish If could know your thoughts about this formula.

Boss Any update ?:confused:

:)