I have 5 numbers 1 to 5. I require assistance on displaying all combinations of those 5 numbers. I do not want to know quantity of combinations these 5 numbers make but only what the combinations are e.g 12345, 12344, 12432 etc displayed in open office or excel spreadsheet. There are several answers from programming point of view but i require a formula or vba coding in excel or open office.I have 5 numbers 1 to 5. I require assistance o