Try Conditional formatting to higlight mismatches without sorting:

On column H

=$H2<INDEX($D$2:$D$8,MATCH(1,($E2=$A$2:$A$8)*($F2 =$B$2:$B$8),0))

set colour (pattern)

"Robert M" wrote:

Hi,

I have the following type of data that I am trying to sort so that blank
cells are kept in their proper relationship to data.

A B C D E F G H

LName FName IDNum Amt LName FName IDNum Amt
Allen Art 12345 100 Allen Art 12345 100
Bell Ben 23456 200 Bell Ben 23456 200
Davis Dan 34557 275 Corn Cal 67891 75
Allen Ann 12345 325 Ball Bob 77793 100
Elon Ed 89012 125 Gill Gay 90876 400
Ford Hal 11456 100
Gill Gay 90876 600

The resulting sort would be:

A B C D E F G H
LName FName IDNum Amt LName FName IDNum Amt
Allen Ann 12345 325
Allen Art 12345 100 Allen Art 12345 100
Ball Bob 77793 100
Bell Ben 23456 200 Bell Ben 23456 200
Corn Cal 67891 75
Davis Dan 34557 275
Elon Ed 89012 125
Ford Hal 11456 100
Gill Gay 90876 600 Gill Gay 90876 400

The goal after the sort is to use the EXACT function see if the Amt columns
(D and H) match for each person.

Perhaps from the above examples and explantion, there may be a better way to
accomplish this task.

Thanks in advance for any and all help.