Hi Experts,
In a given table, when specific number occurs, find another given number that occurred along with specific number in row same time.
choosing data and filters consume too much time !
File attached (excel 2007 revised on 3May
1 1 6 6 6 8 9
2 2 5 7 7 8 9
3 2 6 7 8 9 9
4 1 3 5 6 8 9
5 2 5 5 6 6 9
6 1 1 1 6 7 8
7 5 6 7 7 9 9
8 4 4 5 5 6 8
9 1 2 4 5 5 6
10 6 7 7 7 8 9
task:
If only 6 present in a row from B1:G10 then count total number "8" in rows 1 to 10
(following is result manually counted)
Count number of 8 when 6 appears in same row from table
Final Results:
If following No is present =6 Count 8 total =6
Thanks in advance
Karnik
Bookmarks