Microsoft Excel Worksheet Functions

Post thread
M
Beyond the VLOOKUP Limitation: Extracting records after the 1st re
  • Morton Detwyler
Replies
3
Views
590
Ms-Exl-Learner
M
N
Formula Based on Multiple Sheets
  • Neil M
Replies
5
Views
513
Neil M
N
A
Termination within number of days
  • Aging Termination Dates
Replies
5
Views
529
Ms-Exl-Learner
M
T
Use RANDBETWEEN form & include certain #'s in the range
  • texas7186
Replies
15
Views
825
Joe User
J
D
complex formula
  • Debi
Replies
1
Views
314
Otávio Alves Ribeiro
O
S
How can print A Id badge From a Excell Work Sheet
  • sbaby
Replies
3
Views
359
Otto Moehrbach
O
A
Question About Date Function
  • Abradaxis
Replies
4
Views
297
Gord Dibben
G
M
A complex formula, help needed
  • Mac
Replies
2
Views
442
Rick Rothstein
R
A
Count non-hidden rows
  • Art
Replies
5
Views
555
Jacob Skaria
J
D
Countif question
  • Dingy101
Replies
7
Views
563
Dingy101
D
E
table lookup
  • engineer
Replies
3
Views
285
engineer
E
J
Conversions in Exel
  • John415
Replies
1
Views
271
Mike H
M
E
LOOKUP value in a table and return value in first column of same r
  • Eric_G
Replies
2
Views
664
Eric_G
E
C
how do I make "NOW" function static
  • chineshg
Replies
2
Views
864
Tom Hutchins
T
Y
Using SUMIF with dates
  • yowzers
Replies
11
Views
729
T. Valko
T
M
Sum amounts based on date field
  • MikeK
Replies
6
Views
620
MikeK
M
T
Print Range not connected
  • Tami
Replies
1
Views
300
Tom Hutchins
T
T
CONVERT(number,from_unit,to_unit)
  • TKS_Mark
Replies
3
Views
298
Fred Smith
F
S
Formula, Pivot Table, ??? Beats me
  • Scott A
Replies
2
Views
470
Scott A
S
H
how do I highlight rows based on conditional formatting
  • Honkus
Replies
1
Views
439
T. Valko
T
S
Macro for multiple rows
  • sbaby
Replies
3
Views
352
sbaby
S
G
Finding and copying whole rows
  • Guest
Replies
1
Views
459
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
692
Rick Rothstein
R
G
Check for NON-presence of a string in another string
  • G.P.N.L. c.v.a.
Replies
3
Views
392
Rick Rothstein
R
P
INDEX and MATCH
  • PPL
Replies
3
Views
357
T. Valko
T
C
MedianIf multiple range and criteria
  • C.
Replies
5
Views
921
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
290
Mike H
M
H
Excel 2007
  • HeatherJ
Replies
4
Views
456
HeatherJ
H
M
Subtraction Function using cells with other functions in them
  • modemers
Replies
2
Views
601
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
279
dimitry scharff
D
J
remove duplicates except blanks
  • jat
Replies
2
Views
739
Jacob Skaria
J
G
Can conditional formatting be used where .....
  • Gotroots
Replies
2
Views
422
Ms-Exl-Learner
M
S
vlookup based on a different cell
  • Scott A
Replies
3
Views
485
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
382
T. Valko
T
H
Text function
  • Howard
Replies
3
Views
349
L. Howard Kittle
L
F
Date Format
  • Freshman
Replies
3
Views
350
Freshman
F
H
Extract Supplier Name
  • Howard
Replies
2
Views
412
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
392
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
330
Rick Rothstein
R
T
Icons on Customized Toolbar
  • Tami
Replies
2
Views
480
Tami
T
D
Return Names From List
  • DeeCee
Replies
2
Views
322
Otávio Alves Ribeiro
O
M
sum only if a certain cell contains a date
  • mimsly17
Replies
2
Views
364
Fred Smith
F
C
Counting only displayed cells in the column
  • CEG_Staffer
Replies
3
Views
476
Pete_UK
P
T
addding/omitting "x"
  • tleehh
Replies
5
Views
394
David Biddulph
D
Back
Top