Excel Functions

Post thread
D
Comparing Values, displaying corresponding date
  • d.munyan
Replies
1
Views
430
Max
M
A
excel '03 data conversion to access
  • alex
Replies
1
Views
351
flummi
F
V
distinct
  • vernalGreens
Replies
1
Views
305
Harlan Grove
H
V
count
  • vernalGreens
Replies
1
Views
351
Harlan Grove
H
D
xAvg Calculation in Pivot Table
  • david_dzikowski
Replies
0
Views
527
[email protected]
D
J
Searching across multiple worksheets
  • Jerry Selinger
Replies
1
Views
358
Pranas
P
K
Copy certain items
  • Keith Crooks
Replies
1
Views
383
[email protected]
G
R
Significant digit formatting.
  • rbielaws
Replies
2
Views
389
[email protected]
R
J
List of memory usage with Excel functions
  • Johney
Replies
2
Views
460
Johney
J
K
Excluding in Excel
  • Kuba
Replies
3
Views
520
Max
M
D
1:N mappings
  • davids58
Replies
0
Views
372
[email protected]
D
G
Count of time values
  • GaryU
Replies
11
Views
739
Max
M
M
Hidden Sheets and Formulas
  • micheldevon
Replies
1
Views
384
flummi
F
N
Excel custom function dialog
  • nicolas.gendron
Replies
0
Views
348
[email protected]
N
M
Autofilter
  • Mickey Mouse
Replies
1
Views
391
Mark
M
P
IF THEN do an AVERAGE
  • pika.white
Replies
3
Views
414
Harlan Grove
H
R
If function with text
  • Richard
Replies
1
Views
317
Don Guillett
D
R
if function
  • Richard
Replies
2
Views
310
Tom Ogilvy
T
G
Match cell value (Date) in a named Range with function
  • gm
Replies
3
Views
480
Max
M
L
Pivit table question
  • lj
Replies
1
Views
301
Max
M
B
Formatting a Date Cell Reference Within a String
  • BarryC
Replies
1
Views
336
flummi
F
B
Hour specification and time calculation
  • BBert
Replies
2
Views
401
BBert
B
M
Ranking based on frequency
  • Maxi
Replies
0
Views
349
Maxi
M
M
Perform a calcualtion if months are matching
  • mjb2005
Replies
1
Views
318
mjb2005
M
M
Detecting Active Cell
  • Mike Hogan
Replies
2
Views
383
Harlan Grove
H
W
getting data from a closed worksheet
  • www.butterflysystems.co.uk
Replies
3
Views
456
Harlan Grove
H
A
reference a cell in path to file - indirect function?
  • alfrodull
Replies
1
Views
446
Harlan Grove
H
A
Fill multiple cells by entering data in one cell
  • AlisonB
Replies
7
Views
522
AlisonB
A
W
Getting Data from closed workbook into userform
  • www.butterflysystems.co.uk
Replies
0
Views
410
www.butterflysystems.co.uk
W
S
Spell check & text box sizing on protected sheet
  • Sue N.
Replies
0
Views
415
Sue N.
S
G
Using Max Min with Array Formula issues with negative numbers
  • Greg
Replies
5
Views
524
Greg
G
B
=proper
  • Bobbie
Replies
1
Views
325
Harlan Grove
H
J
SUMIF(left(A20:A40,2),"=11",D20:D40)?
  • JRF
Replies
2
Views
421
JRF
J
P
Worksheets
  • Paul W Smith
Replies
1
Views
312
Ron de Bruin
R
R
Conditional formtting with text
  • Richard Rosell
Replies
1
Views
305
El Gordo
E
S
Removing all numbers from Excell Cell
  • Sam
Replies
1
Views
330
Sox
S
S
Need Help Removing all Letters Leaving only Numbers
  • Sam
Replies
3
Views
474
Sox
S
L
Need Help on Vlookup
  • lee.dykeman
Replies
0
Views
307
[email protected]
L
L
Nested Vlookup
  • lee.dykeman
Replies
1
Views
344
Jason
J
D
intersection of named ranges
  • david.barbetta
Replies
1
Views
421
Art Farrell
A
G
Change formula for each new month
  • Gerry
Replies
1
Views
380
[email protected]
S
J
complex search
  • juuljus.jogar
Replies
0
Views
340
[email protected]
J
P
Refreshing VB Functions Automatically in Excel?
  • Phillip Nolan
Replies
0
Views
347
Phillip Nolan
P
G
using Dynamic Range and Unique values only
  • GregDAngelo
Replies
1
Views
459
Herbert Seidenberg
H
S
filtering
  • solid
Replies
1
Views
375
GregDAngelo
G
P
colour due to conditional formatting & hyperlink/shortcut to a directory
  • Peter STEVENS
Replies
2
Views
371
GregDAngelo
G
P
Worksheet name
  • Patol
Replies
2
Views
308
Mark
M
C
Find maximum value in list that contains #N/A values
  • chuck.waterfield
Replies
1
Views
435
Jerry W. Lewis
J
C
Creating summary data, returning only those rows whose quantity <> 0
  • christrygstad
Replies
0
Views
386
[email protected]
C
G
vlookup, match/index ????
  • Gerry
Replies
0
Views
458
Gerry
G
Top