Hello,
I am carrying a formula down column c that looks for a specific trigger word in the adjacent cell in column b, and when that word is found the formula will look for the max value in a range that starts with the column where the specific trigger word is located and extends down 20 rows. Then, as the formula makes its way down each row within that 20 row range, the range that I looking for the max value in remains fixed.
This I have no problem with creating...my problem begins when I carry the formula down past this 20 row range until the next trigger word is located and I want the new range to begin at and remain fixed to the location of the new trigger word. Any help is greatly appreciated.
I am carrying a formula down column c that looks for a specific trigger word in the adjacent cell in column b, and when that word is found the formula will look for the max value in a range that starts with the column where the specific trigger word is located and extends down 20 rows. Then, as the formula makes its way down each row within that 20 row range, the range that I looking for the max value in remains fixed.
This I have no problem with creating...my problem begins when I carry the formula down past this 20 row range until the next trigger word is located and I want the new range to begin at and remain fixed to the location of the new trigger word. Any help is greatly appreciated.