I have a master data set on one sheet...
for example
Letter number
t _______ 1
b_______ 2
e ______ 3
d ______ 4
t ______ 5
r ______ 3
t ______ 9
I want another sheet to automatically populate a data set from the master data pertaining to "t" like this...
Letter number
t____ 1
t ____ 5
t ____ 9
thats it.
Is this possible with a formula that can be autofilled down? Thanks.
Bookmarks