Microsoft Excel Worksheet Functions

C
Pulling/Collating Data
  • chrisk
Replies
4
Views
265K
chrisk
C
P
Re: Countif with a date range
  • Paul Corrado
Replies
2
Views
50K
mushtaque_asghar
M
S
Validation list with formula?
  • SaM
Replies
3
Views
266K
Ashish Mathur
A
S
Formula referencing a changing range??
  • Stacie2410
Replies
3
Views
297K
T. Valko
T
G
compare -neg and +pos number that cancel each other in a column
  • Guest
Replies
14
Views
434K
Casper
C
A
2 worksheets--3 questions
  • Anne
Replies
3
Views
478K
Bob Phillips
B
K
Changing Source Data using V-lookup
  • Kevin
Replies
3
Views
415K
Kevin_s
K
D
Protecting Sheets with drop down boxes
  • Dolores Gomez
Replies
1
Views
405K
Duke Carey
D
C
Excel 2003 - deleting Duplicates under conditions
  • Cath
Replies
2
Views
41K
Duke Carey
D
T
data links on subsequent worksheets
  • TerriK
Replies
2
Views
73K
Duke Carey
D
N
Help needed with If & Today function
  • Nemo
Replies
4
Views
341K
Glenn
G
C
vlook up w- multiple variables
  • chilitodd
Replies
2
Views
360K
chilitodd
C
S
Auto Calculate Keeps Resetting to Manual
  • Shirley
Replies
2
Views
186K
Bernard Liengme
B
G
invisible color
  • Guest
Replies
4
Views
240K
lllorigirl
L
E
=INDEX(AF1:BD108,MATCH(Z3,AD2:AD361),AF:AR)
  • excelrookie
Replies
2
Views
44K
excelrookie
E
E
Help with function, not sure which one
  • excelrookie
Replies
4
Views
422K
excelrookie
E
D
If argument
  • DonaMil
Replies
1
Views
56K
Eduardo
E
S
General numbers lookup from FY-PP-WK-D resulting in MM-DD-YY
  • Steve
Replies
3
Views
321K
Steve Dunn
S
G
Contract Value Formula
  • Gizmo28
Replies
0
Views
145K
Gizmo28
G
C
Nested IF(OR(AND) Statement with Two AND Conditions
  • chiefs19
Replies
6
Views
96K
chiefs19
C
A
using CountIF function or Array?
  • AJ
Replies
3
Views
308K
Bernard Liengme
B
Z
Sumproduct with sumif over mutiple worksheets
  • Zeddie_Burger
Replies
2
Views
53K
Eduardo
E
E
Vlookup and if formula
  • edwin
Replies
2
Views
279K
Jacob Skaria
J
G
CONVERT ROMAN TO ARABIC NUMERALS
  • Guest
Replies
7
Views
481K
Ron Rosenfeld
R
D
Conditional Formatting based on match to external list
  • Dawn Mann
Replies
1
Views
151K
Steve Dunn
S
D
SumIf
  • Debi
Replies
3
Views
99K
Mike H
M
J
Multiple section for one answer
  • Jafferi
Replies
3
Views
85K
Jafferi
J
C
Vlookup & relative cell reference?
  • Cecilia
Replies
2
Views
318K
Jacob Skaria
J
L
Icon sets - conditional formatting - in Excel 2003
  • Lou
Replies
1
Views
52K
ozgrid.com
O
T
SUMIF Function
  • Traci P.
Replies
2
Views
509K
Ashish Mathur
A
G
Assigning a number value to text
  • Guest
Replies
5
Views
246K
Fred Smith
F
D
Days in Text to Dates SPECIAL
  • DOUG
Replies
1
Views
79K
Ron Rosenfeld
R
S
How do i convert dates to text but keep the date format
  • SallyP
Replies
1
Views
162K
Gord Dibben
G
P
Find and Replace
  • Pierre
Replies
4
Views
40K
Tom Hutchins
T
J
Help Creating Excel Formula
  • jamesvh
Replies
4
Views
473K
jamesvh
J
C
Can I use Sumproduct with the LEFT Function?
  • Chris
Replies
11
Views
1M
T. Valko
T
P
data validation using named range from another file
  • pat67
Replies
3
Views
358K
Gord Dibben
G
A
Counting with 2 criteria
  • Amethyst
Replies
3
Views
20K
Amethyst
A
M
row height issue
  • Mike SoCal
Replies
1
Views
214K
Gord Dibben
G
B
Average using Sumproduct
  • Basenji
Replies
4
Views
489K
Joe User
J
A
Can't change Pivot Table data source
  • AABob
Replies
2
Views
392K
Titan74
T
C
Rounding
  • Cynthia
Replies
4
Views
261K
Cynthia
C
S
Change the weekends
  • Sadad
Replies
1
Views
237K
Mike H
M
I
Conditional IF formula using multi-dimensional arrays
  • iperlovsky
Replies
2
Views
343K
iperlovsky
I
G
How do I set NETWORKDAYS to regard friday and saturday as weekend
  • Guest
Replies
2
Views
178K
Sadad
S
S
Date Diff - excluding working days
  • Scott_goddard
Replies
2
Views
199K
Rick Rothstein
R
D
Median with Criteria
  • Demosthenes
Replies
2
Views
180K
Demosthenes
D
A
Vendor List
  • Andri
Replies
6
Views
528K
Andri
A
E
Adding totals from different columns
  • Eskercat
Replies
1
Views
216K
Ashish Mathur
A
G
stock control template
  • Gary L
Replies
1
Views
89K
Eduardo
E
You must log in or register to post here.
Back
Top