order data  by column

ADRIANA P
ADRIANA P used Ask the Experts™
on
to put data in order (high to low ) by percent

as shown

A1.PNG29119660a_to_order_high_to_low_perc.xlsm
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Martin LissOlder than dirt
Most Valuable Expert 2017
Distinguished Expert 2018
Commented:
Sorted.
29119816.xlsm
ADRIANA PACCOUNTING ASSISTANT

Author

Commented:
Martin
is sorted  
but
find 2 button is gone ??
Martin LissOlder than dirt
Most Valuable Expert 2017
Distinguished Expert 2018

Commented:
Nothing I did for this question would make that happen.

When you open the workbook, click the 'Open Permute WB' button and the 'Find..." button that matches the data in column 'L' will appear.
Ensure you’re charging the right price for your IT

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden using our free interactive tool and use it to determine the right price for your IT services. Start calculating Now!

ADRIANA PACCOUNTING ASSISTANT

Author

Commented:
You make it look easy.

Great Expert !
Martin LissOlder than dirt
Most Valuable Expert 2017
Distinguished Expert 2018

Commented:
BTW, the same is true for Find 3 and Find 1.
ADRIANA PACCOUNTING ASSISTANT

Author

Commented:
when is alreday open  i get this
b111.PNG
Martin LissOlder than dirt
Most Valuable Expert 2017
Distinguished Expert 2018

Commented:
Do you mean that if you click the 'Open Permute WB a second time that you get that error. If so it doesn't happen to me.
ADRIANA PACCOUNTING ASSISTANT

Author

Commented:
as shown c111.PNG
Martin LissOlder than dirt
Most Valuable Expert 2017
Distinguished Expert 2018

Commented:
If you make a change to the Permute workbook then don't reopen it.
ADRIANA PACCOUNTING ASSISTANT

Author

Commented:
help me to use the find 3 and find 1  

i just get find 2 all times
Martin LissOlder than dirt
Most Valuable Expert 2017
Distinguished Expert 2018
Commented:
I changed the workbook so that Find 1, 2 and 3 are always visible.
29119816a.xlsm
ADRIANA PACCOUNTING ASSISTANT

Author

Commented:
have this situation
d111.PNG
then
e111.PNG
ADRIANA PACCOUNTING ASSISTANT

Author

Commented:
it should be 007  but

don't know why  it show like 07

then  don't work as should be
ADRIANA PACCOUNTING ASSISTANT

Author

Commented:
the error is in permuta  file
ADRIANA PACCOUNTING ASSISTANT

Author

Commented:
may be i gest lost
but working now as needed
Martin LissOlder than dirt
Most Valuable Expert 2017
Distinguished Expert 2018

Commented:
My workbook looks at cell 'L7' in the permutation workbook to decide what kind of Find can be done. Since 'A7' in that picture shows a 2-digit number, only 'Find 2' can be done. If 'L7' should be 007 then you should ask a new question about fixing that. I may not be able to help though.

Mi libro de trabajo mira la celda 'L7' en el libro de trabajo de permutación para decidir qué tipo de búsqueda se puede hacer. Como 'A7' en esa imagen muestra un número de 2 dígitos, solo se puede hacer 'Find 2'. Si 'L7' debe ser 007, entonces debe hacer una nueva pregunta sobre cómo arreglarlo. Puede que no pueda ayudar sin embargo
ADRIANA PACCOUNTING ASSISTANT

Author

Commented:
is an great job !
Martin LissOlder than dirt
Most Valuable Expert 2017
Distinguished Expert 2018

Commented:
I corrected a problem where cell B2 on the V_OUT sheet and similar data on the HIST_DTA sheet were incorrect. I also removed cells A1 and B1 on the TRI-DATA sheet.

Please do not select this as a solution.
29119816b.xlsm
ADRIANA PACCOUNTING ASSISTANT

Author

Commented:
Martin

when i press clean one time i get this

it erase the guide  lines

and changes the row 5



i had to clean it for put new data
is not suppose to do that

yyyyyyy6666666.PNG
Martin LissOlder than dirt
Most Valuable Expert 2017
Distinguished Expert 2018

Commented:
Corrected.

Please do not select this as a solution.
29119816c.xlsm
ADRIANA PACCOUNTING ASSISTANT

Author

Commented:
Martin  

now when i need delete data in TRI-DATA sheet in get this

zzz555555555.PNG
Martin LissOlder than dirt
Most Valuable Expert 2017
Distinguished Expert 2018

Commented:
Corrected.
29119816d.xlsm
ADRIANA PACCOUNTING ASSISTANT

Author

Commented:
Martin


i have this data

then need find all the comnination for 225  (find 3)

i get some numbers with not 225

z999999999.PNG29119816d_to_adjust_.xlsm
Martin LissOlder than dirt
Most Valuable Expert 2017
Distinguished Expert 2018

Commented:
Are these the correct results?2018-09-28_16-07-16.jpg
ADRIANA PACCOUNTING ASSISTANT

Author

Commented:
Yes  only 225X are shown

any combination of 225 is good  

like x225  225x  22x5 ect...
Martin LissOlder than dirt
Most Valuable Expert 2017
Distinguished Expert 2018

Commented:
ADRIANA PACCOUNTING ASSISTANT

Author

Commented:
Martin

V_OUT sheet is have the same issue  

Please need it in any combination

zzzzz888888888.PNG
here the file with the data
29119816e_anycombination_to_adjust_.xlsm
Martin LissOlder than dirt
Most Valuable Expert 2017
Distinguished Expert 2018

Commented:
Please also upload the permutation wb that is the source of the data.
ADRIANA PACCOUNTING ASSISTANT

Author

Commented:
Martin

this file  was ok on that

z777777777777777777777777777777.PNG
the only change from here is now we are working with an list
good_any_combination.xlsm
ADRIANA PACCOUNTING ASSISTANT

Author

Commented:
Please also upload the permutation wb that is the source of the data.
here
permuta_count.xlsm
Martin LissOlder than dirt
Most Valuable Expert 2017
Distinguished Expert 2018

Commented:
Would 8109 be a match for '809'?
ADRIANA PACCOUNTING ASSISTANT

Author

Commented:
yes!

any position for the 809 will work for me

809X  X809  8X09  80X9  ect...
Older than dirt
Most Valuable Expert 2017
Distinguished Expert 2018
Commented:
This has to be a new record for updates.
29119816f.xlsm
ADRIANA PACCOUNTING ASSISTANT

Author

Commented:
Superior work.


Best Experts!

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial