Find numbers of lines ?

**alikirca20** · 04-12-2009, 02:55 AM

I have some number groups. I have also 5 numbers. I want to find numbers of lines in groups include these 5 numbers together? Can I do it only by using one cell and formule? I eplained my question in detail by added file. Thanks.

**TonyB51** · 04-12-2009, 03:39 AM

Hi,

I think the attached amended spreadsheet solves your problem.

Cheers

Tony

**alikirca20** · 04-12-2009, 04:57 AM

hi tony, but it is not my answer,

**VBA Noob** · 04-12-2009, 06:09 AM

Your post does not comply with Rule 8 of our Forum RULES. Cross-posting is when you post the same question in other forums on the web. You'll find people are disinclined to respond to cross-posts because they may be wasting their time solving a problem that has been solved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser)to the cross-post. Expect cross-posts without a link to be closed a message will be posted by the moderator explaining why. We are here to help so help us help you!