Let A2:G100 house the data of interest, including the header labels.

A1: 25

which is your Depth citerion value.

H1: 0

which is mandatory.

H2: Idx

which is a label.

H3, copied down:

=IF((A3<"")*(G2$A$1),LOOKUP(9.99999999999999E+30 7,$H$1:H2)+1,"")

J1:

=LOOKUP(9.99999999999999E+307,H1:H00)

J2: Pos

which is juat a label.

J3:

=IF(ROW()-ROW($J$3)+1<=$J$1,MATCH(ROW()-ROW($J$3)+1,$H$3:$H$100),"")

K3, copied across as far as needed then down:

=IF($J3<"",INDEX(A3:A100,$J3),"")

rhani111 wrote:
I desperately need help with creating a function, macro or anything that
you guys can think of to make things easier!!

I have a range of cells that list different information that I need to
bring together into another table. This has been easy enough, BUT I
need the data to skip zero or blank rows and only list information that
is greater than a certain number.

For example
Column A is an ID number
Column B is the location
Column C is the date
Column D is the total tonnes
Column E is the number of Days
Column F is the Actual rate
Column G is the depth

What i want the table to reflect is ONLY the rows that have a figure
greater than 25 in the Depth or Column G.

This i have managed quite well, but I don't want rows that are blank or
zero in the new table...any ideas????

A macro would be fine here too.....but i would prefer a function????



--

[1] The SumProduct function should implicitly coerce the truth values to
their Excel numeric equivalents.
[2] The lookup functions should have an optional argument for the return
value, defaulting to #N/A in its absence.