Question description:
This user has given permission to use the problem statement for this
blog.
I have a ton of rows of data. Each row has the company name, revenue, and month and year, dating back to 2000. Some companies have 204+ rows of information if they have been open since 2000. I want to add a column for "Month Opened" and "Year Opened" since 2000. Each company has a unique name.
Basically, I want to automatically pull the first date that company showed up. That open date should be the same for that company on every row throughout no matter what month of revenue it is showing on that row.
How do I do this?!
Thank you.
Solved by F. E. in 12 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
Excelchat Expert
20/04/2018 - 07:17
hello
User
20/04/2018 - 07:18
hello
User
20/04/2018 - 07:19
how do i automate this with a formula?
Excelchat Expert
20/04/2018 - 07:20
Automate what ?
Excelchat Expert
20/04/2018 - 07:20
Col E and F ?
User
20/04/2018 - 07:20
yes
User
20/04/2018 - 07:20
i have thousands of rows
Excelchat Expert
20/04/2018 - 07:22
Why row 5 is Jan 2001
User
20/04/2018 - 07:22
it is the first time it showed up
User
20/04/2018 - 07:23
i want to pull the first time that company showed up (month and year)
Excelchat Expert
20/04/2018 - 07:23
Ok
Excelchat Expert
20/04/2018 - 07:23
I see
User
20/04/2018 - 07:25
hm i think that worked? i cannot see the formula though..
Excelchat Expert
20/04/2018 - 07:26
This is the formula =VLOOKUP(A2,$A$1:B2,2,0) for column E
Excelchat Expert
20/04/2018 - 07:26
and form column F the formula is =VLOOKUP(A2,$A$1:C2,3,0)
User
20/04/2018 - 07:27
wow amazing! you area genius!
User
20/04/2018 - 07:27
are a
User
20/04/2018 - 07:28
yes!!!
User
20/04/2018 - 07:28
thank you
Excelchat Expert
20/04/2018 - 07:28
Anything else
Excelchat Expert
20/04/2018 - 07:28
?
User
20/04/2018 - 07:28
no thats all for now.
User
20/04/2018 - 07:29
thanks
Excelchat Expert
20/04/2018 - 07:29
Have a good day
User
20/04/2018 - 07:29
you as well
This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user
information.