greetings all,

I am hoping someone can provide a relatively novice user a simple formula. My project is:

In excel 2010, I have 2 columns (A & B). A data has already been entered, and is a list of all groceries. B column is blank until I enter the price next to the grocery I purchase. I would like to create another sheet I will call results, and would like it to autopopulate only columns A & B that have the price entered in column B, without listing the entire grocery list of items.

The grocery list thing is just an analogy, but I could really use some help. thanks...

Jim