Hi,
If the dollar amounts are in say A2:A100, enter the following formula in B2,
=if($A$2:$A$100=ledger sum,"x",""), where replace the words "ledger sum"
with the actual amount (e.g., 12345.67), and click 'Enter'. Now fill-in the
formula down to the last row.
Regards,
B. R. Ramachandran
"infraterra" wrote:
I have list of dollar amounts given to me and a general ledger sum which some
of those in the list must equal. How can I determine which of these amounts
will equal a given ledger total? Thanks, in advance, for any help.
|