Mr Excel & excelisfun Trick 90: Remove Earlier Duplicates, Keep Last Duplicate
Loading...
Loading...
9:04
Mr Excel & excelisfun Trick 89: PivotTables Grand Totals To Left: LOOKUP or GETPIVOTDATA function?by ExcelIsFun2,330 views- 20:12
Excel 2010 Business Math 44: Payroll Time Sheets, IF Function For Overtime &Gross Pay Calculationsby ExcelIsFun2,897 views
- 14:31
Excel Magic Trick 819: Lookup Second 2nd Item In List: Excel 2010, 2007 and 2003 Methodsby ExcelIsFun1,824 views
- 17:53
Excel 2010 Business Math 43: Excel Time Number Formatting & Excel Time Mathby ExcelIsFun1,596 views
- 13:37
Excel Magic Trick 822: 4-Way Lookup When There ARE Duplicates (Return Multiple Items)by ExcelIsFun2,601 views
- 5:44
excelisfun Search & Find Excel Videos, Playlists, Download Excel Workbooks and more...by ExcelIsFun423,103 views
- 10:03
Excel 2010 Magic Trick 820: Conditional Formatting With Array Formulas!!??by ExcelIsFun2,165 views
- 8:42
Mr Excel & excelisfun Trick 85: Algebra Solving For Unknown: Goal Seek Or Algebra Excel Formula?by ExcelIsFun2,176 views
- 9:41
Mr Excel & excelisfun Trick 75: Dynamic Range VLOOKUP & Data Validation OFFSET or INDEX?by ExcelIsFun4,037 views
- 6:19
Mr Excel & excelisfun Trick 87: Positive Subtotals Only: PivotTable or SUMIFSby ExcelIsFun1,300 views
- 9:06
Mr Excel & excelisfun Trick 84: Count Calls Every 15 Minutes Count Times Between Upper & Lower Limitby ExcelIsFun1,498 views
- 3:44
4-Year Old Does Excel Magic Trick: RAND function, Conditional Formatting & Bubble Chartby ExcelIsFun5,106 views
- 9:42
Mr Excel & excelisfun Trick 93: Watch Window: VBA or Watch Windowby ExcelIsFun2,929 views
- 20:00
Excel 2010 Business Math 37: Checks and Deposits & Withdrawals at Your Bankby ExcelIsFun1,063 views
- 18:57
Excel Magic Trick 823: Conditional Formatting Row, Column, Intersecting and Specific Table 2 Methodsby ExcelIsFun1,898 views
- 3:10
Excel 2010 Business Math 04: Range Functions Rule!by ExcelIsFun1,295 views
- 7:54
Mr Excel & excelisfun Trick 88: Highlight Cumulative Top 70%by ExcelIsFun982 views
- 11:27
Excel 2010 Business Math 39: VLOOKUP to Calculating Checking Feesby ExcelIsFun1,259 views
- 7:46
Mr Excel & excelisfun Trick 76: Worksheet With Hyperlinks That Jump To Each Sheet In The Workbookby ExcelIsFun3,375 views
- 9:09
Mr Excel & excelisfun Trick 86: MODE or MEDIAN From Frequency Table Formula or VBA?by ExcelIsFun923 views
Such an easy formula to solve seems like compliated problem!!! how amazing !!!
1234saiwa 3 months ago
@1234saiwa , Yes it is! Mr Excel should get three points for winning this duel!
ExcelIsFun 3 months ago
This one was tough to follow with all the edits after the fact. I agree -- much easier. Thanks guys.
krn14242 3 months ago
@krn14242 , I was asleep and not thinking clear when I made it...
ExcelIsFun 3 months ago
What is excelisfun thinking!?!?! ISNONTEXT, IF, COUNTIF!?!?!? When all that was needed was =A2 not A3!!!
Point to Mr Excel!
If data set not sorted maybe: =C2=MAX(IF($A$2:$A$595=A2,$C$2:$C$595))
However, Mr Excel's Sort Names, Sort Dates Z to A, Remove Duplicates wins!
ExcelIsFun 3 months ago