Excel Functions

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