Avi Converter: How to Fix - delete empty rows?

2016年9月26日星期一

How to Fix - delete empty rows?

delete empty rows

Hi all
I have columns A to E with data, in column "B" there are numbers witch include the number "1" ,all numbers are in random order
I need to delete a complete row if the number "1" is not present in column "B" eg:
A          B        C        D       E       ect.     changed to :      A      B      C      D       E      ect.
joe       1        0.7      m       45                                         joe     1      0.7    m      45
joe       6        1.5      u        45                                         bill     1      2.2     u       32
joe       9        1.3      m       62                                         john   1      3.1     d       45
bill       2         4.0     d        61                                         john    1     1.5     u       6.0
bill       1         2.2     u        32
john     7         7.4    m        30
john     5         7.6    d         27
john     1         3.1    d         45
john     1         1.5    u         60
down to about 5000 rows
Can some one help me please ?
Is there a work sheet function for this ?

Keys to the Problem delete empty rows

Download Error Fixer (Free)

If you have a row with field names/column headings at the top, you can do the following:
Click in cell A1.
On the Home tab of the ribbon, click Sort & Filter > Filter.
You'll see dropdown arrows in the cells with the field names/
Click the dropdown arrow in cell B1.
Clear the check box labeled "1".
You'll now see only the rows that have something different from 1 in column B.
Select all rows from row 2 down.
Click Delete on the Home tab of the ribbon (or right-click one of the selected row numbers and select Delete from the context menu.
Finally, click Sort & Filter > Filter again.

To check for Windows updates. Open Windows Update by clicking the Start button , clicking All Programs, and then clicking Windows Update. In the left pane, click Check for updates, and then wait while Windows looks for the latest updates for your computer. If any updates are found, click Install updates.

Install the latest updates for Windows and for the program displaying the error. Note that the update for the program might be listed as an optional update on the Windows Update page.

Open Windows Update by clicking the Start button Picture of the Start button. In the search box, type Update, and then, in the list of results, click Windows Update.

Another Safe way to Fix the Problem: delete empty rows:

How to Fix delete empty rows with SmartPCFixer?

1. Download SmartPCFixer . Install it on your system. Click Scan, and it will perform a scan for your computer. The junk files will be shown in the list.