Skip to content (Press Enter)
  • Home
  • Services
  • Blog
  • Case Studies
  • About Me
Macrordinary

Macrordinary

  • Home
  • Services
  • Blog
  • Case Studies
  • About Me
Home>formulas

Tag: formulas

Updated on May 11, 2022May 11, 2022/ Brent Allen

Unique Values from 2 Lists in Excel – Multiple Methods

There are many times where you will need to acquire a unique value from not just one list of values, but from two separate lists. Getting a unique value from a single list is straightforward, and can be accomplished in …

Read More
Updated on June 10, 2020June 10, 2020/ Brent Allen

#SPILL! error – What causes it to occur?

#SPILL! error – What causes it to occur?

With the introduction of dynamic arrays comes a new type of error; the spill error. Other errors, such as #N/A, #NUM! and #REF! have existed in Excel for many years. In many cases, workarounds for these errors have been created …

Read More
Updated on February 13, 2020February 13, 2020/ Brent Allen

Using XLOOKUP and TRANSPOSE

Using XLOOKUP and TRANSPOSE

With XLOOKUP , it is now possible to return multiple values from a single function. However; when these values are returned, they show in multiple columns. If we want to have them appear by row, we have to use the …

Read More
Updated on December 19, 2019December 20, 2019/ Brent Allen

INDEX / MATCH – How does it work?

INDEX / MATCH – How does it work?

Up until the release of the XLOOKUP function, there has been significant debate in the Excel community around which function is better – VLOOKUP, or INDEX / MATCH. But, what is INDEX / MATCH? This is a combination of 2 …

Read More

Recent Posts

  • Unique Values from 2 Lists in Excel – Multiple Methods
  • LAMBDA() in Excel – Generating an Amortization Schedule
  • LET Function in Excel: A Name Parsing Example
  • Make a KPI Card like Power BI – In Excel!
  • Top N Results from Excel using Dynamic Arrays

Categories

  • dashboards
  • excel
  • financial formulas
  • formulas
  • M
  • office script
  • pivot tables
  • power apps
  • power bi
  • power pivot
  • power platform
  • power query
  • scripts
  • VBA
Copyright © 2022 Macrordinary. Software Company | Developed By Rara Theme. Powered by WordPress.