Microsoft Excel Worksheet Functions

Post thread
M
Sum only cells with text in a neighbouring cell
  • matt_the_brum
Replies
11
Views
932
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
345
Jonathan Rynd
J
K
Adding numbers continously in multiple cells
  • KMF
Replies
1
Views
235
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
318
Dave R.
D
R
Calculating time
  • Robert King
Replies
3
Views
296
Guest
G
G
Linking contents of Worksheets
  • Guest
Replies
5
Views
491
Guest
G
G
Absolutes when linking
  • GS
Replies
1
Views
350
Bernard Liengme
B
S
Date Formula
  • Stephanie
Replies
2
Views
396
Stephanie
S
J
Finding "links to other data sources"
  • Jeff
Replies
7
Views
872
Joe
J
D
Sum Function returns zero
  • Dee
Replies
2
Views
595
Peo Sjoblom
P
R
VBA question
  • Robert Nguyen
Replies
5
Views
424
Robert
R
D
lookup_value variable
  • Dar
Replies
1
Views
626
Peo Sjoblom
P
G
Insertng Blank row below subtotal
  • Guest
Replies
4
Views
513
Guest
G
G
Autobackup location changing
  • Guest
Replies
1
Views
324
Jonathan Rynd
J
G
OFFSET cell references
  • Gary Thomson
Replies
3
Views
533
Peo Sjoblom
P
M
MATCH a Web Query
  • mpduffey
Replies
1
Views
252
Jonathan Rynd
J
G
Function Statements
  • Guest
Replies
4
Views
344
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
327
Jonathan Rynd
J
L
Allocating values in proportion to a known value
  • ltclgc
Replies
1
Views
463
Jonathan Rynd
J
A
Copying pivot table results
  • Alex
Replies
5
Views
586
Guest
G
D
Assigning a macro
  • deepakj
Replies
1
Views
433
Jonathan Rynd
J
M
Relative transfer of data from the last sheet
  • Mahendra
Replies
2
Views
333
Bernie Deitrick
B
S
Importing From Excel To Outlook (Ofc 2000/XP Pro)
  • Susan Gerstenmaier
Replies
1
Views
324
Jonathan Rynd
J
J
exporting from a template into a monthly excel list database
  • jake
Replies
1
Views
425
Jonathan Rynd
J
M
update value
  • mark
Replies
1
Views
273
Jonathan Rynd
J
G
Macro causing large file size.
  • Guest
Replies
1
Views
371
Jonathan Rynd
J
G
calculating the number of consecutive shifts in a 6 week schedule
  • Guest
Replies
3
Views
517
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
654
Nekdo Od Nekje
N
A
Can you make a workbook run like a program?
  • Arthur
Replies
8
Views
585
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
746
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
385
kevin
K
L
Worksheets
  • Leonard
Replies
1
Views
314
Frank Kabel
F
S
Query
  • Supriya
Replies
2
Views
209
Arvi Laanemets
A
D
Start date calculations...
  • Dave Ramage
Replies
2
Views
290
Dave Ramage
D
G
Make #Value! error blank
  • Guest
Replies
3
Views
446
Guest
G
E
Headers and Footers
  • Edgar
Replies
2
Views
389
Frank Kabel
F
S
Excel 2000 brackets on negative numbers
  • sandy
Replies
1
Views
560
Roger Whitehead
R
L
Nested formulas - formula displays instead of value
  • Leolin
Replies
3
Views
438
Frank Kabel
F
L
Sum Function Error
  • leblancds
Replies
3
Views
245
Harlan Grove
H
E
Export to text file by use " ; " as separator
  • Eva
Replies
4
Views
423
Harlan Grove
H
C
Date Arithmetic
  • Curtis Croulet
Replies
1
Views
417
Norman Harker
N
R
editing 'refers to'" box in naming dynamic ranges
  • R.VENKATARAMAN
Replies
5
Views
410
R.VENKATARAMAN
R
D
SUMIF type function for product?
  • donafuin
Replies
1
Views
471
Laura Cook
L
R
Consolidating values
  • RD Wirr
Replies
4
Views
354
RD Wirr
R
Back
Top