Microsoft Excel Worksheet Functions

Post thread
V
Sorting Alphabetically
  • Vicki
Replies
3
Views
423
Shane Devenshire
S
D
Calculations in filtered columns
  • Dianeg
Replies
4
Views
336
Ashish Mathur
A
C
Sumif with an array for criteria
  • Chris
Replies
3
Views
572
T. Valko
T
C
count how many different numbers in the column and return to the n
  • CC
Replies
2
Views
363
Shane Devenshire
S
P
DMax with No Criteria
  • Paul Kraemer
Replies
2
Views
952
Shane Devenshire
S
R
repost of question from 2/4 "Using drop-down lists"
  • RoofIL
Replies
2
Views
346
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
328
Cindy
C
T
Is Vlookup the correct way to do this?
  • tammyncook
Replies
9
Views
532
Dave Peterson
D
B
Adding text to an IF statement effeciently
  • Bishop
Replies
2
Views
417
Bishop
B
B
Conditional Formatting Not Working As Intended
  • Bishop
Replies
3
Views
629
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
464
Gord Dibben
G
A
Excel 2007 drop down lists
  • Angela9520
Replies
6
Views
712
Gord Dibben
G
H
Function needed to search and pull data from 1 table to another
  • Heidi
Replies
4
Views
621
Heidi
H
D
multiply criteria in a range using sumifs
  • dloc
Replies
1
Views
942
dloc
D
M
combining =SEARCH & =IF statements
  • McRibIsBack
Replies
4
Views
496
Teethless mama
T
M
Auto Fill-Down?
  • msnyc07
Replies
2
Views
461
msnyc07
M
N
Question About Sorting
  • Nancy
Replies
2
Views
327
Gord Dibben
G
M
IF Formulas
  • MR4815
Replies
2
Views
262
Bob Phillips
B
S
Formula for if name begins with and date is less than or equal to.
  • Senor Martinez
Replies
5
Views
849
Senor Martinez
S
M
Transfering a changing cell value progressively through a workbook
  • Mike1558
Replies
3
Views
517
Gord Dibben
G
P
Formula to count data in a column that falls between a range
  • Paul_UK
Replies
3
Views
652
Eduardo
E
T
limited cell movement
  • thebusinessbus
Replies
2
Views
403
Otto Moehrbach
O
W
Nested subtotals in incorrect order on large worksheets
  • 'Wyn
Replies
1
Views
756
Dave Peterson
D
J
Function needed
  • Jen_T
Replies
2
Views
347
Jen_T
J
A
Frequency
  • Amar
Replies
1
Views
401
Teethless mama
T
S
Formaula for less than date and name begins with...!!! HELP!!!
  • Senor Martinez
Replies
3
Views
530
Senor Martinez
S
S
Stopping duplication within Data validation
  • SNA400
Replies
1
Views
400
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
736
Bob Phillips
B
S
SUMIF and text
  • Silja
Replies
3
Views
941
Silja
S
N
need help with a solution - maybe vlookup?
  • Noetic76
Replies
3
Views
431
Noetic76
N
S
data consolidation
  • Stupac
Replies
1
Views
365
Bernie Deitrick
B
D
Formula in dropdown list
  • David Pickering
Replies
2
Views
493
David Pickering
D
J
help creating a time function
  • Josh
Replies
7
Views
391
Josh
J
J
Bill Payment Form
  • JWR
Replies
6
Views
2K
Fred Smith
F
Z
#REF! error with Multiple Documents
  • zxcvbnm6000
Replies
7
Views
415
zxcvbnm6000
Z
B
list in data validation
  • benji
Replies
4
Views
555
L. Howard Kittle
L
S
printing
  • SBAIG
Replies
2
Views
284
Teethless mama
T
G
Countif - problem counting text, other text
  • gmoore3055
Replies
1
Views
390
T. Valko
T
B
simple countif formula
  • Brian
Replies
2
Views
523
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
578
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
421
Dave Peterson
D
S
if is error then "No Data", if not then average range
  • SK08
Replies
1
Views
371
Teethless mama
T
A
need a formula
  • Aaargh
Replies
7
Views
336
Aaargh
A
M
Value list
  • Maint Girl
Replies
1
Views
281
Otto Moehrbach
O
K
Switch First and Last Names
  • Karen
Replies
3
Views
312
Teethless mama
T
Back
Top