Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Who is up for a challenge?
Jason Morin provided me with the following formula
=INDEX(Scores!$L$1:$L$500,SMALL(IF(Scores! $K$1:$K$500="Padres",ROW(INDIRECT("1:500"))),X)) This accomplished what I wanted but I am looking for something that will do it automatically instead of me having to replace the x with the number I want. I want this formula to work in cells J3, J8-J13, J18-J23. Does anyone know a way to change the formula or a different formula that will do this for me? Thanks. My original help question that Jason answered is called vlookup help... See this if you need more information as to what I am looking for. Thanks |
#2
|
|||
|
|||
What do you mean by "do it automatically"?
How should XL know/calculate what X should automatically be? In article , Jambruins wrote: Jason Morin provided me with the following formula =INDEX(Scores!$L$1:$L$500,SMALL(IF(Scores! $K$1:$K$500="Padres",ROW(INDIRECT("1:500"))),X)) This accomplished what I wanted but I am looking for something that will do it automatically instead of me having to replace the x with the number I want. I want this formula to work in cells J3, J8-J13, J18-J23. Does anyone know a way to change the formula or a different formula that will do this for me? Thanks. My original help question that Jason answered is called vlookup help... See this if you need more information as to what I am looking for. Thanks |
#3
|
|||
|
|||
Jambruins wrote...
Jason Morin provided me with the following formula =INDEX(Scores!$L$1:$L$500,SMALL(IF(Scores! $K$1:$K$500="Padres",ROW(INDIRECT("1:500"))),X) ) This accomplished what I wanted but I am looking for something that will do it automatically instead of me having to replace the x with the number I want. I want this formula to work in cells J3, J8-J13, J18-J23. Does anyone know a way to change the formula or a different formula that will do this for me? .... This is only 13 cells. Not an insurmountable burden to change X as needed in just 13 cells. Heck, it would have taken you less time than posting this message to the newsgroup. So sorry, it'd be a bad thing to even attempt to answer this unanswerable challence because it's more important to teach you how to use Excel efficiently, and sometimes that means making changes manually. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Divide Ranks into two teams (mathematical guru challenge) | Excel Discussion (Misc queries) | |||
Data Validaion Challenge | Excel Worksheet Functions | |||
CHALLENGE! - USING IF MAX MIN AND LOOKUP TOGETHER | Excel Worksheet Functions |