I have the following data:
Bob
Mary
Bean
Scott

I want it to have a sequence when printed when it is filtered or not.
So, if I printed it all I would like to see:

1 Bob
2 Mary
3 Bean
4 Scott

If I filtered on Column B for the items that start with the letter "B"
I would like to see (notice the sequence is accurately reflecting the
number of rows displayed):
1 Bob
2 Bean

Is this possible with simple formulas? I know I can write a macro
that will populate the values each time it is run but I would prefer
to use formulas.

Regards,
-J