#1
|
|||
|
|||
Can I do this? sorting data in seperate columns
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 |