0
[postlink]https://themagicofexcel.blogspot.com/2012/01/mr-excel-excelisfun-trick-90-remove.html[/postlink]http://www.youtube.com/watch?v=tUJ4WGOrHa4endofvid [starttext] See excelisfun create a silly formula that is WAY too long, then see Bill Mr Excel Jelen demonstrate two quick and easy methods for removing the earliest duplicates and keeping the later duplicates using a formula and Remove Duplicates Feature.
Keep The Last Duplicate [endtext]

Mr Excel & excelisfun Trick 90: Remove Earlier Duplicates, Keep Last Duplicate

0
[postlink]https://themagicofexcel.blogspot.com/2012/01/httpwww.html[/postlink]http://www.youtube.com/watch?v=up7H-t2ew7Eendofvid

[starttext]
Download workbook: people.highline.edu See Mr Excel and excelisfun use two methods to create a Wacth Window
[endtext]

Mr Excel & excelisfun Trick 93: Watch Window: VBA or Watch Window

1
[postlink]https://themagicofexcel.blogspot.com/2012/01/mr-excel-excelisfun-excel-trick-1-two-2.html[/postlink]http://www.youtube.com/watch?v=8Cl1sc9ExMIendofvid
[starttext] See Mr Excel and excelisfun demonstrate two methods to do a two way lookup on a table array:
Mr Excel: MATCH and INDEX functions in one formula to retrieve a value from the intersection of a row header and column header in a table array (table of lookup values)
excelisfun: Names, INDIRECT function and the Space Intersector Operator in one formula to retrieve a value from the intersection of a row header and column header in a table array (table of lookup values)

YTL Excel #119: Amazing Lookup Solution!
Excel Lookup Series #11: INDEX & MATCH functions Two 2 Way Lookup
Excel Name Trick #7: INDIRECT function, Names and LOOKUP
Mr Excel & excelisfun Excel Trick #1: Two 2 Way Lookup
MrExcel's Learn Excel #965 - Two-Way Lookup
Excel Magic Trick #136: Two 2 way lookup with VLOOKUP & MATCH [endtext]

Mr Excel & excelisfun Excel Trick #1: Two 2 Way Lookup

Subscribe to: Comments (Atom)