Microsoft Excel Worksheet Functions

Post thread
V
Sorting Alphabetically
  • Vicki
Replies
3
Views
422
Shane Devenshire
S
D
Calculations in filtered columns
  • Dianeg
Replies
4
Views
334
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
361
Shane Devenshire
S
P
DMax with No Criteria
  • Paul Kraemer
Replies
2
Views
950
Shane Devenshire
S
R
repost of question from 2/4 "Using drop-down lists"
  • RoofIL
Replies
2
Views
343
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
325
Cindy
C
T
Is Vlookup the correct way to do this?
  • tammyncook
Replies
9
Views
530
Dave Peterson
D
B
Adding text to an IF statement effeciently
  • Bishop
Replies
2
Views
414
Bishop
B
B
Conditional Formatting Not Working As Intended
  • Bishop
Replies
3
Views
626
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
460
Gord Dibben
G
A
Excel 2007 drop down lists
  • Angela9520
Replies
6
Views
708
Gord Dibben
G
H
Function needed to search and pull data from 1 table to another
  • Heidi
Replies
4
Views
619
Heidi
H
D
multiply criteria in a range using sumifs
  • dloc
Replies
1
Views
940
dloc
D
M
combining =SEARCH & =IF statements
  • McRibIsBack
Replies
4
Views
492
Teethless mama
T
M
Auto Fill-Down?
  • msnyc07
Replies
2
Views
458
msnyc07
M
N
Question About Sorting
  • Nancy
Replies
2
Views
325
Gord Dibben
G
M
IF Formulas
  • MR4815
Replies
2
Views
259
Bob Phillips
B
S
Formula for if name begins with and date is less than or equal to.
  • Senor Martinez
Replies
5
Views
848
Senor Martinez
S
M
Transfering a changing cell value progressively through a workbook
  • Mike1558
Replies
3
Views
515
Gord Dibben
G
P
Formula to count data in a column that falls between a range
  • Paul_UK
Replies
3
Views
650
Eduardo
E
T
limited cell movement
  • thebusinessbus
Replies
2
Views
401
Otto Moehrbach
O
W
Nested subtotals in incorrect order on large worksheets
  • 'Wyn
Replies
1
Views
754
Dave Peterson
D
J
Function needed
  • Jen_T
Replies
2
Views
345
Jen_T
J
A
Frequency
  • Amar
Replies
1
Views
399
Teethless mama
T
S
Formaula for less than date and name begins with...!!! HELP!!!
  • Senor Martinez
Replies
3
Views
528
Senor Martinez
S
S
Stopping duplication within Data validation
  • SNA400
Replies
1
Views
398
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
735
Bob Phillips
B
S
SUMIF and text
  • Silja
Replies
3
Views
940
Silja
S
N
need help with a solution - maybe vlookup?
  • Noetic76
Replies
3
Views
428
Noetic76
N
S
data consolidation
  • Stupac
Replies
1
Views
362
Bernie Deitrick
B
D
Formula in dropdown list
  • David Pickering
Replies
2
Views
491
David Pickering
D
J
help creating a time function
  • Josh
Replies
7
Views
389
Josh
J
J
Bill Payment Form
  • JWR
Replies
6
Views
2K
Fred Smith
F
Z
#REF! error with Multiple Documents
  • zxcvbnm6000
Replies
7
Views
413
zxcvbnm6000
Z
B
list in data validation
  • benji
Replies
4
Views
552
L. Howard Kittle
L
S
printing
  • SBAIG
Replies
2
Views
282
Teethless mama
T
G
Countif - problem counting text, other text
  • gmoore3055
Replies
1
Views
388
T. Valko
T
B
simple countif formula
  • Brian
Replies
2
Views
522
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
577
Eric F.
E
A
I wish to group my worksheets under group tabs
  • Art
Replies
1
Views
374
Dave Peterson
D
W
indirect function
  • WINDMILL
Replies
2
Views
417
Dave Peterson
D
S
if is error then "No Data", if not then average range
  • SK08
Replies
1
Views
369
Teethless mama
T
A
need a formula
  • Aaargh
Replies
7
Views
334
Aaargh
A
M
Value list
  • Maint Girl
Replies
1
Views
279
Otto Moehrbach
O
K
Switch First and Last Names
  • Karen
Replies
3
Views
309
Teethless mama
T
Back
Top