Do you have any error cells in your range? #N/A or #VALUE! or DIV/0! ?
formula worked fine on my test data set which I just copied from your OP
Rgds, Geoff
We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.
Did you enter it as an array formula? In other words, having typed the entry into the cell, do not hit "enter", instead hit Ctrl Shift Enter simultaneously.
Did you also remember to name the appropriate range Bid_Mgr?
N1GHTEYES - I do have the range named Bid_MGR, did the CTRL - Shift - Enter at the same time...though not sure how well I am hitting them at the same time.
I would err against using array formulae unless really necessary - they are very memory intensive
the requirement to use one is often the sign of a workbook that needs a re-design! enerally, if you set out your wrkbook as you would a set of database tables, it is very rare that you actually need an array formula - certaily notmore than a couple - most things you can do with them can be replicted using a pivot table
Rgds, Geoff
We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.