Microsoft Excel Worksheet Functions

Post thread
K
Indirect with index and match
  • Kashyap
Replies
2
Views
685
T. Valko
T
J
Using the results of the ADDRESS formula in another formula
  • JP
Replies
4
Views
871
T. Valko
T
S
Nested If Statements
  • Sarah_Lecturer
Replies
5
Views
423
Ashish Mathur
A
D
Modify search function
  • Dinesh
Replies
3
Views
407
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
584
T. Valko
T
Q
excel 2003
  • Quandary
Replies
1
Views
260
Gord Dibben
G
M
Eliminating #DIV/O!
  • MCheru
Replies
8
Views
516
MCheru
M
D
ogh, why is this not working
  • dlotz
Replies
1
Views
425
Sheeloo
S
D
sot data
  • daniel
Replies
2
Views
231
Gord Dibben
G
J
SUMIF Function ?
  • Joey
Replies
1
Views
311
Gary''s Student
G
R
Force required entry in cell before leaving that cell
  • Retired Bill
Replies
8
Views
503
Gord Dibben
G
E
Count frequence in one column
  • Excel Sum function with IF
Replies
1
Views
347
Elkar
E
J
Email message on cell change event
  • jknapp1005
Replies
1
Views
320
Ron de Bruin
R
Z
Vlookup question
  • *zot*
Replies
2
Views
346
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
508
T. Valko
T
K
Sort not saved across saves/reopens
  • Kris
Replies
2
Views
426
Kris
K
D
#DIV/0 Error
  • Dianne HMM
Replies
4
Views
539
Shane Devenshire
S
J
Formatting Text in cells that already have text entered
  • Jennifer V.
Replies
5
Views
437
jb_tenor1
J
G
COUNT IF with multiple conditions
  • Ghalmaraz
Replies
6
Views
469
Bob Phillips
B
J
Sumproduct or Countif - Counting Occurances within a Date Range
  • J_L_G
Replies
2
Views
827
J_L_G
J
D
Row 1 Deleted
  • Deborah M
Replies
3
Views
277
Gord Dibben
G
W
Identifying the # of cells containing data
  • WA
Replies
3
Views
476
WA
W
U
Run time error
  • ub
Replies
2
Views
392
ub
U
D
Blank Cells showing as 0 in pivot
  • DLoewenthal
Replies
2
Views
843
DLoewenthal
D
D
How to control drop down list width
  • DocBrown
Replies
4
Views
685
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
438
Mark B.
M
C
How to use RIGHT() in sumproduct
  • chrisk
Replies
1
Views
759
Gary''s Student
G
K
Can a column of numbers be set to mix up in random order
  • KayD
Replies
1
Views
761
N harkawat
N
G
Refresh pivot table in workbook A when changing a cell in workbook
  • gildengorin
Replies
2
Views
948
gildengorin
G
I
How to password Protect when WORKSHEET is Very HIDDEN
  • Invisible
Replies
5
Views
940
Harlan Grove
H
R
Macro assistance
  • Rover
Replies
11
Views
539
Hansueli
H
O
remove the cells contents (data) without removing formulas Excel 2
  • onebigred51
Replies
2
Views
388
Gord Dibben
G
D
Return 3D array?
  • Dave P
Replies
6
Views
461
BlueJay
B
C
remove space
  • capreecorn
Replies
4
Views
396
David Biddulph
D
J
If statements query
  • JayM
Replies
4
Views
447
Teethless mama
T
S
Adding and multiplying
  • suroora
Replies
2
Views
365
suroora
S
E
Search for duplicate entries in a column of numbers
  • Eán
Replies
2
Views
299
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
336
Shane Devenshire
S
M
Sort automatically
  • MAX
Replies
2
Views
386
Shane Devenshire
S
A
Date/Time concatenation
  • Al
Replies
4
Views
486
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
615
al
A
C
Summing based on values in other worksheets
  • chickalina
Replies
2
Views
351
chickalina
C
M
Lookup / Match ?
  • Mike B
Replies
8
Views
501
David Biddulph
D
T
Concatenate With Criteria
  • Tracey
Replies
5
Views
491
Tracey
T
Back
Top