Article View: alt.pl.openoffice
Article #14547Re: [Calc] Wyszukiwanie w tekście
From: JaromirD
Date: Fri, 19 Nov 2010 22:51
Date: Fri, 19 Nov 2010 22:51
9 lines
1111 bytes
1111 bytes
JaromirD wrote:
> Po drugie tajemne zaklęcie ma postać:
> =WYSZUKAJ.PIONOWO(MID($G1;SZUKAJ.TEKST("/";$G1;1)+1;4);$A$1:$B$14;2;0)
Małe sprostowanie. Powinno być $A1:$B14 bo inaczej po przeciągnięciu wzoru w
dół nie zadziała. Czyli
=WYSZUKAJ.PIONOWO(MID($G1;SZUKAJ.TEKST("/";$G1;1)+1;4);$A1:$B14;2;0)
Technical Details
Message-ID:
<ic6v1i$6bl$2@news.onet.pl>Path:
mbox-mo1.pugleaf.net!news-archive.icm.edu.pl!news.gazeta.pl!newsfeed.pionier.net.pl!news.nask.pl!news.nask.org.pl!news.onet.pl!not-for-mailReferences:
<ic6mk4$2ef1$1@news.mm.pl> <ic6uqm$6bl$1@news.onet.pl>Show Full Headers
Complete Article Headers
Path: mbox-mo1.pugleaf.net!news-archive.icm.edu.pl!news.gazeta.pl!newsfeed.pionier.net.pl!news.nask.pl!news.nask.org.pl!news.onet.pl!not-for-mail From: JaromirD <rydberg@q2.pl> Newsgroups: alt.pl.openoffice Subject: Re: [Calc] Wyszukiwanie w tekście Followup-To: alt.pl.openoffice Date: Fri, 19 Nov 2010 23:51:29 +0100 Organization: http://onet.pl Lines: 9 Message-ID: <ic6v1i$6bl$2@news.onet.pl> References: <ic6mk4$2ef1$1@news.mm.pl> <ic6uqm$6bl$1@news.onet.pl> NNTP-Posting-Host: 83.1.100.10 Mime-Version: 1.0 X-Trace: news.onet.pl 1290207090 6517 83.1.100.10 (19 Nov 2010 22:51:30 GMT) X-Complaints-To: niusy@onet.pl NNTP-Posting-Date: Fri, 19 Nov 2010 22:51:30 +0000 (UTC) User-Agent: KNode/4.4.7 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit