Mr Excel & excelisfun Trick 39: Lookup Row (ALL COLUMNS) w VLOOKUP & OFFSET wrapped in SUMPRODUCT
Loading...
Loading...
4,981
Link to this comment:
Share to:
Uploader Comments (ExcelIsFun)
see all
All Comments (3)
-
can u guy help me with my little query as well ...please
its kinda actually diff for me to explain my ques here but suppose if instead of products i want "compliments","suggestions" or "complaints" and everytime in a column any of these values comes i wanted the whole row to be copied to another sheet if thts possible
hope u guys would help me out with this as well please
Loading...
- 8:05Mr Excel & excelisfun Trick 96: LOOKUP Function...by ExcelIsFun568 views
- 6:35Excel Magic Trick 862: Count Numbers In Column,...by ExcelIsFun1,651 views
- 7:31Mr Excel & Excelisfun Trick 95: Conditionally F...by ExcelIsFun1,314 views
- 10:23Excel Magic Trick 861: Conditional Format 50 Co...by ExcelIsFun1,604 views
- 4:46Excel Lookup Series #11: INDEX & MATCH function...by ExcelIsFun65,661 views
- 4:18Many VLOOKUP Columns - 1123 - Learn Excel from ...by bjele1238,498 views
- 8:12Excel Magic Trick 714: Three Criteria Lookup Ad...by ExcelIsFun5,541 views
- 2:34The OFFSET functionby AuditExcel9,576 views
- 8:18Combining MATCH and INDEX - Excel for Business ...by raycolondotcom21,501 views
- 9:41Mr Excel & excelisfun Trick 31: Word Wrap Probl...by ExcelIsFun3,502 views
- 5:52Excel Magic Trick #134: Find Last Value In Listby ExcelIsFun3,676 views
- 4:21Excel Dynamic Chart #13: Web Query Stock Percen...by ExcelIsFun4,156 views
- 4:04Mr Excel & excelisfun Trick 44: Count Mondays B...by ExcelIsFun2,029 views
- 5:48Excel Magic Trick 341 Extract Data w OFFSET & I...by ExcelIsFun12,597 views
- 7:09MS Excel: Advanced Data Validation using Listby RaiNtrospection16,782 views
- 6:29Mr Excel & excelisfun Trick 29: Existing Custom...by ExcelIsFun2,295 views
- 4:37Mr Excel & excelisfun Trick 45: + or with Form...by ExcelIsFun2,344 views
- 7:17Mr Excel & excelisfun Trick 57: Extract Many Ye...by ExcelIsFun1,732 views
- 10:55Excel Magic Trick 334: VLOOKUP & Data Validatio...by ExcelIsFun31,411 views
- 17:44Excel Magic Trick 473: Extract Unique Records w...by ExcelIsFun12,203 views
great post!!! but i dun understand wat does 'offset' do??
khurram87 2 years ago
I have made a few videos about OFFSET that explain what it does. Search for and watch these video titles:
Excel Magic Trick #78: OFFSET function
Excel Dynamic Chart #10: OFFSET Function Dynamic Range
ExcelIsFun 2 years ago