Microsoft Excel Worksheet Functions

G
Finding Max values
  • Guest
Replies
1
Views
74K
Max
M
G
pleas help: sumproduct function returns #value or #ref error
  • Guest
Replies
1
Views
227K
Bob Phillips
B
G
How do I use the wildcard character and the NOT function?
  • Guest
Replies
1
Views
61K
Bernie Deitrick
B
G
HOW DO I DELETE A WORKSHEET IN EXCEL? NOT HIDE IT OR RENAME IT
  • Guest
Replies
6
Views
178K
Max
M
G
sumproduct function returns #value or #ref error
  • Guest
Replies
3
Views
336K
Leo Heuser
L
G
Need a formula that counts orders
  • Guest
Replies
6
Views
91K
Guest
G
G
COUNT IF NOT EQUAL TO ZERO
  • Guest
Replies
12
Views
258K
Max
M
C
Formula question
  • Craig Fletcher
Replies
2
Views
49K
Craig Fletcher
C
G
need help with a simple xls equation !!
  • Guest
Replies
3
Views
73K
malik641
M
G
List Unique Occurences and Count
  • Guest
Replies
6
Views
75K
Guest
G
D
how do i password protect an .xls file? how do i unlock it for automation. e.g. want to unlock and a
  • Daniel
Replies
1
Views
128K
sanskar_d
S
G
Concatenating cells to produce a cell ref from another excel file
  • Guest
Replies
1
Views
289K
JE McGimpsey
J
G
Unhide Pivot data tab
  • Guest
Replies
3
Views
165K
Debra Dalgleish
D
A
Extracting from a text string
  • AmyTaylor
Replies
3
Views
271K
BenjieLop
B
G
text in formula explaining formula not to print
  • Guest
Replies
1
Views
64K
JE McGimpsey
J
G
How do i check if something non numeric is in a range & return'Y'
  • Guest
Replies
3
Views
84K
Guest
G
G
ROUNDUP IN 0.2 INCREMENTS
  • Guest
Replies
3
Views
111K
Guest
G
G
Abbreviation for "Rear Derailleur" as "RD"
  • Guest
Replies
4
Views
91K
Bob Phillips
B
G
Meeting two conditions before summing
  • Guest
Replies
1
Views
48K
Bob Phillips
B
G
=IF(TRIM(RIGHT(D4,1))="X",MID(D4,1,LEN(D4)-1),D4) ? remove error
  • Guest
Replies
9
Views
140K
Bob Phillips
B
G
combination of vlookup and match question
  • Guest
Replies
3
Views
149K
Biff
B
G
Transpose formula
  • Guest
Replies
3
Views
181K
Biff
B
M
Generate Payment Statement
  • myty
Replies
5
Views
225K
myty
M
S
Concatenate Multiple Instances in Array
  • sunfish62
Replies
1
Views
130K
Biff
B
G
"E" or "O" for the first, even or odd digit in a number
  • Guest
Replies
2
Views
172K
Ron Rosenfeld
R
W
someone must how to do this. :):)
  • Wei
Replies
3
Views
68K
Lewis Clark
L
G
"E" for even numbers. "O" for odd numbers.
  • Guest
Replies
9
Views
321K
Guest
G
G
Problem with nested IF_OR statement
  • Guest
Replies
7
Views
230K
RagDyer
R
G
Find Median of Positive numbers only in Range
  • Guest
Replies
4
Views
526K
Ron Rosenfeld
R
G
Counting cells with intervals
  • Guest
Replies
4
Views
67K
Ron Rosenfeld
R
G
Help with Excel Macro.
  • Guest
Replies
3
Views
36K
Guest
G
P
How to dynamically reference a dynamic named range
  • paris3
Replies
4
Views
99K
Guest
G
G
using time functions when hours are greater than 10000
  • Guest
Replies
1
Views
130K
Bob Phillips
B
G
saving the format when emailing
  • Guest
Replies
1
Views
28K
Anne Troy
A
G
Conditional Formating
  • Guest
Replies
2
Views
100K
Guest
G
P
Display only surname
  • Pat
Replies
2
Views
66K
CLR
C
G
Extending a balance sheet
  • Guest
Replies
3
Views
173K
Guest
G
G
I need an Excell formula that will add x$'s every 30 days
  • Guest
Replies
1
Views
114K
JE McGimpsey
J
G
Scenarios
  • Guest
Replies
2
Views
78K
Debra Dalgleish
D
G
copying subtotals in Pivot tables
  • Guest
Replies
3
Views
79K
Debra Dalgleish
D
G
dget function
  • Guest
Replies
2
Views
357K
Guest
G
B
HELP: Cell Value as Filename?
  • bajofuego
Replies
1
Views
41K
Paul B
P
G
How can a formula in a cell automatically update when inserting a.
  • Guest
Replies
1
Views
153K
Guest
G
E
Cannot protect worksheet if it includes a list
  • Elladene
Replies
0
Views
48K
Elladene
E
G
Format text in one cell based on value in another cell
  • Guest
Replies
2
Views
139K
Guest
G
G
Excell linked to outlook contacts
  • Guest
Replies
1
Views
42K
JPW
J
D
is there anyway in an excel macro to reorder the sheet tabs from left to right?
  • Daniel
Replies
2
Views
116K
Anne Troy
A
G
Create a pick list to use to go to a text cell in Excel
  • Guest
Replies
1
Views
136K
Debra Dalgleish
D
G
How can I make a cell mandatory and only accept a Y or N?
  • Guest
Replies
1
Views
48K
Ron Rosenfeld
R
A
lists and validation
  • andrewm
Replies
3
Views
105K
Debra Dalgleish
D
You must log in or register to post here.
Back
Top