 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Worksheet Functions / May 2008help with IF formula
=IF('5-19 Epson Ink'!H5-H106<>0, '5-19 Epson Ink'!A5,"") i have this formula in a cell on spreadsheet Variances. instead of having the "" at the end, can i put somethin that will delete this row in this spreadsheet (Variances) but not the Epson Ink one? like the word "skip" or something. i want to make a list of all the rows on the spreadsheet Epson Ink that have a number other than 0 in column H. but with this formula, i have blank rows between the variances on spreadsheet Variances. tia. Why don't you just apply autofilter to this column, and select Non- blanks from the filter pull-down? That will hide all the balank rows and bunch up the others. Hope this helps. Pete > =IF('5-19 Epson Ink'!H5-H106<>0, '5-19 Epson Ink'!A5,"") > [quoted text clipped - 6 lines] > > tia. Hi Tia, I don't think any worksheet functions delete rows. They only do math. You would need to use a macro. Regards - Dave. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.