Test eXcell

XenTR · Apr 8, 2025

Select Excel Language:

Select Delimiter:

tek_duseyara_ile_coklu_sonuc_alma.xlsx

Sayfa1
	A	B	C	D	E	F	G	H
1
2		Aylar	2017	2018	2019	2020	2021
3		Ocak	627	575	109	414	790
4		Şubat	808	183	430	555	543
5		Mart	114	762	923	143	182
6		Nisan	586	975	647	920	185
7		Mayıs	927	474	641	767	247
8		Haziran	779	492	550	231	293
9		Temmuz	401	599	561	942	721
10		Ağustos	435	834	596	655	481
11		Eylül	122	440	751	559	562
12		Ekim	261	505	445	747	189
13		Kasım	230	229	310	483	869
14		Aralık	569	947	716	841	180
15
16			2017	2018	2019	2020	2021
17		Temmuz	401	599	561	942	721
18

Cells with Data Validation
Cell	Allow	Criteria
B17	List	=$B$3:$B$14

Test · Apr 8, 2025

Select Excel Language:

Select Delimiter:

exceljet_groupby_function.xlsx

Sheet4
	A	B	C	D	E	F	G	H	I	J	K
1
2		GROUPBY function - multiple calculations
3
4		Name	Department	Meal	Cost			COUNT	SUM	PERCENTOF
5		O. Sanchez	Marketing	Veggie	$11,50		Beef	42	$609,00	45,4%
6		M. Cox	HR	Beef	$14,50		Chicken	37	$490,25	36,6%
7		I. Bailey	Marketing	Chicken	$13,25		Veggie	21	$241,50	18,0%
8		U. Ward	Marketing	Beef	$14,50		Total	100	$1.340,75	100,0%
9		W. Hughes	Engineering	Beef	$14,50
10		R. Hall	Marketing	Beef	$14,50
11		H. Green	Finance	Chicken	$13,25
12		V. Diaz	HR	Veggie	$11,50
13		K. Ward	HR	Beef	$14,50
14		Y. Cooper	Marketing	Chicken	$13,25
15		Y. Simmons	Finance	Chicken	$13,25
16		B. Ward	Engineering	Veggie	$11,50
17		H. Reed	Engineering	Veggie	$11,50
18		B. Cook	Engineering	Beef	$14,50
19		Z. Roberts	Finance	Chicken	$13,25
20		K. Murphy	Engineering	Beef	$14,50
21		M. Campbell	Finance	Chicken	$13,25
22		I. Bailey	Finance	Beef	$14,50
23		C. Cook	Engineering	Chicken	$13,25

Cell Formulas
Range	Formula
G4:J8	G4	=GROUPBY(D4:D104,E4:E104,HSTACK(COUNT,SUM,PERCENTOF),1)
Dynamic array formulas.

Test · Apr 8, 2025

Select Excel Language:

Select Delimiter:

hucredeki_degerleri_karakterlere_ayirma.xlsx

Sayfa1
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U
1
2		Metin		1	2	3	4	5	6	7	8	9	10	11	12	13	14	15	16	17
3		12 elma		1	2		e	l	m	a
4		31 Ocak 2025		3	1		O	c	a	k		2	0	2	5
5		800-654-5487		8	0	0	-	6	5	4	-	5	4	8	7
6		Türk Evi		T	ü	r	k		E	v	i
7		Çatalca, İstanbul		Ç	a	t	a	l	c	a	,		İ	s	t	a	n	b	u	l
8		Silivri İstanbul		S	i	l	i	v	r	i		İ	s	t	a	n	b	u	l
9		Excel Depo		E	x	c	e	l		D	e	p	o
10		Pin: 4591		P	i	n	:		4	5	9	1
11		McLaren Otomativ		M	c	L	a	r	e	n		O	t	o	m	a	t	i	v
12		Kod Kırıcı		K	o	d		K	ı	r	ı	c	ı
13		3,1415926		3	,	1	4	1	5	9	2	6
14

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
D3:T1300	Expression	=VE(D$2<>"";$D3<>"")	text	NO