andrichara
New Member
- Joined
- Jan 13, 2019
- Messages
- 14
hi to all, i have in G:G a constant values of 1 and 2 and does not change ,is fixed.at F:F there are random variable values of 1 and 2 .what i need is a formula at E1 which counts if for example like workbook attached:if F1 =G1 count 0,if F2=G2 count 0,F3=G3 count 0, F4<>G4 count 1, if F5<>G5 count2,if F6<>G6 count 3 ..and so on ,at F7=G& count zero.I hope i explain well.thanks so much!!