Rohit Bhalotia (CA) (52 Points)
09 June 2008Hi Friends....I have a work sheet in which there are more than 30000line items..In one column name of debtors and in other column amt of transaction is given. As it could be with a single debtors trasaction occur several times.. so a sigle debtor name appear several times in that column.
My requirement is that a list containing all namees of debtors but it should be one time.
Please advice how can i do this easily in excel.
thanks
ranjeet
(student)
(20 Points)
Replied 09 June 2008
Use Subtotal function, you will find it in data menu.
Amit kedia
(article)
(200 Points)
Replied 09 June 2008
use the filter option from data
also u can subtotal it
CA Dushyant Maharishi
(CA)
(178 Points)
Replied 09 June 2008
first you filter the data by the debtors name and just subtotal it.
Deepak Arora
(Accounts Officer)
(27 Points)
Replied 09 June 2008
sub total or even pivot table can be useful in that case.
S.Selvakumar
(Chartered accountants firm)
(36 Points)
Replied 09 June 2008
please enroll my id to see all mail
Rohit Bhalotia
(CA)
(52 Points)
Replied 10 June 2008
Friends...Thanks 4 writing.. my need to take out only list of all debtors not any other data.
Except using subtotal & pivot table
guru santhanam
(Chartered Accountant)
(97 Points)
Replied 10 June 2008
Dear Rohit,
Copy the entire debtors list to a new sheet.
Go to DATA > FILTER > ADVANCED FILTER.....
Under Action, Select copy to another Location.
List Range:- must be the entire list of debtors u copied in the new sheet.
Dont give any criteria...
Copy to:- select any empty column..
Check the 'Unique Records only' box... (this check box filters only unique records)
Unique debtor names will be copied to the new empty column which you mentioned in the copy to range.
Refer the attached file
Hope this helps u
Regards,
gurusanthanam
CAclubindia
