EViews.com

I can not see how the indirect function would help with creating a number range in a single cell. Maybe I was too unclear. For example instead of having to write 1, 2, 3, 4, 5, 6, 7, 8, 9, 10 in 10 cells in Excel I want to be able to just make one cell which consist of the number range 1-10 and then...

It is a good suggestion. Do you know if it is possible in excel to define a "number range" in a single cell so I wont have to drag from for example 2000 - 3678 in a column?

Hi,

I have a lot of variables with SIC codes, I need to check the SIC codes up against Fama French's industry portfolio to determine which group it belongs to. Is there an easy way to do this in Eviews or maybe in excel?

Any suggestions will be appreciated!