Looking for formula to extract values in column S into Column R (Desired Output Column)
1. Column S is where the values to be extracted are located.
2. The values to be extracted in column S must take into account column Q23 (our first occurrence of 1 for Dorman, David W.) and then fill it down to the last row that correspond to Dorman, David W. name in column D.
3.Formula Adjustment:This formulaPlease Login or Register to view this content.
is in column O. Would like it adjusted because it is not working properly. Its first occurrence in O22 = $P$44 should start in O23 by taking into account column P23 (P23 = 2008)Please Login or Register to view this content.
See attached sample file.
Thanks.
Bookmarks