Microsoft Excel Worksheet Functions

G
Any way to calculate an average for more than 30 entries?
  • Guest
Replies
1
Views
90K
Don Guillett
D
D
Max value that meets a criteria
  • David Burr
Replies
6
Views
115K
dimtsan
D
G
Unable to Copy COUNTA() with cell references
  • Guest
Replies
1
Views
103K
Bernie Deitrick
B
G
Bug in DATEVALUE command in Excel 2002??
  • Guest
Replies
1
Views
70K
Arvi Laanemets
A
G
formatting numbers
  • Guest
Replies
2
Views
515K
Guest
G
R
List Box
  • R P
Replies
4
Views
83K
R P
R
G
lookup
  • Guest
Replies
1
Views
91K
CLR
C
G
MS Query - Alias syntax
  • Guest
Replies
3
Views
209K
Jamie Collins
J
G
How to add one number to a range of numbers
  • Guest
Replies
1
Views
147K
Oliver Ferns via OfficeKB.com
O
G
Max charactors for 'ActiveWorkbook.SaveAs Filename'?
  • Guest
Replies
1
Views
221K
Harlan Grove
H
G
Nested IF statements
  • Guest
Replies
14
Views
439K
Arvi Laanemets
A
G
How do you calculate rate of return on monthly cash flows
  • Guest
Replies
1
Views
247K
Fred Smith
F
G
Deleting rows with blank cells
  • Guest
Replies
9
Views
217K
Steve
S
G
conditional formatting
  • Guest
Replies
5
Views
107K
Dave Peterson
D
G
mathmatical error
  • Guest
Replies
2
Views
72K
Jerry W. Lewis
J
G
How to keep the value of a cell not a function of the other cell
  • galsaba
Replies
1
Views
195K
Biff
B
W
Table Array in VLOOKUP Relies on Data Validation
  • willydlish
Replies
2
Views
109K
willydlish
W
L
how to write to other sheet if and only if?
  • Len Canders
Replies
10
Views
337K
Biff
B
B
Formatting a cell to populate on a certain date
  • Brian
Replies
6
Views
95K
Jenny Dempsey
J
G
keeping worksheet title visible during scrolling
  • Guest
Replies
2
Views
72K
Gord Dibben
G
G
Count highlighted cells
  • Guest
Replies
2
Views
45K
Gord Dibben
G
G
IF statement, can it equal more than one number?
  • Guest
Replies
3
Views
54K
Fredrik Wahlgren
F
G
How do I convert from U.S. currency to Canadian?
  • Guest
Replies
4
Views
223K
Gord Dibben
G
D
Help with #DIV/O!
  • davidadiaz
Replies
1
Views
54K
Steve
S
G
gridlines
  • Guest
Replies
1
Views
299K
George Nicholson
G
G
Date
  • Guest
Replies
2
Views
38K
Guest
G
G
How to compare 2 lists and return un-matched?
  • Guest
Replies
1
Views
69K
Guest
G
G
how do i make a list of consecutive numbers in a column?
  • Guest
Replies
1
Views
78K
Guest
G
G
if/then formula
  • Guest
Replies
1
Views
90K
Guest
G
G
Correct Text Case to PROPER capitalization
  • Guest
Replies
1
Views
180K
Paul B
P
G
differing results
  • Guest
Replies
3
Views
152K
Trevor Shuttleworth
T
G
How to find top five States?
  • Guest
Replies
7
Views
71K
Aladin Akyurek
A
G
How do I combine COUNTIF and AND functions in Excel
  • Guest
Replies
2
Views
230K
Peo Sjoblom
P
G
How can I cause a cell to return the sheet name i.e. sheet 1?
  • Guest
Replies
2
Views
57K
Peo Sjoblom
P
G
Is there a WorkDay() type function that count all days except tho.
  • Guest
Replies
8
Views
52K
Guest
G
E
PPMT formula that generates equal payments
  • ExcelMonkey
Replies
3
Views
63K
Harlan Grove
H
J
Limit cursor range
  • Joe
Replies
2
Views
96K
joe
J
G
How to create barcodes in excel?
  • Guest
Replies
2
Views
203K
Thomas Lutz
T
G
random selection from a range of cells
  • Guest
Replies
1
Views
26K
Bernie Deitrick
B
G
How to validate data entries to be unique within an array
  • Guest
Replies
1
Views
214K
Bernie Deitrick
B
G
How do i put a drop down calendar in a cell?
  • Guest
Replies
1
Views
123K
Ron de Bruin
R
J
SUMIF
  • Joseph
Replies
1
Views
122K
Jason Morin
J
S
Holiday information using Excel
  • Sh0t2bts
Replies
1
Views
55K
Bernd Plumhoff
B
G
Lookup with multiple value return
  • Guest
Replies
2
Views
291K
Guest
G
G
Sumif over multiple columns
  • Guest
Replies
1
Views
255K
JulieD
J
G
cell text referring to tab name
  • Guest
Replies
1
Views
62K
Peo Sjoblom
P
G
How do I get zeros to stay in front of a # when using the concate.
  • Guest
Replies
5
Views
101K
Guest
G
G
Making your own trenlines
  • Guest
Replies
2
Views
453K
Guest
G
G
Searching based on Text color
  • Guest
Replies
1
Views
157K
Bob Phillips
B
G
Menu Bar - Tools disappeared
  • Guest
Replies
1
Views
66K
Bob Phillips
B
You must log in or register to post here.
Back
Top