Mr Excel & excelisfun Trick 28: Find Earliest Date From List Of Dates Given 2 Criteria
Loading...
Loading...
6:29
Mr Excel & excelisfun Trick 29: Existing Customers In Prospect List?by ExcelIsFun2,388 views- 10:35
Mr Excel & excelisfun Trick 27: COUNT w More Than 1 Criteria 10 Examples!by ExcelIsFun2,161 views
- 7:46
Mr Excel & excelisfun Trick 30: Count Bills for Money Transactionby ExcelIsFun2,361 views
- 7:22
Mr Excel & excelisfun Trick 34: Dynamic Range for Adding Three Methodsby ExcelIsFun8,425 views
- 8:16
Mr Excel excelisfun Trick 62: Conditional Format Chart Auto Feature or Formulaby ExcelIsFun6,083 views
- 4:46
Excel Lookup Series #11: INDEX & MATCH functions Two 2 Way Lookupby ExcelIsFun69,039 views
- 4:08
Mr Excel & excelisfun Trick 64: Extract Records With Not Criteria VBA or Filterby ExcelIsFun3,728 views
- 9:52
Mr Excel & excelisfun Trick 41: VBA or Formula Extract Prefix for VLOOKUPby ExcelIsFun7,492 views
- 3:17
Excel Magic Trick #152: Extract records w Field Not Blankby ExcelIsFun3,677 views
- 9:03
Mr Excel & excelisfun Trick 74: Dynamic Range For VLOOKUP & Data Validation List - Table Featureby ExcelIsFun3,849 views
- 4:05
Mr Excel & excelisfun Trick 46: Lookup a value and Retrieve the two items to the Right INDEX & MATCHby ExcelIsFun1,701 views
- 13:27
Mr Excel & excelisfun Trick 7: Reverse Lookup VBA or Formula?by ExcelIsFun10,482 views
- 7:53
Mr Excel & excelisfun Trick 19: VLOOKUP to Left (MATCH & INDEX or LOOKUP)by ExcelIsFun9,848 views
- 8:22
Excel Magic Trick 165p1 MACRO Advanced Filter Extract B-daysby ExcelIsFun7,934 views
- 5:20
Mr Excel & excelisfun Trick 37: Evalualte Text Math VBA, Excel 4 Macro Function, MoreFunc add-in?by ExcelIsFun4,591 views
- 9:41
Mr Excel & excelisfun Trick 31: Word Wrap Problem: Formula or VBA solution?by ExcelIsFun3,672 views
- 10:11
Excel MT142 p2: Array Formula for Counting Datesby ExcelIsFun9,146 views
- 3:30
Mr Excel & excelisfun Trick 72: Data Bar Cell Charts in Excel 2007/2010 & Excel 2003by ExcelIsFun2,503 views
- 5:13
Mr Excel & excelisfun Trick 61: Formula To Report Cell Reference 5 Examplesby ExcelIsFun1,832 views
- 10:54
Mr Excel & excelisfun Trick 78: Extract Top Two Customers In Each Industry with Formula (2 Examples)by ExcelIsFun2,025 views
You have to add the Filter By Selection button to the QAT,
or:
Just right-click and "Filter by Seltion".
ExcelIsFun 11 months ago
Mr Excel, your old school method: Filter by selection is not helping me. I'm using Excel 2010, and after creating a table of data, I click on 'Filter' but it doesn't filter in only the selected value (in your example 'ETRADE'). How did u do that ?
KarthikChotuma 11 months ago
I am glad that you liked it!
With this data setup, use Sort or DMIN. The MIN IF IF formula is only efficient when the data is not in a database-setup.
ExcelIsFun 2 years ago
Great video and either way is ok for me.
gucci4ril 2 years ago
The DMIN is the best way amongst all the options!!
If you wtach the Highline Excel Class Series (59 videos about 20 min each), you will be able to do 100s of things your teachers don't know about!
ExcelIsFun 2 years ago
Hehe, I'll stop cropping up on all of your videos when you stop making interesting videos (a looooooonng time in the future.) The first method looks the easiest, and certainly what my ICT teacher would expect the class do, I can't see the idiots I sit with doing that MIN/IF formula in less than three lessons :P.
Mynotoar 2 years ago