Forum Discussion

kpan8's avatar
kpan8
Copper Contributor
Oct 15, 2025

Automate the function

Hi, 

 

I have a few thousand records of Course with ANZSIC allocation proportion. Is it possible to create an excel function to pick up the highest values within the same course whose difference of proportion with the next highest is within 0.1 and highlight it out?  In this case, the first 3 records will be highlighted. 

 

Attached with an example for reference. 

 

coursecodecoursenameANZSICDivisionDescANZSICDivisionCodeANZSICConcordanceProportion
ABC123Certificate III in Meat Processing (Food Services)ManufacturingC0.45
ABC123Certificate III in Meat Processing (Food Services)Retail TradeG0.45
ABC123Certificate III in Meat Processing (Food Services)Wholesale TradeF0.1
BCD123Certificate III in Meat Safety InspectionManufacturingC0.65
BCD123Certificate III in Meat Safety InspectionPublic Administration and SafetyO0.35

 

Regards

EP 

BI & Data Analysis
excel

1 Reply

  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor
    Oct 15, 2025

    Please clarify why third record is to be highlighted. Difference between 0.45 and 0.1 is more than 0.1.

Resources