View Single Post
  #2   Report Post  
B. R.Ramachandran
 
Posts: n/a
Default

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.