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)
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)
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)CiteHR is an AI-augmented HR knowledge and collaboration platform, enabling HR professionals to solve real-world challenges, validate decisions, and stay ahead through collective intelligence and machine-enhanced guidance. Join Our Platform.
Excel Formulas.xls
Excel Formulas.ppt