Excel Functions

Post thread
D
Comparing Values, displaying corresponding date
  • d.munyan
Replies
1
Views
457
Max
M
A
excel '03 data conversion to access
  • alex
Replies
1
Views
377
flummi
F
V
distinct
  • vernalGreens
Replies
1
Views
332
Harlan Grove
H
V
count
  • vernalGreens
Replies
1
Views
387
Harlan Grove
H
D
xAvg Calculation in Pivot Table
  • david_dzikowski
Replies
0
Views
550
[email protected]
D
J
Searching across multiple worksheets
  • Jerry Selinger
Replies
1
Views
389
Pranas
P
K
Copy certain items
  • Keith Crooks
Replies
1
Views
420
[email protected]
G
R
Significant digit formatting.
  • rbielaws
Replies
2
Views
429
[email protected]
R
J
List of memory usage with Excel functions
  • Johney
Replies
2
Views
500
Johney
J
K
Excluding in Excel
  • Kuba
Replies
3
Views
555
Max
M
D
1:N mappings
  • davids58
Replies
0
Views
395
[email protected]
D
G
Count of time values
  • GaryU
Replies
11
Views
803
Max
M
M
Hidden Sheets and Formulas
  • micheldevon
Replies
1
Views
411
flummi
F
N
Excel custom function dialog
  • nicolas.gendron
Replies
0
Views
374
[email protected]
N
M
Autofilter
  • Mickey Mouse
Replies
1
Views
417
Mark
M
P
IF THEN do an AVERAGE
  • pika.white
Replies
3
Views
446
Harlan Grove
H
R
If function with text
  • Richard
Replies
1
Views
350
Don Guillett
D
R
if function
  • Richard
Replies
2
Views
336
Tom Ogilvy
T
G
Match cell value (Date) in a named Range with function
  • gm
Replies
3
Views
519
Max
M
L
Pivit table question
  • lj
Replies
1
Views
329
Max
M
B
Formatting a Date Cell Reference Within a String
  • BarryC
Replies
1
Views
376
flummi
F
B
Hour specification and time calculation
  • BBert
Replies
2
Views
432
BBert
B
M
Ranking based on frequency
  • Maxi
Replies
0
Views
384
Maxi
M
M
Perform a calcualtion if months are matching
  • mjb2005
Replies
1
Views
369
mjb2005
M
M
Detecting Active Cell
  • Mike Hogan
Replies
2
Views
414
Harlan Grove
H
W
getting data from a closed worksheet
  • www.butterflysystems.co.uk
Replies
3
Views
491
Harlan Grove
H
A
reference a cell in path to file - indirect function?
  • alfrodull
Replies
1
Views
476
Harlan Grove
H
A
Fill multiple cells by entering data in one cell
  • AlisonB
Replies
7
Views
569
AlisonB
A
W
Getting Data from closed workbook into userform
  • www.butterflysystems.co.uk
Replies
0
Views
436
www.butterflysystems.co.uk
W
S
Spell check & text box sizing on protected sheet
  • Sue N.
Replies
0
Views
437
Sue N.
S
G
Using Max Min with Array Formula issues with negative numbers
  • Greg
Replies
5
Views
593
Greg
G
B
=proper
  • Bobbie
Replies
1
Views
346
Harlan Grove
H
J
SUMIF(left(A20:A40,2),"=11",D20:D40)?
  • JRF
Replies
2
Views
448
JRF
J
P
Worksheets
  • Paul W Smith
Replies
1
Views
343
Ron de Bruin
R
R
Conditional formtting with text
  • Richard Rosell
Replies
1
Views
332
El Gordo
E
S
Removing all numbers from Excell Cell
  • Sam
Replies
1
Views
355
Sox
S
S
Need Help Removing all Letters Leaving only Numbers
  • Sam
Replies
3
Views
544
Sox
S
L
Need Help on Vlookup
  • lee.dykeman
Replies
0
Views
338
[email protected]
L
L
Nested Vlookup
  • lee.dykeman
Replies
1
Views
378
Jason
J
D
intersection of named ranges
  • david.barbetta
Replies
1
Views
449
Art Farrell
A
G
Change formula for each new month
  • Gerry
Replies
1
Views
403
[email protected]
S
J
complex search
  • juuljus.jogar
Replies
0
Views
363
[email protected]
J
P
Refreshing VB Functions Automatically in Excel?
  • Phillip Nolan
Replies
0
Views
370
Phillip Nolan
P
G
using Dynamic Range and Unique values only
  • GregDAngelo
Replies
1
Views
488
Herbert Seidenberg
H
S
filtering
  • solid
Replies
1
Views
404
GregDAngelo
G
P
colour due to conditional formatting & hyperlink/shortcut to a directory
  • Peter STEVENS
Replies
2
Views
408
GregDAngelo
G
P
Worksheet name
  • Patol
Replies
2
Views
340
Mark
M
C
Find maximum value in list that contains #N/A values
  • chuck.waterfield
Replies
1
Views
474
Jerry W. Lewis
J
C
Creating summary data, returning only those rows whose quantity <> 0
  • christrygstad
Replies
0
Views
413
[email protected]
C
G
vlookup, match/index ????
  • Gerry
Replies
0
Views
489
Gerry
G
Top