Hello Excelsiors!
I'd really appreicate some help with an array formula.
I have a table, columns A through J, and I wish to extract the data that ONLY has a price more than zero (I want all items that have 0 value to be removed from the table). The item values are listed in column F.
For example, cell F16 (Remoulade) is ot required in the new table.
I would like the array formula to be listed on Sheet 2. I know I am able to search for '0', select the rows and delete that way, but I wish to use the array formula for many pieces of data.
Thank you so much!
Danny
Bookmarks