Microsoft Excel Worksheet Functions

Post thread
P
Dynamic 5-week date range & SUMPRODUCT formulas
  • pxp
Replies
0
Views
739
pxp
P
S
Count
  • Skip
Replies
3
Views
767
David8
D
C
Merge Cells
  • CarlainCerebroMode
Replies
4
Views
907
feng Xiansheng
F
E
How to reverse this formula?
  • excellover
Replies
0
Views
1K
excellover
E
L
converting COUNTIFS formula from Excel 2007 to 2003
  • LG
Replies
6
Views
3K
Jimmian
J
E
Protection
  • Esradekan
Replies
2
Views
533
Esradekan
E
A
Calculating age of death
  • Annie
2
Replies
23
Views
2K
Konczér, Tamás
K
N
Need array formula to ignore hidden values
  • NickH
Replies
1
Views
827
NickH
N
G
HELP!I need a specification template purchasing Interior Design it
  • Guest
Replies
2
Views
2K
jcarls
J
H
How do I calculate age using a 12 digit social security number in MS Excel?
  • hazuha
Replies
0
Views
2K
hazuha
H
P
Trying to add column headings to array formula
  • Pierre
Replies
1
Views
754
Pierre
P
C
return next highest number in range
  • Code Numpty
Replies
8
Views
1K
Charabeuh
C
C
How to show best and worst results over a range
  • Colin Hayes
Replies
5
Views
842
Colin Hayes
C
J
Automate a Solver solution
  • Janet
Replies
10
Views
4K
Pete
P
C
Rounding Time to Nearest 5 Minutes
  • carl
Replies
1
Views
964
joeu2004
J
P
if and vlookup formula
  • Pete
Replies
9
Views
2K
Pete
P
D
Date range lookup....tough one!
  • deeds
Replies
19
Views
958
PXP
P
N
number to character and vice-versa
  • noname
Replies
8
Views
784
noname
N
L
How do I exclude text???
  • lsf
Replies
2
Views
504
Rob Golden
R
G
Test cell interior color by worksheet function?
  • Guest
Replies
8
Views
2K
Nick Ryan
N
C
Conditional formatting to highlight the closest value
  • craig oxo
Replies
1
Views
4K
joeu2004
J
A
Look up or Match Function? Excuse my ignornace. This could be simple.Variable Upgrades on Furniture
  • Astanza
Replies
1
Views
619
Pete_UK
P
T
[ask] Quartile and Frequency
  • tnz15
Replies
0
Views
889
tnz15
T
M
Need help with sorting and moving to worksheets
  • M
Replies
1
Views
539
Donald Guillett
D
R
NETWORKDAYS
  • rhhince
Replies
2
Views
882
rhhince
R
C
How to select all the cells with only ' in them
  • Colin Hayes
Replies
2
Views
587
James Ravenswood
J
D
SUBTOTAL and COUNTIF (or SUMIF) combination
  • DKS
Replies
2
Views
12K
Thomas Keddy
T
J
Create unique list of names from list of duplicates and that arefound within another range
  • Jake
Replies
1
Views
1K
Donald Guillett
D
D
Conditional Formatting
  • DaveMoore
Replies
1
Views
558
joeu2004
J
C
I need my SMALL formula to ignore zero's
  • Cloutty
Replies
7
Views
5K
Cloutty
C
M
Format numbers as "Number"
  • Martyn Tindall
Replies
6
Views
716
Martyn Tindall
M
T
Price Comparison formula
  • TJC
Replies
7
Views
5K
Reddick
R
E
Creating a UDF to convert ADDRESS function output as a reference
  • exceluser
Replies
3
Views
663
joeu2004
J
E
Dynamic Named Range formula without using OFFSET function
  • exceluser
Replies
5
Views
1K
exceluser
E
R
Summary of Unique item values
  • Robert Hatcher
Replies
2
Views
611
Robert Hatcher
R
T
Adding Hours & Minutes
  • Tina
Replies
3
Views
714
Rick Rothstein
R
I
Vlookup into 2 columns
  • Irina
Replies
2
Views
951
Irina
I
K
Need some help with a COUNTIF function
  • KimonH
Replies
4
Views
879
Charabeuh
C
E
Weighted Regression
  • Engineer001
Replies
6
Views
2K
ulric thered
U
C
Counting assistance
  • cil
Replies
3
Views
662
cil
C
E
Auto sort help.
  • Ephraim
Replies
2
Views
571
Don Guillett
D
K
HELP
  • KK
Replies
2
Views
541
KK
K
P
Formula for adding a cell in multiple workbooks
  • PaPr
Replies
3
Views
1K
Everett P
E
B
Append shortcut link to open a particular workbook TAB
  • bob
Replies
1
Views
689
Jim Cone
J
D
Force input & colour cells
  • Duncs
Replies
4
Views
795
Duncs
D
D
Identify part number in list and tag it with characters from another list
  • DanDungan
Replies
4
Views
872
DanDungan
D
S
How do I keep the "tab" key from jumping over adjacent cell
  • Srobinson2
Replies
6
Views
891
Diana Grijalva
D
M
Top 4 scores in excel
  • maff
Replies
4
Views
1K
Jim Cone
J
G
How do I display the pathname/address of a hyperlink?
  • Guest
Replies
7
Views
725
ngoc lam
N
D
sorting problem?
  • danial mansoor
Replies
1
Views
532
Pete_UK
P
Back
Top