Sorting data?

Ice5 · Apr 2nd, 2002, 10:35 AM

I'm working on a pilot logbook in Excel.

Right now I have some columns with data that I would like to manipulate.

For example Column C contains registrations.

What I would like to do is go through the column, extracting unique registrations, and putting them in their own column.

I would then count the number of flights per plane.

i.e.
Column C contains the following: FILQ, FQHT, FQHT, FIMM, FILQ

I want to create a column with only: FILQ, FIMM, FQHT

Is there a way to do this? Preferably as a forumla and not a macro.

Thanks

Russell Hauf · Apr 2nd, 2002, 10:37 AM

Try Advanced Filter. Go to Data, Filter, Advanced Filter. Choose "Unique records only", and "Copy to" (the last to move to a new column).

Ice5 · Apr 2nd, 2002, 10:43 AM

Sweet, thanks, that definitely simplifies things.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 2nd, 2002, 10:35 AM	#1
Ice5 New Member Join Date: Mar 2002 Posts: 9	I'm working on a pilot logbook in Excel. Right now I have some columns with data that I would like to manipulate. For example Column C contains registrations. What I would like to do is go through the column, extracting unique registrations, and putting them in their own column. I would then count the number of flights per plane. i.e. Column C contains the following: FILQ, FQHT, FQHT, FIMM, FILQ I want to create a column with only: FILQ, FIMM, FQHT Is there a way to do this? Preferably as a forumla and not a macro. Thanks

Apr 2nd, 2002, 10:37 AM	#2
Russell Hauf MrExcel MVP Join Date: Feb 2002 Location: Portland, OR USA Posts: 1,374	Try Advanced Filter. Go to Data, Filter, Advanced Filter. Choose "Unique records only", and "Copy to" (the last to move to a new column).

Apr 2nd, 2002, 10:43 AM	#3
Ice5 New Member Join Date: Mar 2002 Posts: 9	Sweet, thanks, that definitely simplifies things.