I have a large amount of data I want summarized without having any blank
rows. The data looks like the following (only thousands of rows of different
numbers):

A B
3 123
3 567
3 578
4 746
5 645

Column A represents a sales person # and Column B represents a part number.
I want a summay on a different sheet that shows a range of part numbers by
sales person. One section will show part numbers starting with the number 5,
another section starting with 6, etc. There is a lot of formatting on the
other worksheet so I can't use a filter and I don't want any blank rows. For
example I would like sales person #3 to display as follows for part number
starting with 5 only. Is there a formula I could use to pull in only part
numbers starting with 5 for sales person #3 that does not show any blanks?

A B
3 567
3 578