Showing Custom Value Based on the Condition of Dynamic Table

**Anshu** · 09-14-2020, 09:56 PM

Thank you for the Macro. It works fine!
But there are 2 important points which I want to mention...

Point 1) Missing comma: When all the three rows contains values in descending order, then B4 shows - Student is decreasing in ENGLISH and HINDI and MATHS
It should be - Student is decreasing in ENGLISH, HINDI and MATHS (as we normally write in English language)

Point 2) I've forgot one point to mention in my top post. So I edited my top most post after 3 hours of first posting. So, I think, the point got unnoticed. It's here...

Important:
All of the above conditions are applied only if there are minimum 3 consecutive cells which are in descending order.
For example, cells D5, E5 and F5 have values which are satisfied all the three condition, i.e, they are in descending order, and they are consecutive (side by side), and they are minimum three.

In the support of the line, I've edited the attachments too.
__________________________________________________ __________________________________________________ _______________________________________

If you ever want a detailed explanation of anything in my coding, then please ask.
I prefer to explain my coding in detail to help educate, rather than continually producing similar codings

How nice your idea is! I really like it.
But before asking for any explanation, I first need to understand at least 70 to 80 percent of the macro provided above. And for understanding this highly compex and complicated coding (for me) for a person like me, who has just started his journey of excel 3 months ago, it may took several days. First, I have to search the meaning of various terms used in the code above like .End(xlUp).Row, UBound etc. Then I have to search for the meaning of various lines used in the code above. Only then I'll consider myself eligible to ask for any explaination here.
Thank you very much for educating and improving my area of knowledge, surprisingly, without any cost!