Microsoft Excel Worksheet Functions

Post thread
R
CountIf Formula
  • Redi
Replies
1
Views
760
Sean Timmons
S
R
Inserting curly brackets within a formula
  • Romileyrunner1
Replies
4
Views
2K
Romileyrunner1
R
N
count the # of times "name" is in E and "x" in F are in the same r
  • Nielly
Replies
2
Views
338
Shane Devenshire
S
D
Function shows repeating decimal?
  • Doug
Replies
3
Views
1K
JP Ronse
J
S
Conditionally Formatting Cells based on Values in a Range (2007)
  • sreid64
Replies
3
Views
590
sreid64
S
H
Averaging
  • Hookette
Replies
6
Views
606
JoeU2004
J
R
vlookup cells thAT are `NOT EQUAL` to a value / text
  • Romileyrunner1
Replies
4
Views
5K
Romileyrunner1
R
N
Subtracting an absolute value
  • NOAAlw
Replies
2
Views
505
NOAAlw
N
M
Sundays
  • Maresa
Replies
5
Views
676
T. Valko
T
R
SUMIF question
  • RedDixieCup
Replies
2
Views
419
Jacob Skaria
J
I
Straight line depreciation
  • Ian
Replies
4
Views
783
Pete_UK
P
W
Conditional formating
  • Walley
Replies
1
Views
418
Herbert Seidenberg
H
E
Create a new sheet dependant on values
  • edwgolz
Replies
1
Views
435
Bernie Deitrick
B
S
vlookup by the lengh
  • Shairal
Replies
2
Views
400
Shairal
S
J
sum cells based upon color of text
  • Jessop
Replies
1
Views
862
Eduardo
E
J
Rounding in the Same Cell
  • Johnnie
Replies
2
Views
379
Johnnie
J
R
avoid Descending Sort putting error cells uppermost in collumn
  • Romileyrunner1
Replies
3
Views
483
Romileyrunner1
R
C
Vlookup - Update Path
  • Clyde Dickson
Replies
3
Views
867
Dave Peterson
D
T
If C2 = East AND D2 < 20,000.00 then multiply D2 by 8%
  • trip_to_tokyo
Replies
4
Views
675
trip_to_tokyo
T
N
Anyone developed a template for employee span of control?
  • NuBee
Replies
2
Views
3K
Suzanne Sarah Mcallen
S
R
Need benefit budget projections template
  • renee
Replies
3
Views
769
Suzanne Sarah Mcallen
S
R
Ignoring #VALUE! errors and MORE!!!!!
  • Romileyrunner1
Replies
3
Views
814
Romileyrunner1
R
A
Row protection
  • ab3d4u
Replies
1
Views
365
Max
M
K
Partial background
  • Kash
Replies
3
Views
406
Pete_UK
P
L
Matching 2 columns
  • Lynda
Replies
3
Views
488
Lynda
L
A
Return the text before a | in a text string
  • ArcticWolf
Replies
5
Views
478
ArcticWolf
A
M
Nght shift allowance
  • Maresa
Replies
6
Views
2K
Maresa
M
W
calculating months between dates
  • wendy
Replies
4
Views
610
wendy
W
N
how to use the number format
  • newbie101
Replies
3
Views
300
Lars-Åke Aspelin
L
M
How to change text/font colour, using formula
  • Maulwy
Replies
2
Views
1K
T. Valko
T
M
Conditional Formatting Error
  • marwildfw
Replies
3
Views
497
marwildfw
M
Q
will a function do this for me?
  • quailwood
Replies
1
Views
403
Max
M
S
SUMIF with "OR" criteria
  • SwtHapa8
Replies
1
Views
408
T. Valko
T
D
Matching dates to cells
  • Donna
Replies
8
Views
625
Max
M
G
sun total of one column using criteria in another column
  • Guest
Replies
5
Views
422
T. Valko
T
B
calculated fields in pivot tables
  • Brad Autry
Replies
1
Views
454
Dave Peterson
D
B
Pivot Table Calculate Field
  • Brad Autry
Replies
1
Views
458
Dave Peterson
D
F
Inserting pictures into unprotected range in a protected worksheet
  • Fernando Reyes
Replies
1
Views
451
Dave Peterson
D
D
How do I turn on Paste Special for linked data?
  • dlps
Replies
1
Views
518
Gord Dibben
G
S
Drop down list - color coding
  • Sue
Replies
1
Views
427
Gord Dibben
G
T
Total Working hours If
  • Tia
Replies
2
Views
664
Tia
T
S
Is there a way...
  • salgud
Replies
5
Views
717
salgud
S
R
Creating a function to auto hide rows
  • Robert G.
Replies
1
Views
556
Gord Dibben
G
J
I'm trying to include a cell reference as part of an ext. link
  • John M
Replies
4
Views
548
Dave Peterson
D
J
Using a variable to point to a location
  • John
Replies
2
Views
320
John
J
H
Formula for elapsed time
  • Hookette
Replies
3
Views
590
Hookette
H
M
Merging sheets
  • mo773w
Replies
1
Views
241
Jacob Skaria
J
T
Updated Formula question
  • TLC
Replies
10
Views
639
Pete_UK
P
S
Row Height-expand if text wraps in a cell
  • Selah West
Replies
1
Views
664
Gord Dibben
G
S
Allocated amount rounded to nearest .25 without exceeding total
  • sheri
Replies
6
Views
921
Pete_UK
P
Back
Top