Microsoft Excel Worksheet Functions

S
Sumproduct query
  • Scrunch
Replies
9
Views
847K
ShaneDevenshire
S
S
Auto Filters
  • se7098
Replies
2
Views
38K
se7098
S
P
ANALYST TOOL PACK --> #VALUE!
  • Paulo
Replies
1
Views
270K
ShaneDevenshire
S
A
Excel 2007: Insert Row into Defined Area & Inherit Above Formulas
  • Andrew Gill
Replies
4
Views
473K
Gord Dibben
G
C
Formula for adding sums
  • CMB
Replies
3
Views
316K
Max
M
T
Password to enter the sheet
  • Tia
Replies
6
Views
443K
Gord Dibben
G
T
Duplicate Entry
  • Tracy
Replies
2
Views
98K
ShaneDevenshire
S
A
Predicting results
  • Alfredo_CPA
Replies
2
Views
109K
Alfredo_CPA
A
C
Multiple Variable Formula
  • C.W.
Replies
3
Views
80K
ShaneDevenshire
S
S
SUMIFS based on date
  • SeanU
Replies
3
Views
395K
SeanU
S
B
How do I make the status bar bigger?
  • Brian
Replies
1
Views
280K
Gord Dibben
G
L
Autofill cell references with a pattern of every 110 rows
  • Light
Replies
3
Views
388K
ShaneDevenshire
S
R
more than 3 conditional formats
  • rory_r
Replies
2
Views
104K
Gord Dibben
G
F
Shelly Cashmen Sreies
  • frantic 901
Replies
2
Views
155K
ShaneDevenshire
S
G
Arranging single-row records across multiple rows
  • Greg Spencer
Replies
4
Views
296K
Sheeloo
S
W
COUNTA with IF in an array
  • WildWill
Replies
4
Views
335K
WildWill
W
A
Average function help
  • Andys517
Replies
4
Views
176K
T. Valko
T
W
Once formula runs how to store result permenantly
  • workingatit
Replies
1
Views
90K
Peo Sjoblom
P
S
Macro Delete cell if value >
  • Sojo
Replies
3
Views
30K
Sojo
S
D
function works on some sheets but not others
  • danafeldman
Replies
4
Views
235K
danafeldman
D
D
Percentage and rank
  • dcarr
Replies
6
Views
614K
dcarr
D
S
Nested Functions Help
  • Swtmelly
Replies
6
Views
58K
John C
J
M
Trying to pull up price for matching product?
  • mrajotte
Replies
7
Views
70K
John C
J
P
Exporting MS Project Values into Excel
  • Paul Peterson - Velox Consulting, LLC
Replies
2
Views
112K
Paul Peterson - Velox Consulting, LLC
P
G
#REF Error in Named Range with INDIRECT, SUMPRODUCT, and OFFSET
  • Greg in CO
Replies
6
Views
1M
Greg in CO
G
G
How to extract text when it's included in the format?
  • gilliam
Replies
3
Views
361K
Rick Rothstein
R
T
How to get month number for fiscal year starting in Oct.
  • Tim
Replies
3
Views
206K
John C
J
S
How do I unprotect a spreadsheet?
  • Sofiya
Replies
1
Views
143K
John C
J
M
VLOOKUP with a Named Range argument
  • modernminstrel
Replies
1
Views
419K
John C
J
N
Adding suffix to column entries
  • NCdesigner
Replies
5
Views
174K
NCdesigner
N
W
Automating search and replace
  • Wellman
Replies
2
Views
163K
Sheeloo
S
M
Countif based on two criteria
  • MJKelly
Replies
4
Views
52K
MJKelly
M
F
how to change one valuta ex. doller to euro
  • Frost
Replies
1
Views
63K
Sheeloo
S
I
SumIf conditional to date range
  • IlliniDan
Replies
5
Views
522K
IlliniDan
I
N
Simultaneously use VLOOKUP and HLOOKUP in EXCEL 2003
  • Nicky
Replies
3
Views
309K
Nicky
N
S
Problem w/vlookup
  • Sandy
Replies
5
Views
380K
John C
J
S
Totaling functions in Excel
  • SueL
Replies
2
Views
180K
SueL
S
P
Identifying and totaling up duplicate cells in Excel
  • Paul
Replies
2
Views
95K
Paul
P
R
Validation Formula only worked once.
  • Rick Arends
Replies
2
Views
106K
Max
M
C
SUMPRODUCT arguments
  • Chris T-M
Replies
3
Views
130K
Bob Phillips
B
T
How to extract anitials from an email adresse?
  • Tippo22
Replies
4
Views
135K
Tippo22
T
E
lookup database
  • ellebelle
Replies
3
Views
140K
Pete_UK
P
N
changing the Duplicate entries
  • Nitin Kapoor
Replies
1
Views
104K
Stefi
S
J
tenure
  • Janice Reid
Replies
14
Views
91K
Doehead
D
D
Encryption using excel
  • Doehead
Replies
1
Views
114K
Doehead
D
N
Getting the Sum from months
  • noreaster
Replies
6
Views
766K
Noreaster
N
M
Search For A Column Width in Conditional Formatting
  • ml
Replies
3
Views
479K
Sheeloo
S
L
Consolidate Lists from Multiple Sheets on another Sheet
  • Lemmesee
Replies
9
Views
601K
Lemmesee
L
H
INTERMIDIATE VALUE OF A CURVE (PRECISION 1 MICRON)
  • HARSHAWARDHAN. S .SHASTRI
Replies
13
Views
569K
MartinW
M
S
Changing the format of a phone number
  • scr
Replies
2
Views
317K
scr
S
You must log in or register to post here.
Back
Top