I'm trying to find the beginning and end date of a list of clients based on whether or not revenue > 0. Beginning date was this.


For the end date, I want to start the cell reference at the cell pulled with the below function


So, combined, it would look like this


But that returns an error. Thanks in advance for help

EDIT: the issue seems to be you can't use the =CELL() function in a range. Anyone have a solution to this?


I figured it out. I needed to use the indirect function


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.