Search results

Hi All, I am unable to understand the formula explained at the following link However, it is working fine: http://www.get-digital-help.com/2009/03/30/how-to-extract-a-unique-list-and-the-duplicates-in-excel-from-one-column/ Let me explain the problem: 1. Syntax for Countif is...

Hi Masters, thank you for this wonderful website. It is really helping me to learn new everyday. Kindly assist with the basics of VBA programming so that I can link Excel with other applications for example If I want to mark my attendance in our HR tool when I reach my office and without...

Kindly assist with Pivot Table Formats as these are volatile in nature i.e. formatting disappears on refresh. I am using excel 2007

Hi All, Sorry for the late reply as I could not visit Chandoo.com in past few days. Thank you so much for your help but actually I am very well aware with the Vlookup function's syntex and know that last argument can take only two values (Tru/False i.e. 1/0). However, confusion comes when I...

I have come to know that Vlookup function's fourth argument can have values other than 0,1 and 3. Kindly assist me with the different values that this function can have and their usage. Thanks Dheeraj

I want to learn VBA to create macros. I am a bigginner and can create small macros using Excel Macro recorder to perform some repetitive tasks but that is not enough. Actually I wish to learn VBA coding from scratch. I hope you will help me providing some study metarial by giving some...