Hello,
I am working with Excel 2003. I need the formula to look in Column 1 and look at all these names. and compares the name if it is Sally the add Tom in column next to it ( this is who she reports to) , if first column second row is Mary and automatically add Julie on the same row she is but this specific column.
Example:
Name of employee Reports to
Sally Tom
Mary Julie
Bob Julie
John Tom
so it looks at NameofEmployee column and it matches if it is this , this , this name then the manger is this and adds that name in the specif column.
Thank you
Brian b
Configuration: Windows XP Internet Explorer 6.0
Suppose in your sheet1 you have data of Employee Name & Manager of employee in column A & B
|
Adding word in column in excel Addition columns in excel Convert list of address into column excel Could not find an ip address for this domain name Ddr2 column row address Delete rows if column match Excel adding up same cell contents in one column Excel difference between two columns and add the result in third column Excel macro add column to chart range Extract words in columns text files I got my ip address but i don'nt know how to use this If column equals text than If name in this column then add numbers in this column In excel match the values in two columns match Match excel columns and add data to column Run macro to match column a sheet1 to column a sheet2 Text to columns all cells text not general Windows was unable to add this computer to the list of valid remote access servers