Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2003
I have a spread sheet with info in columns A-K. Column K is the Balance
column. I am trying to sort out all of the 0.00 figures in the Balance column and move the info from columns A-K with a balance of 0.00 to another location on the spreadsheet. I know I can sort or filter the 0.00 balance but don't know how to automatically copy the data in the whole row to another location. Thank you, -- Dena320 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2003
If desired, send your file to my address below along with this msg and
a clear explanation of what you want and before/after examples. -- Don Guillett Microsoft MVP Excel SalesAid Software "dena320" wrote in message ... I have a spread sheet with info in columns A-K. Column K is the Balance column. I am trying to sort out all of the 0.00 figures in the Balance column and move the info from columns A-K with a balance of 0.00 to another location on the spreadsheet. I know I can sort or filter the 0.00 balance but don't know how to automatically copy the data in the whole row to another location. Thank you, -- Dena320 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2003
I have a spread sheet with info in columns A-K. Column K is the
Balance column. I am trying to sort out all of the 0.00 figures in the Balance column and move the info from columns A-K with a balance of 0.00 to another location on the spreadsheet. I know I can sort or filter the 0.00 balance but don't know how to automatically copy the data in the whole row to another location. Here's one way using Excel 2003. In my example, "another location" starts at cell O2. Column N is a helper column. In N2, put =IF(AND(ISNUMBER(K1),K1=0),MAX($N$1:$N1)+1,"") In O2 put =IF(ROW()MAX($N:$N)+1,"", OFFSET($A$1,MATCH(ROW()-1,$N:$N)-2,COLUMN()-15)) Extend O2 rightward to Y2. Select N2:Y2 and extend downward for as many rows as needed. Hide column N if desired. Modify to suit. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
importing/linking data from an Access 2003 Query to an Excel 2003 | Excel Discussion (Misc queries) | |||
Convert Excel 2003 spreadsheet into Outlook Contacts table 2003 | Excel Discussion (Misc queries) | |||
import Excel 2003 file into Outlook 2003 - NO NAMED RANGES?? | Excel Discussion (Misc queries) | |||
Copying Excel 2003 Selection into Outlook 2003 HTML E-Mail Message | Excel Discussion (Misc queries) | |||
Excel 2003 Database Driver Visual FoxPro 7 on Server 2003. | Excel Discussion (Misc queries) |