do you know if there is a way i can replace=20
Adam1 Chicago wrote:
the "6" below with a cell reference?
=3Dif(countif(a1:a100,"X64"),"Warning","")

To point to cell references, use in this way:
=3DIF(COUNTIF(A1:A100,""&X64),"Warning","")
where X64 contains the number

--
Rgds
Max
xl 97
---
GMT+8, 1=B0 22' N 103=B0 45' E
xdemechanik <atyahoo<dotcom
----