Microsoft Excel Worksheet Functions

J
Using the results of the ADDRESS formula in another formula
  • JP
Replies
4
Views
204K
T. Valko
T
S
Nested If Statements
  • Sarah_Lecturer
Replies
5
Views
210K
Ashish Mathur
A
D
Modify search function
  • Dinesh
Replies
3
Views
277K
Ashish Mathur
A
V
Excel Formula to evaluate multiple criteria (countif + and)
  • VPSales
Replies
2
Views
137K
Ashish Mathur
A
L
Count text within numbers
  • LiAD
Replies
5
Views
190K
Ashish Mathur
A
C
sumproduct formula work around
  • Chris
Replies
11
Views
121K
T. Valko
T
Q
excel 2003
  • Quandary
Replies
1
Views
44K
Gord Dibben
G
M
Eliminating #DIV/O!
  • MCheru
Replies
8
Views
484K
MCheru
M
D
ogh, why is this not working
  • dlotz
Replies
1
Views
151K
Sheeloo
S
D
sot data
  • daniel
Replies
2
Views
68K
Gord Dibben
G
J
SUMIF Function ?
  • Joey
Replies
1
Views
295K
Gary''s Student
G
R
Force required entry in cell before leaving that cell
  • Retired Bill
Replies
8
Views
278K
Gord Dibben
G
E
Count frequence in one column
  • Excel Sum function with IF
Replies
1
Views
171K
Elkar
E
J
Email message on cell change event
  • jknapp1005
Replies
1
Views
96K
Ron de Bruin
R
Z
Vlookup question
  • *zot*
Replies
2
Views
145K
T. Valko
T
J
Sumproduct and Networkdays Together
  • J_L_G
Replies
2
Views
465K
J_L_G
J
C
#DIV/O! Error
  • Chris
Replies
5
Views
196K
T. Valko
T
K
Sort not saved across saves/reopens
  • Kris
Replies
2
Views
210K
Kris
K
D
#DIV/0 Error
  • Dianne HMM
Replies
4
Views
401K
Shane Devenshire
S
J
Formatting Text in cells that already have text entered
  • Jennifer V.
Replies
5
Views
497K
jb_tenor1
J
G
COUNT IF with multiple conditions
  • Ghalmaraz
Replies
6
Views
654K
Bob Phillips
B
J
Sumproduct or Countif - Counting Occurances within a Date Range
  • J_L_G
Replies
2
Views
199K
J_L_G
J
D
Row 1 Deleted
  • Deborah M
Replies
3
Views
253K
Gord Dibben
G
W
Identifying the # of cells containing data
  • WA
Replies
3
Views
327K
WA
W
U
Run time error
  • ub
Replies
2
Views
263K
ub
U
D
Blank Cells showing as 0 in pivot
  • DLoewenthal
Replies
2
Views
278K
DLoewenthal
D
D
How to control drop down list width
  • DocBrown
Replies
4
Views
313K
Gord Dibben
G
A
vlookup & Extrapolation
  • alawi
Replies
3
Views
82K
Bernd P
B
M
If A1 = 4, cut and paste a2:a227 to a specific worksheet
  • Mark B.
Replies
2
Views
153K
Mark B.
M
C
How to use RIGHT() in sumproduct
  • chrisk
Replies
1
Views
92K
Gary''s Student
G
K
Can a column of numbers be set to mix up in random order
  • KayD
Replies
1
Views
178K
N harkawat
N
G
Refresh pivot table in workbook A when changing a cell in workbook
  • gildengorin
Replies
2
Views
300K
gildengorin
G
I
How to password Protect when WORKSHEET is Very HIDDEN
  • Invisible
Replies
5
Views
636K
Harlan Grove
H
R
Macro assistance
  • Rover
Replies
11
Views
134K
Hansueli
H
O
remove the cells contents (data) without removing formulas Excel 2
  • onebigred51
Replies
2
Views
96K
Gord Dibben
G
D
Return 3D array?
  • Dave P
Replies
6
Views
225K
BlueJay
B
C
remove space
  • capreecorn
Replies
4
Views
20K
David Biddulph
D
J
If statements query
  • JayM
Replies
4
Views
403K
Teethless mama
T
S
Adding and multiplying
  • suroora
Replies
2
Views
130K
suroora
S
E
Search for duplicate entries in a column of numbers
  • Eán
Replies
2
Views
42K
Gary''s Student
G
S
Expanding Grouped Rows when sheet is Protected
  • SimonB
Replies
2
Views
183K
SimonB
S
M
Data merging with 2 worksheets
  • markmerid
Replies
2
Views
17K
Shane Devenshire
S
M
Sort automatically
  • MAX
Replies
2
Views
191K
Shane Devenshire
S
A
Date/Time concatenation
  • Al
Replies
4
Views
190K
Shane Devenshire
S
M
countif only when an exact match occurs
  • Mike
Replies
5
Views
515K
Mike
M
A
Count every group of numbers whose sum is zero & put formula next toeach number
  • al
Replies
7
Views
448K
al
A
C
Summing based on values in other worksheets
  • chickalina
Replies
2
Views
199K
chickalina
C
M
Lookup / Match ?
  • Mike B
Replies
8
Views
501K
David Biddulph
D
T
Concatenate With Criteria
  • Tracey
Replies
5
Views
421K
Tracey
T
F
Formula to identify text into columns
  • Forgone
Replies
7
Views
363K
Jarek Kujawa
J
You must log in or register to post here.
Back
Top