Can someone help show me how to consolidate a list of names in MsExcel
example
Joe
Joe
Joe
Steve
Harry
Harry
Harry
Harry
Robert
Robert
I just want to have one list of
Joe
Steve
Harry
Robert
Thanks
Printable View
Can someone help show me how to consolidate a list of names in MsExcel
example
Joe
Joe
Joe
Steve
Harry
Harry
Harry
Harry
Robert
Robert
I just want to have one list of
Joe
Steve
Harry
Robert
Thanks
you can use data > filter > advanced > unique