return multiple cell references
My sheet could have anywhere from 1 to 200 rows.
A B C
1 Jones 9 8
2 Smith 3
3 Jones 6 6
4 Clark 4 3
5 Young 1 1
There's alot of other data in numerous sheets which gets summarized on one
sheet. From this sheet I need to find the row numbers is C0 and B<C. The
problem is I need a one line answer for the summary sheet (ex - The following
rows have errors: 1, 4). Is there anyway to do this? Due to the way my data
is compiled, I am unable to use Data Validation.
Thanks!
|