I am not able to use a formatted cell within an array formula. The array
formula is set up to average the number of days it is taking to get a product
from a third party vendor and one range used in the formula is formatted and
the array formula does not like the formatted cell.
Any thoughts on how i can get around the formatted cell / format the cell
where the array formula will accept the formatted cell?
Thanks,

Michael

You need to provide detail. Paste your formula and your sample data which is
causing the issue. Tell us what are the current errors you are getting and
the expected results.

p/s: Formulas, whether normal or array, work on underlying values in the
precedent cells. The format applied to these precedents affect only how these
values display/appear on screen, not how they are evaluated by formulas using
them.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik
---
"Michael" wrote:
I am not able to use a formatted cell within an array formula. The array
formula is set up to average the number of days it is taking to get a product
from a third party vendor and one range used in the formula is formatted and
the array formula does not like the formatted cell.
Any thoughts on how i can get around the formatted cell / format the cell
where the array formula will accept the formatted cell?
Thanks,

Michael