ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Finding pieces of a value in a table (https://www.excelbanter.com/excel-discussion-misc-queries/100580-finding-pieces-value-table.html)

root

Finding pieces of a value in a table
 

Suppose I have a set of data below. I know that that a combination of
some values in dataset make up a value of 252. What is the most
efficient formula to find and isolate these values?
34
3
34
34
33
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51


--
root
------------------------------------------------------------------------
root's Profile: http://www.excelforum.com/member.php...o&userid=36627
View this thread: http://www.excelforum.com/showthread...hreadid=563736



All times are GMT +1. The time now is 09:06 PM.

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