I am having trouble getting my weather and road conditions to work.
When the data in Column H changes but the data in Column I stays the same my formula will not show the change and stops.
i.e.
Column H Column I
Overcast Wet
Rain Wet
How do I get the formula to recognize the change?
Thank you so much for your time.
What formula? What changes? Obvious to you, but still a mystery to me (yes, looked at the attachment). More details, please.
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.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Try this in B153 copied down
Your formula was ignoring values if either Road or Weather conditions remained constant.Formula:
Please Login or Register to view this content.
ChemistB
My 2?
substitute commas with semi-colons if your region settings requires
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)
Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
Thank you for your reply.
Sorry about that. The formulas are in the following cells.
B153, C153, E153 and F153.
What happens is, if he road conditions are the same but the weather changes the formula does not report the weather change or road condition. To see what I mean change the values in the range I138 to I145 to ICY. You will see the report picks that up. The issue is that there are many occasions when the road conditions will remain the same but the weather conditions will change.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks