Download workbook: http://people.highli ne.edu/mgirvin/Excel IsFun.htm
See how to Do a lookup that finds the smallest value that is greater than or equal to lookup_value using the INDEX function and a -1 (minus one) in the 3rd argument of the MATCH function, or said a different way: Upside down VLOOKUP: Sort 1st Column Decending & Bump Into First Smallest Value, then jump back a row.
Download workbook: http://people.highli ne.edu/mgirvin/Excel IsFun.htm
See how to:
1. Select From Drop Down and Pull Data From Different Sheets using Data Validation List, the INDIRECT Function, and the join symbol ampersand &
2. Learn about syntax for Sheet References
3. INDIRECT Function
4. Data Validation Drop Down List
Download workbook: http://people.highli ne.edu/mgirvin/Excel IsFun.htm
SchultzesBlues and Daniel1Dion at YouTube give great examples of how to add a leading zero and dash to a number using the REPLACE function and Custom Number Formatting,
Related to this video:
Mr Excel & excelisfun Trick 107: Add Leading Zero At Front & Dash In Middle, Variable Length Numbers
Download workbook: http://people.highli ne.edu/mgirvin/Excel IsFun.htm
See how to Adding with AND, BETWEEN and OR Criteria with SUMIFS function for AND criteria and 2 COUNTIF functions for OR criteria.
Download workbook: http://people.highli ne.edu/mgirvin/Excel IsFun.htm
See Mr Excel and excelisfun use two methods to count between words using formulas and VBA.
INDEX and MATCH and COUNTA functions to count between words
Download workbook: http://people.highli ne.edu/mgirvin/Excel IsFun.htm
See how to:
1. Count Text Entries Between Two Dates using COUNTIFS, Date Criteria and Comparative Operators, and wildcards for Text
Download workbook: http://people.highli ne.edu/mgirvin/Excel IsFun.htm
See how to:
Copy First, then Paste Special values 1 of 6 ways::
1. Ribbon Method
2. Alt, E, S, V, Enter
3. Right-click Key, S, V, Enter
4. Right-click Edge of highlighted Range, Drag, Drag back, point to "Copy Here As Values Only"
5. F2, F9
6. Highlight, F9
Download workbook: http://people.highli ne.edu/mgirvin/Excel IsFun.htm
See how to add 1 to every number in a column that is greater than 20 using the IF Function and paste Special Values
Select Cells Not Next To Each Other (Noncontiguous), Hold Ctrl Key While Clicking
Download workbook: http://people.highli ne.edu/mgirvin/Excel IsFun.htm
Keyboard to jump to Active Cell is Ctrl + Backspace:
1. In A Formula
2. In The Worksheet
Shmuel Oluwa at Facebook!!!
Download workbook: http://people.highli ne.edu/mgirvin/Excel IsFun.htm
See how to:
1. Lookup First & Last Name From 2 Different Cells & Return Then To 1 Cell
2. Lookup & Return Two Items to Single Cell Using INDEX Function Array Capabilities
3. INDEX and MATCH functions
Download workbook: http://people.highli ne.edu/mgirvin/Excel IsFun.htm
See how to use a logical formula uising Mixed Cell References, Comparative Operators, TODAY and AND Functions to format the row in a To Do List if the date is TODAY and the items has not been completed yet.
Download workbook: http://people.highli ne.edu/mgirvin/Excel IsFun.htm
See how to calculate the "first of the month" and "last of the month" from any date in the month using:
1. Excel 2007, Excel 2010 and Analysis Toolpak function EOMONTH
2. Excel 2003 or earlier: DATE, MONTH functions and addition tick and zero in day argument of DATE function
Download workbook: http://people.highli ne.edu/mgirvin/Excel IsFun.htm
See how to Lookup Group Number and Return Names In Group using an array formula that lookup a single group number and return multiple names. See the Functions, INDEX, SMALL, IF, ROW, ROWS, IFERROR, AGGREGATE.
