Devam Ediyor

504207 Excel Macro Needed

I need an excel macro that can do the following:

Input:

The macro should evaluate a two-column table with columns labeled "Word" and "Frequency". The "Word" column will have a word value like "dog" and a frequency number like "5".

Output:

For each word,frequency row in the macro, the macro should output a line of text printing the word the same number of times as the frequency.

So for an Input row with word as "dog" and frequency as "5", the output would be:

dog, dog, dog, dog, dog;

The output must be in the same excel spreadsheet as the Input table. It must include the comma punctuation and the semi-colon at the end of each line.

Please see the attached photo for a sample of Input data and output for the macro.

Beceriler: Her şey Kabul, Excel

Daha fazlasını görün: macro, excel frequency table, excel row column, excel macro row, excel number word, input data excel photo, number word excel, excel column row, macro spreadsheet, excel text column, column row excel, frequency data, spreadsheet excel word, excel text columns, excel table word, excel input word, data input excel word, text table excel, spreadsheet photo, input output macro excel, excel input output macro, spreadsheet photo data, excel data input word, word input data excel, excel line

İşveren Hakkında:
( 9 değerlendirme )

Proje NO: #2250131

Seçilen:

vserv

Easy, can be made quite flexible to use

0 gün içinde 10$ USD
(72 Değerlendirme)
5.8