View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
test test test test is offline
external usenet poster
 
Posts: 1
Default How do I search thr'o column and put unique values in differnt sheet and sum corresponding values in


How do I search thr'o column and put unique values in differnt sheet and
sum corresponding values in different column?

For example I have 3 columns in one sheet
from To total
ABC WP 10
ABC ABC 10

My output should looks like this

col from To
ABC 20 20
WP 0 10

thanks in advaced


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!