Search results

hi hui, I am using office 2003. so the shortcut is not the way you mentioned. i am typing in the insert function option but there is no ISNA function showing up

hi jeffrey, can you advice my last query to you ?

Hi jeffrey, understood. so the second formula is using not to show N/A. Just one more help if u dont mind, as you know that vlookup has its own format that auto show up when we click the formula bar and select vlookup formula by mouse, select the criteria by mouse and get the desired result...

hi vijay, thanks for your explanation. I have a little query that, if the first formula can do all the job, why there is a second formula to check. this one is making me think so much.In the vlookup i usually use one equation, though i am a primary user. and there is a (B$1),0)), zero in the...

Hi all, this is ryan again. I have a sheet, where in "R4" AND "S4" column there is a formula. when any of the section updated in "c" column, then R4 and S4 automatically getting updated from the second sheet named terms master data. CAN ANY ONE HELP ME TO LEARN THIS FORMULA ? THE FORMULA IS...

Hi raj, Advanced users will detect the hidden bar that excel shows.

hi this is ryan, I want to hide my formula. I know how to hide it, but when ever I am hiding it I am unable to work there. I can edit cells. To edit I need to unprotect again. Can you help me how can I work in my sheet hiding the formulas. I m using office 2003. ryan

hi sirJb7, i would like to show the below link that i am facing now. http://www.mediafire.com/download/5xi4xxwop0v6mwv/helpjpg.JPG The way i want the file is like the link below,supplied by dave turton. where i input any information in main data, it changes upon criteria.can i make the...

hi sirjb7, thanks for your prompt reply. Actually i am a newbie in this kind of advanced formulas. i have tried, its not happening. the first formula vendortable means the first sheet or second sheet, i have a slight confusion. i am failing to do it. would you mind to put the formula there...

Hi, This is Ryan again. I have a sheet that my junior staffs mistakes so much for wrong data input. I have decided to put it in this way that when ever I will write the data in one sheet, exact matching information from another sheet will appear in the specific columns. Like, I have...

hi all, this is Ryan recently joined in chandoo and having real fun and knowldeges. Recently discovered the various way of using Indexing formulas. As i have less idea about it, could you please suggest me any place where i can learn index formulas basic start?

hi dev and hui, it is solved. Now it is working. so many thanks. hi sirJB7, with so much respect to you, sorry that i didnt introduce myself but i didnt find any urgent/important word in my writting.i will follow it in future thanks.

:(

hi all it would be very appreciated if any formula can come out. dave...?

hi Hui, no, its not happening :(

i have a sheet which i have to update data everyday.after updating i have to update the last modified date as well. the datas are in G,H,I,J Column. if i update any of this column the last modification date in M3has to be auto changed with the current date. can anybody help me out how to do...

Yup. it is happening. Lol that this task i am doing this since one year only calcualting in desk calendar or PC calendar. this tricks could save so many times in these days. thanks chandoo and thanks dave. u r from UK ?

yes. this is the file i wanted. thanks again. you are a genius. i am trying to include korea, and Thailand there. hope i will be successful.if i cant, i will knock you.. :) plz dont mind

Hi dave, I am having one more problem here. I Want to add one extra column with ETA. The ETA should be added with ETD. Like china has 15 days transit time, hongkong has 14 days transit time, Taiwan has 16 days, and donguang is 15 days transit time. As I am selecting country in your sheet ETD...

Hey dave, how did you do that ? :) thanks mate. thanks a lot. i think u have experience in shipping. Hope i will be a super hero in our office from today. thanks a lot again.

Hi dave, your one is working also.can you please help me for taiwan, hongkong and donguang port also. i just need the three countries. thats it.

it will be very helpful if u guys help me to solve the first sheet which is "rough data".

hi SP and Narayan and others, okay. i am uploading my sample file. This sheet contains two sections. one is for rough, to calculate the ship dates separately which i will use if you guys help me on the based of above information.This will be enough to help me out. But i use the master...

hi narayan, if you want any template of excel file from me you can tell me. i will give you.

hi narayan, you are super correct. the line you mentioned either june 8 or June 15, it should be June 15 as you already wrote. i am amazed that you understood the whole shipping system within very few time. so can you help me out ?