All, I'm being the slowest person today,
I have a formula:
=IF(LEN(A102)>0,IF(A102+1<=MAX(Listing!B:B),Breakdown!A102+1,""),"")
Which will return a blank IF the number above is <= the max on a sheet AND also return a blank if the one above has no text in.
The formula is so I can extend beyond the range required, so it will fill when the Listings sheet expands.
There's probably a lot of way to do this, the problem I'm having is understanding why:
=IF(or(LEN(A102)>0,A102+1<=MAX(Listing!B:B)),Breakdown!A102+1,"")
doesn't do the same job??
I have a formula:
=IF(LEN(A102)>0,IF(A102+1<=MAX(Listing!B:B),Breakdown!A102+1,""),"")
Which will return a blank IF the number above is <= the max on a sheet AND also return a blank if the one above has no text in.
The formula is so I can extend beyond the range required, so it will fill when the Listings sheet expands.
There's probably a lot of way to do this, the problem I'm having is understanding why:
=IF(or(LEN(A102)>0,A102+1<=MAX(Listing!B:B)),Breakdown!A102+1,"")
doesn't do the same job??