| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Counting differences in numbers across columns
I think this is probably pretty easy.
I have a table here is the first row (starting at a1), with numbers in individual columns A B c d e 1624 1433 1546 1244 1287 The columns represent years with A being the current year. I want to count how many years improved upon the previous year. The answer is two, C is greater than D, and A is greater than B. Of course units went down from E to D and again from C to B. How do I write a formula that can analyze the four relationships across the five years and count how many times units went down from one year to the immediately following year? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| identify numbers which are listed in two columns. | Excel Worksheet Functions | |||
| Sum of all even and odd numbers between two columns | New Users to Excel | |||
| How to sort random numbers in columns | Excel Discussion (Misc queries) | |||
| Counting the Contents of Two Columns | Excel Discussion (Misc queries) | |||
| How do I take two columns of sequential numbers and insert spaces | Excel Discussion (Misc queries) | |||
Threaded Mode
