Microsoft Excel Worksheet Functions

Post thread
K
How to insert Checkbox in excel to simply click and tick it?
  • Keegan
Replies
3
Views
13K
Bob Umlas, Excel MVP
B
G
Password protect cells
  • Guest
Replies
9
Views
468
Dave Peterson
D
N
SumIf AND
  • NoodNutt
Replies
6
Views
648
Fred Smith
F
M
count similar text with using filters
  • mj
Replies
1
Views
403
Eduardo
E
L
Match - not sure how to use this function
  • Luvable Lady
Replies
3
Views
426
Bob Phillips
B
J
Help with SUMPRODUCT & converting date to value
  • jrproudfoot
Replies
1
Views
462
Bob Phillips
B
T
Using wildcard characters in find & replace
  • Tola
Replies
3
Views
1K
Tola
T
S
activate formula when adjacent cell populated
  • Simon
Replies
4
Views
619
Pete_UK
P
J
Compare
  • Joe
Replies
3
Views
348
Joe
J
A
Changing cell colours on a pie chart
  • acprc
Replies
0
Views
579
acprc
A
L
formula to copy from a cell
  • Legolas
Replies
3
Views
421
Roger Govier
R
M
About Data Validation
  • moonhkt
Replies
2
Views
409
Roger Govier
R
G
formula for month that is prior to actual
  • GoBonnieGo
Replies
6
Views
422
[email protected]
A
G
inventory
  • Gary
Replies
2
Views
445
ozgrid.com
O
A
Regression Formula
  • Abby
Replies
1
Views
503
Mike Middleton
M
N
Counting results of a formula
  • Nadine
Replies
9
Views
509
Nadine
N
M
Count blanks by date
  • Molasses26
Replies
2
Views
420
Max
M
R
In Excel need to have a sub worksheet inserted into each row
  • RT
Replies
2
Views
374
Dave Peterson
D
M
lookup?
  • Mezani
Replies
1
Views
460
Bob Phillips
B
I
set flashing alarm by a date for a text box
  • In a quandary always
Replies
1
Views
484
Tom Hutchins
T
M
LOOKUP formula when term may not be present
  • MichaelRobert
Replies
1
Views
439
Niek Otten
N
K
Trending Function?
  • Kevin
Replies
3
Views
416
Jim Thomlinson
J
N
Count, Sum, Index,Match or other formula needed
  • Nadine
Replies
1
Views
865
Tom Hutchins
T
N
Identifying a label.
  • Nicole
Replies
1
Views
393
Gord Dibben
G
H
formatting a spreadsheet help
  • hj
Replies
4
Views
440
Billns
B
M
copied from web page to excel sheet and cant remove from sheet
  • mitch
Replies
2
Views
561
Billns
B
P
Excel Security
  • Patp
Replies
2
Views
375
Gord Dibben
G
C
Formula to calculate Latest Cost (inventory valuation)
  • Curtis
Replies
6
Views
561
Curtis
C
C
keep formula delete contents
  • carspjcars
Replies
3
Views
438
Gord Dibben
G
D
Vlookup?
  • Doug
Replies
2
Views
342
Niek Otten
N
K
Macro Help
  • karim
Replies
1
Views
337
Luke M
L
M
counting occurences specific month appears
  • MM
Replies
4
Views
502
MM
M
D
IF Function Help
  • Dewayne
Replies
3
Views
461
Steve Dunn
S
K
Aggregating data among multiple workbooks
  • Kadco
Replies
1
Views
482
Otto Moehrbach
O
C
Formula for competition pairing
  • Colin
Replies
1
Views
512
Pete_UK
P
C
change text color when the value become lower than a certain value
  • change text color automatically
Replies
1
Views
395
Jacob Skaria
J
J
Formula to sum based on a change in another column
  • J Harris
Replies
2
Views
502
Herbert Seidenberg
H
J
Vlookup and match part of text in a cell
  • Joe Phan
Replies
3
Views
29K
T. Valko
T
D
Help with Conditional Format Formula
  • David K.
Replies
6
Views
509
T. Valko
T
F
filtering subtotals and if functions
  • fam
Replies
2
Views
429
Domenic
D
G
how do I achieve my xl spread sheet in Alphabetical order
  • Generous
Replies
1
Views
446
JLatham
J
H
conditional format help
  • hj
Replies
3
Views
361
JLatham
J
A
Conditional Formatting - stuck on formula
  • Awrex
Replies
3
Views
477
Fred Smith
F
Z
Simple calculation where values change to letters?
  • Zuo
Replies
3
Views
428
Zuo
Z
M
Find latest date from list and corresponding info
  • MCRH
Replies
2
Views
524
Teethless mama
T
J
How can I reference a worksheet in a formula based on a cell value
  • JZinGA
Replies
2
Views
513
David K.
D
S
Excel and consecutive number
  • Shadowkiller361
Replies
2
Views
1K
Shadowkiller361
S
W
IF function
  • winnie123
Replies
3
Views
473
winnie123
W
M
countif/sumproduct + month
  • MM
Replies
1
Views
429
Teethless mama
T
M
counting occurences of month on a specific worksheet
  • MM
Replies
1
Views
429
Fred Smith
F
Back
Top