Microsoft Excel Worksheet Functions

Post thread
V
Sorting Alphabetically
  • Vicki
Replies
3
Views
437
Shane Devenshire
S
D
Calculations in filtered columns
  • Dianeg
Replies
4
Views
361
Ashish Mathur
A
C
Sumif with an array for criteria
  • Chris
Replies
3
Views
620
T. Valko
T
C
count how many different numbers in the column and return to the n
  • CC
Replies
2
Views
375
Shane Devenshire
S
P
DMax with No Criteria
  • Paul Kraemer
Replies
2
Views
969
Shane Devenshire
S
R
repost of question from 2/4 "Using drop-down lists"
  • RoofIL
Replies
2
Views
358
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
347
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
441
Bishop
B
B
Conditional Formatting Not Working As Intended
  • Bishop
Replies
3
Views
664
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
522
Gord Dibben
G
A
Excel 2007 drop down lists
  • Angela9520
Replies
6
Views
753
Gord Dibben
G
H
Function needed to search and pull data from 1 table to another
  • Heidi
Replies
4
Views
642
Heidi
H
D
multiply criteria in a range using sumifs
  • dloc
Replies
1
Views
980
dloc
D
M
combining =SEARCH & =IF statements
  • McRibIsBack
Replies
4
Views
534
Teethless mama
T
M
Auto Fill-Down?
  • msnyc07
Replies
2
Views
472
msnyc07
M
N
Question About Sorting
  • Nancy
Replies
2
Views
353
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
881
Senor Martinez
S
M
Transfering a changing cell value progressively through a workbook
  • Mike1558
Replies
3
Views
580
Gord Dibben
G
P
Formula to count data in a column that falls between a range
  • Paul_UK
Replies
3
Views
684
Eduardo
E
T
limited cell movement
  • thebusinessbus
Replies
2
Views
416
Otto Moehrbach
O
W
Nested subtotals in incorrect order on large worksheets
  • 'Wyn
Replies
1
Views
768
Dave Peterson
D
J
Function needed
  • Jen_T
Replies
2
Views
355
Jen_T
J
A
Frequency
  • Amar
Replies
1
Views
425
Teethless mama
T
S
Formaula for less than date and name begins with...!!! HELP!!!
  • Senor Martinez
Replies
3
Views
574
Senor Martinez
S
S
Stopping duplication within Data validation
  • SNA400
Replies
1
Views
426
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
853
Bob Phillips
B
S
SUMIF and text
  • Silja
Replies
3
Views
984
Silja
S
N
need help with a solution - maybe vlookup?
  • Noetic76
Replies
3
Views
452
Noetic76
N
S
data consolidation
  • Stupac
Replies
1
Views
380
Bernie Deitrick
B
D
Formula in dropdown list
  • David Pickering
Replies
2
Views
529
David Pickering
D
J
help creating a time function
  • Josh
Replies
7
Views
438
Josh
J
J
Bill Payment Form
  • JWR
Replies
6
Views
2K
Fred Smith
F
Z
#REF! error with Multiple Documents
  • zxcvbnm6000
Replies
7
Views
470
zxcvbnm6000
Z
B
list in data validation
  • benji
Replies
4
Views
570
L. Howard Kittle
L
S
printing
  • SBAIG
Replies
2
Views
310
Teethless mama
T
G
Countif - problem counting text, other text
  • gmoore3055
Replies
1
Views
400
T. Valko
T
B
simple countif formula
  • Brian
Replies
2
Views
557
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
600
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
456
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
361
Aaargh
A
M
Value list
  • Maint Girl
Replies
1
Views
282
Otto Moehrbach
O
K
Switch First and Last Names
  • Karen
Replies
3
Views
328
Teethless mama
T
Back
Top