REVscene Automotive Forum - View Single Post

tiger_handheld · 05-04-2019, 02:35 PM

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?

excel.JPG

05-04-2019, 02:35 PM	#1
tiger_handheld MiX iT Up! Join Date: May 2006 Location: vancouver Posts: 8,153 Thanked 2,076 Times in 871 Posts Failed 642 Times in 183 Posts	Excel help! 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? excel.JPG __________________ 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