1. Excel Magic Trick 185 Dynamic Formula Extract Data 1criteria

  2. Excel Magic Trick 185.5 Advanced Filter Data Extract 1criter

  3. Excel Magic Trick 186 Dynamic Formula Extract Data 2 criteria

  4. Excel Magic Trick 186.5 Advanced Filter Data Extract 2 criteria

  5. Excel Magic Trick #187: Unique List w Dynamic Formula

  6. Excel Magic Trick #188: Page Setup Across Multiple Sheets

  7. Excel Magic Trick #189: Count Days Not Sunday

  8. Excel Magic Trick #190: Rearrange First Last Name w Formula

  9. Excel Magic Trick #191: Extract Middle Name Formula

  10. Excel Magic Trick #192: Extract Middle Name Text To Column

  11. Excel Magic Trick #193: Grade Book Based on Total Score

  12. Excel Magic Trick #194: Grade Book Based on Percentages

  13. Excel Magic Trick #195: Grade Book That Subtracts Lowest Score

  14. Excel Magic Trick #196: Grade Book That Subtracts Two Lowest

  15. Excel Magic Trick 285: Markup On Sell Price Formula

  16. Excel Magic Trick #197: Grade Book with Weights

  17. Excel Magic Trick #198: 3 Formulas For Frequency Distribution

  18. Excel Magic Trick #199: Histogram w Conditional Formatting

  19. Excel Magic Trick #200: 2007 Table Formula Nomenclature

  20. Excel Magic Trick #201: Custom Number Format For Pro ID

  21. Excel Magic Trick #202: Calculate Vacation Days

  22. Excel Magic Trick #203: SUMIF function formula 21 Examples of Different Criteria

  23. Excel Magic Trick #204: Adding w Case Sensitive Criteria

  24. Excel Magic Trick #203: Sequential Numbers in Formulas ROWS function

  25. Excel Magic Trick #204: Scatter & Bar Chart Together

  26. Excel Magic Trick #205: Get C21 Values From Across Sheets

  27. Excel Magic Trick #206: Artists Commissions & VLOOKUP

  28. Excel Magic Trick #207: Business Math Word Problem Setup

  29. Excel Magic Trick #208 Ctrl + Enter 6 Examples Of Efficiency

  30. Excel Magic Trick #209: Formula Or Function Confusion

  31. Excel Magic Trick #210: Formula Not Calculating Stuck

  32. Excel Magic Trick #211: Advanced Filter Extract ID Variable

  33. Excel Magic Trick #212: Filter Copy Paste Data Extract

  34. Excel Magic Trick #213: Dynamic Data Extract w Formula

  35. Excel Magic Trick #214: Circular Reference in Formula

  36. Excel Magic Trick #215: Dynamic Print Range

  37. Excel Magic Trick 216 Pivot Table 4 Variable Cross Tabulation

  38. Excel Magic Trick #217: IF Function Text Logical Test

  39. Excel Magic Trick #218: Pivot Table Macro w Dynamic Range #1

  40. Excel Magic Trick #219: Pivot Table Macro w Dynamic Range #2

  41. Excel Magic Trick #220: Count Dates In Each Month

  42. Excel Magic Trick #221: LEN function Counts Spaces

  43. Excel Magic Trick #222: Find and Count Longest Word / Text

  44. Excel Magic Trick #223 Count Single Character In Text String

  45. Excel Magic Trick #224: Extract Prefix From Product ID

  46. Excel Magic Trick #225: 2 Way Lookup With Duplicates

  47. Excel Magic Trick #226: Apply Names To Formulas

  48. Excel Magic Trick #228: Text Formula & Forced Wrap Text

  49. Excel Magic Trick #229: Dump Data Pivot Table Macro

  50. Excel Magic Trick #230: Dynamic Stock Chart Excel Table List

  51. Excel Magic Trick #231: VLOOKUP w 3 Tables on Diff Sheets

  52. Excel Magic Trick #232: Add w 3 Criteria OR 2 Criteria

  53. Excel Magic Trick #233: 2 Business Math Tricks

  54. Excel Magic Trick #234: Trig functions PI RADIANS DEGREES

  55. Excel Magic Trick #235: Custom Number Format for Inches

  56. Excel Magic Trick # 256: 162 Excel Keyboard Shortcuts

  57. Excel Magic Trick #236: Excel For Home Improvement

  58. Excel Magic Trick #237: ROUND to Digit or Multiple

  59. Excel Magic Trick #238: Round Times To 5 Minutes

  60. Excel Magic Trick #239: Graphing Functions of X Scatter Diag

  61. Excel Magic Trick #240: Dynamic Range New Data At Top

  62. Excel Magic Trick #241: Data Validation w Shrinking List

  63. Excel Magic Trick #242: Excel Sudoku Puzzle

  64. Excel Magic Trick #243: MEAN MEDIAN MODE STDEV Histogram

  65. Excel Magic Trick #244: Advanced Filter Extract To New Sheet (Word Criteria)

  66. Excel Magic Trick #245: Matching 2 Lists w IF & OR functions

  67. Excel Magic Trick #246: Waterfall Profit Chart (Create an Excel Waterfall Chart)

  68. Excel Magic Trick #247: Add Leading Zeroes w Formula

  69. Excel Magic Trick #248: PERCENTILE QUARTILE functions Decile

  70. Excel Magic Trick #249: Data Extract To New Workbook using Advanced Filter

  71. Excel Magic Trick 250 Pivot Table Unique List in Unique List

  72. Excel Magic Trick 251 Formula Unique List within Unique List

  73. Excel Magic Trick # 252: Text Cell Range In A Function

  74. Excel Magic Trick 253: Data Table 1 Variable What If Analysis

  75. Excel Magic Trick # 254: Data Table Creates 100 Formulas

  76. Excel Magic Trick 255: Data Table 2 Variable What If Analysis

  77. Excel Magic Trick # 256: 162 Excel Keyboard Shortcuts

  78. Excel Magic Trick 257 Convert Dates as Text to Dates As No.

  79. Excel Magic Trick # 258: Chart From Noncontiguous Data

  80. Excel Magic Trick # 259: Dynamic DV List Based On DV List

  81. Excel Magic Trick # 260: Delete All Invoices w TBO

  82. Excel Magic Trick 261: Random Num 1- 100 Not Divisible By 3

  83. Excel Magic Trick # 262: Dynamic Weekly Chart

  84. Excel Magic Trick # 263: Math Function of X & Dynamic Charts

  85. Excel Magic Trick # 264: Absolute & Relative Macro Fix Data

  86. Excel Magic Trick # 265: Mixed Cost Accounting Linear Regression - Ron's Class

  87. Excel Magic Trick # 266: Count Words Only w COUNTIF ?*

  88. Excel Magic Trick # 267: Percentage Change Formula & Chart

  89. Igor's Physics Class Linear Regression Tricks

  90. Video For Carly: Chemestry 2 X Y Scatter Diagrams 1 Chart

  91. Excel Magic Trick # 268: Conditional Formatting Max In Row

  92. Excel Magic Trick # 269: COUNTIF & Ampersand

  93. Excel Magic Trick # 270: Conditional Format Based On Diff Cell

  94. Excel Magic Trick # 271: Conditional Format w DATEDIF function

  95. Excel Magic Trick # 272: Count Unique Or Duplicate Records

  96. Excel Magic Trick # 273: Extract Top 5 Records w Formula

  97. Excel Magic Trick # 274: Probabilities Binomial Distribution

  98. Excel Magic Trick # 275: Reduce Column Of Numbers By 35%

  99. Excel Magic Trick 276 MoreFunc Excel add-in 66 New functions

  100. Excel Magic Trick # 277: Add 01-12-13-14-15 Text String From

  101. Excel Magic Trick # 278: Return Every 10th Value w Formula

  102. Excel Magic Trick # 279: Create the Series AA, AB, ZZ w For

  103. Excel Magic Trick # 280: Calculate the Year You Retire

  104. Excel Magic Trick # 281: Formula For Vest Date

  105. Excel Magic Trick # 282: Lookup Name When Today Is Birthday

  106. Excel Magic Trick # 283: Lookup Vendor Name With Low Bid

  107. Excel Magic Trick 284 Create Line Chart W Two Number Series

  108. How To Post Questions At The Mr Excel Message Board

  109. Excel Magic Trick 285: Markup On Sell Price Formula

  110. Excel Magic Trick 286: MOD function & Time Calculations (Time For Night Shift, or Negative Time)

  111. Excel Magic Trick 287: Lookup Adding - Array & Non-Array Formula

  112. Excel Magic Trick 288: Count Character or Nums. In Text String

  113. Excel Magic Trick 289: LEN & SUBSTITUTE functions Counting Tricks

  114. Excel Magic Trick 290: Count Codes From Column of Text Strings

  115. Excel Magic Trick 291: Add Nums Associated w Codes From String

  116. Excel Magic Trick 292: Reverse Last & First Name Tricks

  117. Excel Magic Trick 293: Dynamic Count Unique Words In Column

  118. Excel Magic Trick 294: Filter Pie Chart w Formula & Pivot Table

  119. Excel Magic Trick 295: DV Dropdown From Diff Workbook

  120. Excel Magic Trick 296: Conditional Format Intersection Row & Column

  121. Excel Magic Trick 297: Add Certain Column Only

  122. Excel Magic Trick 297.5: Conditional Sum for Varying Columns

  123. Excel Magic Trick 298: MOD function Formula for Total Time Worked

  124. Excel Magic Trick 299: Date & Time Number - Total Days & Hours Formula

  125. Excel Magic Trick 300: YEAR DATE TEXT functions for Date Label

  126. Excel Magic Trick 301: 1900 Date Problems and Fixes

  127. Excel Magic Trick 302: Randomly Select Names No Repeats

  128. Excel Magic Trick 303: VLOOKUP from middle of text-string

  129. Excel Magic Trick 304: Charts: Add Secondary Axis To Frequency Column Chart

  130. Excel Magic Trick 305: SUM digits from string

  131. Excel Magic Trick 306: MCONCAT LOOKUP functions (CAT = 593)

  132. Excel Magic Trick 307: Invert Range With Formula

  133. Excel Magic Trick 308: Extract Data To New Workbook W Formula

  134. Excel Magic Trick 309: Partial Text Match: Why 2^15?

  135. Excel Magic Trick 310: D Functions & Date Criteria

  136. Excel Magic Trick 311: Verify ID prefix w OR function 3 Examples

  137. Excel Magic Trick 312: Extract Date & Time From Text String

  138. Excel Magic Trick 313: Some Facts About Array Formulas

  139. Excel Magic Trick 314: Convert TRUE & FALSE to 1 and 0

  140. Excel Magic Trick 315: SUMIF Only Accept Ranges, Not Arrays

  141. Excel Magic Trick 316: Concatenate Selection w Criteria (MoreFunc Excel Add-in functions)

  142. Excel Magic Trick 317: MID function: Pattern Recognition

  143. Excel Magic Trick 318: MID Text (substring) VLOOKUP Trouble

  144. Excel Magic Trick 319: VLOOKUP - Lookup Table In Descending Order Use INDEX & MATCH

  145. Excel Magic Trick 320: Lookup Adding: SUMPRODUCT & SUMIF

  146. Excel Magic Trick 321: Match Text Substrings

  147. Excel Magic Trick 322: NOT Advanced Filter Data Extract

  148. Excel Magic Trick 323: Partial Text VLOOKUP (Fuzzy Match)

  149. Excel Magic Trick 324: Dynamic Data Validation List of Dates

  150. Excel Magic Trick 325: Aggregate Daily Cost to Monthly Cost

  151. Excel Magic Trick 326: Hyperlink Worksheet To Worksheet

  152. Excel Magic Trick 327: Gantt Chart with Weekends and Holidays

  153. Excel Magic Trick 328: VLOOKUP Without 1st Column

  154. Excel Magic Trick 329: Frequency Polygon With 2 Or More Line

  155. Excel Magic Trick 330: DCOUNT DSUM between 2 Numbers

  156. Excel Magic Trick 331: EXTRACT Numbers without Leading Zeros

  157. Excel Magic Trick 332: Insert Text with REPLACE function

  158. Excel Magic Trick 333: #DIV/0! Error IF & ISERROR or IFERROR functions

  159. Excel Magic Trick 334: VLOOKUP & Data Validation for Invoice

  160. Excel Magic Trick 337: RANK function 10 Examples

  161. Excel Magic Trick 338: Extract Records By E-mail Extension

  162. Excel Magic Trick 339: Sum Differences with 2 Criteria SUMPRODUCT

  163. Excel Magic Trick 340: Weighted Percent without 2 Lowest (SMALL & LARGE functions)

  164. Excel Magic Trick 341 Extract Data w OFFSET & INDEX function

  165. Excel Magic Trick 343: Delete Blanks Rows & Keyboard Magic

  166. Excel Magic Trick 344: MAX IF & RANK functions without Zeros

  167. Excel Magic Trick 345: Find 1st Positive number and assign 1 MATCH & COUNTIF functions

  168. Excel Magic Trick 346: EXPONENTS Formula and Formatting in Excel

  169. Excel Magic Trick 347: Magic Moments In Excel! MROUND v ROUND functions

  170. Excel Magic Trick 348: Formula for Unit Inventory Total SUMIF function Trick

  171. Excel Magic Trick 349: Automatic Dynamic Chart for Last Nine Weeks of Data

  172. Excel Magic Trick 350: Conditional Format Values Listed 3 Times COUNTIF function Trick

  173. Excel Magic Trick 351: Dynamic Area Chart (Plot x & f(x) on Area Chart)

  174. Excel Magic Trick 352: English and Math Comparative Operators

  175. Excel Magic Trick 353: Date VLOOKUP for Seasons

  176. Excel Magic Trick 354: 2 Criteria Counting for Blood Sugar Levels

  177. Excel Magic Trick 355: VLOOKUP for Mortgage Calculator

  178. Excel Magic Trick 356: Dynamic Two-Way Look Form Different Workbook

  179. Excel Magic Trick 357: Excel Efficiency: Proper Data Setup, Then Lookup From Different Sheet

  180. Excel Magic Trick 358: Part 1: Return Multiple Items From One Lookup Value for Table w Formula

  181. Excel Magic Trick 359: Part 2: Return Multiple Items From One Lookup Value for Column w Formula

  182. Excel Magic Trick 360: Part 3: Return Multiple Items From One Lookup Value for Row w Formula

  183. Excel Magic Trick 362: 12 Amazing Counting Formulas

  184. Excel Magic Trick 363: Return Cell Address of First Non-Blank

  185. Excel Magic Trick 364: Return First Non-Blank (Array Formula)

  186. Excel Magic Trick 365: Return First Non-Blank (Not An Array Formula)

  187. Excel Magic Trick 366: Lookup Adding For Accounting Estimate

  188. Excel Magic Trick 367: Any Number Not Zero = TRUE

  189. Excel Magic Trick 368: Count Unique Items With More Than One Criteria

  190. Excel Magic Trick 369: Compare 2 Lists, Extract Records Not Listed Twice

  191. Excel Magic Trick 370: Conditional Formatting Odd & Even Numbers

  192. Excel Magic Trick 371: Average Time Between Customer Orders AVERAGEIF & AVERAGE IF

  193. Excel Magic Trick 372: WORKDAY function - Find Date in Future

  194. Excel Magic Trick 373: Randomize with No Repeats (Numbers or Words)

  195. Excel Magic Trick 375: Keyboard Shortcut For Copying Columns

  196. Excel Magic Trick 376: Stem & Leaf Chart for Big Numbers

  197. Excel Magic Trick 377: Add Every Other Number In Range of Cells

  198. Excel Magic Trick 378: Field Names Should Be Formatted