View Single Post
  #18   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Max Max is offline
external usenet poster
 
Posts: 9,221
Default Pick Ref# randomly on an average

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..