• Status: Solved
  • Priority: High
  • Security: Public
  • Views: 31
  • Last Modified:

2n covert 0 to

2n convert 0 to
2n_convert_0_to.xlsm
0
ADRIANA P
Asked:
ADRIANA P
  • 4
  • 2
1 Solution
 
Martin LissOlder than dirtCommented:
Do you agree that rather than there being several permutations of column "A" in columns 'C' to 'E' or 'F', etc., that column 'C' should be just the ord rule value of column 'A'?
0
 
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
Martin

Do you agree that rather than there being several permutations of column "A" in columns 'C' to 'E' or 'F', etc., that column 'C' should be just the ord rule value of column 'A'?

I don't understand

can you show an sample


remember 03  is too    35     85     80      00  55  33  88
0
 
Martin LissOlder than dirtCommented:
Here's an example. In the 4n workbook when the value in column 'A' is 8809, columns C to F are 88, 80, 89 and 09 because those are the unique permutations of 8809 in ord rule order.

In this workbook when the value in column 'A' is 06 (row 2326) for example, there is only one unique, ord rule order and that is "60" and that should go in column 'C'.
0
Cloud Class® Course: Python 3 Fundamentals

This course will teach participants about installing and configuring Python, syntax, importing, statements, types, strings, booleans, files, lists, tuples, comprehensions, functions, and classes.

 
Martin LissOlder than dirtCommented:
By the way, row 2326 is the only row where 'A' is not already in ord rule order.
0
 
Martin LissOlder than dirtCommented:
Here is the result.
29095533.xlsm
1
 
ADRIANA PACCOUNTING ASSISTANTAuthor Commented:
Great Job  Martin !!

working as needed
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Introducing Cloud Class® training courses

Tech changes fast. You can learn faster. That’s why we’re bringing professional training courses to Experts Exchange. With a subscription, you can access all the Cloud Class® courses to expand your education, prep for certifications, and get top-notch instructions.

  • 4
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now