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.

[TABLE="width: 192"]
<colgroup><col width="64" span="3" style="width:48pt"> </colgroup><tbody>[TR]
[TD="class: xl63, width: 64"][/TD]
[/TR]
</tbody>[/TABLE]
[TABLE="width: 500"]
<tbody>[TR]
[TD]SID[/TD]
[TD]NAME[/TD]
[TD]Sales[/TD]
[/TR]
[TR]
[TD]9182[/TD]
[TD]Sample1[/TD]
[TD]23009[/TD]
[/TR]
[TR]
[TD]9092[/TD]
[TD]Sample2[/TD]
[TD]23008[/TD]
[/TR]
[TR]
[TD]3349[/TD]
[TD]Sample3[/TD]
[TD]23007[/TD]
[/TR]
[TR]
[TD]3345[/TD]
[TD]Sample4[/TD]
[TD]23006[/TD]
[/TR]
[TR]
[TD]2234[/TD]
[TD]Sample5[/TD]
[TD]23005[/TD]
[/TR]
</tbody>[/TABLE]

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.

[TABLE="width: 500"]
<tbody>[TR]
[TD]SID[/TD]
[TD]NAME[/TD]
[TD]SALES[/TD]
[/TR]
[TR]
[TD]3349[/TD]
[TD]Sample3[/TD]
[TD]23007[/TD]
[/TR]
[TR]
[TD]3345[/TD]
[TD]Sample4[/TD]
[TD]23006[/TD]
[/TR]
[TR]
[TD]2234[/TD]
[TD]Sample5[/TD]
[TD]23005[/TD]
[/TR]
</tbody>[/TABLE]

 

[Aladin Akyurek]

the output should be the last three data.

[TABLE="width: 500"]
<TBODY>[TR]
[TD]SID
[/TD]
[TD]NAME
[/TD]
[TD]SALES
[/TD]
[/TR]
[TR]
[TD]3349
[/TD]
[TD]Sample3
[/TD]
[TD]23007
[/TD]
[/TR]
[TR]
[TD]3345
[/TD]
[TD]Sample4
[/TD]
[TD]23006
[/TD]
[/TR]
[TR]
[TD]2234
[/TD]
[TD]Sample5
[/TD]
[TD]23005
[/TD]
[/TR]
</TBODY>[/TABLE]

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:

[TABLE="class: grid, width: 50, align: left"]
<tbody>[TR]
[TD]Sales[/TD]
[/TR]
[TR]
[TD]2345[/TD]
[/TR]
[TR]
[TD]2346[/TD]
[/TR]
[TR]
[TD]2356[/TD]
[/TR]
[TR]
[TD]2345[/TD]
[/TR]
[TR]
[TD]2343[/TD]
[/TR]
[TR]
[TD]2234[/TD]
[/TR]
[TR]
[TD]2346[/TD]
[/TR]
[TR]
[TD]2356[/TD]
[/TR]
[TR]
[TD]3321[/TD]
[/TR]
[TR]
[TD]3321[/TD]
[/TR]
[TR]
[TD]2343[/TD]
[/TR]
[TR]
[TD]2356[/TD]
[/TR]
[TR]
[TD]1234[/TD]
[/TR]
</tbody>[/TABLE]

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:

[TABLE="class: grid, width: 50, align: left"]
<TBODY>[TR]
[TD]Sales
[/TD]
[/TR]
[TR]
[TD]2345
[/TD]
[/TR]
[TR]
[TD]2346
[/TD]
[/TR]
[TR]
[TD]2356
[/TD]
[/TR]
[TR]
[TD]2345
[/TD]
[/TR]
[TR]
[TD]2343
[/TD]
[/TR]
[TR]
[TD]2234
[/TD]
[/TR]
[TR]
[TD]2346
[/TD]
[/TR]
[TR]
[TD]2356
[/TD]
[/TR]
[TR]
[TD]3321
[/TD]
[/TR]
[TR]
[TD]3321
[/TD]
[/TR]
[TR]
[TD]2343
[/TD]
[/TR]
[TR]
[TD]2356
[/TD]
[/TR]
[TR]
[TD]1234
[/TD]
[/TR]
</TBODY>[/TABLE]























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

What would be result, given the sample above?