tag:blogger.com,1999:blog-8311566489967769569.post3125340945229983765..comments2011-11-30T11:50:32.012-08:00Comments on Winchester Isle: Excel Nerd PostMonahttp://www.blogger.com/profile/04824468998607637466noreply@blogger.comBlogger1125tag:blogger.com,1999:blog-8311566489967769569.post-50716120092579299152011-11-30T11:50:32.012-08:002011-11-30T11:50:32.012-08:00For #1, try selecting the section you want sorted ...For #1, try selecting the section you want sorted and sort all of that (including all the columns so your formulas stay intact) <br /><br />For #2, try using Vlookup or Hlookup instead of just lookup<br /><br />For #3, try a countif formula<br /><br />Hope that helps, I love excel :)Apple Valleyhttps://www.blogger.com/profile/15211791410107503046noreply@blogger.com