Formulas

3 Ways to Transpose Excel Data

3 Ways to Transpose Excel Data (Rotate data from Horizontal to Vertical or Vice Versa) Check out 3 ways to Transpose your data in Excel. These are useful when you want to switch the orientation of your data from columns to rows

VLOOKUP Explained with 2 Practical Examples

VLOOKUP & HLOOKUP for Dynamic Lookups These two functions are easy to write, understand, and they’re a major time-saver for simpler lookups. The VLOOKUP function can search for a specific category or value in a table and return the “opposing” value from adjacent columns.

Return Multiple Match Values in Excel

Lookup 1 Value, Return Many Matches The VLOOKUP and INDEX & MATCH formulas are great for looking up a value in a large data table and returning a result from the adjacent columns. But how can you return multiple results? What if

Excel SUM Between Dates

How can you sum values between two dates in Excel? What if you wanted the sum for a specific month? And what if you decided to add in multiple criteria to your existing sum? For example get the sum by month AND division AND