Suresh Kumar Kuppusamy

Author's posts

Jan 22

INDEX – MATCH Formula’s Combination

INDEX – MATCH Formula’s Combination VLookup – Searching a value in the left-most column of table array and return value based on column index number.   Combined INDEX MATCH –   formulas work as a right to left lookup, whereas VLOOKUP only works left to right. We can use INDEX MATCH to lookup a value that is …

Continue reading »

Sep 22

VBA – Turn off Auto Filter

Turn off Auto Filter in Active sheet   If ActiveSheet.AutoFilterMode Then ActiveSheet.AutoFilterMode = False     Turn off Auto Filter in Table   If Sheet1.ListObjects(“Table1”).ShowAutoFilter = True Then              Sheet1.ListObjects(“Table1”).ShowAutoFilter = False      End If