Highlight column B, then right-click in the highlighted area Copy
right-click again PasteSpecial Values OK.........

This will convert the formulas into their results..........

Vaya con Dios,
Chuck, CABGx3


"ijl" wrote in message
...
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.