How to exclude the row from an array which has the formula in it.

For example the formula below is in cell AU6. I want to exclude A6 from the array. Row AU7 would need to exclude A7 when I drag it down.

=MAX(IF($A$6:$A$493=AT6,$AS$6:$AS$493))

Perhaps
=MAX(IF($A$6:$A$493=AT6,IF(ROW($A$6:$A$493)<>ROW(A6),$AS$6:$AS$493)))

Works Perfectly! Thank you very much Jonmo1!

You're welcome.