Debraj Roy! You are a GENIUS! But not just a GENIUS, you are a very thoughtful and generous GENIUS!!! Thank you for sharing your knowledge with me and others seeking answers! This was exactly what I was looking for, EXACTLY! and IT WORKED PERFECTLY! THANK YOU, THANK YOU, THANK YOU from the...
Thanks for responding jskushawah! But if I filter column B to a different last name, I need F2 to automatically reflect this newly selected last name. Any ideas which formula to use?
LABELING PROJECT: I am using Microsoft Excel 2007 and have a column containing different last names. When I filter this column to a particular last name (i.e. "Smith"), I need a cell that is located outside of this column to show this last name. What formula can I use on this cell so that when...