Microsoft Excel Worksheet Functions

Post thread
M
Sum only cells with text in a neighbouring cell
  • matt_the_brum
Replies
11
Views
933
Ron Rosenfeld
R
J
Pivot Table new items as bold
  • jale
Replies
2
Views
369
jale
J
M
a new VLOOKUP ?
  • MIKEKBR
Replies
1
Views
349
Jonathan Rynd
J
K
Adding numbers continously in multiple cells
  • KMF
Replies
1
Views
237
Jonathan Rynd
J
W
AVERAGE function using arrays
  • WANDO
Replies
2
Views
437
WANDO
W
B
How to find differnces between 2 files
  • BLanca
Replies
1
Views
319
Dave R.
D
R
Calculating time
  • Robert King
Replies
3
Views
308
Guest
G
G
Linking contents of Worksheets
  • Guest
Replies
5
Views
492
Guest
G
G
Absolutes when linking
  • GS
Replies
1
Views
352
Bernard Liengme
B
S
Date Formula
  • Stephanie
Replies
2
Views
408
Stephanie
S
J
Finding "links to other data sources"
  • Jeff
Replies
7
Views
875
Joe
J
D
Sum Function returns zero
  • Dee
Replies
2
Views
596
Peo Sjoblom
P
R
VBA question
  • Robert Nguyen
Replies
5
Views
425
Robert
R
D
lookup_value variable
  • Dar
Replies
1
Views
628
Peo Sjoblom
P
G
Insertng Blank row below subtotal
  • Guest
Replies
4
Views
515
Guest
G
G
Autobackup location changing
  • Guest
Replies
1
Views
326
Jonathan Rynd
J
G
OFFSET cell references
  • Gary Thomson
Replies
3
Views
551
Peo Sjoblom
P
M
MATCH a Web Query
  • mpduffey
Replies
1
Views
252
Jonathan Rynd
J
G
Function Statements
  • Guest
Replies
4
Views
345
Guest
G
E
Using ADDRESS results in another formula
  • erik
Replies
1
Views
540
Jonathan Rynd
J
D
Insert Hyperlink Macro
  • Dave McLachlan
Replies
1
Views
330
Jonathan Rynd
J
L
Allocating values in proportion to a known value
  • ltclgc
Replies
1
Views
469
Jonathan Rynd
J
A
Copying pivot table results
  • Alex
Replies
5
Views
589
Guest
G
D
Assigning a macro
  • deepakj
Replies
1
Views
434
Jonathan Rynd
J
M
Relative transfer of data from the last sheet
  • Mahendra
Replies
2
Views
336
Bernie Deitrick
B
S
Importing From Excel To Outlook (Ofc 2000/XP Pro)
  • Susan Gerstenmaier
Replies
1
Views
325
Jonathan Rynd
J
J
exporting from a template into a monthly excel list database
  • jake
Replies
1
Views
428
Jonathan Rynd
J
M
update value
  • mark
Replies
1
Views
275
Jonathan Rynd
J
G
Macro causing large file size.
  • Guest
Replies
1
Views
372
Jonathan Rynd
J
G
calculating the number of consecutive shifts in a 6 week schedule
  • Guest
Replies
3
Views
527
Jonathan Rynd
J
K
Custom # formats
  • Keyur
Replies
1
Views
315
Norman Harker
N
N
Using VBA function as worksheet function?
  • Nekdo Od Nekje
Replies
3
Views
659
Nekdo Od Nekje
N
A
Can you make a workbook run like a program?
  • Arthur
Replies
8
Views
592
Kurt
K
D
Opening of excel
  • David
Replies
4
Views
286
Guest
G
K
Macro to sort a range in ascending order
  • Kerrick Sawyers
Replies
1
Views
750
Norman Harker
N
F
Data validation using external cell contents
  • Frozen_Smoke
Replies
3
Views
338
Frozen_Smoke
F
K
copying and controling a formula cell to cell
  • kevin
Replies
5
Views
387
kevin
K
L
Worksheets
  • Leonard
Replies
1
Views
315
Frank Kabel
F
S
Query
  • Supriya
Replies
2
Views
210
Arvi Laanemets
A
D
Start date calculations...
  • Dave Ramage
Replies
2
Views
291
Dave Ramage
D
G
Make #Value! error blank
  • Guest
Replies
3
Views
458
Guest
G
E
Headers and Footers
  • Edgar
Replies
2
Views
390
Frank Kabel
F
S
Excel 2000 brackets on negative numbers
  • sandy
Replies
1
Views
563
Roger Whitehead
R
L
Nested formulas - formula displays instead of value
  • Leolin
Replies
3
Views
440
Frank Kabel
F
L
Sum Function Error
  • leblancds
Replies
3
Views
246
Harlan Grove
H
E
Export to text file by use " ; " as separator
  • Eva
Replies
4
Views
425
Harlan Grove
H
C
Date Arithmetic
  • Curtis Croulet
Replies
1
Views
418
Norman Harker
N
R
editing 'refers to'" box in naming dynamic ranges
  • R.VENKATARAMAN
Replies
5
Views
415
R.VENKATARAMAN
R
D
SUMIF type function for product?
  • donafuin
Replies
1
Views
473
Laura Cook
L
R
Consolidating values
  • RD Wirr
Replies
4
Views
362
RD Wirr
R
Back
Top