PLEASE HELP--Sorting one column to match entries in another

wilkisa · Apr 8th, 2002, 01:46 PM

The sheet has 11 columns, A to K. Col. A-E are in the correct order; Col. G-K needs to be sorted so that the information in Col G matches the information in Col. A. Col. F is blank.

I would be happy to send an example if someone could give me a hand. I tried to put an example in an early message but got no help so I figured the example didn't make sense.

yussi1870 · Apr 8th, 2002, 01:52 PM

Highlight columns A through K. Then Select Data from the menu. Then Sort... Then Select Sort By Column G. Then hit OK.

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

Apr 8th, 2002, 01:46 PM	#1
wilkisa Board Regular Join Date: Apr 2002 Location: Decatur IL, USA Posts: 494	The sheet has 11 columns, A to K. Col. A-E are in the correct order; Col. G-K needs to be sorted so that the information in Col G matches the information in Col. A. Col. F is blank. I would be happy to send an example if someone could give me a hand. I tried to put an example in an early message but got no help so I figured the example didn't make sense.

Apr 8th, 2002, 01:52 PM	#2
yussi1870 Board Regular Join Date: Mar 2002 Posts: 128	Highlight columns A through K. Then Select Data from the menu. Then Sort... Then Select Sort By Column G. Then hit OK.