Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Count every group of numbers whose sum is zero & put number next toeach number
I have the following numbers in column A
1 2 3 -2 -4 5 5 -10 3 3 -6 I need in column B next to each number - the number telling me to which group of sum zero it belows(by selecting first cell next to column A up to last cell - (B1:B11) i.e 1,2,3,-2,-4 would each have number 1 next to each of them in column B (first group of sum zero) 5,5,-10 would each have number 2 next each of them in column B (second group of sum zero) 3,3,-6 would each have number 3 next to each of them in column B (third group of sun zero) Need a macro which would work in any range of numbers in any column ( not necessarily column A i.e if numbers are in column D - count would be in column E next to the number Pls help thxs |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Count every group of numbers whose sum is zero & put formula next toeach number | Excel Worksheet Functions | |||
How to Determine group of numbers best fit into 1 number | Excel Programming | |||
How do I select a number from a specific group of numbers? | Excel Worksheet Functions | |||
Count Number of different numbers | Excel Programming | |||
Number count - postcodes and need to count the numbers of tim... | Excel Discussion (Misc queries) |