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 column 1 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:
I want to be able to have a calculated column read "Yes" for all the rows that are for the secretary, 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 for the position if a value is found for special flag in any given row for that position.
Reply With Quote
