Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
To the well I return...!
Here's the deal: an excel worksheet (Trial balance) is populated (approx. 3,000 rows) from a download and has 4 columns (first 3 are text and 4th is numeric). The 1st column has values of 00, 01, 02, 03, etc. through 20. I used the following formula to extract to seperate workbooks the rows needed (i.e., 01 rows to spreadsheet Property A): =IF(AND('P:\Common\Portfolio\OER\2006\[Trial balance.xls]12 31 06 TB'!$A1="01",'P:\Common\Portfolio\OER\2006\[Trial balance.xls]12 31 06 TB'!$D1<0),'P:\Common\Portfolio\OER\2006\[Trial balance.xls]12 31 06 TB'!A1,"") I get what I need (about 150 rows). However, I also get almost 2,900 visibly blank lines. Therefore, I humbly seek help either after the extraction of the rows based on the first column 2 digit number or should I change directions while navigating through the above funtion? Grazie....molti! -- MVD San Francisco, California |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Copy rows of data (eliminating blank rows) from fixed layout | Excel Discussion (Misc queries) | |||
#N/A coming up in VLOOKUP when visibly the two cells are same | Excel Worksheet Functions | |||
Inserting Blank rows after every row upto 2500 rows | Excel Worksheet Functions | |||
Get number of rows that data takes up, including blank rows | Excel Worksheet Functions | |||
HOW DO I CREATE A MACRO TO STRIP OUT ROWS? | Excel Discussion (Misc queries) |