Asking for two formulas here to give the overall picture/goal. If that’s against policy, I’ll repost as two posts.
First, in column B of my destination tab, I need a formula that will look in Revenue!S4:S9000 (I’d prefer to use S:S) for any value greater than 10,000. If I filter that column and show only those with values greater than 10,000 I see there are 15. In this case that means B1:B15 is being populated with the corresponding value greater than 10,000. One row for every value greater than 10,000, one row for every qualified response
Secondarily, lets say the value in RevenueS37 is 10,390. It will show up in column B because of the formula above I need. I then need a formula in column A that says “Oh look, Revenue!S37 is greater than 10,000. Show me what the value in Revenue!C37 is.
Thanks in advance
First, in column B of my destination tab, I need a formula that will look in Revenue!S4:S9000 (I’d prefer to use S:S) for any value greater than 10,000. If I filter that column and show only those with values greater than 10,000 I see there are 15. In this case that means B1:B15 is being populated with the corresponding value greater than 10,000. One row for every value greater than 10,000, one row for every qualified response
Secondarily, lets say the value in RevenueS37 is 10,390. It will show up in column B because of the formula above I need. I then need a formula in column A that says “Oh look, Revenue!S37 is greater than 10,000. Show me what the value in Revenue!C37 is.
Thanks in advance