# need help to make5 functions in same cell

1. ## need help to make5 functions in same cell

hi dears
good day to you ,
now am a logistics supervisor and i face a problem to make a balance sheet for every customer
, based on his shipment records , so i suffer a lot till reach for a formula to record every shipment in a sheet and make another sheet showing a drop list for every customer once hit customer name ,his accounting sheet debit/credit status be visible in one sheet , but the formula doesn't work at all , so can some one help me to finalize it ,

thanks s million

2. ## Re: need help to make5 functions in same cell

Hi,

Try this in C8 and across:
=IFERROR(INDEX('MAIN SHEET'!B\$1:B\$33,AGGREGATE(15,6,((ROW('MAIN SHEET'!\$C\$6:\$C\$33)/('1001'!\$E\$5='MAIN SHEET'!\$C\$6:\$C\$33))),ROWS('MAIN SHEET'!\$M\$3:M3))),"")

3. ## Re: need help to make5 functions in same cell

are you really solve it , many thanks dear .... amazing ,
thank you soooooooo much , i had been try for 3 days
many thanks and appreciate it ,

4. ## Re: need help to make5 functions in same cell

You should have come earlier.... : ) you're welcome neighbor...

5. ## Re: need help to make5 functions in same cell

thank you ....