Microsoft Excel Worksheet Functions

Post thread
V
Sorting Alphabetically
  • Vicki
Replies
3
Views
431
Shane Devenshire
S
D
Calculations in filtered columns
  • Dianeg
Replies
4
Views
353
Ashish Mathur
A
C
Sumif with an array for criteria
  • Chris
Replies
3
Views
608
T. Valko
T
C
count how many different numbers in the column and return to the n
  • CC
Replies
2
Views
370
Shane Devenshire
S
P
DMax with No Criteria
  • Paul Kraemer
Replies
2
Views
965
Shane Devenshire
S
R
repost of question from 2/4 "Using drop-down lists"
  • RoofIL
Replies
2
Views
354
Shane Devenshire
S
O
Using wildcards with logical (IF, AND) conditional formatting
  • olddog
Replies
2
Views
2K
Shane Devenshire
S
C
formula question
  • Cindy
Replies
1
Views
340
Cindy
C
T
Is Vlookup the correct way to do this?
  • tammyncook
Replies
9
Views
538
Dave Peterson
D
B
Adding text to an IF statement effeciently
  • Bishop
Replies
2
Views
439
Bishop
B
B
Conditional Formatting Not Working As Intended
  • Bishop
Replies
3
Views
657
Bishop
B
D
Compatibility Mode error w/ Defined Names
  • DocBrown
Replies
1
Views
1K
Juantonio123
J
R
Using drop-down lists
  • RoofIL
Replies
4
Views
501
Gord Dibben
G
A
Excel 2007 drop down lists
  • Angela9520
Replies
6
Views
750
Gord Dibben
G
H
Function needed to search and pull data from 1 table to another
  • Heidi
Replies
4
Views
637
Heidi
H
D
multiply criteria in a range using sumifs
  • dloc
Replies
1
Views
973
dloc
D
M
combining =SEARCH & =IF statements
  • McRibIsBack
Replies
4
Views
523
Teethless mama
T
M
Auto Fill-Down?
  • msnyc07
Replies
2
Views
466
msnyc07
M
N
Question About Sorting
  • Nancy
Replies
2
Views
343
Gord Dibben
G
M
IF Formulas
  • MR4815
Replies
2
Views
263
Bob Phillips
B
S
Formula for if name begins with and date is less than or equal to.
  • Senor Martinez
Replies
5
Views
872
Senor Martinez
S
M
Transfering a changing cell value progressively through a workbook
  • Mike1558
Replies
3
Views
542
Gord Dibben
G
P
Formula to count data in a column that falls between a range
  • Paul_UK
Replies
3
Views
668
Eduardo
E
T
limited cell movement
  • thebusinessbus
Replies
2
Views
411
Otto Moehrbach
O
W
Nested subtotals in incorrect order on large worksheets
  • 'Wyn
Replies
1
Views
765
Dave Peterson
D
J
Function needed
  • Jen_T
Replies
2
Views
352
Jen_T
J
A
Frequency
  • Amar
Replies
1
Views
418
Teethless mama
T
S
Formaula for less than date and name begins with...!!! HELP!!!
  • Senor Martinez
Replies
3
Views
569
Senor Martinez
S
S
Stopping duplication within Data validation
  • SNA400
Replies
1
Views
420
Luke M
L
C
Excluding a column from range in COUNTIF function
  • connole99
Replies
3
Views
1K
Eduardo
E
Y
Find the cell ID of last row in the column and use it in SUMIF for
  • YY san.
Replies
2
Views
754
Bob Phillips
B
S
SUMIF and text
  • Silja
Replies
3
Views
973
Silja
S
N
need help with a solution - maybe vlookup?
  • Noetic76
Replies
3
Views
450
Noetic76
N
S
data consolidation
  • Stupac
Replies
1
Views
377
Bernie Deitrick
B
D
Formula in dropdown list
  • David Pickering
Replies
2
Views
511
David Pickering
D
J
help creating a time function
  • Josh
Replies
7
Views
436
Josh
J
J
Bill Payment Form
  • JWR
Replies
6
Views
2K
Fred Smith
F
Z
#REF! error with Multiple Documents
  • zxcvbnm6000
Replies
7
Views
464
zxcvbnm6000
Z
B
list in data validation
  • benji
Replies
4
Views
564
L. Howard Kittle
L
S
printing
  • SBAIG
Replies
2
Views
297
Teethless mama
T
G
Countif - problem counting text, other text
  • gmoore3055
Replies
1
Views
399
T. Valko
T
B
simple countif formula
  • Brian
Replies
2
Views
547
Lars-Åke Aspelin
L
G
how to return mulitple corresponding values
  • Guest
2 3 4
Replies
69
Views
2K
T. Valko
T
E
selecting an item at random for QA sampling
  • Eric F.
Replies
1
Views
594
Eric F.
E
A
I wish to group my worksheets under group tabs
  • Art
Replies
1
Views
376
Dave Peterson
D
W
indirect function
  • WINDMILL
Replies
2
Views
453
Dave Peterson
D
S
if is error then "No Data", if not then average range
  • SK08
Replies
1
Views
374
Teethless mama
T
A
need a formula
  • Aaargh
Replies
7
Views
360
Aaargh
A
M
Value list
  • Maint Girl
Replies
1
Views
282
Otto Moehrbach
O
K
Switch First and Last Names
  • Karen
Replies
3
Views
327
Teethless mama
T
Back
Top