Can excel 2016 search through a column for an exact amount I am looking for?

[jbstream09]

Can excel 2016 search and highlight through a column for an exact amount I am looking for? I need to know which rows 1 through 2027 in column A add to an specific amount. I tried the add-in solver but it is giving me a message "too many variables".

 

[mumps]

Can there be more than one occurrence of the same amount? What amount are you looking for?

 

[jbstream09]

Row A has different amounts from row A1 to row A2027.
The amount I am looking for is $111,323.69
I need to know which amounts in row A1 - A2027 add up to the amount I am looking for.

 

[Brian from Maui]

Row A has different amounts from row A1 to row A2027.
The amount I am looking for is $111,323.69
I need to know which amounts in row A1 - A2027 add up to the amount I am looking for.

This might get you started, although 2,027 rows may take some time to run.

http://www.tushar-mehta.com/excel/templates/match_values/index.html#VBA_multiple_combinations