excel work -- 2
$10-30 AUD
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.
Numer ID Projektu: #24555823
O projekcie
14 freelancerów złożyło ofertę za $18 w tym projekcie
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
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
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
Hello. I know Excel very well also program macros. I have also knowledge in maths to solve your case. Relevant Skills and Experience ........
The number of combinations you're looking for is 36x30x24=25,920 I hope this be useful Best Regards, Eduardo
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.
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.
Hi, I had more experience in data entry and technical documentation. Kindly assign me the project work.
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
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