Hello to all,
Maybe someone could help me with a macro to do the following complex arrangement.
In attached sample file I have in range A1:A1000 consecutive values from 3000 to 3999. Some numbers have next to them the string "ffh".
In this example it happens like this,
- From 3000 to 3009 --> There are no numbers associated with "ffh"
- From 3010 to 3019 --> There are no numbers associated with "ffh"
- From 3020 to 3029 --> There are 2 numbers associated with "ffh" (3024 adn 3028)
- From 3030 to 3999 --> There are no numbers associated with "ffh"
What I would like is to represent in the minimin expression the ranges that don't have "ffh" within it, so, for this
case, instead to have numbers from 3000 to 3009 I'd like to have only 300 (since 300 is common to all numbers from 3000 to 3009),
and instead to have numbers from 3010 to 3019 I'd like to have only 301.
Another example that something that happens in range A1:A1000 is:
From 3300 to 3399 there are no numbers with "ffh", then I'd like to have only 33. (33 is common for numbers in range 3300 to 3399)
Then the final array will be reduced as shown in column B (B1:B28)
I hope make sense
Thanks in advance for any help.