Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
I have the following numbers in column A
1 2 3 -2 -4 5 5 -10 3 3 -6 I need a formula in column B next to each number telling me to which group of sum zero it belows 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) Pls help thxs |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I select a number from a specific group of numbers? | Excel Worksheet Functions | |||
Help! How do you get excel to find the x(changes daily, marked in a cell from another formula) highest numbers in a group of numbers and sum them up? | Excel Worksheet Functions | |||
Help! How do you get excel to find the x(changes daily, marked in a cell from another formula) highest numbers in a group of numbers and sum them up? | Excel Worksheet Functions | |||
count a group of numbers but do not count duplicates | Excel Worksheet Functions | |||
Group by count formula | Excel Worksheet Functions |