Forum Discussion
Is Excel capable of this operation?
THIS QUERY IS NOT FOR THE FAINT OF HEART!
Speadsheet has Column A and Column B. Intermittently, Column A has a "plateau", where data is "stable" ( within 3%) for at least 4, and as many as 20, rows. Between plateaus, data is dynamic and may be higher or lower. I want to assess data in Column B to find when Column B data reaches a "plateau" between 2 and 20 rows (always) AFTER Column A. Absolute values and ranges in both Columns are different, but "plateau definition" is identical. A) How can Excel identify when "plateaus" occur, and B) How can Excel identify when Column B has a "plateau" within 2-20 rows, when Column B has a different data value/ range than Column A? Is this beyond Excel capabilities?
22 Replies
- It sounds very do-able. Do you happen to have an anonymized sample workbook you can share by attachment or upload to a host like OneDrive?
Sorry for the delay, Patrick! I was creating some docs to help explain my problem and my target. Here they are:
https://1drv.ms/f/s!AosKAG2c8jifcvJgOxXyASyf-Rg?e=m9XQbM
I sincerely appreciate your help with this problem, in advance. I'm not an Excel wiz, so I'm not sure that this is even possible. I hope you're able to prove me wrong, and maybe show me an example.
- If you have any problems with OneDrive access, just let me know. I have other avenues of access.
- Yes, working on numeric AND visual example. Expect to post within 24 hrs. Appreciate your patience. Glad to have a response to my query!!
