Microsoft Excel Worksheet Functions

S
vlookup in different workbooks with dynamic ranges
  • steph
Replies
6
Views
562K
T. Valko
T
L
Excel 2003 - Help writing a formula to get time (w, d, h, m)
  • Lady_Aleena
2
Replies
21
Views
402K
Glenn
G
Y
Fred Smith - Extracting data
  • Yoli
Replies
1
Views
57K
Luke M
L
Y
Extract data from worksheet to worksheet
  • Yoli
Replies
6
Views
193K
Shane Devenshire
S
A
copy & pasting automatic formulas
  • AtlantaResearch
Replies
3
Views
204K
Shane Devenshire
S
O
how do i change cell text colour based on value in other cell
  • Oscarrot
Replies
2
Views
236K
Max
M
T
VBA coding for expiry dates alert threw email
  • Tia
Replies
1
Views
241K
Eduardo
E
S
National language function names
  • Stefi
Replies
2
Views
415K
Stefi
S
Z
Show only future Dates
  • Zebrageek
Replies
4
Views
95K
Max
M
R
ALPHABETIZING!
  • rebecca
Replies
2
Views
266K
Luke M
L
S
Siva and surya
  • siva
Replies
2
Views
280K
Eduardo
E
C
Using Lookup
  • Colette
Replies
1
Views
168K
Colette
C
J
Help with formula
  • Josh W
Replies
7
Views
150K
JoeU2004
J
J
countif comparing two columns
  • Johndb
Replies
4
Views
264K
Ashish Mathur
A
S
Unique data
  • Shah Alam
Replies
2
Views
23K
Jacob Skaria
J
P
Sum If with two ranges
  • Portiapuss
Replies
2
Views
263K
Mike H
M
H
Give a sheet name from a Cell
  • Hardeep Kanwar
Replies
5
Views
549K
Rick Rothstein
R
V
formula for work rosters to deduct for different breaks
  • vefl
Replies
3
Views
261K
Liliana
L
S
Formula for calculating YTD values
  • Suan
Replies
3
Views
379K
JoeU2004
J
K
display actual value
  • Kenny
Replies
1
Views
115K
Rick Rothstein
R
M
using dates for lookup
  • Mal
Replies
2
Views
304K
Max
M
A
How to read value of a cell in a relative location
  • AnatolyV
Replies
1
Views
209K
T. Valko
T
N
excel
  • neptune
Replies
1
Views
22K
Shane Devenshire
S
S
Won't copy formulas
  • Sandra
Replies
1
Views
243K
Shane Devenshire
S
A
How to add traffice light
  • Avadh
Replies
3
Views
352K
MyVeryOwnSelf
M
C
Sumproduct
  • Curtis
Replies
4
Views
289K
Curtis
C
P
Expanding beyond "Very Hidden"
  • Paul
Replies
1
Views
212K
Paul
P
P
Excel
  • Paul Rimmer
Replies
2
Views
33K
Paul Rimmer
P
R
Figuring total # of hours between multiple times
  • R P Wilson
Replies
5
Views
388K
T. Valko
T
W
linking data from one worksheet to another
  • Wilma
Replies
1
Views
164K
Otto Moehrbach
O
X
Finding the largest match
  • XJSquared
Replies
9
Views
366K
Don Guillett
D
V
Structured reference does not return correct value
  • vsoler
Replies
5
Views
129K
Teethless mama
T
B
Want more 256 column in 2007
  • Bachadega
Replies
3
Views
248K
macropod
M
H
Conditional Formatting
  • Hardeep Kanwar
Replies
8
Views
314K
Hardeep Kanwar
H
H
Equal column widths
  • Herb
Replies
1
Views
218K
Jacob Skaria
J
2
Excel
  • 2angels
Replies
1
Views
53K
Don Guillett
D
K
Extracting Data
  • klafert
Replies
9
Views
485K
Rick Rothstein
R
D
excel formula
  • digit
Replies
2
Views
52K
Don Guillett
D
T
Want to open docs in two seperate windows..not the same screen.
  • touchingrainbows
Replies
2
Views
214K
FSt1
F
G
Calculate age
  • Guest
Replies
5
Views
335K
rh33a
R
V
Index lookup with multiple match criteria
  • Vance K
Replies
5
Views
151K
haffa
H
N
Time and Date populates automatically
  • newbie_010108
Replies
4
Views
601K
newbie_010108
N
M
how do I delete cells concatenanted w/out loosing combined info
  • mngirlintx
Replies
2
Views
121K
Shane Devenshire
S
B
=TEXT(L9-K9,"h:mm") How can I sum the results to a total value
  • be013fc
Replies
4
Views
98K
Shane Devenshire
S
Z
If Formula When Contains Partial Word
  • zeetoe04
Replies
5
Views
429K
zeetoe04
Z
R
insert
  • Rajat Soni
Replies
2
Views
61K
Ashish Mathur
A
C
Calculation automatically
  • capricorngirlone
Replies
2
Views
33K
Shane Devenshire
S
G
How do I set a formula, that add next cell reference in a Formula
  • Gary
Replies
2
Views
286K
Shane Devenshire
S
L
vlookups
  • lfrick
Replies
3
Views
25K
T. Valko
T
S
Using SUMIF with a drop down.
  • Steve
Replies
3
Views
357K
Steve
S
You must log in or register to post here.
Back
Top