Microsoft Excel Worksheet Functions

Post thread
M
Beyond the VLOOKUP Limitation: Extracting records after the 1st re
  • Morton Detwyler
Replies
3
Views
597
Ms-Exl-Learner
M
N
Formula Based on Multiple Sheets
  • Neil M
Replies
5
Views
535
Neil M
N
A
Termination within number of days
  • Aging Termination Dates
Replies
5
Views
547
Ms-Exl-Learner
M
T
Use RANDBETWEEN form & include certain #'s in the range
  • texas7186
Replies
15
Views
828
Joe User
J
D
complex formula
  • Debi
Replies
1
Views
317
Otávio Alves Ribeiro
O
S
How can print A Id badge From a Excell Work Sheet
  • sbaby
Replies
3
Views
362
Otto Moehrbach
O
A
Question About Date Function
  • Abradaxis
Replies
4
Views
304
Gord Dibben
G
M
A complex formula, help needed
  • Mac
Replies
2
Views
443
Rick Rothstein
R
A
Count non-hidden rows
  • Art
Replies
5
Views
555
Jacob Skaria
J
D
Countif question
  • Dingy101
Replies
7
Views
567
Dingy101
D
E
table lookup
  • engineer
Replies
3
Views
289
engineer
E
J
Conversions in Exel
  • John415
Replies
1
Views
275
Mike H
M
E
LOOKUP value in a table and return value in first column of same r
  • Eric_G
Replies
2
Views
667
Eric_G
E
C
how do I make "NOW" function static
  • chineshg
Replies
2
Views
866
Tom Hutchins
T
Y
Using SUMIF with dates
  • yowzers
Replies
11
Views
742
T. Valko
T
M
Sum amounts based on date field
  • MikeK
Replies
6
Views
671
MikeK
M
T
Print Range not connected
  • Tami
Replies
1
Views
303
Tom Hutchins
T
T
CONVERT(number,from_unit,to_unit)
  • TKS_Mark
Replies
3
Views
300
Fred Smith
F
S
Formula, Pivot Table, ??? Beats me
  • Scott A
Replies
2
Views
498
Scott A
S
H
how do I highlight rows based on conditional formatting
  • Honkus
Replies
1
Views
446
T. Valko
T
S
Macro for multiple rows
  • sbaby
Replies
3
Views
356
sbaby
S
G
Finding and copying whole rows
  • Guest
Replies
1
Views
475
Gord Dibben
G
E
How to get rid of #Value when multiplying
  • erika rock
Replies
1
Views
1K
Peo Sjoblom
P
S
Settign a Maximum and Minimum Row Height
  • Stephen
Replies
1
Views
695
Rick Rothstein
R
G
Check for NON-presence of a string in another string
  • G.P.N.L. c.v.a.
Replies
3
Views
393
Rick Rothstein
R
P
INDEX and MATCH
  • PPL
Replies
3
Views
359
T. Valko
T
C
MedianIf multiple range and criteria
  • C.
Replies
5
Views
931
T. Valko
T
R
Subtotals (outline) features grayed out
  • Rubystarx
Replies
2
Views
2K
Kelly Gates
K
M
Formula to return data using hyperlink?
  • Mohamed
Replies
2
Views
293
Mike H
M
H
Excel 2007
  • HeatherJ
Replies
4
Views
474
HeatherJ
H
M
Subtraction Function using cells with other functions in them
  • modemers
Replies
2
Views
633
Paul C
P
J
3 tier incentive matrix w/ infinite possibilities
  • jjones
Replies
7
Views
2K
Pete_UK
P
D
Monthly files
  • dimitry scharff
Replies
2
Views
280
dimitry scharff
D
J
remove duplicates except blanks
  • jat
Replies
2
Views
740
Jacob Skaria
J
G
Can conditional formatting be used where .....
  • Gotroots
Replies
2
Views
433
Ms-Exl-Learner
M
S
vlookup based on a different cell
  • Scott A
Replies
3
Views
490
Pete_UK
P
J
How do I produce consecutive invoice numbers in Excel?
  • John Z
Replies
4
Views
1K
John Z
J
G
Max Cell Value
  • Guest
Replies
5
Views
387
T. Valko
T
H
Text function
  • Howard
Replies
3
Views
349
L. Howard Kittle
L
F
Date Format
  • Freshman
Replies
3
Views
351
Freshman
F
H
Extract Supplier Name
  • Howard
Replies
2
Views
413
Jacob Skaria
J
I
How do I convert dd/mm/yy date format to yyddd Julian date format
  • itzy bitzy
Replies
7
Views
2K
Rick Rothstein
R
K
Subtotaling
  • Katie
Replies
1
Views
399
Teethless mama
T
D
how do i resize column letters in excel 2007
  • Debby
Replies
1
Views
399
T. Valko
T
A
Boolean Math
  • Art
Replies
8
Views
335
Rick Rothstein
R
T
Icons on Customized Toolbar
  • Tami
Replies
2
Views
489
Tami
T
D
Return Names From List
  • DeeCee
Replies
2
Views
326
Otávio Alves Ribeiro
O
M
sum only if a certain cell contains a date
  • mimsly17
Replies
2
Views
366
Fred Smith
F
C
Counting only displayed cells in the column
  • CEG_Staffer
Replies
3
Views
480
Pete_UK
P
T
addding/omitting "x"
  • tleehh
Replies
5
Views
406
David Biddulph
D
Back
Top