Hi,
I have an inventory list in one column and an "x" in the next column if the item needs to be purchased. I'd like to create a shopping list from these 2 columns. What formula do I use to create the list. I'm trying to retrieve the item that has an "x" in the next column and would like to create a column of all those that have the "x". Example: I know I can use: =if(isblank(E4),"",D4), however I'll have multiple blank cells that don't contain the "x". I'm pretty sure there's a formula using INDEX with SMALL(SMALLIF) enclosed with the { } brackets. forum.ozgrid.com/index.php?attachment/55607/
Thanks!