Excel Functions

Post thread
V
distinct
  • vernalGreens
Replies
1
Views
226
Harlan Grove
H
V
count
  • vernalGreens
Replies
1
Views
263
Harlan Grove
H
D
xAvg Calculation in Pivot Table
  • david_dzikowski
Replies
0
Views
449
[email protected]
D
J
Searching across multiple worksheets
  • Jerry Selinger
Replies
1
Views
259
Pranas
P
K
Copy certain items
  • Keith Crooks
Replies
1
Views
291
[email protected]
G
R
Significant digit formatting.
  • rbielaws
Replies
2
Views
298
[email protected]
R
J
List of memory usage with Excel functions
  • Johney
Replies
2
Views
358
Johney
J
K
Excluding in Excel
  • Kuba
Replies
3
Views
421
Max
M
D
1:N mappings
  • davids58
Replies
0
Views
283
[email protected]
D
G
Count of time values
  • GaryU
Replies
11
Views
522
Max
M
M
Hidden Sheets and Formulas
  • micheldevon
Replies
1
Views
308
flummi
F
N
Excel custom function dialog
  • nicolas.gendron
Replies
0
Views
273
[email protected]
N
M
Autofilter
  • Mickey Mouse
Replies
1
Views
296
Mark
M
P
IF THEN do an AVERAGE
  • pika.white
Replies
3
Views
293
Harlan Grove
H
R
If function with text
  • Richard
Replies
1
Views
227
Don Guillett
D
R
if function
  • Richard
Replies
2
Views
214
Tom Ogilvy
T
G
Match cell value (Date) in a named Range with function
  • gm
Replies
3
Views
344
Max
M
L
Pivit table question
  • lj
Replies
1
Views
214
Max
M
B
Formatting a Date Cell Reference Within a String
  • BarryC
Replies
1
Views
249
flummi
F
B
Hour specification and time calculation
  • BBert
Replies
2
Views
298
BBert
B
M
Ranking based on frequency
  • Maxi
Replies
0
Views
269
Maxi
M
M
Perform a calcualtion if months are matching
  • mjb2005
Replies
1
Views
243
mjb2005
M
M
Detecting Active Cell
  • Mike Hogan
Replies
2
Views
297
Harlan Grove
H
W
getting data from a closed worksheet
  • www.butterflysystems.co.uk
Replies
3
Views
354
Harlan Grove
H
A
reference a cell in path to file - indirect function?
  • alfrodull
Replies
1
Views
351
Harlan Grove
H
A
Fill multiple cells by entering data in one cell
  • AlisonB
Replies
7
Views
343
AlisonB
A
W
Getting Data from closed workbook into userform
  • www.butterflysystems.co.uk
Replies
0
Views
340
www.butterflysystems.co.uk
W
S
Spell check & text box sizing on protected sheet
  • Sue N.
Replies
0
Views
341
Sue N.
S
G
Using Max Min with Array Formula issues with negative numbers
  • Greg
Replies
5
Views
421
Greg
G
B
=proper
  • Bobbie
Replies
1
Views
235
Harlan Grove
H
J
SUMIF(left(A20:A40,2),"=11",D20:D40)?
  • JRF
Replies
2
Views
350
JRF
J
P
Worksheets
  • Paul W Smith
Replies
1
Views
234
Ron de Bruin
R
R
Conditional formtting with text
  • Richard Rosell
Replies
1
Views
227
El Gordo
E
S
Removing all numbers from Excell Cell
  • Sam
Replies
1
Views
245
Sox
S
S
Need Help Removing all Letters Leaving only Numbers
  • Sam
Replies
3
Views
357
Sox
S
L
Need Help on Vlookup
  • lee.dykeman
Replies
0
Views
240
[email protected]
L
L
Nested Vlookup
  • lee.dykeman
Replies
1
Views
265
Jason
J
D
intersection of named ranges
  • david.barbetta
Replies
1
Views
339
Art Farrell
A
G
Change formula for each new month
  • Gerry
Replies
1
Views
288
[email protected]
S
J
complex search
  • juuljus.jogar
Replies
0
Views
267
[email protected]
J
P
Refreshing VB Functions Automatically in Excel?
  • Phillip Nolan
Replies
0
Views
274
Phillip Nolan
P
G
using Dynamic Range and Unique values only
  • GregDAngelo
Replies
1
Views
391
Herbert Seidenberg
H
S
filtering
  • solid
Replies
1
Views
277
GregDAngelo
G
P
colour due to conditional formatting & hyperlink/shortcut to a directory
  • Peter STEVENS
Replies
2
Views
286
GregDAngelo
G
P
Worksheet name
  • Patol
Replies
2
Views
211
Mark
M
C
Find maximum value in list that contains #N/A values
  • chuck.waterfield
Replies
1
Views
344
Jerry W. Lewis
J
C
Creating summary data, returning only those rows whose quantity <> 0
  • christrygstad
Replies
0
Views
316
[email protected]
C
G
vlookup, match/index ????
  • Gerry
Replies
0
Views
383
Gerry
G
A
Is there a worksheet function that will..
  • Adam Kroger
Replies
1
Views
241
[email protected]
R
A
I need assistance on Rand() and Combo box in '97
  • Adam Kroger
Replies
5
Views
374
Dave Peterson
D
Top