Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]() Could you please help me automating a process in EXCEL for the following problem. I have data arranged in the following format: 1/A B C D E F G 2 ColA ColB ColC ColD Population 3 25 68 20 93 78 4 48 48 100 94 24 5 20 4 26 53 46 6 37 12 92 93 10 7 80 6 31 27 91 8 85 42 96 56 76 9 1 8 88 82 78 10 3 24 59 20 63 11 97 89 45 53 94 12 13 Negative 14 Positive In Cells C13 to C14, I want to get the results of the counts if the differenc e (e.g., ColA-Population, ColB-Population, etc.) is negative or positive. Is there a function that will automatically compute this across ColA through ColD. Thank you in anticipation. Jack |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
percentage computation | Excel Discussion (Misc queries) | |||
computation error | Excel Discussion (Misc queries) | |||
Time Computation | Excel Discussion (Misc queries) | |||
What type of pc is best for computation | Excel Discussion (Misc queries) | |||
.01 or .02 diffrence in computation | Excel Discussion (Misc queries) |