1

I want to get summarize information from the following sheet. I don't know how to summarize this information.

enter image description here

My scenario is like this.

If I input -6, I want to find my target value in this range.

enter image description here

If I input 70, I want to show only the following record.

enter image description here

So, summary is like this. I will be key-in one by one

.=
-6
70

If I hit enter, result want to display like;

865.5   70   155    4

enter image description here

Please help me to provide sample solution or sample function to solve this.

3
  • If I input -6, I want to find my target value in this range How is target value decided. Is -6 used as an index into the rows of data.
    – kingchris
    Feb 6, 2016 at 5:08
  • @kingchris Column + 3 and Row + 9. E.g -6 is A11. So, Column is A11+3 and Row is A11+9 Row
    – 502_Geek
    Feb 6, 2016 at 5:14
  • No sorry. I don't understand the thinking here. Perhaps edit your question to clarify how these minus figures offset into your rows and columns and then why the positive 70 does not. There are quite a few cell range functions in Excel but if we don't know what you want its difficult to advise on a solution.
    – kingchris
    Feb 6, 2016 at 5:31

1 Answer 1

1

The equivalent to grep in Excel is AutoFilter. You can use it to view subsets of data based on criteria.

However, to use it your data would require re-organization. The criteria must appear in columns rather than rows. So you would a column for -6, -7, -8, -9, -10, etc.

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .