Hi Everyone,
I have a small request and I am pretty sure many Excel champions can resolve this in minutes. I am extracting numbers from a range. Lets say following range. It has zero or blank values in between & also negative and positive values. If I apply large numbers and link the ranking to other cells it is stopping at cells having zero values and If i take if formula with large and small the ranking range goes irrelevant due to formula being dragged into different cell. I have around 300 rows and around 150 having positive and negative values. I want to compile a table which gives me only
I have a small request and I am pretty sure many Excel champions can resolve this in minutes. I am extracting numbers from a range. Lets say following range. It has zero or blank values in between & also negative and positive values. If I apply large numbers and link the ranking to other cells it is stopping at cells having zero values and If i take if formula with large and small the ranking range goes irrelevant due to formula being dragged into different cell. I have around 300 rows and around 150 having positive and negative values. I want to compile a table which gives me only
Column A | Column B |
A | 800 |
B | 900 |
C | 405 |
D | 400 |
E | |
F | |
G | -100 |
H | |
I | 80 |
J | -190 |
K |