Question description:
This user has given permission to use the problem statement for this
blog.
i need to know expiry dates in column (P),chassis number (Q), serial number (Y),Engine no (R) and fitness type (S)
for column (O) registration numbers
Solved by O. L. in 40 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
User
24/05/2018 - 12:30
i have my excel file
User
24/05/2018 - 12:30
its 34MB
User
24/05/2018 - 12:30
am not able to upload it
Excelchat Expert
24/05/2018 - 12:31
Hello, I understand that you need help with your file to retrieve the several columns you mentioned.
Excelchat Expert
24/05/2018 - 12:31
Are you able to upload modified file so it can be smaller?
User
24/05/2018 - 12:31
i can give you a team viewer access if possible
Excelchat Expert
24/05/2018 - 12:31
I'm afraid that is not possible and is against policy.
User
24/05/2018 - 12:31
oh ok
Excelchat Expert
24/05/2018 - 12:32
You can just give me a sample file or create one using the document to the right.
User
24/05/2018 - 12:32
ok
Excelchat Expert
24/05/2018 - 12:32
But know that the solution I'll be giving you will not be as accurate as if I have the file.
Excelchat Expert
24/05/2018 - 12:32
Before we proceed, this is a reminder that our policy is 1 question per session so for this session we'll be resolving this particular question. We also currently do not support VBA/Macro solutions.
User
24/05/2018 - 12:34
i have 600,000 lines
User
24/05/2018 - 12:34
i need something that show me details of the reg mark i put
Excelchat Expert
24/05/2018 - 12:34
Okay, I can see what you've written.
Excelchat Expert
24/05/2018 - 12:34
Where will you get the information from?
User
24/05/2018 - 12:35
exported from sql server
User
24/05/2018 - 12:35
as csv
Excelchat Expert
24/05/2018 - 12:35
Are you able to save the CSV as an excel file so it can be accessed via formulas?
Excelchat Expert
24/05/2018 - 12:36
Because that's the only way we can do it.
User
24/05/2018 - 12:36
already saved as excel
User
24/05/2018 - 12:37
let say i want to seek these details for AS1234
User
24/05/2018 - 12:37
there are more column on that excel
Excelchat Expert
24/05/2018 - 12:37
I'm creating a sample for you but you will have to update it yourself since you are the only one with access to your file and its formatting.
User
24/05/2018 - 12:38
ok no prob
Excelchat Expert
24/05/2018 - 12:38
For example, if you'll look at the sheet I created called CSV
Excelchat Expert
24/05/2018 - 12:38
Do you see that?
User
24/05/2018 - 12:38
yes
Excelchat Expert
24/05/2018 - 12:38
For example, that is your CSV file that was saved and opened in Excel.
User
24/05/2018 - 12:38
ok
Excelchat Expert
24/05/2018 - 12:39
Now the first file, I called it Excel File, this where you type a Reg mark and the result is retrieved from the CSV sheet.
Excelchat Expert
24/05/2018 - 12:39
I'll write the formula now.
Excelchat Expert
24/05/2018 - 12:40
So I wrote a index/match formula in the Excel File. Now you can change the value of A2 and if it finds the Reg Mark from the CSV sheet, it will display the result.
Excelchat Expert
24/05/2018 - 12:40
Try changing the Reg Mark.
User
24/05/2018 - 12:41
but if i do it in the same excel
User
24/05/2018 - 12:41
can i?
Excelchat Expert
24/05/2018 - 12:41
What do you mean if you do it in the same Excel?
Excelchat Expert
24/05/2018 - 12:41
The sample I gave you is the same file.
User
24/05/2018 - 12:41
oh sorry
User
24/05/2018 - 12:41
i think i got it
User
24/05/2018 - 12:41
thank
Excelchat Expert
24/05/2018 - 12:41
Or do you mean that you just want to work on the actual CSV?
Excelchat Expert
24/05/2018 - 12:42
Then type a reg mark and the rest of the records are hidden?
Excelchat Expert
24/05/2018 - 12:45
Are you still with me?
Excelchat Expert
24/05/2018 - 12:48
Hi, I have not received a reply from you for quite some time. I'm afraid the session will end automatically soon. I sincerely hope we were able to address your concern.
Excelchat Expert
24/05/2018 - 12:49
Thank you for contacting Got It Pro. I'd appreciate a 5-star rating and your feedback if you think I deserve it.
Excelchat Expert
24/05/2018 - 12:49
Have an awesome day!
Excelchat Expert
24/05/2018 - 12:50
It seems that you have extended the session but are not responding. I would politely ask you to please end the session now if you have no other questions regarding the original question as there are others seeking our help.
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.