How do I search an array for values in a column greater than zero

L

letsagmj

I have a table_array set up with 4 columns... pay item, unit, unit price and
qty. There are maybe 30 rows in the array and I want to search the qty
column for values greater than zero and then apply the contents of the
columns in the pay item, unit and unit price (in another worksheet) from the
same row where the qty was greater than zero.

If Excel does not find a value greater than zero then it must skip to the
next line in the taable array reporting only the content from col's 1, 2 and
3 in cells in another worksheet until it has looked at the last or 30th row.

Final is a list of pay items with qty, unit, unit price after only inputting
the qty values in the table_array.

I know this sounds confusing but can anyone help?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

count the number of rows with entries greater than zero 1
return multiple values when within range (greater than and less than) 11
Data Entry Confusion 1
How to search a SS for values greater-than? 0
Problem with formula for finding last greater than/less than or equal to value 2
Countif and values greater than zero for a named range 1
Unable to set the desired column width for a table with merged cells 0
Problem with Values greater than a quardrillion(1,000,000,000,000, 1

Top