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?

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