heres the scenario, in one column I need to come up with how many stores
of a specific type are in a given area, I have the area's in one column
on ones sheet and the types in another column. so on a different sheet
i need to sum the number of stores of one type in one area, but the
tricky part is i'm looking for general stores names like, shaws, or
acme, and the listing has them as shaws/southeast or acme/southwest,
acme/mountain. Is there a way to look for all the stores that have the
"shaws" in the name and cound all of them with the specific area i
need?? does that question make sense....?


--
rcarrollct
------------------------------------------------------------------------
rcarrollct's Profile: http://www.excelforum.com/member.php...o&userid=24931
View this thread: http://www.excelforum.com/showthread...hreadid=385123