foralloccasions

This is nick and when he gets stressed he needs to release a lil energy.

This formula will extract records that meet two conditions (criteria) and list them in order with no extra rows between records. Create a formula t...

Learn How To Use A Macro With Relative and Absolute References to Deal With Data With Variable Row Size!

A MUST TRICK IF YOU USE RECORDED MACROS.

S...

In this tutorial, I demonstrate how to use the "Logical Functions" of IF, AND, and OR in Excel. In order to return the answer TRUE with the AND Fun...

This is the first in a series of tutorials, where I am taking data from a Point-of-Sale (POS) System and using Excel to Analyze the Inventory statu...

1. See Mr Excel and excelisfun try to take a database with repeat names of students with failing Grades and create a unique list of student names t...

Robert asks how he can combine an HLOOKUP and a VLOOKUP together into a single formula. This is a common problem, but you don't use either VLOOKUP ...

Comprehensive Video that shows how to extract records from a table covering these topics:

1. Filter with 6 criteria then extract records to a new l...

Download workbook: http://people.highline.edu/...

See how to:

1. Summarize GL Balances For Specific Date Period From Different W...

Adam liked my Filter/Sort by color trick on the recent CFO Magazine webcast. He asks if there is any way to sum by color. In Episode #1415, Bill s...

Always love this time of year - when Microsoft is hosting the MVP Summit - because it means that Bill "MrExcel" Jelen gets to go out to Seattle, Wa...