On LIST:

=COUNTIF(DATA!E2:E50000,DATA!I2)

"Mighty Magpie" wrote:

Hello



If I use the following formula I sort of get what I want but I would like to
put the formula onto a sheet named "LIST" and for it to find the information
from a different sheet (named DATA)



=COUNTIF(E2:E50000,I2)





Can someone please advise me how to do this?



TIA