How Can This Excel Directory Make Your Work Easier?

Hi all,

Please find the attached Excel file directory; it is very useful.

Cheers,
Keyran

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 a logical order? Please advise.

CVH

Hi Keyran,

It's indeed a very good file, very helpful. Please find attached another one on the same lines.

Nisha

[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

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

I am a Business Analyst and work on Excel for most of my calculations, so I keep on exploring.

Cheers,
Keyran

Dear Udayakumaran,

I suggest you to join a KG group instead of this one. This group is for a little more matured people. I pity the people you work for if you are an HR professional.

B+