Index match

donniedorian

Board Regular
Joined
May 27, 2015
Messages
132
Hi
I need an index match to get all the b1:e1 which are greater than 0

Anyone can help ?


a
b
c
d
e
f
g
h
i
k
1
aaa
bbb
ccc
ddd
2
0
1
0
1
bbb
ddd
3
1
2
3
0
aaa
bbb
ccc
4
2
0
0
0
aaa
5
6

<tbody>
</tbody>
 

Some videos you may like

Excel Facts

Can you AutoAverage in Excel?
There is a drop-down next to the AutoSum symbol. Open the drop-down to choose AVERAGE, COUNT, MAX, or MIN

Watch MrExcel Video

Forum statistics

Threads
1,109,272
Messages
5,527,712
Members
409,785
Latest member
lalz1205

This Week's Hot Topics

Top