order data by column

to put data in order (high to low ) by percent

as shown

A1.PNG29119660a_to_order_high_to_low_perc.xlsm
ADRIANA PACCOUNTING ASSISTANTAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Martin LissOlder than dirtCommented:
Sorted.
29119816.xlsm
0
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
Martin
is sorted  
but
find 2 button is gone ??
0
Martin LissOlder than dirtCommented:
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.
0
Big Business Goals? Which KPIs Will Help You

The most successful MSPs rely on metrics – known as key performance indicators (KPIs) – for making informed decisions that help their businesses thrive, rather than just survive. This eBook provides an overview of the most important KPIs used by top MSPs.

ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
You make it look easy.

Great Expert !
0
Martin LissOlder than dirtCommented:
BTW, the same is true for Find 3 and Find 1.
0
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
when is alreday open  i get this
b111.PNG
0
Martin LissOlder than dirtCommented:
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.
0
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
as shown c111.PNG
0
Martin LissOlder than dirtCommented:
If you make a change to the Permute workbook then don't reopen it.
0
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
help me to use the find 3 and find 1  

i just get find 2 all times
0
Martin LissOlder than dirtCommented:
I changed the workbook so that Find 1, 2 and 3 are always visible.
29119816a.xlsm
0
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
have this situation
d111.PNG
then
e111.PNG
0
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
it should be 007  but

don't know why  it show like 07

then  don't work as should be
0
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
the error is in permuta  file
0
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
may be i gest lost
but working now as needed
0
Martin LissOlder than dirtCommented:
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
0
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
is an great job !
0
Martin LissOlder than dirtCommented:
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
0
ADRIANA PACCOUNTING ASSISTANTAuthor 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
0
Martin LissOlder than dirtCommented:
Corrected.

Please do not select this as a solution.
29119816c.xlsm
0
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
Martin  

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

zzz555555555.PNG
0
Martin LissOlder than dirtCommented:
Corrected.
29119816d.xlsm
0
ADRIANA PACCOUNTING ASSISTANTAuthor 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
0
Martin LissOlder than dirtCommented:
Are these the correct results?2018-09-28_16-07-16.jpg
0
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
Yes  only 225X are shown

any combination of 225 is good  

like x225  225x  22x5 ect...
0
Martin LissOlder than dirtCommented:
0
ADRIANA PACCOUNTING ASSISTANTAuthor 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
0
Martin LissOlder than dirtCommented:
Please also upload the permutation wb that is the source of the data.
0
ADRIANA PACCOUNTING ASSISTANTAuthor 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
0
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
Please also upload the permutation wb that is the source of the data.
here
permuta_count.xlsm
0
Martin LissOlder than dirtCommented:
Would 8109 be a match for '809'?
0
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
yes!

any position for the 809 will work for me

809X  X809  8X09  80X9  ect...
0
Martin LissOlder than dirtCommented:
This has to be a new record for updates.
29119816f.xlsm
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
Superior work.


Best Experts!
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
VBA

From novice to tech pro — start learning today.