For help, want to extract the yellow background data in a table, condition is:
1. The three Numbers separated by less than 100 lines
2. The three Numbers are periodic high, and must be greater than 10 rows between adjacent, less than 30 lines
3. The three Numbers reduced gradually, and the difference is not more than 10%
4. Find all conform to the conditions of the three Numbers in a table
5. According to the bank the date of the corresponding

Hope to have a great god can answer, had better use python code, EXCEL can realize can also, thank humbly!

CodePudding user response:

This shouldn't be hard, but there are several don't understand:

Three Numbers are periodic high what's the meaning of
Three digital gradually decreases, and the meaning of a than a small, understanding deviation less than 10%? ABC:/A< (B - A); B=10% (C -)/B<=10%?

I am a beginner, welcome to discuss