Your are viewing a read-only archive of the old DiS boards. Please hit the Community button above to engage with the DiS !
pretty pleased with myself.
what are your latest excel achievements?
Range("BE10").FormulaArray = "=SUM(IF((R10C44:R50000C44=RC53)*(R10C47:R50000C47=""Y""),1,0))"
I did it all by myself.
to no acclaim
be curious to know whether we used the same formulae.
or rather, tacking on some textboxes at the front to turn it into a self-service template.
Fistpumped and shouted my own name in the office and got naked in celebration.