PDA

View Full Version : VBA or Possible with Excel Functions ?



FinEnergyMan
03-28-2013, 04:08 PM
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.

sassora
03-28-2013, 11:31 PM
A picture can paint a thousand words - could you upload the before and after tabs?