Hello,
I was just playing with MATCH, and I noticed it only returns the position of the first match it finds. I was trying to make it spill out all matching positions, but didn't get anywhere I thought it would be pretty simple, but I might need more coffee
Thanks for any input!
I was just playing with MATCH, and I noticed it only returns the position of the first match it finds. I was trying to make it spill out all matching positions, but didn't get anywhere I thought it would be pretty simple, but I might need more coffee
Blank power workbook1.xlsx | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | J | |||
1 | 1 | 2 | 3 | 4 | 1 | actual result: | 1 | |||||
2 | intended result: | 1 | 5 | |||||||||
3 | ||||||||||||
4 | a | b | c | d | a | actual result: | 1 | |||||
5 | intended result: | 1 | 5 | |||||||||
6 | ||||||||||||
Sheet7 |
Cell Formulas | ||
---|---|---|
Range | Formula | |
H1 | H1 | =MATCH(1,A1:E1,0) |
H4 | H4 | =MATCH("a",A4:E4,0) |
Thanks for any input!