I'm struggling with this and would much appreciate some expert help please.
I want to scan down a column of decimals and if any group has four numbers which are all less than or equal to 0.6, then I want to copy a number from column A alongside the first of those four cells. Hopefully my screenshot clarifies this.
FormulaToScanGroups.jpg
I've also uploaded an example of a full worksheet, which contains at least one other group that qualifies.
https://www.dropbox.com/s/34x1g5njn6...ple.xlsx?raw=1
NOTE: I changed my attached image but there now seem to be TWO images, although only a single ATTACH code is shown when I use the Edit tool. So I'm unsure how to remove the unwanted older image.
Bookmarks