Initialize or Assign Array Values

I have the following data in a spreadsheet:

No. Name Type Location Module

1 .. .. .. ..
2 .. .. .. ..
3 .. .. .. ..

... .. .. .. ..

100 .. .. .. ..

I want Module to be an Array of 28 and all of them to be initialized with the ModuleName: "Mod_ABCD" i.e,
Module[0] = "Mod_ABCD"
Module[1] = "Mod_ABCD"
..
Module[27] = "Mod_ABCD"

1. How to program this? Is there any initialization statement where in I can do something like this: Module[1:28] = {"Mod_ABCD"}

2. If not, can I assign it in a loop (for loop / do loop )? How & where to write it?

Thanks
ap

Hi

Assuming that the data is in the range E1:E28 then try

Please Login or Register  to view this content.

rylo