You are currently viewing our boards as a guest which gives you limited access to view most discussions and access our other features. By joining our free community you will have access to post topics, communicate privately with other members (PM), respond to polls, upload content and access many other special features. Registration is fast, simple and absolutely free so please, join our community today!
The banners on the left side and below do not show for registered users!
If you have any problems with the registration process or your account login, please contact contact us.
The Business and Financial ForumTHIS SPACE OPEN FOR ADVERTISEMENT. YOU SHOULD BE ADVERTISING HERE! Revscene Wall Street.
Consolidating debt? Good business tips? Buying stock? How's our economy doing? Discuss and share advice and tools on everyday banking, investing, wealth management and insurance.
Guys i'm trying to work on a presentation and need some help!
Refer to below screenshot
Question 1 - In Cell D4, I need to add a trend icon (conditional formatting, icon sets, directional) to show the trend direction of the 3 numbers. How can I do this?
Question 2 - I have table 2 as the raw data, and in table 1, i need to look up the value for "single & march" and drop it into the cell B12 and "triple and March" into B13 etc. for all the remaining cell. How can I do this?
Sometimes we tend to be in despair when the person we love leaves us, but the truth is, it's not our loss, but theirs, for they left the only person who couldn't give up on them.
Make the effort and take the risk..
"Do what you feel in your heart to be right- for you'll be criticized anyway. You'll be damned if you do, and damned if you don't." - Eleanor Roosevelt
Question 2 - Vlookup + Match, i will try it out. Vlookup itself will not work as it needs to look up 2 variables.
__________________
Sometimes we tend to be in despair when the person we love leaves us, but the truth is, it's not our loss, but theirs, for they left the only person who couldn't give up on them.
Make the effort and take the risk..
"Do what you feel in your heart to be right- for you'll be criticized anyway. You'll be damned if you do, and damned if you don't." - Eleanor Roosevelt
The video is not what i'm looking for though. Maybe wrong link?
Basically, I want to use the directional arrows to say
1.6 1.5 1.3 - it's trending down and show an arrow.
1.5 1.4 1.6 - staying the same, and show the steady arrow.
hope i'm explaining this ok.
__________________
Sometimes we tend to be in despair when the person we love leaves us, but the truth is, it's not our loss, but theirs, for they left the only person who couldn't give up on them.
Make the effort and take the risk..
"Do what you feel in your heart to be right- for you'll be criticized anyway. You'll be damned if you do, and damned if you don't." - Eleanor Roosevelt
Yeah I don't think I understood the question the first time around.
This should be what you're looking for. Though, it's a graph not an arrow.
Alternatively, you could take the difference of the numbers, they're within you're steady parameters you conditional formatting to have a even sign. If it's negative outside your parameters, down arrow. If positive outside your parameters, up arrow.
You could also use numerical differentiation to find the change in slope of the data points. the resulting number would give you a positive number, trending up. Negative number trending down. or approximately zero, steady.
Yeah I don't think I understood the question the first time around.
This should be what you're looking for. Though, it's a graph not an arrow.
Alternatively, you could take the difference of the numbers, they're within you're steady parameters you conditional formatting to have a even sign. If it's negative outside your parameters, down arrow. If positive outside your parameters, up arrow.
OOoh. sparklines may just work. I shall try tomorrow.
__________________
Sometimes we tend to be in despair when the person we love leaves us, but the truth is, it's not our loss, but theirs, for they left the only person who couldn't give up on them.
Make the effort and take the risk..
"Do what you feel in your heart to be right- for you'll be criticized anyway. You'll be damned if you do, and damned if you don't." - Eleanor Roosevelt
You are currently viewing our boards as a guest which gives you limited access to view most discussions and access our other features. By joining our free community you will have access to post topics, communicate privately with other members (PM), respond to polls, upload content and access many other special features. Registration is fast, simple and absolutely free so please, join our community today!
The banners on the left side and below do not show for registered users!
