Are these 25 number fields all part of the same record?
Might it be possible to restructure this so that they are up to 25 related records?
(Might make this a tad easier.)
Hi PhilModJunk (nice name :) )
yes they are all part of the same record and ... no they don't all have to be and in fact, having worked through some of it in my mind this afternoon, it may be better to have them in a separate table. What do you have in mind?
For one thing, in a portal set up to sort the records by the value in this field, the first 25 rows in the portal would be your 25 largest values.
In a conditional format, an expression that returns a fill color when the field's value is greater than or equal to the 25th row in this portal would highlight the top 25.