[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 483: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/functions_content.php on line 678: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/functions_content.php on line 678: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/functions_content.php on line 678: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/functions_content.php on line 678: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/functions_content.php on line 678: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/functions_content.php on line 678: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/bbcode.php on line 112: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/functions_content.php on line 678: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/functions_content.php on line 678: preg_replace(): The /e modifier is no longer supported, use preg_replace_callback instead
[phpBB Debug] PHP Warning: in file [ROOT]/includes/functions.php on line 4714: Cannot modify header information - headers already sent by (output started at [ROOT]/includes/functions.php:3829)
[phpBB Debug] PHP Warning: in file [ROOT]/includes/functions.php on line 4716: Cannot modify header information - headers already sent by (output started at [ROOT]/includes/functions.php:3829)
[phpBB Debug] PHP Warning: in file [ROOT]/includes/functions.php on line 4717: Cannot modify header information - headers already sent by (output started at [ROOT]/includes/functions.php:3829)
[phpBB Debug] PHP Warning: in file [ROOT]/includes/functions.php on line 4718: Cannot modify header information - headers already sent by (output started at [ROOT]/includes/functions.php:3829)
Çoklu Numara Bulma

Çoklu Numara Bulma

Çoklu Numara Bulma

#2463 İleti | Eytisim | 15 Mar 2019, 09:53

Selamlar,
Şirketimizde kayıtlı 1 milyona yakın üyenin telefon numarası bulunmakta, bu excel de bazı üyelerin numaralarını toplu halde arama yaparak bulabilirmiyiz?
Eytisim
 
İleti: 2
Kayıt: 15 Mar 2019, 09:50
İşletim Sisteminiz:
LibreOffice Sürümü:

Re: Çoklu Numara Bulma

#2464 İleti | Hamurcu | 15 Mar 2019, 10:59

Excel değil LibreOffice Calc için anlatacağım.

Tablonuzun formatını bilmiyorum ancak aşağıdaki gibi bir formata sahip ise Otomatik Süzgeç ile yapabilirsiniz.

A Sütunu : İsim Soyisim
B Sütunu : Telefon Numarası
C Sütunu : ....
D Sütunu : ....

Tüm tabloyu işaretleyip (A'nın solu, 1'in üstündeki Boş kutu sembolü) Veri-->Otomaitk Süzgeç seçin.

Tüm sütun başlıklarının sağına ok sembolü gelecektir.

Sonrasında istediğiniz sütunun yanındaki aşağı yönlü OK işaretine basarak açılan diyalog kutusundan istediğiniz kadar seçim yapın ve Tamam butonuna basın.
Kullanıcı avatarı
Hamurcu
 
İleti: 172
Kayıt: 06 Ağu 2012, 00:14
Konum: İstanbul
İşletim Sisteminiz:
LibreOffice Sürümü:

Re: Çoklu Numara Bulma

#2465 İleti | Eytisim | 15 Mar 2019, 11:12

Sanırım ben yanlış anlattım. liste şu şekil aşağı doğru gidiyor http://prntscr.com/my5trg ben burada aynı anda 3 numaraya erişmek veya aratarak seçilmesini istiyorum.
Eytisim
 
İleti: 2
Kayıt: 15 Mar 2019, 09:50
İşletim Sisteminiz:
LibreOffice Sürümü:

Re: Çoklu Numara Bulma

#2466 İleti | Hamurcu | 15 Mar 2019, 11:50

Eklentiler
kosullubicim2.png
kosullubicim2
kosullubicim2.png (5.48 KiB) 111 defa görüntülendi
kosullubicim1.png
kosullubicim1
kosullubicim1.png (28.39 KiB) 111 defa görüntülendi
Kullanıcı avatarı
Hamurcu
 
İleti: 172
Kayıt: 06 Ağu 2012, 00:14
Konum: İstanbul
İşletim Sisteminiz:
LibreOffice Sürümü:


Calc - Hesap Tablosu

Kimler çevrimiçi

Kayıtlı kullanıcılar: Google [Bot]

cron