Hi all,
I have DATA in Column A from Row A2 : A20000 ( Debit items)
And I have DATA in Column B from Row B2: B 8000 ( Credit items)
Generally an Amount in B Cell (ex: 8500/- is divided in A Cell into 4000(A4),3000(A8),800(A12),500(A15),200(A18)=8500 (B2))
Now I want to Match Rs 8500/- to Cells in Column A.
What is the Formula to find the Cells in Column A to Match B2 Cell
Bookmarks