Hi all, Find the attached Excel directory, this is very useful. Cheers, Keyran
From India
Acknowledge(0)
Amend(0)
From India
Acknowledge(0)Amend(0)
Hi Keyran Very useful Gist. Can you pl. further guide as to how to write syntax for various functions eg VLOOKUP, HLOOKUP etc. Is there any logical order ? Pl advise . CVH
From India, Mumbai
Acknowledge(0)Amend(0)
6From India, Mumbai
Acknowledge(0)Amend(0)
thanks for the share..could any one bring out the excel 07 e-book itself.it would be helpful for us and for the knowledge/learning sharing guys also..
From India, Bangalore
Acknowledge(0)Amend(0)
From India, Bangalore
Acknowledge(0)Amend(0)
Hi Keyran, its indeed a very good file...very helpful...PFA another one on the same lines... Nisha
From India, Mumbai
Acknowledge(0)Amend(0)
From India, Mumbai
Acknowledge(0)Amend(0)
[QUOTE=cvh;956617]
Hi Keyran,
Very useful gist. Can you please further guide on how to write syntax for various functions such as VLOOKUP, HLOOKUP, etc.? Is there any logical order? Please advise.
Hey,
I have attached the syntax for Lookup (Lookup, VLOOKUP, and HLOOKUP). I use this extensively.
Cheers,
Keyran
From India
Acknowledge(0)Amend(0)
Hi Keyran,
Very useful gist. Can you please further guide on how to write syntax for various functions such as VLOOKUP, HLOOKUP, etc.? Is there any logical order? Please advise.
Hey,
I have attached the syntax for Lookup (Lookup, VLOOKUP, and HLOOKUP). I use this extensively.
Cheers,
Keyran
From India
Acknowledge(0)Amend(0)
gr8 man. I have been looking for such a comprehensive guide in excel for a long time. Thax a lot
Acknowledge(0)Amend(0)
Acknowledge(0)Amend(0)
Many thanks, Keyran, for sharing this. Can you provide us with a useful formula to calculate the number of days between two dates? For example, how many days have passed from 10.02.2008 to 20.11.2009? I would like to know an easy way to calculate days for any given time period. I hope you can assist with this. Awaiting your response.
With best regards,
Aazad
From India, Vijayawada
Acknowledge(0)Amend(0)
With best regards,
Aazad
From India, Vijayawada
Acknowledge(0)Amend(0)
Thank you, dear, for sharing this valuable concept with us. It's really very helpful to adopt the same. I have a request for you, and that is if you have any concept of Excel VLOOKUP & HLOOKUP, then please send it to my email ID: amitbanerjee52@yahoo.com / amit.banerjee@tmscl.com.
Thanks,
Amit
From India, Calcutta
Acknowledge(0)Amend(0)
Thanks,
Amit
From India, Calcutta
Acknowledge(0)Amend(0)Gathering data for an AI comment.... Sending emails to relevant members...
Stuck with an HR fire? Get a verified answer before your next coffee. - Join Our Community and get connected with the right people who can help. Our AI-powered platform provides real-time fact-checking, peer-reviewed insights, and a vast historical knowledge base to support your search.
Excel Formulas.xls
Excel Formulas.ppt