Need quick help filtering data

All:
I have the following table:


1 2

- -
- B
A -
- -
- -


There are dashes in some rows and then and A and a B in one row for each column.

How can i do a search of a column and find out what letter is being displayed. IE - what letter is in the column, ignore all the dashes.

Any help would be great. thanks!

Do you want this information returned to specific cells or are you just looking for the information? If you do an autofilter (data dropdown), the dropdown list on each column should just give you the options what's in that row (e.g. a letter or a -). If you want a formula for a cell, let us know and we can work one out.

ChemistB

Thanks for the reply. Yes i know the excel autofilter but i do need the exact letter returned in an exact cell. I could do it in VBQ using loops but i want to avoid that because my spreadsheet has too much data and is slow as is.

I was thinking of using a function of =MAX or =COUNT or something like that but i didnt know one that returned the value of just one cell.

If it helps, i could have it return a number and not a letter. Then i could just vlookup the letter from the number. Thanks!