We are playing a silly game that is teaching me about trading on the Stock Market. I am trying to figure out how to work my spreadsheet up so that it will tell me when to buy and when to sell my stocks in certain companies. I have the basic spreadsheet with category, business, bought, sold, buy, sell but I am having a problem. I need a column to automatically tell me the lowest amount seen in "buy" and the highest amount seen in "sell". Is there a way to do this? I used to think I was proficient in Excel but this gives new meaning to "tearing your hair out" for me. I'm sure that there are pivot tables and all sorts of other things to utilize but I'm not sure how when I'm only wanting to see things a certain way. Can you help?