How to do Permutations in numbers. Not just the of possible permutations but the actual combinations.

Downloaded the document, got the combinations folder. I can see the preview images, opened the zip. However it doesn't suggest a program to open them with. All there is, is a whole lot of .iwa files?

Yes I get a "folder" here too. Add .numbers as a suffix to the folder name (so it becomes Combinations.numbers), confirm in the dialog that's what you want, and you should be good to go.

SG

Thanks so much!

Unfortunately its in the new version of numbers 😟 which I don't have (or the new pages/keynote).

its in the new version of numbers 😟 which I don't have (or the new pages/keynote).

Numbers 3 (and Mavericks on which it runs) is a free download. So why not give it a try? If you don't like Numbers 3, you can easily export this document back Numbers 2 via File > Export to > Numbers '09 ...

SG

Turns out I had the new numbers downloaded on my MBP.

Thanks it works great, however the final column, does not seam to be printing out the correct information

I've set the cells to
[0]

[A]

[J]

It adds all the new combinations, however it only prints out the first type [0] where it should be either [A] or [J]?

many thankks

Hi there! Thanks for helping the first time round! I have a few questions if you have the time to answer them?

1. Is there a way to print out the combination as a string in this format: A-B-1-2-3 (where the numbers/letters no necessarily in that order are separated with hypons in a single cell?

2. Is there a way to add a monetary value to the input letters in the first table? Where A=£50 B=£20 etc.

3. Finally, the goal is to find out the total price for each combination, hence the necessity to apply values to the original table, create the strings and lastly find the total monetary value of that string?

many thanks

You should start a new thread

New thread started here 🙂
How to add value (£) to worded cells?