I have a formula that count repeat number only once, but in the same area only:
IF(COUNTIF(A2:C3,A1)0,1,0)+IF(COUNTIF(A6:C9)0,1, 0)
I want to count all the repeats to A1 in both area only once.
thanks
EggHeadCafe - Software Developer Portal of Choice
MDI Inter-Form Communication with Events
http://www.eggheadcafe.com/tutorials...ommunicat.aspx