Help with Cell Comparison

I have a spreadsheet that has a column of dollar amounts. I need to find a way to compare all of the cells in the column and find ones that add up to a specified value.

Explain in detail

Originally Posted by anilsolipuram

Explain in detail

Lets Say I have the following in a spreadsheet

123.66
36276.74
135.67
111.11
333.45
333.79

I need to know what items above will add up to 593.12. I need to be able to type the target number in a cell or VBA box and have it highlight the cells that add up to it.

How many cells we need to consider for adding

Originally Posted by anilsolipuram

How many cells we need to consider for adding

It could be up to 2000 cells in the column

I mean In the given example how many should cell should added up to 593.12,is it 2 cells or 3cells or combination of any number of cells