Return-Path: X-Original-To: apmail-incubator-ooo-users-de-archive@minotaur.apache.org Delivered-To: apmail-incubator-ooo-users-de-archive@minotaur.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id E6B7BD63A for ; Fri, 2 Nov 2012 11:41:20 +0000 (UTC) Received: (qmail 79280 invoked by uid 500); 2 Nov 2012 11:41:20 -0000 Delivered-To: apmail-incubator-ooo-users-de-archive@incubator.apache.org Received: (qmail 78796 invoked by uid 500); 2 Nov 2012 11:41:14 -0000 Mailing-List: contact ooo-users-de-help@incubator.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: ooo-users-de@incubator.apache.org Delivered-To: mailing list ooo-users-de@incubator.apache.org Received: (qmail 78731 invoked by uid 99); 2 Nov 2012 11:41:12 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 02 Nov 2012 11:41:12 +0000 X-ASF-Spam-Status: No, hits=2.4 required=5.0 tests=FREEMAIL_ENVFROM_END_DIGIT,HTML_MESSAGE,RCVD_IN_DNSWL_NONE,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: local policy) Received: from [195.4.92.91] (HELO mout1.freenet.de) (195.4.92.91) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 02 Nov 2012 11:41:01 +0000 Received: from [195.4.92.141] (helo=mjail1.freenet.de) by mout1.freenet.de with esmtpa (ID chindog01@freenet.de) (port 25) (Exim 4.76 #1) id 1TUFc8-0006Vy-8j for ooo-users-de@incubator.apache.org; Fri, 02 Nov 2012 12:40:40 +0100 Received: from localhost ([::1]:47895 helo=mjail1.freenet.de) by mjail1.freenet.de with esmtpa (ID chindog01@freenet.de) (Exim 4.76 #1) id 1TUFc8-0001bt-25 for ooo-users-de@incubator.apache.org; Fri, 02 Nov 2012 12:40:40 +0100 Received: from [195.4.92.20] (port=39836 helo=10.mx.freenet.de) by mjail1.freenet.de with esmtpa (ID chindog01@freenet.de) (Exim 4.76 #1) id 1TUFaA-0000Jz-C3 for ooo-users-de@incubator.apache.org; Fri, 02 Nov 2012 12:38:38 +0100 Received: from p4ff85575.dip.t-dialin.net ([79.248.85.117]:62634 helo=linux-kru7.speedport.ip) by 10.mx.freenet.de with esmtpa (ID chindog01@freenet.de) (port 25) (Exim 4.76 #1) id 1TUFa9-0007XH-Rb for ooo-users-de@incubator.apache.org; Fri, 02 Nov 2012 12:38:38 +0100 From: chindog Reply-To: chindog01@freenet.de To: ooo-users-de@incubator.apache.org Subject: Re: Tabellen vergleichen... aber wie ??? Date: Fri, 2 Nov 2012 12:38:36 +0100 User-Agent: KMail/1.13.6 (Linux/2.6.34.10-0.6-default; KDE/4.5.5; i686; ; ) References: <201210282130.50603.chindog01@freenet.de> <201210290840.22369.chindog01@freenet.de> In-Reply-To: X-KMail-Markup: true MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="Boundary-01=_8C7kQ3/o81Yp8xw" Content-Transfer-Encoding: 7bit Message-Id: <201211021238.36806.chindog01@freenet.de> X-Virus-Checked: Checked by ClamAV on apache.org --Boundary-01=_8C7kQ3/o81Yp8xw Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: quoted-printable Klappt irgendwie nicht :( Habe die Tabellen so umgeformt, wie beschrieben; die Formel eingef=C3=BCgt = und nun=20 steht im Feld "E1" (wo ich die Formel eingegeben habe) ein einsamer Name :( Die Tabelle 1 hat 345 Felder; die Tabelle 2 204 Felder.=20 Anhand der mnummer mu=C3=9F ich die 141 rausfinden, die nicht gezahlt haben= - oder=20 die 204, die gezahlt haben...... Egal wie ..... Stehe hier echt auf den Schlauch...... Nochmals danke Axel Am Montag, 29. Oktober 2012 schrieb J=C3=B6rg Schmidt: =2E >=20 > Dann verwende SVERWEIS(), ich schrieb es bereits. Wenn in Tabelle 2 Spalte > E Meier auftauchen soll mu=C3=9F Tabelle1 zweckm=C3=A4=C3=9Fig so umsorti= ert werden das > vorne die Nummer und dann Name und Nachname steht und in Tabelkle 2 geh= =C3=B6rt > in E1 die Formel: >=20 > =3DSVERWEIS(A1;Tabelle1.A1:D20;2) >=20 > Gru=C3=9F > J=C3=B6rg >=20 >=20 > P.S. > Antworten NUR in die Mailingliste! >=20 >=20 > --------------------------------------------------------------------- >=20 > Abmelden von der Mailingliste: > ooo-users-de-unsubscribe@incubator.apache.org Informationen: > http://www.openoffice.org/de/ >=20 > To unsubscribe, e-mail: ooo-users-de-unsubscribe@incubator.apache.org > For additional commands, e-mail: ooo-users-de-help@incubator.apache.org =2D-=20 --Boundary-01=_8C7kQ3/o81Yp8xw--