Bring different number into another sheet
Closed
Melissa
-
Jun 24, 2010 at 07:05 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Jun 26, 2010 at 06:40 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Jun 26, 2010 at 06:40 AM
Related:
- Bring different number into another sheet
- Windows network commands cheat sheet - Guide
- Google sheet right to left - Guide
- Mark sheet in excel - Guide
- Little alchemy cheat sheet - Guide
- How to open excel sheet in notepad++ - Guide
4 responses
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Jun 24, 2010 at 07:11 PM
Jun 24, 2010 at 07:11 PM
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
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
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
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Jun 24, 2010 at 07:33 PM
Jun 24, 2010 at 07:33 PM
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
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
Thank you for your help
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Jun 24, 2010 at 08:20 PM
Jun 24, 2010 at 08:20 PM
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.
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Jun 25, 2010 at 04:14 PM
Jun 25, 2010 at 04:14 PM
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
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
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Jun 26, 2010 at 06:40 AM
Jun 26, 2010 at 06:40 AM
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)
=Max(I:I)
and
=MIN(I:I)
