Forum

SunnyKow
@sunnykow
Noble Member
Joined: Jun 25, 2016
Topics: 0 / Replies: 1417
Reply
RE: Conditional Formatting

Hi Melinda Give this a try

6 years ago
Reply
RE: Need advice on the formula to use

Hi Crystal Q1) You can try =IF(S2<15,"under","") to compare cell S2. You can just highlight the cell with the formula in red font. Q2) Try =S...

6 years ago
Reply
RE: VBA Automation?

Hi Steve Maybe you could try using Index and Match. Good luck. Sunny

6 years ago
Forum
Reply
RE: How to protect multiple sheet for different users

Hi Vic Give this a try. Please note that since there are no error checking on whether the sheet name you allocated exist, make sure it exist. Ot...

6 years ago
Reply
RE: Show max value data label on a stacked chart?

I myself don't quite understand how my own brains work at times but I am happy that the solution is working for you. Cheers Sunny

6 years ago
Reply
RE: Show max value data label on a stacked chart?

Hi Andrea What I am trying to do is to make the Max series "float" above the Jan-December series. For that to happen, I need to determine how mu...

6 years ago
Reply
RE: Show max value data label on a stacked chart?

Hi Andrea I have updated the file with months from Jan-Dec. Sunny

6 years ago
Reply
RE: Show max value data label on a stacked chart?

Hi Andrea Creating interactive custom labels is challenging enough and using a stacked bar chart makes it worse. Since I was unable to find any...

6 years ago
Reply
Reply
RE: Show max value data label on a stacked chart?

Hi Andera From your screenshot it looks like the chart came from a PivotTable and this can complicate matters. Furthermore I don't know if the M...

6 years ago
Reply
RE: Excel function for a spreadsheet

That's great Thanks for the feedback. Sunny

6 years ago
Reply
RE: Combine Tabs on different work books to One Tab in another workbook

Hi Gerri You can give this Add-In a try. I think it will be useful for your situation. Good luck Sunny

6 years ago
Page 22 / 95