Looking for formula to extract values in G2:G10 into A17:A27 if alphabet select in A13 (for example, A) matches the first letter of values in G2:G10. For example, if A was selected in A13, need formula to only extract all values that has "A" as their first letter (see F2:F10) into A17:A27 and their corresponding values.
See attached sample file.
Thanks
Bookmarks