Can I do this? sorting data in seperate columns

shumonsaha · #1 07-04-2010, 03:05 AM

Hi.

I have data in 2 columns

Column 1 has the name of different channels.... NGC, Discovery, etc

Column 2 has different GRP levels in numbers.

I want to have Column 3 and 4 which would return

1. Column 3 would return the names of top 10 channels only with the 11 cell returning a value called "all others"
2. Column 4 would return the values against the top 10 channels. The 11 th cell even in column 4 (others column) would return the sum of all other channels.

Is this possible?

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
CHALLENGE! Issue sorting data containing relative references on a separate tab	lax828	Excel	3	01-07-2010 11:28 AM
CAUTION!! Sorting a spreadsheet with hidden columns will trash your data.	psmaster@earthlink.net	Excel	0	11-24-2009 11:54 AM
Sorting columns in Excel - please advise	Jonre	Excel	2	08-21-2009 02:38 AM
macro for comparing data from 3 columns and pasting into another worksheet	ashukla	Excel	1	06-24-2009 05:01 PM
Compare data in different columns in an Excel sheet	kgfendi	Excel	5	05-16-2009 05:42 PM