Thread: Lookup Help
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Jessinat Jessinat is offline
external usenet poster
 
Posts: 7
Default Lookup Help

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.