All solutions COLUMNS Expert Solution – Excel COLUMN Problems

Excel - COLUMN Function Problem - Expert Solution

Question description:
This user has given permission to use the problem statement for this blog.

I need to extruct data from column B for a particular month stored in column C as a date in format of dd/mm/yyyy
Solved by E. H. in 20 mins
This is the chat thread from the real Excelchat help session. It contains no private user information.
Excelchat Expert 28/07/2018 - 01:43
Welcome, thank you for choosing Got It Pro-Excel! I'll be glad to assist you with your concern. :)
Excelchat Expert 28/07/2018 - 01:44
Okay, from what you've posted, it seems you want to extract data from column B based on the values in column C. May I kindly ask if you can provide the file you're working on so we could get a better grasp of the situation. Thanks!
Excelchat Expert 28/07/2018 - 01:48
I see that you've pasted data in our document preview. Column B seems to contain brands while column C contains dates. However, for the columns G to R, they seem to be wanting to get the GRPs, not the brand per se. Can you please further clarify on this? Thanks!
Excelchat Expert 28/07/2018 - 01:51
Hello? :)
Excelchat Expert 28/07/2018 - 01:54
Okay, I've included a formula in columns G to R that captures the GRP value for the month based on the date in column C.
Excelchat Expert 28/07/2018 - 01:55
So in row 2, we have 20/06/0216 as our date. The month would thus be in June, and the GRP value of 67 should show under the Jun GRP (column L) on the right side of the table.
Excelchat Expert 28/07/2018 - 01:55
The formula used is as follows: =IF(TEXT(DATE(RIGHT($C2,4),MID($C2,4,2),LEFT($C2,2)),"MMM")=LEFT(G$1,3),$D2,"")
Excelchat Expert 28/07/2018 - 01:57
This formula first checks IF the date in column C would match the month header under columns G to R. If it matches, it copies over the GRP value of that date under the corresponding month.
Excelchat Expert 28/07/2018 - 01:58
If this do not match, it just leaves the cell as blank.
Excelchat Expert 28/07/2018 - 01:58
If you look at the document preview, you'll notice that we have the sheet "Copying GRP" and "Copying BRAND". In "Copying GRP", it copies the GRP value under the following months.
Excelchat Expert 28/07/2018 - 01:59
In "Copying BRAND", the formula in this does the same formula, just that it copies the BRAND, not the GRP.
Excelchat Expert 28/07/2018 - 02:00
I can see that your avatar is still here in the session. Please do respond either in the document preview or thru this chat for any clarifications.
Excelchat Expert 28/07/2018 - 02:02
I can see you're checking the formula in cell H3. Please do extend the session if you need more time for clarifications.
Excelchat Expert 28/07/2018 - 02:02
Btw, you can download a copy of the document preview by going to File > Download as > Microsoft Excel (.xlsx). The formulas will be downloaded as well. :)
User 28/07/2018 - 02:02
Thank you.
Excelchat Expert 28/07/2018 - 02:02
Nice! You can now end the session via the button on your upper right (sorry, can't do it from our end). I would also appreciate it if you can leave a great feedback after this.Thanks so much for using Got it pro and have a nice day! :)

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.

Get instant expert help with Excel and Google Sheets

Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.

Click here to get your free Excelchat help session

Subscribe to Excelchat.co
Trusted by people who work at
Amazon.com, Inc
Facebook, Inc
Accenture PLC
Siemens AG
Macy's
The Allstate Corporation
United Parcel Service
Dell Inc