"driller" wrote:

can you post the formulas to see sensitivity and meaning?

"Santas Helper" wrote:

I have created a simple formula to compare 2 values and now I would like to
sort the cells Alpabetically but since they contain formulas. I would like to
find a way to place these values on a seperate worksheet and excel
automatically eliminate the blank cells.


The formula is as follows:

=if(a1=b1,b1,"")