Home |
Search |
Today's Posts |
#8
![]()
Posted to microsoft.public.excel.worksheet.functions,microsoft.public.excel.misc,microsoft.public.excel.programming,microsoft.public.excel,microsoft.public.excel.newusers
|
|||
|
|||
![]()
If your list only has up to 9 values, the following worksheet functions
will do the trick. 1. In range A1:A9 enter the list of amounts 2. Enter you're the figure you need to reconcile in A11 3. In the range of cells A15:I525, enter the formula "=VALUE(MID(DEC2BIN(ROW()-14,9),COLUMN(),1))" 4. In the range J15:J525, enter the array formula "{=MMULT(A15:I525,A1:A9)}" 5. In the range B1:B9, enter the formula "=OFFSET($A$14,MATCH($A$11,$J$15:$J$525,0),ROW ()-1)" Amounts that reconcile to the figure in A11 will have a 1 next to them in column B |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
find sum in list of of numbers | Excel Discussion (Misc queries) | |||
find sum in list of of numbers | New Users to Excel | |||
find sum in list of of numbers | New Users to Excel | |||
find sum in list of of numbers | Excel Discussion (Misc queries) | |||
find a sum from a list of numbers | Excel Worksheet Functions |