exclusion of values

  1. R

    Return Top 5 Accounts while excluding accounts placed on an "Exclusion" list

    I have a list of customer accounts with various past due balances. I would like a formula to rank the accounts based on past due values while excluding specific accounts that have been placed on a separate "Do Not Include" list. I have used LARGE, which works great until I need to exclude...
  2. T

    How to include values from a serie within a given coefficient of variation

    Hi, I have a serie of values (cf. bellow) from which I want to sort as following: The coefficient of variation (CV) (=Stdev/mean) of this population should be 5% or bellow. As you might see from the whole population, the CV is higher than 5%. How can I keep the population the biggest...

Some videos you may like

This Week's Hot Topics