Hi,

I'm trying to figure out a way of flagging numbers in a spreadsheet that fall between various number ranges, i'm fairly new to these kind of formula so could do with a little help

What I have is a dump of all the external telephone calls made on our telephone system and what I want to find out is which of these calls could have been made internally between sites.

So I have several phone number ranges i'm looking for in this dump and would like an easy way of marking them. Currently I have been importing it into an Access DB and using the "Like" function to filter out all the numbers and then having to export it back to XL to do various calculations.

Is there a way I can do all this just within XL?

Thanks,

Kam