limiting results

  • Thread starter Thread starter JT
  • Start date Start date
J

JT

I hope I can explain this properly.

I have a sheet with 100 results but I only want to display the last 4
results on another sheet if there are more than 4 results - so the results
displayed would be 97,98,99,100.

Anyone have a suggestion?

thanks
JT
 
Ron Rosenfeld said:
You could enter =cell_ref for the last for results, where cell_ref is the
sheet and cell where that result is located. Or you could use a formula
that figures that out for you, and adjusts as you add more data.
There are relatively easy ways to do this, but without knowing how your
data is set up, it is not useful for me to speculate on which solution
might be best for you.
Click to expand...

Your second option would be great, essentially what we have is a field where
text is entered. When the data is displayed it lists everything - if we
only had 4 entries that's what it would display, if we had 500 entries it
shows all of them. We just need to see the last 4 entries or whatever
number we choose to set it at.
 
Hi JT
If you want the top four all in one cell, do it this way:
=LARGE(A1:A7,1)& ","&LARGE(A1:A7,2)&","& LARGE(A1:A7,3)&","& LARGE(A1:A7,4)
If you want the lowest, change the large for small and the number after the
range will give you the series, first, second etc.
HTH
Cimjet
 
I just notice You want it on an other sheet.
=LARGE(Sheet1!A1:A100,1)&
","&LARGE(Sheet1!A1:A100,2)&","&LARGE(Sheet1!A1:A100,3)&","&LARGE(Sheet1!A1:A100,4)
You need to adjust the range to your needs also.
HTH
Cimjet
 
Hi Cimjet,

Your formula works pretty close to what I was looking for. The only thing
is the cell with the data (which is feedback) is numbered automatically when
data is entered. I can't send the information but maybe this example will
explain what I am trying to accomplish:


In the field I could type: The sky is blue most of the time but not at
night......... when I save, it automatically gets numbered (which is
hidden) - if it was the first feedback it would be listed 1 if it was the
30th comment it would be given the number 30 and so on. So what I need is
your formula with the feedback associated with the number - so I have a
column A which is numerical and column B with the text associated with
column A.
 
I'm a novice at excel, inherited the spreadsheet. What I was trying to
accomplish was to have the results in one cell --- 96 go to the store, 97
come back from the store etc. but have the numbers in a list with the
associated comment beside each number.
 
Back
Top