1- Click following web link
https://www.scheller.gatech.edu/cent...lab/index.html
2- Download excel file by pressing All Industries (non-financials) from bottom of that web link
3- Open downloaded excel file.
4- You will see following formula when you go to B6 cell of Tables sheet
=IF($A6="";"";INDEX(Data!$2:$9996;ROW(B6)-4;MATCH(B$5;Data!$2:$2;0)))
My question is here:
I cant find any sheet which is named Data.
So, what is Data?
Sub DontForgetThese() If Your thread includes any code Then Please use code tags... If Your thread has been solved Then Please mark as solved... If Anybody has helped to you Then Please add reputation... End Sub
There are instructions at the top of the page explaining how to attach your sample workbook.
The sheet in question must be hidden.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
I have checked but there is no hidden sheet.
Last edited by AliGW; 04-18-2020 at 01:56 AM. Reason: Please don’t quote unnecessarily!
There must be. Please attach the file here. It’s probably a very hidden sheet.
No need to attach file because I have already put the web link.
Last edited by AliGW; 04-18-2020 at 02:04 AM. Reason: Please don’t quote unnecessarily!
Unless you attach the file here, I won’t be looking at this for you. No member should need to follow an external link in order to help you. You are the one asking for help - please provide all necessary materials here. Thanks.
Solved by myself.
thank you.
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks