Results 1 to 33 of 33

Average without Duplicate Values

Threaded View

  1. #1
    Forum Contributor
    Join Date
    02-11-2024
    Location
    Chicago
    MS-Off Ver
    2021
    Posts
    102

    Average without Duplicate Values

    I have a predictive model for MLB games. I use the following formula to take averages of the last four numbers in a single column. But the numbers I am using are duplicates. I would like to keep this formula, but have it disregard the duplicate values. Is that possible? Thanks in advance.

    =IFERROR(AVERAGE(OFFSET(INDEX(B2:B163,AGGREGATE(14,6,(ROW(B2:B163)-ROW(B1))/(B2:B163<>""),1)),0,0,MAX(-COUNT(B2:B163),-4),1)),0)
    Average Without Duplicates.xlsx
    Last edited by IdabaMalouki; 04-07-2025 at 03:55 PM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Average with multiple criteria and exclude duplicate values
    By chriswrcg in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 06-23-2023, 04:42 PM
  2. [SOLVED] Average and array formula not using duplicate values
    By kflemi16 in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 10-10-2022, 06:37 AM
  3. [SOLVED] Removing duplicate rows based on single column duplicate values
    By Miasav90 in forum Excel General
    Replies: 7
    Last Post: 09-23-2021, 08:40 AM
  4. Replies: 45
    Last Post: 01-04-2021, 09:03 AM
  5. [SOLVED] Average if values in adjacent columns is >0 AND adjust the average range each time
    By ew17 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-17-2020, 12:56 PM
  6. Replies: 4
    Last Post: 07-25-2017, 12:26 PM
  7. Replies: 1
    Last Post: 03-03-2014, 11:06 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1