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 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.
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
=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...
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...