excel how to show names associated with other cells
 

How do I display drivers name coloumn A when associating or adding up column
c MON when "ROY" appears beside there name.



DRIVERS MON
Sean Abercrombie
Angela Baker
Bob Brand
Nick Brandis
Ron Brown
Bill Cadman
Kevin Cahill ROY
Gerald Cartmale
Terry Condy
Kelly Cook
Ed Courty
Romeo Courty
Geroge Dakin
Shirley Devreeze
Rick Fisher
Al Freake NEL
Rob Graham
Keith Hambly
Tim Harten
Mike Hatley
A

Paul Hayward SOU
Chris Hemmings ROY
Steve Hill
Justin Hughes
Robert Kaminsky
Craig King
Robin King
Jeff Kloos
Whilly Knelson ROY

excel how to show names associated with other cells
 

a simple option would be to use a filter.

Data-Filter-AutoFilter
hit the drop down in column c and select ROY
can copy and paste the rows to a new sheet if desired to create a table with
just these names.

"curley stooge" wrote:

How do I display drivers name coloumn A when associating or adding up column
c MON when "ROY" appears beside there name.



DRIVERS MON
Sean Abercrombie
Angela Baker
Bob Brand
Nick Brandis
Ron Brown
Bill Cadman
Kevin Cahill ROY
Gerald Cartmale
Terry Condy
Kelly Cook
Ed Courty
Romeo Courty
Geroge Dakin
Shirley Devreeze
Rick Fisher
Al Freake NEL
Rob Graham
Keith Hambly
Tim Harten
Mike Hatley
A

Paul Hayward SOU
Chris Hemmings ROY
Steve Hill
Justin Hughes
Robert Kaminsky
Craig King
Robin King
Jeff Kloos
Whilly Knelson ROY