Microsoft Excel Worksheet Functions

M
Sum only cells with text in a neighbouring cell
  • matt_the_brum
Replies
11
Views
112K
Ron Rosenfeld
R
J
Pivot Table new items as bold
  • jale
Replies
2
Views
30K
jale
J
M
a new VLOOKUP ?
  • MIKEKBR
Replies
1
Views
56K
Jonathan Rynd
J
K
Adding numbers continously in multiple cells
  • KMF
Replies
1
Views
58K
Jonathan Rynd
J
W
AVERAGE function using arrays
  • WANDO
Replies
2
Views
118K
WANDO
W
B
How to find differnces between 2 files
  • BLanca
Replies
1
Views
102K
Dave R.
D
R
Calculating time
  • Robert King
Replies
3
Views
61K
Guest
G
G
Linking contents of Worksheets
  • Guest
Replies
5
Views
154K
Guest
G
G
Absolutes when linking
  • GS
Replies
1
Views
18K
Bernard Liengme
B
S
Date Formula
  • Stephanie
Replies
2
Views
154K
Stephanie
S
J
Finding "links to other data sources"
  • Jeff
Replies
7
Views
83K
Joe
J
D
Sum Function returns zero
  • Dee
Replies
2
Views
142K
Peo Sjoblom
P
R
VBA question
  • Robert Nguyen
Replies
5
Views
213K
Robert
R
D
lookup_value variable
  • Dar
Replies
1
Views
184K
Peo Sjoblom
P
G
Insertng Blank row below subtotal
  • Guest
Replies
4
Views
46K
Guest
G
G
Autobackup location changing
  • Guest
Replies
1
Views
20K
Jonathan Rynd
J
G
OFFSET cell references
  • Gary Thomson
Replies
3
Views
255K
Peo Sjoblom
P
M
MATCH a Web Query
  • mpduffey
Replies
1
Views
14K
Jonathan Rynd
J
G
Function Statements
  • Guest
Replies
4
Views
54K
Guest
G
E
Using ADDRESS results in another formula
  • erik
Replies
1
Views
35K
Jonathan Rynd
J
D
Insert Hyperlink Macro
  • Dave McLachlan
Replies
1
Views
160K
Jonathan Rynd
J
L
Allocating values in proportion to a known value
  • ltclgc
Replies
1
Views
80K
Jonathan Rynd
J
A
Copying pivot table results
  • Alex
Replies
5
Views
52K
Guest
G
D
Assigning a macro
  • deepakj
Replies
1
Views
23K
Jonathan Rynd
J
M
Relative transfer of data from the last sheet
  • Mahendra
Replies
2
Views
88K
Bernie Deitrick
B
S
Importing From Excel To Outlook (Ofc 2000/XP Pro)
  • Susan Gerstenmaier
Replies
1
Views
55K
Jonathan Rynd
J
J
exporting from a template into a monthly excel list database
  • jake
Replies
1
Views
39K
Jonathan Rynd
J
M
update value
  • mark
Replies
1
Views
63K
Jonathan Rynd
J
G
Macro causing large file size.
  • Guest
Replies
1
Views
65K
Jonathan Rynd
J
G
calculating the number of consecutive shifts in a 6 week schedule
  • Guest
Replies
3
Views
302K
Jonathan Rynd
J
K
Custom # formats
  • Keyur
Replies
1
Views
103K
Norman Harker
N
N
Using VBA function as worksheet function?
  • Nekdo Od Nekje
Replies
3
Views
104K
Nekdo Od Nekje
N
A
Can you make a workbook run like a program?
  • Arthur
Replies
8
Views
66K
Kurt
K
D
Opening of excel
  • David
Replies
4
Views
215K
Guest
G
K
Macro to sort a range in ascending order
  • Kerrick Sawyers
Replies
1
Views
47K
Norman Harker
N
F
Data validation using external cell contents
  • Frozen_Smoke
Replies
3
Views
44K
Frozen_Smoke
F
K
copying and controling a formula cell to cell
  • kevin
Replies
5
Views
97K
kevin
K
L
Worksheets
  • Leonard
Replies
1
Views
46K
Frank Kabel
F
S
Query
  • Supriya
Replies
2
Views
79K
Arvi Laanemets
A
D
Start date calculations...
  • Dave Ramage
Replies
2
Views
105K
Dave Ramage
D
G
Make #Value! error blank
  • Guest
Replies
3
Views
277K
Guest
G
E
Headers and Footers
  • Edgar
Replies
2
Views
154K
Frank Kabel
F
S
Excel 2000 brackets on negative numbers
  • sandy
Replies
1
Views
92K
Roger Whitehead
R
L
Nested formulas - formula displays instead of value
  • Leolin
Replies
3
Views
215K
Frank Kabel
F
L
Sum Function Error
  • leblancds
Replies
3
Views
163K
Harlan Grove
H
E
Export to text file by use " ; " as separator
  • Eva
Replies
4
Views
31K
Harlan Grove
H
C
Date Arithmetic
  • Curtis Croulet
Replies
1
Views
63K
Norman Harker
N
R
editing 'refers to'" box in naming dynamic ranges
  • R.VENKATARAMAN
Replies
5
Views
33K
R.VENKATARAMAN
R
D
SUMIF type function for product?
  • donafuin
Replies
1
Views
152K
Laura Cook
L
R
Consolidating values
  • RD Wirr
Replies
4
Views
71K
RD Wirr
R
You must log in or register to post here.
Back
Top