LinkBack URL
About LinkBacks
Does anyone know if and how to exclude a cell from calculations based on "manually" changing the cell style. I would like to use the "Bad" cell style to exclude outlying data from a statistical calculation. Thanks. - Bill
Does anyone know if and how to exclude a cell from calculations based on "manually" changing the cell style. I would like to use the "Bad" cell style to exclude outlying data from a statistical calculation. Thanks. - Bill
Welcome to the forum.
The 'bad' news is that it cannot be done: Excel is not able to use any form of cell formatting in a formula. Under what conditions would a cell be formatted as bad?
There are instructions at the top of the page explaining how to attach your sample workbook.
A good sample workbook has just 10-20 rows of representative data that has been desensitised. It also has expected results mocked up, relevant cells highlighted and a few explanatory notes.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
Thanks so much for the quick response. I was going to "manually" format (by simply click on the "Bad" style) outliers in a data set that I want to examine for trends. I could do it another way, I suppose, but was trying to take the simpliest route due to my lack of Excel skills. Thanks. I will try to clean it up a little and post some specifics and see where it goes. Thanks, and have a great weekend!
If you can tell us how you'd define the outliers, then we can tell you how to write a formula to exclude them AND a formatting rule to format them automatically.
Yes, some sample data would help.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks