Microsoft Excel Worksheet Functions

Post thread
S
Matching 2 Text fields
  • Sprowler
Replies
3
Views
378
Sprowler
S
S
Sumproduct query
  • Scrunch
Replies
9
Views
536
ShaneDevenshire
S
S
Auto Filters
  • se7098
Replies
2
Views
324
se7098
S
P
ANALYST TOOL PACK --> #VALUE!
  • Paulo
Replies
1
Views
543
ShaneDevenshire
S
A
Excel 2007: Insert Row into Defined Area & Inherit Above Formulas
  • Andrew Gill
Replies
4
Views
8K
Gord Dibben
G
C
Formula for adding sums
  • CMB
Replies
3
Views
393
Max
M
T
Password to enter the sheet
  • Tia
Replies
6
Views
464
Gord Dibben
G
T
Duplicate Entry
  • Tracy
Replies
2
Views
362
ShaneDevenshire
S
A
Predicting results
  • Alfredo_CPA
Replies
2
Views
400
Alfredo_CPA
A
C
Multiple Variable Formula
  • C.W.
Replies
3
Views
349
ShaneDevenshire
S
S
SUMIFS based on date
  • SeanU
Replies
3
Views
10K
SeanU
S
B
How do I make the status bar bigger?
  • Brian
Replies
1
Views
2K
Gord Dibben
G
L
Autofill cell references with a pattern of every 110 rows
  • Light
Replies
3
Views
604
ShaneDevenshire
S
R
more than 3 conditional formats
  • rory_r
Replies
2
Views
391
Gord Dibben
G
F
Shelly Cashmen Sreies
  • frantic 901
Replies
2
Views
283
ShaneDevenshire
S
G
Arranging single-row records across multiple rows
  • Greg Spencer
Replies
4
Views
704
Sheeloo
S
W
COUNTA with IF in an array
  • WildWill
Replies
4
Views
555
WildWill
W
A
Average function help
  • Andys517
Replies
4
Views
385
T. Valko
T
W
Once formula runs how to store result permenantly
  • workingatit
Replies
1
Views
390
Peo Sjoblom
P
S
Macro Delete cell if value >
  • Sojo
Replies
3
Views
382
Sojo
S
D
function works on some sheets but not others
  • danafeldman
Replies
4
Views
340
danafeldman
D
D
Percentage and rank
  • dcarr
Replies
6
Views
523
dcarr
D
S
Nested Functions Help
  • Swtmelly
Replies
6
Views
362
John C
J
M
Trying to pull up price for matching product?
  • mrajotte
Replies
7
Views
502
John C
J
P
Exporting MS Project Values into Excel
  • Paul Peterson - Velox Consulting, LLC
Replies
2
Views
348
Paul Peterson - Velox Consulting, LLC
P
G
#REF Error in Named Range with INDIRECT, SUMPRODUCT, and OFFSET
  • Greg in CO
Replies
6
Views
3K
Greg in CO
G
G
How to extract text when it's included in the format?
  • gilliam
Replies
3
Views
478
Rick Rothstein
R
T
How to get month number for fiscal year starting in Oct.
  • Tim
Replies
3
Views
364
John C
J
S
How do I unprotect a spreadsheet?
  • Sofiya
Replies
1
Views
561
John C
J
M
VLOOKUP with a Named Range argument
  • modernminstrel
Replies
1
Views
489
John C
J
N
Adding suffix to column entries
  • NCdesigner
Replies
5
Views
577
NCdesigner
N
W
Automating search and replace
  • Wellman
Replies
2
Views
349
Sheeloo
S
M
Countif based on two criteria
  • MJKelly
Replies
4
Views
503
MJKelly
M
F
how to change one valuta ex. doller to euro
  • Frost
Replies
1
Views
723
Sheeloo
S
I
SumIf conditional to date range
  • IlliniDan
Replies
5
Views
1K
IlliniDan
I
N
Simultaneously use VLOOKUP and HLOOKUP in EXCEL 2003
  • Nicky
Replies
3
Views
4K
Nicky
N
S
Problem w/vlookup
  • Sandy
Replies
5
Views
524
John C
J
S
Totaling functions in Excel
  • SueL
Replies
2
Views
424
SueL
S
P
Identifying and totaling up duplicate cells in Excel
  • Paul
Replies
2
Views
453
Paul
P
R
Validation Formula only worked once.
  • Rick Arends
Replies
2
Views
333
Max
M
C
SUMPRODUCT arguments
  • Chris T-M
Replies
3
Views
460
Bob Phillips
B
T
How to extract anitials from an email adresse?
  • Tippo22
Replies
4
Views
694
Tippo22
T
E
lookup database
  • ellebelle
Replies
3
Views
300
Pete_UK
P
N
changing the Duplicate entries
  • Nitin Kapoor
Replies
1
Views
277
Stefi
S
J
tenure
  • Janice Reid
Replies
14
Views
1K
Doehead
D
D
Encryption using excel
  • Doehead
Replies
1
Views
406
Doehead
D
N
Getting the Sum from months
  • noreaster
Replies
6
Views
381
Noreaster
N
M
Search For A Column Width in Conditional Formatting
  • ml
Replies
3
Views
423
Sheeloo
S
L
Consolidate Lists from Multiple Sheets on another Sheet
  • Lemmesee
Replies
9
Views
587
Lemmesee
L
H
INTERMIDIATE VALUE OF A CURVE (PRECISION 1 MICRON)
  • HARSHAWARDHAN. S .SHASTRI
Replies
13
Views
689
MartinW
M
Back
Top