i need a formula to count the amount of cells with the same number in the two
cells. at the moment im using =countif(range,"="&range) but when i use this
it counts the blank squares which i dont want it to. i cant enter text into
the boxes as i have other formulas using them cells. does anybody have and
ideas is there another formula or a modifyed version of my current one ????