Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help with rest of forumla - Delete rows based on criteria
I am extracting information from a named range of information from one sheet
to another based on matching sets of data. That is working great but I'm wondering if there is a formula that will expand this to delete rows when the salary is returned as 0.00. Here is what I have so far: =SUMIF(SSNLLS,SSNLLBL,salary) (if the social on one sheet matches social on the other, return the salary information) Does anyone know of an easy formula to add to this or would I have to write a macro to delete those rows that return 0.00? Thanks so much! Mariann |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Delete Rows based on criteria in excel | Excel Discussion (Misc queries) | |||
How can I delete rows programmatically based on certain criteria? | New Users to Excel | |||
How can I delete rows programmatically based on certain criteria? | Excel Worksheet Functions | |||
Delete rows based on criteria | Excel Discussion (Misc queries) | |||
Delete rows based on certain criteria | Excel Discussion (Misc queries) |