ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Return range of values on an "IF" statement (https://www.excelbanter.com/excel-worksheet-functions/28857-return-range-values-%22if%22-statement.html)

KelleyS

Return range of values on an "IF" statement
 
I am trying to extract rows of data meeting certain criteria and accumulate
them in another worksheet using an IF statement.

For example, I have data in cells A1 through F10. If the value in cell A11
is not zero, I'd like to copy cells A1:A10 to another worksheet. If the
value in cell B11 IS 0, I don't want to copy that row, and so on through F.
So far I can't find any formula or function that lets me return a
value_if_true from an IF statement to more than one cell.

Or is there a better way to do this than using "IF"?


All times are GMT +1. The time now is 03:04 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com