I have in sheet1
A B C
Name Date fee
rock 1/12/2013 100
brock 1/12/2013 200
sam 3/12/2013 150
after using sumif statement i coud arrange as below in a sheet2
A B
Date Fee
1/12/2013 300 (sumif)
2/12/2013 0
3/12/2013 150
now in the c collum i need the result as
A B C
Date Fee contibuted from
1/12/2013 300 (sumif) rock , brock
2/12/2013 0
3/12/2013 150 sam
How do we achive this !
Bookmarks