Microsoft Excel Worksheet Functions

D
Calculations in filtered columns
  • Dianeg
Replies
4
Views
261K
Ashish Mathur
A
C
Sumif with an array for criteria
  • Chris
Replies
3
Views
357K
T. Valko
T
C
count how many different numbers in the column and return to the n
  • CC
Replies
2
Views
196K
Shane Devenshire
S
P
DMax with No Criteria
  • Paul Kraemer
Replies
2
Views
172K
Shane Devenshire
S
R
repost of question from 2/4 "Using drop-down lists"
  • RoofIL
Replies
2
Views
176K
Shane Devenshire
S
O
Using wildcards with logical (IF, AND) conditional formatting
  • olddog
Replies
2
Views
325K
Shane Devenshire
S
C
formula question
  • Cindy
Replies
1
Views
180K
Cindy
C
T
Is Vlookup the correct way to do this?
  • tammyncook
Replies
9
Views
159K
Dave Peterson
D
B
Adding text to an IF statement effeciently
  • Bishop
Replies
2
Views
117K
Bishop
B
B
Conditional Formatting Not Working As Intended
  • Bishop
Replies
3
Views
389K
Bishop
B
D
Compatibility Mode error w/ Defined Names
  • DocBrown
Replies
1
Views
227K
Juantonio123
J
R
Using drop-down lists
  • RoofIL
Replies
4
Views
541K
Gord Dibben
G
A
Excel 2007 drop down lists
  • Angela9520
Replies
6
Views
318K
Gord Dibben
G
H
Function needed to search and pull data from 1 table to another
  • Heidi
Replies
4
Views
92K
Heidi
H
D
multiply criteria in a range using sumifs
  • dloc
Replies
1
Views
202K
dloc
D
M
combining =SEARCH & =IF statements
  • McRibIsBack
Replies
4
Views
269K
Teethless mama
T
M
Auto Fill-Down?
  • msnyc07
Replies
2
Views
203K
msnyc07
M
N
Question About Sorting
  • Nancy
Replies
2
Views
145K
Gord Dibben
G
M
IF Formulas
  • MR4815
Replies
2
Views
40K
Bob Phillips
B
S
Formula for if name begins with and date is less than or equal to.
  • Senor Martinez
Replies
5
Views
182K
Senor Martinez
S
M
Transfering a changing cell value progressively through a workbook
  • Mike1558
Replies
3
Views
352K
Gord Dibben
G
P
Formula to count data in a column that falls between a range
  • Paul_UK
Replies
3
Views
284K
Eduardo
E
T
limited cell movement
  • thebusinessbus
Replies
2
Views
258K
Otto Moehrbach
O
W
Nested subtotals in incorrect order on large worksheets
  • 'Wyn
Replies
1
Views
162K
Dave Peterson
D
J
Function needed
  • Jen_T
Replies
2
Views
108K
Jen_T
J
A
Frequency
  • Amar
Replies
1
Views
166K
Teethless mama
T
S
Formaula for less than date and name begins with...!!! HELP!!!
  • Senor Martinez
Replies
3
Views
237K
Senor Martinez
S
S
Stopping duplication within Data validation
  • SNA400
Replies
1
Views
185K
Luke M
L
C
Excluding a column from range in COUNTIF function
  • connole99
Replies
3
Views
444K
Eduardo
E
Y
Find the cell ID of last row in the column and use it in SUMIF for
  • YY san.
Replies
2
Views
322K
Bob Phillips
B
S
SUMIF and text
  • Silja
Replies
3
Views
277K
Silja
S
N
need help with a solution - maybe vlookup?
  • Noetic76
Replies
3
Views
264K
Noetic76
N
S
data consolidation
  • Stupac
Replies
1
Views
180K
Bernie Deitrick
B
D
Formula in dropdown list
  • David Pickering
Replies
2
Views
333K
David Pickering
D
J
help creating a time function
  • Josh
Replies
7
Views
137K
Josh
J
J
Bill Payment Form
  • JWR
Replies
6
Views
190K
Fred Smith
F
Z
#REF! error with Multiple Documents
  • zxcvbnm6000
Replies
7
Views
296K
zxcvbnm6000
Z
B
list in data validation
  • benji
Replies
4
Views
268K
L. Howard Kittle
L
S
printing
  • SBAIG
Replies
2
Views
155K
Teethless mama
T
G
Countif - problem counting text, other text
  • gmoore3055
Replies
1
Views
69K
T. Valko
T
B
simple countif formula
  • Brian
Replies
2
Views
282K
Lars-Åke Aspelin
L
G
how to return mulitple corresponding values
  • Guest
2 3 4
Replies
69
Views
409K
T. Valko
T
E
selecting an item at random for QA sampling
  • Eric F.
Replies
1
Views
202K
Eric F.
E
A
I wish to group my worksheets under group tabs
  • Art
Replies
1
Views
16K
Dave Peterson
D
W
indirect function
  • WINDMILL
Replies
2
Views
152K
Dave Peterson
D
S
if is error then "No Data", if not then average range
  • SK08
Replies
1
Views
14K
Teethless mama
T
A
need a formula
  • Aaargh
Replies
7
Views
384K
Aaargh
A
M
Value list
  • Maint Girl
Replies
1
Views
64K
Otto Moehrbach
O
K
Switch First and Last Names
  • Karen
Replies
3
Views
74K
Teethless mama
T
R
edit a comment while protect sheet is on the cell is unprotected
  • Rubber 4 u
Replies
1
Views
171K
Gord Dibben
G
You must log in or register to post here.
Back
Top