Microsoft Excel Worksheet Functions

Post thread
D
directing cell contents dependent on its value
  • Debi
Replies
2
Views
444
Mike H
M
C
Pulling/Collating Data
  • chrisk
Replies
4
Views
559
chrisk
C
P
Re: Countif with a date range
  • Paul Corrado
Replies
2
Views
20K
mushtaque_asghar
M
S
Validation list with formula?
  • SaM
Replies
3
Views
463
Ashish Mathur
A
S
Formula referencing a changing range??
  • Stacie2410
Replies
3
Views
479
T. Valko
T
G
compare -neg and +pos number that cancel each other in a column
  • Guest
Replies
14
Views
931
Casper
C
A
2 worksheets--3 questions
  • Anne
Replies
3
Views
474
Bob Phillips
B
K
Changing Source Data using V-lookup
  • Kevin
Replies
3
Views
459
Kevin_s
K
D
Protecting Sheets with drop down boxes
  • Dolores Gomez
Replies
1
Views
469
Duke Carey
D
C
Excel 2003 - deleting Duplicates under conditions
  • Cath
Replies
2
Views
405
Duke Carey
D
T
data links on subsequent worksheets
  • TerriK
Replies
2
Views
362
Duke Carey
D
N
Help needed with If & Today function
  • Nemo
Replies
4
Views
454
Glenn
G
C
vlook up w- multiple variables
  • chilitodd
Replies
2
Views
394
chilitodd
C
S
Auto Calculate Keeps Resetting to Manual
  • Shirley
Replies
2
Views
2K
Bernard Liengme
B
G
invisible color
  • Guest
Replies
4
Views
396
lllorigirl
L
E
=INDEX(AF1:BD108,MATCH(Z3,AD2:AD361),AF:AR)
  • excelrookie
Replies
2
Views
262
excelrookie
E
E
Help with function, not sure which one
  • excelrookie
Replies
4
Views
502
excelrookie
E
D
If argument
  • DonaMil
Replies
1
Views
416
Eduardo
E
S
General numbers lookup from FY-PP-WK-D resulting in MM-DD-YY
  • Steve
Replies
3
Views
495
Steve Dunn
S
G
Contract Value Formula
  • Gizmo28
Replies
0
Views
879
Gizmo28
G
C
Nested IF(OR(AND) Statement with Two AND Conditions
  • chiefs19
Replies
6
Views
820
chiefs19
C
A
using CountIF function or Array?
  • AJ
Replies
3
Views
637
Bernard Liengme
B
Z
Sumproduct with sumif over mutiple worksheets
  • Zeddie_Burger
Replies
2
Views
388
Eduardo
E
E
Vlookup and if formula
  • edwin
Replies
2
Views
493
Jacob Skaria
J
G
CONVERT ROMAN TO ARABIC NUMERALS
  • Guest
Replies
7
Views
3K
Ron Rosenfeld
R
D
Conditional Formatting based on match to external list
  • Dawn Mann
Replies
1
Views
572
Steve Dunn
S
D
SumIf
  • Debi
Replies
3
Views
379
Mike H
M
J
Multiple section for one answer
  • Jafferi
Replies
3
Views
329
Jafferi
J
C
Vlookup & relative cell reference?
  • Cecilia
Replies
2
Views
2K
Jacob Skaria
J
L
Icon sets - conditional formatting - in Excel 2003
  • Lou
Replies
1
Views
1K
ozgrid.com
O
T
SUMIF Function
  • Traci P.
Replies
2
Views
487
Ashish Mathur
A
G
Assigning a number value to text
  • Guest
Replies
5
Views
915
Fred Smith
F
D
Days in Text to Dates SPECIAL
  • DOUG
Replies
1
Views
335
Ron Rosenfeld
R
S
How do i convert dates to text but keep the date format
  • SallyP
Replies
1
Views
477
Gord Dibben
G
P
Find and Replace
  • Pierre
Replies
4
Views
432
Tom Hutchins
T
J
Help Creating Excel Formula
  • jamesvh
Replies
4
Views
684
jamesvh
J
C
Can I use Sumproduct with the LEFT Function?
  • Chris
Replies
11
Views
9K
T. Valko
T
P
data validation using named range from another file
  • pat67
Replies
3
Views
947
Gord Dibben
G
A
Counting with 2 criteria
  • Amethyst
Replies
3
Views
293
Amethyst
A
M
row height issue
  • Mike SoCal
Replies
1
Views
548
Gord Dibben
G
B
Average using Sumproduct
  • Basenji
Replies
4
Views
7K
Joe User
J
A
Can't change Pivot Table data source
  • AABob
Replies
2
Views
10K
Titan74
T
C
Rounding
  • Cynthia
Replies
4
Views
387
Cynthia
C
S
Change the weekends
  • Sadad
Replies
1
Views
358
Mike H
M
I
Conditional IF formula using multi-dimensional arrays
  • iperlovsky
Replies
2
Views
423
iperlovsky
I
G
How do I set NETWORKDAYS to regard friday and saturday as weekend
  • Guest
Replies
2
Views
974
Sadad
S
S
Date Diff - excluding working days
  • Scott_goddard
Replies
2
Views
548
Rick Rothstein
R
D
Median with Criteria
  • Demosthenes
Replies
2
Views
800
Demosthenes
D
A
Vendor List
  • Andri
Replies
6
Views
630
Andri
A
E
Adding totals from different columns
  • Eskercat
Replies
1
Views
400
Ashish Mathur
A
Back
Top