S
sierra spiegel
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/tutorial...5f-20ce4f44f644/mdi-interform-communicat.aspx
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/tutorial...5f-20ce4f44f644/mdi-interform-communicat.aspx