I have a workbook Range (A1:A500)........text values
Cell C1 represent the last value in range (A1:A500)
I need help with creating a formula in cell D1.
This will return the most common text value in the range that follows an occurrence determined by C1.
eg if C1 was to equal "Paul" then D1 would show "Helen", as "Helen" is the most common text value that follows a text value of "Paul" in the range
A1 = Paul
A2 = Helen
A3 = Paul
A4 = Duncan
A5 = Paul
A6 = Helen
A7 = Duncan
A8 = Duncan
A9 = Paul
A10 = Helen
A11 = Paul
A12 = Helen
A13 = Paul
A14 = Duncan
Cell C1 represent the last value in range (A1:A500)
I need help with creating a formula in cell D1.
This will return the most common text value in the range that follows an occurrence determined by C1.
eg if C1 was to equal "Paul" then D1 would show "Helen", as "Helen" is the most common text value that follows a text value of "Paul" in the range
A1 = Paul
A2 = Helen
A3 = Paul
A4 = Duncan
A5 = Paul
A6 = Helen
A7 = Duncan
A8 = Duncan
A9 = Paul
A10 = Helen
A11 = Paul
A12 = Helen
A13 = Paul
A14 = Duncan