I need to know a formula for a file. In the file two sheets contain one for raw data and second for final partywise letter. There is a partyname, bill no, bill date and amount in first sheet. There may be two or more bills against same party. I need to put a formula in second sheet if party name is same from the data list, it must display all bills pertaining to that party. I don’t know which formula could be used for the same. So Frnz, kindly guide me if aware of the solution.
Looking for reply soon.
Regds,
JMD
CAclubindia
