I have a sheet1 where users will enter an unknown number of items in column
A, and a rating from 1-10 /or/ the letter "M" in column B.

On sheet2, I want to (re)show those items and their ratings in the following
order, based on their rating: all 'M' first, then in descending order, and
have this list automatically update/recalculate when any item is added or
changed on the Sheet1.

Item X M
Item C M
Item K M
Item J 10
Item W 10
Item A 9
Item F 8
Item Y 8
Item N 8
etc.

I know how to do this in VBA, but I'm trying to complete this workbook
without any macros because some users have their macro security set on high
by default and I'd like this to work for everyone without asking them to
change their security settings.

I'm sure there is a way to do this with just formulas (lookups, match,
etc.), but I'm struggling trying to find a combination that will work, since
each row shouldn't repeat data that is already showing above, and should
find the next highest item to bring over.

Helpful hints please?
Thanks,
Keith