Yes, of course.
Afterall we're checking only for blanks in col C in Sheet1,
via the part: (Sheet1!$C$2:$C$100="")
in the formula
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"FARAZ QURESHI" wrote:
WOW! Max!
That was wonderful. By the way would the same formula also work if the ID is
non-numerical, e.g. B-2200?