In an Excel table I use a formula =if(a1=a2, 1, 0) to mark first of the two
consecutive lines that have identical content in cell a by putting 1 or 0 in
column b.
Then I want to sort the table by its b values. To do this I have to change
the computed 1's and 0's to unconditional constants.