About the Blog
Copy Data on visible cells only (Skip hidden Cells)
VLOOKUP Multiple Occurrence
INDIRECT Function (Basics)
VLOOKUP Search in middle or right column & get result from left side column(s)
Key Advanced Skill: Creating List from scattered entries by Avoiding/Ignoring/Skipping empty rows
Array (Excel Function - Conceptual)
6 Ways: Unique List of items from Multiple entries
Drop Down Menu in Cell / Data Validation List
Variable Drop Down Menu / Data Validation (DV) List