[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
I can think of numerous inelegant ways to do this using Excel. But the
most elegant solution would be (i think) something like this.
step 1: reshape to wide: so the data now looks like this
gvkey revenue1999 revenue2000.....
1000 111 222
step 2: gen singlerev = the value contained in the cell whose name is
The problem I have is finding the function that does this:" the value
contained in the cell whose name is ("revenue" +"lookupyear") )
Any help is appreciated. Any simpler way to do this is even more appreciated.
* For searches and help try: