How do you create a formula in excel to drop the lowest two grades of assignments that have different total points

Dear @Rosa M Fernandez,

Thank you for posting your question in the Microsoft Q&A forum.

Based on your description, you have a gradebook with 12 assignments that each have different total points, and you want to drop the two lowest percentage grades.

For better understand your situation, could you please provide me more detail information as:

• Can you confirm how you want to drop grades by raw points or by percentage (earned ÷ total)? because you mentioned that each one has different total points
• Can you share the exact layout of your data? For example, which columns contain earned points and total points?
• Which version of Excel are you using?
• Do you want the final output to be the overall percentage or total points after dropping two?

The more detail information you provide, the more effective I can support you.

Looking forward to your update

Thank you for your understanding.

The following function will produce an array that contains your original data with the two lowest scores removed:

=LET(rng,A1:B12,cnt,ROWS(rng),srt,SORT(rng,2),seq,SEQUENCE(1,cnt-2),CHOOSEROWS(srt,seq))

In my example, the data was in A1:B12 and the sores were in column B.

Change the value of rng to match your data. Change the second SORT argument to match the relative column containing the scores.

If you don't want the array but just need to compute some value, like average, based on the remaining scores, replace the last argument to LET with the expression you need, such as AVERAGE(CHOOSECOLS(CHOOSEROWS(srt,seq),2))