Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have a spreadsheet where I have data (column A)
800-aaa-nnnn abcde 1 800-aaa-nnnn fghijk 1 800-aaa-nnnn lmnop 1 800-aaa-nnnn qrstuv 11 800-aaa-nnnn wxyz 3 800-bbb-oooo abcde 1 800-bbb-oooo fghijk 4 800-bbb-oooo lmnop 1 800-bbb-oooo qrstuv 1 800-bbb-oooo wxyz 1 800-bbb-oooo aderq 2 866-ccc-pppp fghijk 1 866-ccc-pppp lmnop 1 866-ccc-pppp qrstuv 2 866-ccc-pppp wxyz 2 866-ccc-pppp aderq 2 And I need to be able to summarize the data by Toll Free Number and Type abcde fghijk lmnop qrstuv wxyz aderq 800-aaa-nnnn 800-bbb-oooo 866-ccc-pppp I really need help with this, thanks in advance. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Another way to lookup data | Excel Worksheet Functions | |||
Lookup Vector > Lookup Value | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Lookup function w/Text and Year | Excel Worksheet Functions | |||
double lookup, nest, or macro? | Excel Worksheet Functions |