Find and place number between two numbers

[MaxL76]

Hi All,
How all you going?
My question is:
I have row of random numbers from 1 to 70 on A1 - Q1.
I would like find and place on S1 number between 29 - 42 that exist on row A1 - Q1.
On T1 i would like find and place number that between 29 - 42 but not equal to S1.

Thanks a lot

 

[Phuoc]

Try this in S1 and copy to right:

=IFERROR(AGGREGATE(15,6,$A$1:$Q$1/($A$1:$Q$1>=29)/($A$1:$Q$1<=42),COLUMNS($S$1:S1)),"")

 

[MaxL76]

Try this in S1 and copy to right:

=IFERROR(AGGREGATE(15,6,$A$1:$Q$1/($A$1:$Q$1>=29)/($A$1:$Q$1<=42),COLUMNS($S$1:S1)),"")

Thanks a lot Phuoc,
it's do a work, wow.
Can you give me small explanation how it work.

Thansk,

 

[MaxL76]

Another challenge:
Same situation but now i have to ranges
1: 1 - 8;
2: 61 - 70;

Thanks a lot

 

[Phuoc]

Another challenge:
Same situation but now i have to ranges
1: 1 - 8;
2: 61 - 70;

Thanks a lot

1. 1-8

=IFERROR(AGGREGATE(15,6,$A$1:$Q$1/($A$1:$Q$1>=1)/($A$1:$Q$1<=8),COLUMNS($S$1:S1)),"")

2. 61-70

=IFERROR(AGGREGATE(15,6,$A$1:$Q$1/($A$1:$Q$1>=61)/($A$1:$Q$1<=70),COLUMNS($S$1:S1)),"")

...

 

[MaxL76]

1. 1-8

=IFERROR(AGGREGATE(15,6,$A$1:$Q$1/($A$1:$Q$1>=1)/($A$1:$Q$1<=8),COLUMNS($S$1:S1)),"")

2. 61-70

=IFERROR(AGGREGATE(15,6,$A$1:$Q$1/($A$1:$Q$1>=61)/($A$1:$Q$1<=70),COLUMNS($S$1:S1)),"")

...

Hi Phuoc,
Thanks,
Sorry but i meant check two ranges in same time.

BR
Max

 

[MaxL76]

Hi Phuoc,
Thanks,
Sorry but i meant check two ranges in same time.

BR
Max

What i meant it if i cad do that:
=IFERROR(AGGREGATE(15,6,$A$1:$Q$1/($A$1:$Q$1>=1)/($A$1:$Q$1<=8),COLUMNS($S$1:S1)),"") and IFERROR(AGGREGATE(15,6,$A$1:$Q$1/($A$1:$Q$1>=61)/($A$1:$Q$1<=70),COLUMNS($S$1:S1)),"")
Thanks,