Forum Discussion
Solved
Cell location while filtering
Hi Folks, This is probably a simple procedure, but I haven't been able to figure it out. I have a cell with a few nested if/or statements that rely on the data in another cell. For example, let's...
You may use directly like
=IF(<formula>="Something","Name1","no name")
but better to keep formula result in helper cell(s) and use them for the reference.
Cory McKissick , for the model like here
=INDEX(B2:B30,AGGREGATE(15,6,1/(SUBTOTAL(3,OFFSET(B2,ROW(B2:B30)-ROW($B$1)-1,0)))*(ROW(B2:B30)-ROW($B$1)),1))
SergeiBaklan Wow, thank you! I have absolutely no idea what is happening in your code, but it does what I need it to. I'll have to figure out how to integrate that into the If/or statement, but it shouldn't be too tough.
You may use directly like
=IF(<formula>="Something","Name1","no name")
but better to keep formula result in helper cell(s) and use them for the reference.
