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.

ijl wrote:
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.

And you question is....

Not sure what you are wanting here or what you mean by a "unconditional
constant". Try Auto filter. Data Filter Autofilter You can now filter
or limit by any value in the drop down box.

If this doesn't help post back and state exactly what you are trying to do.

gls858

.. change the computed 1's and 0's to unconditional constants.

You can freeze the values in the col with formulas by an in-place copy
paste special values
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----

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.