Microsoft Excel Worksheet Functions

Post thread
D
directing cell contents dependent on its value
  • Debi
Replies
2
Views
427
Mike H
M
C
Pulling/Collating Data
  • chrisk
Replies
4
Views
537
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
435
Ashish Mathur
A
S
Formula referencing a changing range??
  • Stacie2410
Replies
3
Views
463
T. Valko
T
G
compare -neg and +pos number that cancel each other in a column
  • Guest
Replies
14
Views
929
Casper
C
A
2 worksheets--3 questions
  • Anne
Replies
3
Views
455
Bob Phillips
B
K
Changing Source Data using V-lookup
  • Kevin
Replies
3
Views
445
Kevin_s
K
D
Protecting Sheets with drop down boxes
  • Dolores Gomez
Replies
1
Views
442
Duke Carey
D
C
Excel 2003 - deleting Duplicates under conditions
  • Cath
Replies
2
Views
390
Duke Carey
D
T
data links on subsequent worksheets
  • TerriK
Replies
2
Views
346
Duke Carey
D
N
Help needed with If & Today function
  • Nemo
Replies
4
Views
436
Glenn
G
C
vlook up w- multiple variables
  • chilitodd
Replies
2
Views
381
chilitodd
C
S
Auto Calculate Keeps Resetting to Manual
  • Shirley
Replies
2
Views
2K
Bernard Liengme
B
G
invisible color
  • Guest
Replies
4
Views
372
lllorigirl
L
E
=INDEX(AF1:BD108,MATCH(Z3,AD2:AD361),AF:AR)
  • excelrookie
Replies
2
Views
258
excelrookie
E
E
Help with function, not sure which one
  • excelrookie
Replies
4
Views
486
excelrookie
E
D
If argument
  • DonaMil
Replies
1
Views
414
Eduardo
E
S
General numbers lookup from FY-PP-WK-D resulting in MM-DD-YY
  • Steve
Replies
3
Views
454
Steve Dunn
S
G
Contract Value Formula
  • Gizmo28
Replies
0
Views
870
Gizmo28
G
C
Nested IF(OR(AND) Statement with Two AND Conditions
  • chiefs19
Replies
6
Views
790
chiefs19
C
A
using CountIF function or Array?
  • AJ
Replies
3
Views
616
Bernard Liengme
B
Z
Sumproduct with sumif over mutiple worksheets
  • Zeddie_Burger
Replies
2
Views
385
Eduardo
E
E
Vlookup and if formula
  • edwin
Replies
2
Views
467
Jacob Skaria
J
G
CONVERT ROMAN TO ARABIC NUMERALS
  • Guest
Replies
7
Views
2K
Ron Rosenfeld
R
D
Conditional Formatting based on match to external list
  • Dawn Mann
Replies
1
Views
559
Steve Dunn
S
D
SumIf
  • Debi
Replies
3
Views
368
Mike H
M
J
Multiple section for one answer
  • Jafferi
Replies
3
Views
325
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
439
Ashish Mathur
A
G
Assigning a number value to text
  • Guest
Replies
5
Views
901
Fred Smith
F
D
Days in Text to Dates SPECIAL
  • DOUG
Replies
1
Views
327
Ron Rosenfeld
R
S
How do i convert dates to text but keep the date format
  • SallyP
Replies
1
Views
467
Gord Dibben
G
P
Find and Replace
  • Pierre
Replies
4
Views
429
Tom Hutchins
T
J
Help Creating Excel Formula
  • jamesvh
Replies
4
Views
634
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
928
Gord Dibben
G
A
Counting with 2 criteria
  • Amethyst
Replies
3
Views
292
Amethyst
A
M
row height issue
  • Mike SoCal
Replies
1
Views
535
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
355
Cynthia
C
S
Change the weekends
  • Sadad
Replies
1
Views
346
Mike H
M
I
Conditional IF formula using multi-dimensional arrays
  • iperlovsky
Replies
2
Views
406
iperlovsky
I
G
How do I set NETWORKDAYS to regard friday and saturday as weekend
  • Guest
Replies
2
Views
961
Sadad
S
S
Date Diff - excluding working days
  • Scott_goddard
Replies
2
Views
528
Rick Rothstein
R
D
Median with Criteria
  • Demosthenes
Replies
2
Views
755
Demosthenes
D
A
Vendor List
  • Andri
Replies
6
Views
600
Andri
A
E
Adding totals from different columns
  • Eskercat
Replies
1
Views
385
Ashish Mathur
A
Back
Top