Not sure whether you amended the eyeball alert N1's expression correctly?
viz: the output range monitored and the physical num that its equated to?
Eg in my sample ver2, it was written in N1:
=SUMPRODUCT((M2:M11<"")/COUNTIF(M2:M11,M2:M11&""))=10
where M2:M11 = output range, and M2:M11 is a range that spans 10 cells
If the output range is now: M2:M21
N1 should be adapted to read:
=SUMPRODUCT((M2:M21<"")/COUNTIF(M2:M21,M2:M21&""))=20
Btw, pl go back to ALL responses which helped you in this thread,
click the YES buttons in ALL responses.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:23,500 Files:370 Subscribers:66
xdemechanik
---
"Kashyap" wrote:
Hi Max,
If I increase the size of COL K,L,M to 20 and A,B,C to 40, I'm not getting
'TRUE' in N1 at all..