Microsoft Excel Worksheet Functions

Post thread
R
CountIf Formula
  • Redi
Replies
1
Views
735
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
337
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
563
sreid64
S
H
Averaging
  • Hookette
Replies
6
Views
544
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
484
NOAAlw
N
M
Sundays
  • Maresa
Replies
5
Views
655
T. Valko
T
R
SUMIF question
  • RedDixieCup
Replies
2
Views
392
Jacob Skaria
J
I
Straight line depreciation
  • Ian
Replies
4
Views
731
Pete_UK
P
W
Conditional formating
  • Walley
Replies
1
Views
394
Herbert Seidenberg
H
E
Create a new sheet dependant on values
  • edwgolz
Replies
1
Views
417
Bernie Deitrick
B
S
vlookup by the lengh
  • Shairal
Replies
2
Views
385
Shairal
S
J
sum cells based upon color of text
  • Jessop
Replies
1
Views
860
Eduardo
E
J
Rounding in the Same Cell
  • Johnnie
Replies
2
Views
363
Johnnie
J
R
avoid Descending Sort putting error cells uppermost in collumn
  • Romileyrunner1
Replies
3
Views
471
Romileyrunner1
R
C
Vlookup - Update Path
  • Clyde Dickson
Replies
3
Views
863
Dave Peterson
D
T
If C2 = East AND D2 < 20,000.00 then multiply D2 by 8%
  • trip_to_tokyo
Replies
4
Views
653
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
768
Suzanne Sarah Mcallen
S
R
Ignoring #VALUE! errors and MORE!!!!!
  • Romileyrunner1
Replies
3
Views
783
Romileyrunner1
R
A
Row protection
  • ab3d4u
Replies
1
Views
356
Max
M
K
Partial background
  • Kash
Replies
3
Views
406
Pete_UK
P
L
Matching 2 columns
  • Lynda
Replies
3
Views
468
Lynda
L
A
Return the text before a | in a text string
  • ArcticWolf
Replies
5
Views
432
ArcticWolf
A
M
Nght shift allowance
  • Maresa
Replies
6
Views
2K
Maresa
M
W
calculating months between dates
  • wendy
Replies
4
Views
593
wendy
W
N
how to use the number format
  • newbie101
Replies
3
Views
298
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
480
marwildfw
M
Q
will a function do this for me?
  • quailwood
Replies
1
Views
387
Max
M
S
SUMIF with "OR" criteria
  • SwtHapa8
Replies
1
Views
400
T. Valko
T
D
Matching dates to cells
  • Donna
Replies
8
Views
566
Max
M
G
sun total of one column using criteria in another column
  • Guest
Replies
5
Views
419
T. Valko
T
B
calculated fields in pivot tables
  • Brad Autry
Replies
1
Views
432
Dave Peterson
D
B
Pivot Table Calculate Field
  • Brad Autry
Replies
1
Views
440
Dave Peterson
D
F
Inserting pictures into unprotected range in a protected worksheet
  • Fernando Reyes
Replies
1
Views
438
Dave Peterson
D
D
How do I turn on Paste Special for linked data?
  • dlps
Replies
1
Views
497
Gord Dibben
G
S
Drop down list - color coding
  • Sue
Replies
1
Views
416
Gord Dibben
G
T
Total Working hours If
  • Tia
Replies
2
Views
624
Tia
T
S
Is there a way...
  • salgud
Replies
5
Views
636
salgud
S
R
Creating a function to auto hide rows
  • Robert G.
Replies
1
Views
532
Gord Dibben
G
J
I'm trying to include a cell reference as part of an ext. link
  • John M
Replies
4
Views
535
Dave Peterson
D
J
Using a variable to point to a location
  • John
Replies
2
Views
309
John
J
H
Formula for elapsed time
  • Hookette
Replies
3
Views
558
Hookette
H
M
Merging sheets
  • mo773w
Replies
1
Views
241
Jacob Skaria
J
T
Updated Formula question
  • TLC
Replies
10
Views
611
Pete_UK
P
S
Row Height-expand if text wraps in a cell
  • Selah West
Replies
1
Views
658
Gord Dibben
G
S
Allocated amount rounded to nearest .25 without exceeding total
  • sheri
Replies
6
Views
892
Pete_UK
P
Back
Top