Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Dear Experts,
Which Formula shd I use so as to compute how many times a certain pair of numbers appeared in a few groups of 6 numbers example 1st group of 6 numbers: 2 (A1), 1 (B1), 7 (C1), 10 (D1), 8 (E1), 5 (F1) 2nd group of 6 numbers: 5 (A2), 10 (B2), 11 (C2), 12 (D2), 20 (E2), 1 (F2), 3rd group of 6numbers: 15 (A3), 10 (B3), 16 (C3), 17 (D3), 18 (E3), 1 (F3), ... ... ... Number (5 & 10) appear: 2 times Number (1 & 10) appear: 3 times I tried to use countif but it only enable me to match a Single range with a Single citeria but now i have multiple Range to match with 2 citeria. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
formula suggestion please | Excel Worksheet Functions | |||
Suggestion about a formula | Excel Discussion (Misc queries) | |||
Suggestion about a formula | Excel Discussion (Misc queries) | |||
Suggestion about a formula | Excel Discussion (Misc queries) | |||
If Formula suggestion | Excel Worksheet Functions |