I have a task that I need to get the 95th item of a certain product. I need to get it in a database type table. Getting it using a formula array like this is easy task.
=SMALL(IF(Product_Range = "Prod1",Value_range),ROUND(COUNTIF(Product_Range,"Prod1")*95,0))
But my question is, can...