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 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

  • 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
  • DA-100 – The Certified Data Analyst Exam
  • Ranges in Office Script – They are different than VBA!

Categories

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