steve_stiller
New Member
- Joined
- Sep 1, 2006
- Messages
- 28
Hi,
I have two issues that involving looking up cells in a table... however, the catch is I can't use a macro but only functions built into excel.
First I need to lookup the second and third occurences of a value and return the adjacent cell. I usually, use a macro called nth_occurrence, but due to the updating of my spreadhseet, this has to be done using Match or other built-in functions. And that's where I get stumped. For example. a table A1:b5
1 bob
0 bill
0 bucky
1 steve
1 mike
I need to build a function that would pull the second corresponding occurrence of 1... meaning steve. I'm sure this may be rather simple, but I've been trying things and can't quite get it.
The other issue is, is there a way to return a corresponding row's cell to the highest value in a table w/o a macro.
1 bill
2 mark
5 bucky
4 steve
3 mary
the function would return "bucky". I'm clueless here and could greatly use the help.
Thank you,
Steve
I have two issues that involving looking up cells in a table... however, the catch is I can't use a macro but only functions built into excel.
First I need to lookup the second and third occurences of a value and return the adjacent cell. I usually, use a macro called nth_occurrence, but due to the updating of my spreadhseet, this has to be done using Match or other built-in functions. And that's where I get stumped. For example. a table A1:b5
1 bob
0 bill
0 bucky
1 steve
1 mike
I need to build a function that would pull the second corresponding occurrence of 1... meaning steve. I'm sure this may be rather simple, but I've been trying things and can't quite get it.
The other issue is, is there a way to return a corresponding row's cell to the highest value in a table w/o a macro.
1 bill
2 mark
5 bucky
4 steve
3 mary
the function would return "bucky". I'm clueless here and could greatly use the help.
Thank you,
Steve