I have a spread sheet of 100 rows & 60 columns
Bottom row is years 2008 thru 2068 -- Range A1:BH100
Columns have numbers scattered randomly. Most numbers are 0
Some rows have only one column with a number, others have several columns
with numbers. The numbers are of different values and are not in ascending or
decending value.
How can I start in a1 and locate the first column,in the row, with a number
greater than 0 and then identify the year? I need to start with " If(A1 = 0
----.
I have tried lookup, hlookup & match but probably am not doing something
right.