Forum Discussion

Excel's avatar
Excel
Iron Contributor
Jul 08, 2021
Solved

List of students with excel formula

Hello Everyone, I have students details -    Conditions is - I want to name of students with the help of formula which -  1. Between 0-15 Kg 2. Above 15 but less than or equal to 20 Kg 3....
excel
Formulas and Functions
  • Lorenzo's avatar
    Lorenzo
    Jul 08, 2021

    Excel 

    Problem misunderstood - sorry & Thanks for providing the Excel version

     

     

    I'm not a big fan of IFERROR so when I can avoid it I do. If you pref. a version with IFERROR to avoid the COUNTIFS let me know. See attached file

Excel's avatar
Excel
Iron Contributor
Jul 08, 2021

Hello L z,
Sir, It give only number. I want list of name according to conditions.

I am Using Microsoft office 2019 Home and Student

Lorenzo's avatar
Lorenzo
Silver Contributor
Jul 08, 2021

Excel 

Problem misunderstood - sorry & Thanks for providing the Excel version

 

 

I'm not a big fan of IFERROR so when I can avoid it I do. If you pref. a version with IFERROR to avoid the COUNTIFS let me know. See attached file

Resources