Forum Discussion

ShamsM's avatar
ShamsM
Copper Contributor
Aug 26, 2025
Solved

Return only one instance of value for a repeated Item Codes in Excel

Hello,   I have a large data set at the transaction level. For context, let's start with Item Code#1234. In the month of January 2025, there may be a 1,000 recorded transactions for this 1 Item Cod...
excel
Formulas and Functions
office 365
  • NikolinoDE's avatar
    NikolinoDE
    Aug 28, 2025

    You want to avoid double-counting ad spend for an item that has multiple transactions in a month. Essentially, you want one value per item code per month, regardless of how many rows there are for that item, if I understand correctly.

     

    You can use UNIQUE and FILTER (Excel 365 dynamic arrays)

    If the value truly never changes within the month for an item, MAXIFS or MINIFS is the easiest and fastest.

    If there’s a chance values differ and you want the first instance only, UNIQUE(FILTER(...)) is more precise.

     

     

    hope this helps you

NikolinoDE's avatar
NikolinoDE
Platinum Contributor
Aug 28, 2025

You want to avoid double-counting ad spend for an item that has multiple transactions in a month. Essentially, you want one value per item code per month, regardless of how many rows there are for that item, if I understand correctly.

 

You can use UNIQUE and FILTER (Excel 365 dynamic arrays)

If the value truly never changes within the month for an item, MAXIFS or MINIFS is the easiest and fastest.

If there’s a chance values differ and you want the first instance only, UNIQUE(FILTER(...)) is more precise.

 

 

hope this helps you

Resources