r/excel

General Information

As of February 8, 2024

Subreddit Name

r/excel

Title

Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

Language

Public Description

A vibrant community of Excel enthusiasts. Get expert tips, ask questions, and share your love for all things Excel. Elevate your spreadsheet skills with us!

Description

all
hide solved
new
Solved
Unsolved
[Discussion](/r/excel/search?q=flair:%27disc...

Subscribers

665,869

Created

March 11, 2009

Type

public

Whitelist Status

all_ads

Flags

Restricted Submissions

Community Reviewed

Total Submissions

343,687

Total Comments

1,964,221

Earliest Submission

July 12, 2009

Earliest Comment

September 17, 2010

Rank↕	Word↕	Occurrences in Subreddit ↕	Total Occurrences ↕	Rate in Subreddit (per 1M words) ↕	Rate in Reddit (per 1M words) ↕	Ratio (Sub Rate / Reddit Rate) ↕
#1	sharingquestions sharingquestions	86,265	86,390	3683.1	0.7	5112.75
#2	xlookup	14,657	19,485	625.8	0.2	3851.48
#3	vlookup	9,669	18,532	412.8	0.2	2671.42
#4	1d976f9b7441694162c8 1d976f9b7441694162c8	10,457	21,778	446.5	0.2	2458.51
#5	gistdotgithubdotcom gistdotgithubdotcom	10,457	21,778	446.5	0.2	2458.51
#6	two9a	20,914	43,556	892.9	0.4	2458.51
#7	hachyderm	10,457	22,002	446.5	0.2	2433.48
#8	decronym	41,214	87,165	1759.6	0.7	2420.95
#9	initialisms	10,463	38,307	446.7	0.3	1398.50
#10	excel	324,449	1,235,316	13852.3	10.3	1344.78
#11	stub	50,583	208,757	2159.6	1.7	1240.64
#12	vba	15,041	74,499	642.2	0.6	1033.74
#13	worksheet	6,628	46,124	283.0	0.4	735.76
#14	xlsx	2,285	18,060	97.6	0.2	647.82
#15	columns	32,935	283,943	1406.2	2.4	593.89
#16	workbook	10,912	98,010	465.9	0.8	570.06
#17	column	71,374	738,196	3047.3	6.2	495.05
#18	transpose	2,654	28,626	113.3	0.2	474.70
#19	4321	1,359	16,930	58.0	0.1	411.00
#20	installations	10,475	134,397	447.2	1.1	399.07
#21	formulas	15,774	230,413	673.5	1.9	350.52
#22	sortby	1,206	18,130	51.5	0.2	340.59
#23	lambda	10,659	167,236	455.1	1.4	326.34
#24	subtotal	987	15,620	42.1	0.1	323.53
#25	contractions	10,459	175,471	446.5	1.5	305.19
#26	abbreviations	10,536	183,976	449.8	1.5	293.22
#27	navigated	4,004	71,129	170.9	0.6	288.22
#28	rows	27,555	556,099	1176.5	4.6	253.71
#29	lookups	860	17,779	36.7	0.1	247.67
#30	a2	16,862	385,619	719.9	3.2	223.89
#31	b10	839	19,849	35.8	0.2	216.42
#32	365	20,976	505,857	895.6	4.2	212.31
#33	conditional	12,015	290,296	513.0	2.4	211.92
#34	assigns	1,977	51,108	84.4	0.4	198.06
#35	acronyms	21,039	550,911	898.3	4.6	195.54
#36	array	22,843	606,538	975.3	5.1	192.83
#37	8700	679	18,045	29.0	0.2	192.66
#38	helper	13,391	361,107	571.7	3.0	189.87
#39	slicers	793	21,430	33.9	0.2	189.47
#40	lemmy	10,459	284,602	446.5	2.4	188.16
#41	a1	21,258	580,836	907.6	4.8	187.39
#42	dropdown	2,603	71,138	111.1	0.6	187.35
#43	summarize	10,264	281,586	438.2	2.3	186.63
#44	i2	863	23,690	36.8	0.2	186.52
#45	worksheets	2,346	66,059	100.2	0.6	181.84
#46	arrays	2,784	79,535	118.9	0.7	179.22
#47	workbooks	2,504	72,159	106.9	0.6	177.68
#48	yyyy	1,349	40,616	57.6	0.3	170.06
#49	leftmost	669	20,983	28.6	0.2	163.25
#50	b2	11,471	364,143	489.8	3.0	161.29

Rank↕

Word↕

Occurrences

in Subreddit

↕

Total

Occurrences

↕

Rate in

Subreddit

(per 1M words)

↕

Rate in

(per 1M words)

↕

Ratio

(Sub Rate / Reddit Rate)

↕

sharingquestions

86,265

86,390

3683.1

0.7

5112.75

xlookup

14,657

19,485

625.8

0.2

3851.48

vlookup

9,669

18,532

412.8

0.2

2671.42

1d976f9b7441694162c8

10,457

21,778

446.5

0.2

2458.51

gistdotgithubdotcom

10,457

21,778

446.5

0.2

2458.51

two9a

20,914

43,556

892.9

0.4

2458.51

hachyderm

10,457

22,002

446.5

0.2

2433.48

decronym

41,214

87,165

1759.6

0.7

2420.95

initialisms

10,463

38,307

446.7

0.3

1398.50

#10

excel

324,449

1,235,316

13852.3

10.3

1344.78

#11

stub

50,583

208,757

2159.6

1.7

1240.64

#12

vba

15,041

74,499

642.2

0.6

1033.74

#13

worksheet

6,628

46,124

283.0

0.4

735.76

#14

xlsx

2,285

18,060

97.6

0.2

647.82

#15

columns

32,935

283,943

1406.2

2.4

593.89

#16

workbook

10,912

98,010

465.9

0.8

570.06

#17

column

71,374

738,196

3047.3

6.2

495.05

#18

transpose

2,654

28,626

113.3

0.2

474.70

#19

4321

1,359

16,930

58.0

0.1

411.00

#20

installations

10,475

134,397

447.2

1.1

399.07

#21

formulas

15,774

230,413

673.5

1.9

350.52

#22

sortby

1,206

18,130

51.5

0.2

340.59

#23

lambda

10,659

167,236

455.1

1.4

326.34

#24

subtotal

987

15,620

42.1

0.1

323.53

#25

contractions

10,459

175,471

446.5

1.5

305.19

#26

abbreviations

10,536

183,976

449.8

1.5

293.22

#27

navigated

4,004

71,129

170.9

0.6

288.22

#28

rows

27,555

556,099

1176.5

4.6

253.71

#29

lookups

860

17,779

36.7

0.1

247.67

#30

16,862

385,619

719.9

3.2

223.89

#31

b10

839

19,849

35.8

0.2

216.42

#32

365

20,976

505,857

895.6

4.2

212.31

#33

conditional

12,015

290,296

513.0

2.4

211.92

#34

assigns

1,977

51,108

84.4

0.4

198.06

#35

acronyms

21,039

550,911

898.3

4.6

195.54

#36

array

22,843

606,538

975.3

5.1

192.83

#37

8700

679

18,045

29.0

0.2

192.66

#38

helper

13,391

361,107

571.7

3.0

189.87

#39

slicers

793

21,430

33.9

0.2

189.47

#40

lemmy

10,459

284,602

446.5

2.4

188.16

#41

21,258

580,836

907.6

4.8

187.39

#42

dropdown

2,603

71,138

111.1

0.6

187.35

#43

summarize

10,264

281,586

438.2

2.3

186.63

#44

863

23,690

36.8

0.2

186.52

#45

worksheets

2,346

66,059

100.2

0.6

181.84

#46

arrays

2,784

79,535

118.9

0.7

179.22

#47

workbooks

2,504

72,159

106.9

0.6

177.68

#48

yyyy

1,349

40,616

57.6

0.3

170.06

#49

leftmost

669

20,983

28.6

0.2

163.25

#50

11,471

364,143

489.8

3.0

161.29

General Information

As of February 8, 2024

Metrics

Activity Over Time

Submission Flags

Comment Flags

Submission Score Distribution

Comment Score Distribution

Title Length

Submission Text Length

Comments per Submission

Most Distinctive Words