How to generate random strings in Excel automatically using a macro. More details available at www.exceltrain... including the use of RANDARRAY function.
Жүктеу.....
Пікірлер: 20
@Exceltrainingvideos2 жыл бұрын
How to generate random strings in Excel automatically using a macro: www.exceltrainingvideos.com/generate-random-strings-in-excel-automatically/
@Rajan-kk8nl2 жыл бұрын
Very very intersting your all videos, thank you so much sir.
@Exceltrainingvideos
2 жыл бұрын
Thanks 👍
@swapnilwankhede34402 жыл бұрын
Thanks for your uploading useful information
@Exceltrainingvideos
2 жыл бұрын
Thanks and welcome
@jasonturingan3279 Жыл бұрын
HI Sir Dinesh, Thank you for the Awesome tutorial, Can you do a tutorial that generates a name of person pulling from an excel list list?
@arjunspata19132 жыл бұрын
Nice sir 👍
@Exceltrainingvideos
2 жыл бұрын
👍
@dkhallmarkcentre13192 жыл бұрын
How could we use countaA for P=countaA(A:A)-1 as For i = 2 To P
@AnasTahira Жыл бұрын
hi, why are you using the formula for 15 times using concatenate function to generate 15 character sting? just write 15 instead of 1 as the last argument of the Mid Function?
@ExcelMadeEasy4442 жыл бұрын
Nice Explained. Sir, How we can generate random words ?
@Exceltrainingvideos
2 жыл бұрын
Create random strings and compare the random strings with all words in an English dictionary. If it matches, place it in an appropriate cell.
@aryklanees53732 жыл бұрын
sir , have you made any videos to send the data from master wb to closed multiple workbook based on the workbook name & specific column ranges.
@Exceltrainingvideos
2 жыл бұрын
This VBA lesson in Excel will help: www.exceltrainingvideos.com/how-to-copy-column-data-into-another-workbook/
@aryklanees5373
2 жыл бұрын
@@Exceltrainingvideos thank u sir
@kartikk75542 жыл бұрын
Hello sir. Your videos helped me a lot in building industry level applications and i am really thankful for that. Can you please show us, ho we can show the shapes on a userform selected from a listbox. Like, suppose there is a listbox consisting shape names like square, circle, triangle etc. And when I select any shape, it would show me that perticular shape on userform. Can you please help me with that?
@Exceltrainingvideos
2 жыл бұрын
OK
@mbarekmakhfi16352 жыл бұрын
If you would like to help me sir with a job I have to do. It is a question of randomly dispatching a group of supervisors 2 by 2, from a list, over a number of rooms with the following conditions: Each pair should only meet once Each supervisor must pass only once in a room leave 20% of supervisors as replacements
@Exceltrainingvideos
2 жыл бұрын
This link will guide: www.exceltrainingvideos.com/staff-scheduling-solutions-using-solver-in-excel/
Пікірлер: 20
How to generate random strings in Excel automatically using a macro: www.exceltrainingvideos.com/generate-random-strings-in-excel-automatically/
Very very intersting your all videos, thank you so much sir.
@Exceltrainingvideos
2 жыл бұрын
Thanks 👍
Thanks for your uploading useful information
@Exceltrainingvideos
2 жыл бұрын
Thanks and welcome
HI Sir Dinesh, Thank you for the Awesome tutorial, Can you do a tutorial that generates a name of person pulling from an excel list list?
Nice sir 👍
@Exceltrainingvideos
2 жыл бұрын
👍
How could we use countaA for P=countaA(A:A)-1 as For i = 2 To P
hi, why are you using the formula for 15 times using concatenate function to generate 15 character sting? just write 15 instead of 1 as the last argument of the Mid Function?
Nice Explained. Sir, How we can generate random words ?
@Exceltrainingvideos
2 жыл бұрын
Create random strings and compare the random strings with all words in an English dictionary. If it matches, place it in an appropriate cell.
sir , have you made any videos to send the data from master wb to closed multiple workbook based on the workbook name & specific column ranges.
@Exceltrainingvideos
2 жыл бұрын
This VBA lesson in Excel will help: www.exceltrainingvideos.com/how-to-copy-column-data-into-another-workbook/
@aryklanees5373
2 жыл бұрын
@@Exceltrainingvideos thank u sir
Hello sir. Your videos helped me a lot in building industry level applications and i am really thankful for that. Can you please show us, ho we can show the shapes on a userform selected from a listbox. Like, suppose there is a listbox consisting shape names like square, circle, triangle etc. And when I select any shape, it would show me that perticular shape on userform. Can you please help me with that?
@Exceltrainingvideos
2 жыл бұрын
OK
If you would like to help me sir with a job I have to do. It is a question of randomly dispatching a group of supervisors 2 by 2, from a list, over a number of rooms with the following conditions: Each pair should only meet once Each supervisor must pass only once in a room leave 20% of supervisors as replacements
@Exceltrainingvideos
2 жыл бұрын
This link will guide: www.exceltrainingvideos.com/staff-scheduling-solutions-using-solver-in-excel/
@mbarekmakhfi1635
2 жыл бұрын
Thank you very match sir