ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Find which values sum up another vaule, please help! (https://www.excelbanter.com/excel-discussion-misc-queries/74039-find-values-sum-up-another-vaule-please-help.html)

samsg

Find which values sum up another vaule, please help!
 

Hi, i have a list of values in a column, for example

A

5
10
3.5
...

I need to find out which values or cells sum up 8.5, the answere will
be 5 and 3.5 (A1 and A3). However my column is very large and i need to
find the solution for several values.

Any ideas are rally really apreciated, thanks a lot for the help!!!


--
samsg
------------------------------------------------------------------------
samsg's Profile: http://www.excelforum.com/member.php...o&userid=16245
View this thread: http://www.excelforum.com/showthread...hreadid=516730



All times are GMT +1. The time now is 07:17 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com