Question description:
This user has given permission to use the problem statement for this
blog.
I am looking to export part of an excel spreadsheet: only those lines that have some text in Column N. How do I do that please?
Solved by B. Q. in 20 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
Excelchat Expert
07/11/2017 - 12:18
Hi, It's pleasure to help you today:)
User
07/11/2017 - 12:18
How do I create and insert a formula for exporting from an excel document only lines that have date in a certain line?
Excelchat Expert
07/11/2017 - 12:19
Can you please show me a sample in the preview.
Excelchat Expert
07/11/2017 - 12:19
With the help of filters, we can copy the data containing in column N.
User
07/11/2017 - 12:20
Let's say I want to export only lines that have hello in line F?
Excelchat Expert
07/11/2017 - 12:20
Ok. Normally, row 1 will be Titles and is called title row.
User
07/11/2017 - 12:20
The entire row would be exported IF there is date in F
Excelchat Expert
07/11/2017 - 12:21
So, select the data and apply filter
Excelchat Expert
07/11/2017 - 12:21
Now, from the filter, select all expect blanks
Excelchat Expert
07/11/2017 - 12:22
Now, you can copy the data by selecting and pasting it.
Excelchat Expert
07/11/2017 - 12:23
Please check in sheet 2
Excelchat Expert
07/11/2017 - 12:23
After copying the data, only data containing rows are appearing.
User
07/11/2017 - 12:23
Explain one more time. I select data "hello" and then?
Excelchat Expert
07/11/2017 - 12:24
select column N
User
07/11/2017 - 12:24
ok
Excelchat Expert
07/11/2017 - 12:24
and then apply filter
Excelchat Expert
07/11/2017 - 12:24
Please try step by step now
Excelchat Expert
07/11/2017 - 12:24
1) Select column F
Excelchat Expert
07/11/2017 - 12:25
2) Apply Filter
User
07/11/2017 - 12:25
where do you press apply filter?
Excelchat Expert
07/11/2017 - 12:25
It is available under Data menu, filter
Excelchat Expert
07/11/2017 - 12:25
It was already applied
Excelchat Expert
07/11/2017 - 12:25
3) click on the funnel symbol located in F1 cell
User
07/11/2017 - 12:26
How did you create that filter to begin iwth?
Excelchat Expert
07/11/2017 - 12:26
Please try again
Excelchat Expert
07/11/2017 - 12:26
1) select column F
Excelchat Expert
07/11/2017 - 12:27
2) Click on filter under Data menu
Excelchat Expert
07/11/2017 - 12:28
Hi, there?
User
07/11/2017 - 12:28
I'm confused please start again
Excelchat Expert
07/11/2017 - 12:29
Try adding some data in other column to understand better
User
07/11/2017 - 12:29
OK now how do I export all rows that have date in I?
Excelchat Expert
07/11/2017 - 12:29
1) select all columns that has data
Excelchat Expert
07/11/2017 - 12:30
That is from A to I
Excelchat Expert
07/11/2017 - 12:30
Can you please select
User
07/11/2017 - 12:30
how do I do that?
Excelchat Expert
07/11/2017 - 12:31
At the top you can see A B C D in grey colour select them together by just dragging your cursor
Excelchat Expert
07/11/2017 - 12:32
Select the top letter A that represents column A
Excelchat Expert
07/11/2017 - 12:32
Not the cell. You are in A1 cell
Excelchat Expert
07/11/2017 - 12:32
Can you see letter A at the top
Excelchat Expert
07/11/2017 - 12:32
click on that
Excelchat Expert
07/11/2017 - 12:33
The timer is running down.
Excelchat Expert
07/11/2017 - 12:33
Are you able to select it?
User
07/11/2017 - 12:34
ON A1?
Excelchat Expert
07/11/2017 - 12:34
on letter A, just below formula bar
Excelchat Expert
07/11/2017 - 12:34
or press ctrl A
Excelchat Expert
07/11/2017 - 12:34
it will select the whole data
Excelchat Expert
07/11/2017 - 12:35
or at the end junction of A column and row 1, there is a rectangular grey colour box
Excelchat Expert
07/11/2017 - 12:35
select that
User
07/11/2017 - 12:35
Got it!
Excelchat Expert
07/11/2017 - 12:35
Can you see fx?
Excelchat Expert
07/11/2017 - 12:35
below that there is a rectangular box in grey colour
Excelchat Expert
07/11/2017 - 12:36
Please try in preview
Excelchat Expert
07/11/2017 - 12:36
Please extend the session
User
07/11/2017 - 12:36
what is fx?
Excelchat Expert
07/11/2017 - 12:36
Are you able to select all the cells?
User
07/11/2017 - 12:36
yes
Excelchat Expert
07/11/2017 - 12:36
please extend the session
Excelchat Expert
07/11/2017 - 12:37
The timer is running out
User
07/11/2017 - 12:37
ok will do
Excelchat Expert
07/11/2017 - 12:37
I did not get any message
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.