Microsoft Excel Worksheet Functions

Post thread
D
Value used is wrong data type..
  • Destrachan
Replies
2
Views
8K
Ms-Exl-Learner
M
P
Troubleshooting macro to save in Compatability Mode
  • Pierre
Replies
2
Views
1K
AM
A
B
a data validation list that contains a list of named ranges - not alist from a named range
  • BoringAccountant
Replies
1
Views
1K
Max
M
T
WHAT IS THE RIGHT FUNCTION ?
  • Terrance Wyatt
Replies
3
Views
700
Max
M
N
sorting coloumns
  • newexler
Replies
0
Views
593
newexler
N
H
Combine Pivot tables - confused about 'how-to'
  • heyredone
Replies
7
Views
18K
Sarfaraj Desai
S
M
Relationship Help - Problem and Incident Database
  • Moon
Replies
1
Views
612
Moon
M
S
Arranging dates in a single column
  • shriil
Replies
5
Views
887
shriil
S
B
Find >cell_value with COUNTIF. Can't Refer to Cell Value in "quotemarks"
  • bony_tony
Replies
1
Views
610
Pete_UK
P
D
Logging users accessing a spreadsheet
  • DT
Replies
3
Views
706
neodjandre
N
J
how to fill in names in cells automatically
  • john
Replies
2
Views
609
Don Guillett Excel MVP
D
J
EXcel IF function
  • jamie
Replies
1
Views
468
Don Guillett Excel MVP
D
B
find last non-zero entry
  • Bruce Bowler
Replies
5
Views
2K
Ziggy
Z
L
Lose formatting on pivot tables
  • Louja
Replies
3
Views
2K
Roger Govier
R
B
Data Look Up
  • bwottle
Replies
2
Views
611
Max
M
J
Total Strength to Concentration
  • jakeo
Replies
2
Views
452
Ms-Xl-Learner
M
P
Where did everybody go?
  • Pierre
Replies
4
Views
444
Max
M
P
Calculating Initial Payment - Excell
  • pietm3
Replies
0
Views
774
pietm3
P
R
Excel sort dialog box: Display of column header instead of columnname
  • Raj
Replies
1
Views
836
trip_to_tokyo
T
S
Find
  • Slim Slender
Replies
3
Views
560
larske
L
S
excel time stamp
  • surveyor kyle
Replies
3
Views
2K
surveyor kyle
S
A
how to use an formula to transpose a list(left) to be like the right?
  • Alex
Replies
2
Views
889
Alex
A
E
Help using the LARGE function "WITHOUT" using an array
  • exceluser
Replies
14
Views
2K
Max
M
E
INDEX function array causes problem when attempting to use LARGEfunction to sort positive and negati
  • exceluser
Replies
10
Views
1K
exceluser
E
E
Can you use an INDEX array in a COUNTIF formula ?
  • exceluser
Replies
1
Views
2K
exceluser
E
P
Password prompting to unhide worksheet allows temporary visibility
  • Pierre
Replies
2
Views
4K
Pierre
P
I
DB.SUM and whole cell value
  • IgorM
Replies
2
Views
551
IgorM
I
P
game timer
  • pat67
Replies
5
Views
694
FSt1
F
S
I have either a H or A in cell B5.
  • Skip
Replies
2
Views
588
Don Guillett Excel MVP
D
T
MATCH and A:A
  • Ty
Replies
2
Views
439
Dave Peterson
D
P
adding data from a form
  • pat67
Replies
1
Views
451
Dave Peterson
D
D
If a cell equals another cell, then use the value in the cell to theright.
  • dicko1
Replies
2
Views
3K
dicko1
D
S
Spin Button
  • Steve
Replies
1
Views
677
Steve
S
P
Macro to unhide all except for. . .
  • Pierre
Replies
5
Views
1K
Pierre
P
C
Summing Like items
  • Carl
Replies
2
Views
512
James Ravenswood
J
C
excel sumproduct value error
  • cstang
Replies
6
Views
7K
Bob Phillips
B
L
Can someone help me please? Prefix to add international diallingcodes to Uk mobile numbers
  • Les Lilas
Replies
1
Views
1K
Bob Phillips
B
S
How to deal with content thieves like fixya.com?
  • Stan Brown
Replies
2
Views
1K
Stan Brown
S
L
Split Text into Two Columns
  • laingds
Replies
1
Views
607
Don Guillett Excel MVP
D
S
IF(ISBLANK for multiple cells A1:N1
  • SCrowley
Replies
6
Views
27K
siti.rohaini
S
F
[CSE] SUM Array Formula with if condition
  • Forgone
Replies
1
Views
1K
Forgone
F
M
Man hours calculation
  • Mama Mia
Replies
9
Views
19K
Marlon
M
T
Automatize chart building
  • tuli
Replies
1
Views
618
Bob Phillips
B
C
IF AND formula
  • Colin Hayes
Replies
5
Views
478
Colin Hayes
C
S
I have an Excel workbook with multiple pages.
  • Skip
Replies
1
Views
457
Cimjet
C
K
Comparing and populating data between 2 sheets
  • Kurt Herman-Roloff
Replies
1
Views
652
Pete_UK
P
S
default format for text in cells
  • Sdlentertd
Replies
3
Views
982
Gord Dibben
G
R
Custom format string from cell value
  • Raj
Replies
2
Views
1K
James Ravenswood
J
A
NA() and COUNTIF functions together?
  • amandaTES
Replies
1
Views
1K
amandaTES
A
L
Open multiple workbooks from directory path
  • Len
Replies
1
Views
670
Len
L
Back
Top