excel work -- 2

W Toku Opublikowano 4 lat temu Płatność przy odbiorze
W Toku Płatność przy odbiorze

I would like to know how I can generate the maximum random combinations between 6 columns containing each 6 elements, and the generated combinations cannot contain more than one element per column. Can anyone help me with this function?

Ex:

1 7 13 19 25 31

2 8 14 20 26 32

3 9 15 21 27 33

4 10 16 22 28 34

5 11 17 23 29 35

6 12 18 24 30 36

1.7.13

1.7.19

2.8,14

2.8.32

10,22,34

Thus generating the total combination of the 6 columns.

Excel Przetwarzanie danych Visual Basic Excel VBA

Numer ID Projektu: #24555823

O projekcie

14 ofert Zdalny projekt Aktywny 4 lat temu

14 freelancerów złożyło ofertę za $18 w tym projekcie

vsprybhanu

Hi, My name is Virendra. I am experienced Data Analyst and Macro Developer. I have excellent knowledge and experience of Manipulating and Exchanging Data in Multiple Sheets, Using Advanced Formulas, Critical Program Więcej

$30 AUD w ciągu 1 dnia
(145 Oceny)
6.2
Jatin77777

Hello, Please try =RANDBETWEEN(0,9) I have gone through with contents and attached files to understand the requirements. I am really interested to do this work and break your huddle. Please allow me to do this job. I Więcej

$20 AUD w ciągu 7 dni
(28 Oceny)
4.8
diptymojumder

Greetings, I understand your project description very well. I think you're looking for someone to generate the maximum random combinations between 6 columns containing each 6 elements. But I want to know more about you Więcej

$10 AUD w ciągu 1 dnia
(25 Oceny)
5.0
VbaStudio

Hello. I know Excel very well also program macros. I have also knowledge in maths to solve your case. Relevant Skills and Experience ........

$20 AUD w ciągu 1 dnia
(14 Oceny)
3.8
eduardtorres

The number of combinations you're looking for is 36x30x24=25,920 I hope this be useful Best Regards, Eduardo

$15 AUD w ciągu 1 dnia
(1 Ocena)
1.0
abilasha26

Hello Its interesting

$25 AUD w ciągu 7 dni
(1 Ocena)
0.0
callsignnovember

Can you please further explain the requirements? As I am not being to understand the result which you are looking for and what are the data types in the source data.

$20 AUD w ciągu 7 dni
(0 Oceny)
0.0
GuyEisen

Hi, I have read your description, and I think there's no other person who is more ready to make this project for you. Send me a message now so we can start as quickly as possible! I got more than 4 years of experience Więcej

$10 AUD w ciągu 1 dnia
(0 Oceny)
0.0
karenancy2

hello,I have read and understood your project and I am interested in it,I am an experienced professional writer of 5 years of experience. kindly hire me and I am always available and negotiable.

$25 AUD w ciągu 2 dni
(1 Ocena)
0.0
pm1170680

Hello, My name is Pankaj Mehra. I am a dedicated and hard working person who believes in honesty and good working relation. I have certain qualities which make me good at this. I have completed Diploma in Computer Appl Więcej

$20 AUD w ciągu 3 dni
(0 Oceny)
0.0
ramachandransrn

Hi, I had more experience in data entry and technical documentation. Kindly assign me the project work.

$10 AUD w ciągu 1 dnia
(0 Oceny)
0.0
Pampanahari

I will do your project of " Excel Project"within period with accuracy as per your requirements and also I have good experience and skilled in all types of data entry operating, MS Office ,high speed typing skilled, we Więcej

$10 AUD w ciągu 1 dnia
(1 Ocena)
0.0
acmaathil2001

Hi. I have read your project details. I can complete it successfully without mistakes as I have good knowledge in excel. Please consider me and give this project to me. Give further more details about the project. I wi Więcej

$10 AUD w ciągu 3 dni
(0 Oceny)
0.0
Pareshv141082

Pllllll

$25 AUD w ciągu 1 dnia
(0 Oceny)
0.0