Microsoft Excel Worksheet Functions

Post thread
K
Indirect with index and match
  • Kashyap
Replies
2
Views
652
T. Valko
T
J
Using the results of the ADDRESS formula in another formula
  • JP
Replies
4
Views
850
T. Valko
T
S
Nested If Statements
  • Sarah_Lecturer
Replies
5
Views
386
Ashish Mathur
A
D
Modify search function
  • Dinesh
Replies
3
Views
391
Ashish Mathur
A
V
Excel Formula to evaluate multiple criteria (countif + and)
  • VPSales
Replies
2
Views
3K
Ashish Mathur
A
L
Count text within numbers
  • LiAD
Replies
5
Views
303
Ashish Mathur
A
C
sumproduct formula work around
  • Chris
Replies
11
Views
567
T. Valko
T
Q
excel 2003
  • Quandary
Replies
1
Views
257
Gord Dibben
G
M
Eliminating #DIV/O!
  • MCheru
Replies
8
Views
475
MCheru
M
D
ogh, why is this not working
  • dlotz
Replies
1
Views
414
Sheeloo
S
D
sot data
  • daniel
Replies
2
Views
230
Gord Dibben
G
J
SUMIF Function ?
  • Joey
Replies
1
Views
299
Gary''s Student
G
R
Force required entry in cell before leaving that cell
  • Retired Bill
Replies
8
Views
502
Gord Dibben
G
E
Count frequence in one column
  • Excel Sum function with IF
Replies
1
Views
330
Elkar
E
J
Email message on cell change event
  • jknapp1005
Replies
1
Views
317
Ron de Bruin
R
Z
Vlookup question
  • *zot*
Replies
2
Views
324
T. Valko
T
J
Sumproduct and Networkdays Together
  • J_L_G
Replies
2
Views
1K
J_L_G
J
C
#DIV/O! Error
  • Chris
Replies
5
Views
484
T. Valko
T
K
Sort not saved across saves/reopens
  • Kris
Replies
2
Views
412
Kris
K
D
#DIV/0 Error
  • Dianne HMM
Replies
4
Views
508
Shane Devenshire
S
J
Formatting Text in cells that already have text entered
  • Jennifer V.
Replies
5
Views
389
jb_tenor1
J
G
COUNT IF with multiple conditions
  • Ghalmaraz
Replies
6
Views
435
Bob Phillips
B
J
Sumproduct or Countif - Counting Occurances within a Date Range
  • J_L_G
Replies
2
Views
812
J_L_G
J
D
Row 1 Deleted
  • Deborah M
Replies
3
Views
267
Gord Dibben
G
W
Identifying the # of cells containing data
  • WA
Replies
3
Views
442
WA
W
U
Run time error
  • ub
Replies
2
Views
381
ub
U
D
Blank Cells showing as 0 in pivot
  • DLoewenthal
Replies
2
Views
822
DLoewenthal
D
D
How to control drop down list width
  • DocBrown
Replies
4
Views
629
Gord Dibben
G
A
vlookup & Extrapolation
  • alawi
Replies
3
Views
871
Bernd P
B
M
If A1 = 4, cut and paste a2:a227 to a specific worksheet
  • Mark B.
Replies
2
Views
421
Mark B.
M
C
How to use RIGHT() in sumproduct
  • chrisk
Replies
1
Views
745
Gary''s Student
G
K
Can a column of numbers be set to mix up in random order
  • KayD
Replies
1
Views
753
N harkawat
N
G
Refresh pivot table in workbook A when changing a cell in workbook
  • gildengorin
Replies
2
Views
936
gildengorin
G
I
How to password Protect when WORKSHEET is Very HIDDEN
  • Invisible
Replies
5
Views
888
Harlan Grove
H
R
Macro assistance
  • Rover
Replies
11
Views
528
Hansueli
H
O
remove the cells contents (data) without removing formulas Excel 2
  • onebigred51
Replies
2
Views
378
Gord Dibben
G
D
Return 3D array?
  • Dave P
Replies
6
Views
453
BlueJay
B
C
remove space
  • capreecorn
Replies
4
Views
392
David Biddulph
D
J
If statements query
  • JayM
Replies
4
Views
417
Teethless mama
T
S
Adding and multiplying
  • suroora
Replies
2
Views
357
suroora
S
E
Search for duplicate entries in a column of numbers
  • Eán
Replies
2
Views
298
Gary''s Student
G
S
Expanding Grouped Rows when sheet is Protected
  • SimonB
Replies
2
Views
1K
SimonB
S
M
Data merging with 2 worksheets
  • markmerid
Replies
2
Views
334
Shane Devenshire
S
M
Sort automatically
  • MAX
Replies
2
Views
370
Shane Devenshire
S
A
Date/Time concatenation
  • Al
Replies
4
Views
460
Shane Devenshire
S
M
countif only when an exact match occurs
  • Mike
Replies
5
Views
4K
Mike
M
A
Count every group of numbers whose sum is zero & put formula next toeach number
  • al
Replies
7
Views
580
al
A
C
Summing based on values in other worksheets
  • chickalina
Replies
2
Views
336
chickalina
C
M
Lookup / Match ?
  • Mike B
Replies
8
Views
472
David Biddulph
D
T
Concatenate With Criteria
  • Tracey
Replies
5
Views
458
Tracey
T
Back
Top