Hello
I am trying to find a cell with a smallest value based on custom format data in range of cells
Custom format looks like 55-XXXXXX/201X
Is it possible to find smallest value in range of cells if is meet smallest XXXXXX and also 201X criteria.Where 201X is first in priority
For example 46-000123/2010 is smaller than 55-000122/2011 and also 55-000015/2012 is smaller than 55-000014/2012.
Also is important to mention that those value is result from array formula (INDEX; SMALL; MATCH; ROW)
Any idea is highly appericiated
Bookmarks