How to find the bottom data

[gimran]

hello everyone,

I am a bit confused regarding the a issue stated below.

I have an changing data set with values in descending order. Now I want to find out the 3 or 4 smallest data in the data set. But i am afraid i could not figure it out how to do.

<colgroup><col width="64" span="3" style="width:48pt"> </colgroup><tbody>
</tbody>

SID	NAME	Sales
9182	Sample1	23009
9092	Sample2	23008
3349	Sample3	23007
3345	Sample4	23006
2234	Sample5	23005

<tbody>
</tbody>

Now I want get the bottom the sales persons name and all the information across rows in a different table.

Please help me to know how I can do that.

Br
Imran

 

[Aladin Akyurek]

If that exhibit is the output, what is the input?

 

[gimran]

The input is the example. Now how can I find the bottom three data as the data range will be expandable .

 

[Aladin Akyurek]

The input is the example. Now how can I find the bottom three data as the data range will be expandable .

What is the output: the last 3 records, that is, DID, NAME, and Sales?

 

[gimran]

the output should be the last three data.

SID	NAME	SALES
3349	Sample3	23007
3345	Sample4	23006
2234	Sample5	23005

<tbody>
</tbody>

 

[Aladin Akyurek]

the output should be the last three data.

SID	NAME	SALES
3349	Sample3	23007
3345	Sample4	23006
2234	Sample5	23005

<TBODY>
</TBODY>

What if the input contains an additional record like below;

4567,Sample9,23007

Must this record also included in the output along with the three already listed?

 

[gimran]

Please understand what I am trying to say.

I need to find the 3 bottom sales person SID, name and sales count, from a data range which changes everyday. I have to do it manually.

answer to your qus, if that input is the bottom three the it should be in the output in relevant position (descending order).

 

[Aladin Akyurek]

Please understand what I am trying to say.

I need to find the 3 bottom sales person SID, name and sales count, from a data range which changes everyday. I have to do it manually.

answer to your qus, if that input is the bottom three the it should be in the output in relevant position (descending order).

Let A:C house the input.

E2, copy across and down:

=IF(ROWS(F$2:F2)<=3,
  OFFSET(INDEX(A:A,MATCH(9.99999999999999E+307,$A:$A)),-(3-ROWS(F$2:F2)),0,1),
  "")

 

[gimran]

Thanks a lot, it solved my problem.

Now I have another problem. I have numerical data set across rows which are not identical in numbers. How can I find the top 10 unique values from that data set.
below is an example of my data set:

Sales
2345
2346
2356
2345
2343
2234
2346
2356
3321
3321
2343
2356
1234

<tbody>
</tbody>

Please let me know how can I get the top 10 unique values.

 

[Aladin Akyurek]

Thanks a lot, it solved my problem.

You are welcome.

Now I have another problem. I have numerical data set across rows which are not identical in numbers. How can I find the top 10 unique values from that data set.
below is an example of my data set:

Sales
2345
2346
2356
2345
2343
2234
2346
2356
3321
3321
2343
2356
1234

<TBODY>
</TBODY>

Please let me know how can I get the top 10 unique values.

What would be result, given the sample above?