Microsoft Excel Worksheet Functions

G
Password protect cells
  • Guest
Replies
9
Views
47K
Dave Peterson
D
N
SumIf AND
  • NoodNutt
Replies
6
Views
615K
Fred Smith
F
M
count similar text with using filters
  • mj
Replies
1
Views
73K
Eduardo
E
L
Match - not sure how to use this function
  • Luvable Lady
Replies
3
Views
239K
Bob Phillips
B
J
Help with SUMPRODUCT & converting date to value
  • jrproudfoot
Replies
1
Views
217K
Bob Phillips
B
T
Using wildcard characters in find & replace
  • Tola
Replies
3
Views
425K
Tola
T
S
activate formula when adjacent cell populated
  • Simon
Replies
4
Views
364K
Pete_UK
P
J
Compare
  • Joe
Replies
3
Views
176K
Joe
J
A
Changing cell colours on a pie chart
  • acprc
Replies
0
Views
213K
acprc
A
L
formula to copy from a cell
  • Legolas
Replies
3
Views
418K
Roger Govier
R
M
About Data Validation
  • moonhkt
Replies
2
Views
226K
Roger Govier
R
G
formula for month that is prior to actual
  • GoBonnieGo
Replies
6
Views
132K
[email protected]
A
G
inventory
  • Gary
Replies
2
Views
41K
ozgrid.com
O
A
Regression Formula
  • Abby
Replies
1
Views
43K
Mike Middleton
M
N
Counting results of a formula
  • Nadine
Replies
9
Views
328K
Nadine
N
M
Count blanks by date
  • Molasses26
Replies
2
Views
270K
Max
M
R
In Excel need to have a sub worksheet inserted into each row
  • RT
Replies
2
Views
256K
Dave Peterson
D
M
lookup?
  • Mezani
Replies
1
Views
224K
Bob Phillips
B
I
set flashing alarm by a date for a text box
  • In a quandary always
Replies
1
Views
83K
Tom Hutchins
T
M
LOOKUP formula when term may not be present
  • MichaelRobert
Replies
1
Views
84K
Niek Otten
N
K
Trending Function?
  • Kevin
Replies
3
Views
206K
Jim Thomlinson
J
N
Count, Sum, Index,Match or other formula needed
  • Nadine
Replies
1
Views
219K
Tom Hutchins
T
N
Identifying a label.
  • Nicole
Replies
1
Views
115K
Gord Dibben
G
H
formatting a spreadsheet help
  • hj
Replies
4
Views
342K
Billns
B
M
copied from web page to excel sheet and cant remove from sheet
  • mitch
Replies
2
Views
179K
Billns
B
P
Excel Security
  • Patp
Replies
2
Views
94K
Gord Dibben
G
C
Formula to calculate Latest Cost (inventory valuation)
  • Curtis
Replies
6
Views
521K
Curtis
C
C
keep formula delete contents
  • carspjcars
Replies
3
Views
55K
Gord Dibben
G
D
Vlookup?
  • Doug
Replies
2
Views
147K
Niek Otten
N
K
Macro Help
  • karim
Replies
1
Views
170K
Luke M
L
M
counting occurences specific month appears
  • MM
Replies
4
Views
182K
MM
M
D
IF Function Help
  • Dewayne
Replies
3
Views
204K
Steve Dunn
S
K
Aggregating data among multiple workbooks
  • Kadco
Replies
1
Views
255K
Otto Moehrbach
O
C
Formula for competition pairing
  • Colin
Replies
1
Views
140K
Pete_UK
P
C
change text color when the value become lower than a certain value
  • change text color automatically
Replies
1
Views
206K
Jacob Skaria
J
J
Formula to sum based on a change in another column
  • J Harris
Replies
2
Views
413K
Herbert Seidenberg
H
J
Vlookup and match part of text in a cell
  • Joe Phan
Replies
3
Views
286K
T. Valko
T
D
Help with Conditional Format Formula
  • David K.
Replies
6
Views
272K
T. Valko
T
F
filtering subtotals and if functions
  • fam
Replies
2
Views
245K
Domenic
D
G
how do I achieve my xl spread sheet in Alphabetical order
  • Generous
Replies
1
Views
175K
JLatham
J
H
conditional format help
  • hj
Replies
3
Views
425K
JLatham
J
A
Conditional Formatting - stuck on formula
  • Awrex
Replies
3
Views
252K
Fred Smith
F
Z
Simple calculation where values change to letters?
  • Zuo
Replies
3
Views
327K
Zuo
Z
M
Find latest date from list and corresponding info
  • MCRH
Replies
2
Views
312K
Teethless mama
T
J
How can I reference a worksheet in a formula based on a cell value
  • JZinGA
Replies
2
Views
413K
David K.
D
S
Excel and consecutive number
  • Shadowkiller361
Replies
2
Views
145K
Shadowkiller361
S
W
IF function
  • winnie123
Replies
3
Views
475K
winnie123
W
M
countif/sumproduct + month
  • MM
Replies
1
Views
153K
Teethless mama
T
M
counting occurences of month on a specific worksheet
  • MM
Replies
1
Views
237K
Fred Smith
F
D
complex lookup
  • Doug
Replies
8
Views
584K
Bernd P
B
You must log in or register to post here.
Back
Top