Bring different number into another sheet

[Closed]
Report
-
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
-
Hello,

I will try to explain myself in the best possible way. I have a spreasheet in excel. I also have a list of number like this:

Cell C

23456789
23456789
23456789
56487902
23456789
23456789
56487902

I am looking for a formula where I can bring this order numbers into another sheet or tab like this:

cell A1: bring the order 23456789 and in cell A2 bring the other order, in this case 56487902. The problem that Iam facing is how to tell excel to bring those numbers into those cells. iN OTHER WORDS i WANT TO EXTRACT THE DIFFERENT ORDER NUMBERS IN CELL C, SO IT COULD BE 3 OR FOUR OF THEM. iS THERE ANY WAY POSSIBLE..

THANK YOU







4 replies

Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
Are you looking to copy the unique values from t he list to a new location ?
if that is the case then you can use FILTER -> ADVANCE FILTER
I want to copy the different order numbers that appear, it could be in the same sheet, example:

Cell C

23456789
23456789
23456789
56487902
23456789
23456789
56487902

I want a formula to bring the order numbers: in this case only 23456789 and 56487902, even thought I have in cell C 7 entries, only are two order numbers are repeated. please help me :)

melissa
A filter is not useful for me in this case :(
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
Not the filter, use the advance filter

select the list
click on advance filter
choose copy to new location
enable unique values only
click on copy to and type in the cell from where you want the unique list to show up
Hi that is a good idea, the only problem is the list is always changing so a user would have to do this every time,, do you know a way to do this with a formula so there is no user intervention

Thank you for your help
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
I am not sure that if that would be possible via formula only. I am hard pressed to see you living without a macro to accomplish this.
And do you know how?
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
You need to provide more information. A sample file how that show how you want things to be. Also you can use a macro recorder to create this macro
Hi, this is my example:

https://authentification.site/files/23134963/order_numbers.xlsx

you will see that in the "column I", I have the order numbers, they will always be different everyday and they will come or show up in different orders. I would like to extract those records in two different cells.

Thank you I appreciate your help
Posts
4476
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
August 2, 2020
768
So there would be only two numbers always in the list and you want to pull those number , then use

=Max(I:I)
and
=MIN(I:I)