View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bob Phillips Bob Phillips is offline
external usenet poster
 
Posts: 10,593
Default need some help on sumproduct

Apply autofilter to the columns, DataFilterAutofilter.., and just select
the required account from the dropdown in column B.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"dinadvani via OfficeKB.com" <u22798@uwe wrote in message
news:68968de133a78@uwe...
Hello everyone,

I have an excel sheet that has some registration nos., account names,
reference nos and revenue collected against each reference no.

Some what like in this format:

Registration No. Account names Reference no. Revenue
collected
12 ABC 01
1000
18 ADC 04
500

Now I have to prepare a window wherein if I click any account names, then

it
should display all the registrations nos. reference nos and revenue

amount.

But the main problem is an account can have more than 1 registration nos.

so
I want that first row should display 1 registration no. 2nd row 2
registration no. and so on and so forth.. DO YOU THINK THIS IS POSSIBLE BY
ANY LUCK

Please help me, as I don't have any clue about this.

Regards,
D

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200610/1