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 July 31, 2022July 31, 2022/ Brent Allen

Non-Unique List in Excel: Showing Only Duplicates

Non-Unique List in Excel: Showing Only Duplicates

When receiving a list of data, it can be desirable to find unique values. This can be accomplished in Excel using the UNIQUE() function, or by using other methods for getting unique values. But, what happens if you’d like a …

Read More
Updated on June 12, 2022June 12, 2022/ Brent Allen

BYROW() in Excel: A Marginal Tax Schedule Example

The BYROW() function allows calculations to be done on a row by row basis. This allows for new functions to be created that are similar to the SUMPRODUCT() function, but are much more customizable. In this example, we will be …

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

  • Non-Unique List in Excel: Showing Only Duplicates
  • BYROW() in Excel: A Marginal Tax Schedule Example
  • Unique Values from 2 Lists in Excel – Multiple Methods
  • LAMBDA() in Excel – Generating an Amortization Schedule
  • LET Function in Excel: A Name Parsing Example

Categories

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