| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Filtering out rows with an empty column A
I have created a .csv file by exporting only last name and email address from
my OE6 address book. In more than half of the resultant spreadsheet rows, column A (last name) is empty. Is there any way I can eliminate all such rows, so that the only rows that appear are those with entries in both columns A and B? Thanks. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Filtering out rows with an empty column A
Filter Col A on blanks...
Select the result and delete rows... Do make a backup just in case. "Nautico" wrote: I have created a .csv file by exporting only last name and email address from my OE6 address book. In more than half of the resultant spreadsheet rows, column A (last name) is empty. Is there any way I can eliminate all such rows, so that the only rows that appear are those with entries in both columns A and B? Thanks. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Filtering out rows with an empty column A
I selected all rows of cells A (name) and B (email address), but when I
attempted to follow your instructions, the following appeared: MS Excel cannot determine which row in your list or selection contains column labels, which are required for this command. "Sheeloo" wrote: Filter Col A on blanks... Select the result and delete rows... Do make a backup just in case. "Nautico" wrote: I have created a .csv file by exporting only last name and email address from my OE6 address book. In more than half of the resultant spreadsheet rows, column A (last name) is empty. Is there any way I can eliminate all such rows, so that the only rows that appear are those with entries in both columns A and B? Thanks. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Filtering out rows with an empty column A
Looks like you don't have headers...
If you have them then select them also otherwise insert row at the top and enter headings, then select the range including headings. "Nautico" wrote: I selected all rows of cells A (name) and B (email address), but when I attempted to follow your instructions, the following appeared: MS Excel cannot determine which row in your list or selection contains column labels, which are required for this command. "Sheeloo" wrote: Filter Col A on blanks... Select the result and delete rows... Do make a backup just in case. "Nautico" wrote: I have created a .csv file by exporting only last name and email address from my OE6 address book. In more than half of the resultant spreadsheet rows, column A (last name) is empty. Is there any way I can eliminate all such rows, so that the only rows that appear are those with entries in both columns A and B? Thanks. |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Filtering out rows with an empty column A
But I do have headers, Last Name and Email Address, and they appear in
columns A and B of row 1. "Sheeloo" wrote: Looks like you don't have headers... If you have them then select them also otherwise insert row at the top and enter headings, then select the range including headings. "Nautico" wrote: I selected all rows of cells A (name) and B (email address), but when I attempted to follow your instructions, the following appeared: MS Excel cannot determine which row in your list or selection contains column labels, which are required for this command. "Sheeloo" wrote: Filter Col A on blanks... Select the result and delete rows... Do make a backup just in case. "Nautico" wrote: I have created a .csv file by exporting only last name and email address from my OE6 address book. In more than half of the resultant spreadsheet rows, column A (last name) is empty. Is there any way I can eliminate all such rows, so that the only rows that appear are those with entries in both columns A and B? Thanks. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Why is autofilter only filtering up to # of rows in prev column? | Excel Discussion (Misc queries) | |||
| How do I sort with empty rows between none empty rows? | Excel Worksheet Functions | |||
| how insert same text in empty cells in column (10000 rows) | Excel Worksheet Functions | |||
| trouble filtering a list. Why isn't column filtering? | Excel Worksheet Functions | |||
| Pivot Tables: How do I show ALL field rows, including empty rows?? | Excel Worksheet Functions | |||
Linear Mode
