ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   vert.search (https://www.excelbanter.com/excel-worksheet-functions/8221-vert-search.html)

tyn

vert.search
 
I've justed vert.search to search in kolum A for: z, Now comes the problem:
there are more than one z. and the cel can't show more than on hit. But i wan
all the z's..
How can I solve this prblem??

Excuse my bad English..:(

a b
z (vert.search)
q (vert search)
t etc..
z ....

Frank Kabel

Hi
not really possible without VBA

--
Regards
Frank Kabel
Frankfurt, Germany

tyn wrote:
I've justed vert.search to search in kolum A for: z, Now comes the
problem: there are more than one z. and the cel can't show more than
on hit. But i wan all the z's..
How can I solve this prblem??

Excuse my bad English..:(

a b
z (vert.search)
q (vert search)
t etc..
z ....





All times are GMT +1. The time now is 02:34 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com