Microsoft Excel Worksheet Functions

Post thread
M
Beyond the VLOOKUP Limitation: Extracting records after the 1st re
  • Morton Detwyler
Replies
3
Views
634
Ms-Exl-Learner
M
N
Formula Based on Multiple Sheets
  • Neil M
Replies
5
Views
643
Neil M
N
A
Termination within number of days
  • Aging Termination Dates
Replies
5
Views
611
Ms-Exl-Learner
M
T
Use RANDBETWEEN form & include certain #'s in the range
  • texas7186
Replies
15
Views
862
Joe User
J
D
complex formula
  • Debi
Replies
1
Views
327
Otávio Alves Ribeiro
O
S
How can print A Id badge From a Excell Work Sheet
  • sbaby
Replies
3
Views
378
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
460
Rick Rothstein
R
A
Count non-hidden rows
  • Art
Replies
5
Views
563
Jacob Skaria
J
D
Countif question
  • Dingy101
Replies
7
Views
604
Dingy101
D
E
table lookup
  • engineer
Replies
3
Views
309
engineer
E
J
Conversions in Exel
  • John415
Replies
1
Views
282
Mike H
M
E
LOOKUP value in a table and return value in first column of same r
  • Eric_G
Replies
2
Views
690
Eric_G
E
C
how do I make "NOW" function static
  • chineshg
Replies
2
Views
881
Tom Hutchins
T
Y
Using SUMIF with dates
  • yowzers
Replies
11
Views
832
T. Valko
T
M
Sum amounts based on date field
  • MikeK
Replies
6
Views
810
MikeK
M
T
Print Range not connected
  • Tami
Replies
1
Views
311
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
552
Scott A
S
H
how do I highlight rows based on conditional formatting
  • Honkus
Replies
1
Views
461
T. Valko
T
S
Macro for multiple rows
  • sbaby
Replies
3
Views
368
sbaby
S
G
Finding and copying whole rows
  • Guest
Replies
1
Views
494
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
712
Rick Rothstein
R
G
Check for NON-presence of a string in another string
  • G.P.N.L. c.v.a.
Replies
3
Views
401
Rick Rothstein
R
P
INDEX and MATCH
  • PPL
Replies
3
Views
397
T. Valko
T
C
MedianIf multiple range and criteria
  • C.
Replies
5
Views
969
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
304
Mike H
M
H
Excel 2007
  • HeatherJ
Replies
4
Views
529
HeatherJ
H
M
Subtraction Function using cells with other functions in them
  • modemers
Replies
2
Views
667
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
741
Jacob Skaria
J
G
Can conditional formatting be used where .....
  • Gotroots
Replies
2
Views
443
Ms-Exl-Learner
M
S
vlookup based on a different cell
  • Scott A
Replies
3
Views
514
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
389
T. Valko
T
H
Text function
  • Howard
Replies
3
Views
358
L. Howard Kittle
L
F
Date Format
  • Freshman
Replies
3
Views
381
Freshman
F
H
Extract Supplier Name
  • Howard
Replies
2
Views
423
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
421
Teethless mama
T
D
how do i resize column letters in excel 2007
  • Debby
Replies
1
Views
407
T. Valko
T
A
Boolean Math
  • Art
Replies
8
Views
335
Rick Rothstein
R
T
Icons on Customized Toolbar
  • Tami
Replies
2
Views
501
Tami
T
D
Return Names From List
  • DeeCee
Replies
2
Views
339
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
496
Pete_UK
P
T
addding/omitting "x"
  • tleehh
Replies
5
Views
422
David Biddulph
D
Back
Top