Microsoft Excel Worksheet Functions

J
Multiple IF functions
  • Jafferi
Replies
6
Views
288K
Jafferi
J
C
how to remove spacing in between text
  • Calculate Date range
Replies
6
Views
119K
Calculate Date range
C
B
LOOKUP & MATCH syntax ??
  • Bassman62
Replies
6
Views
149K
Bassman62
B
W
how many rows away from a number to a space below
  • wolfgangea
Replies
3
Views
112K
Teethless mama
T
J
Sumproduct array
  • Jumbo Jock
Replies
6
Views
277K
Ashish Mathur
A
M
linking cells with scheduling workbook
  • MattSwift
Replies
2
Views
314K
Ashish Mathur
A
M
copying info from one workbook to another one
  • Mago
Replies
1
Views
220K
Gord Dibben
G
P
COPY RIGHT AND TRANSPOSE
  • Pam M
Replies
2
Views
467K
Gord Dibben
G
S
Conditional Formatting based on 2 criteria
  • Still learning@work
Replies
4
Views
169K
Sheeloo
S
G
Sum when one cell is blank & another cell is not blank.
  • Greta
Replies
2
Views
49K
Greta
G
R
Average formula for dates range - Excell 2007
  • Radrays
Replies
4
Views
306K
Glenn
G
T
Deleting rows (with zeros) with a macro
  • ToddS
Replies
4
Views
318K
Mike H
M
G
Can you make a cell = 0 if original function is creating a"#ref!"?
  • Guest
Replies
5
Views
39K
UpGrade
U
R
Help Counting 10 Columns * X Number of Rows
  • Rob
Replies
5
Views
156K
Rob
R
S
Lookup two factors in an array
  • sjstewart1981
Replies
1
Views
295K
Bill Johnson
B
D
IF function question
  • Dutilbug
Replies
9
Views
1M
Bob Phillips
B
C
how do I automatically open blank workbook when Excel
  • Cher1221
Replies
1
Views
213K
Dave Peterson
D
N
Truncating data in drop down list
  • Nightrain
Replies
6
Views
515K
Gord Dibben
G
J
Delete blank columns
  • Johannes_R
Replies
2
Views
301K
Archimedes' Lever
A
B
Based on data in previous column - sum of values in next column
  • Beena K
Replies
1
Views
198K
Sheeloo
S
P
Formula for the calculation needed to come up with a total
  • Phillse
Replies
5
Views
269K
JoeU2004
J
T
Last Line
  • terri
Replies
4
Views
172K
Gord Dibben
G
T
Using Sumifs
  • tomferrin
Replies
3
Views
420K
klswvu
K
K
VBA Code not working on Shared Workbook
  • KC_Cheer_Coach
Replies
3
Views
414K
Dave Peterson
D
M
lock of copy command
  • MANISH
Replies
2
Views
93K
Paul
P
E
Input "="
  • edscholar
Replies
4
Views
69K
Glenn
G
F
Macro !
  • fi.or.jp.de
Replies
1
Views
186K
Gord Dibben
G
H
Functions referencing a different workbook
  • Haydie-lady
Replies
1
Views
357K
PJFry
P
A
how to save worksheet with hard tabs
  • Alan
Replies
1
Views
106K
Dave Peterson
D
C
Extract one character
  • Carl
Replies
5
Views
412K
Carl
C
B
Figure out date from total days in year
  • bijoutery
Replies
2
Views
196K
bijoutery
B
N
How do I find arctanh() in exel
  • Neville
Replies
5
Views
452K
Neville
N
T
Training matrix
  • talalhisham
Replies
3
Views
326K
talalhisham
T
P
Displaying items from a column list in another sheet?
  • pieman3
Replies
18
Views
886K
simon
S
C
NEED TO COUNTIF WITH TWO CRITERIA
  • CAYLEY01
Replies
3
Views
278K
CAYLEY01
C
A
cell referencing problems when sorting data
  • am
Replies
9
Views
967K
D Zandveld
D
C
How can I add up multiple IF results.
  • crabflinger
Replies
3
Views
120K
Arvi Laanemets
A
J
Use Sum() with variable range
  • Jeff
Replies
4
Views
243K
Jeff
J
C
Ranking Formula
  • carl
Replies
6
Views
772K
T. Valko
T
M
Day of week Fill down column not working
  • Minion
Replies
4
Views
195K
Minion
M
L
Drop Down Box in 2003
  • Larry52
Replies
1
Views
22K
Debra Dalgleish
D
T
Run macro on all sheets
  • trey1982
Replies
3
Views
409K
Archimedes' Lever
A
R
Need help finding the last cell w/data
  • Richard
Replies
4
Views
92K
T. Valko
T
M
Need help with formula to search and compare data in different col
  • Michael
Replies
4
Views
355K
Michael
M
T
SUMMATION combined with PV formula
  • turjes
Replies
3
Views
374K
Fred Smith
F
S
Excel 2003
  • SchizJoe
Replies
1
Views
114K
TomPl
T
M
match-up formula
  • Melvin_Flint_2247
Replies
3
Views
307K
PJFry
P
J
Separate raw data onto different worksheets
  • JN
Replies
4
Views
329K
MyVeryOwnSelf
M
G
How to create a lookup table with an added varable?
  • Guest
Replies
3
Views
177K
MyVeryOwnSelf
M
R
find the second match using the match function
  • Ray
Replies
1
Views
22K
N harkawat
N
You must log in or register to post here.
Back
Top