Need to know if there is a way to read through an unstructured list and return a value for a calculated column.
In Excel 2007, have a list of employee positions. Column 1, Position Title, Column 2, Salary Type (Annual, Monthly), Column 3 Special Flag, (will have some type of alphanumeric value).
I would like to read through the list and for any position that has the special flagged turned on return a value for the rest of the rows for the same position in a calculated column.
Example:
-- removed inline image ---
I want to be able to have column D read "Yes" for rows 7-10, because it found out that for one of the rows for the secretary position it did have a value for special flag... There is no telling how many rows there are for any given position, but want to read through all the rows for the positions and set a flag for all rows if a value is found for special flag in any given row for that position.
In Excel 2007, have a list of employee positions. Column 1, Position Title, Column 2, Salary Type (Annual, Monthly), Column 3 Special Flag, (will have some type of alphanumeric value).
I would like to read through the list and for any position that has the special flagged turned on return a value for the rest of the rows for the same position in a calculated column.
Example:
-- removed inline image ---
I want to be able to have column D read "Yes" for rows 7-10, because it found out that for one of the rows for the secretary position it did have a value for special flag... There is no telling how many rows there are for any given position, but want to read through all the rows for the positions and set a flag for all rows if a value is found for special flag in any given row for that position.