Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
Can I insert a file or folder names in Excel cells? | Excel Discussion (Misc queries) | |||
copy & paste spreadsheet cells from excel to outlook to excel | Excel Discussion (Misc queries) | |||
Cells User Select Locked after upgrade to Excel 2002 | Excel Discussion (Misc queries) | |||
How do I show protected cells in an EXCEL worksheet | Excel Discussion (Misc queries) |