Microsoft Excel Worksheet Functions

L
Multiple Condition SumProduct Ques.
  • LdoubleE80
Replies
3
Views
260K
LdoubleE80
L
M
Dozens formula
  • Mark
Replies
3
Views
137K
Dave R.
D
M
TIME and IF Function: over 23:59:59
  • Mediaexcel
Replies
1
Views
135K
Jason Morin
J
B
Count if for # for how many cells contain a specific date range
  • Bryan
Replies
4
Views
84K
Dave R.
D
J
Formatting Palette
  • Jeff
Replies
3
Views
62K
Gord Dibben
G
L
IRR/XIRR
  • Liz
Replies
1
Views
57K
Harlan Grove
H
G
sumif; conditional sum
  • Guest
Replies
3
Views
102K
Nancy
N
A
Excel 2000 function compatibility
  • Araten
Replies
2
Views
65K
George Nicholson
G
J
AVG not including '0' or value or blank cells.
  • JEM
Replies
6
Views
85K
Harlan Grove
H
G
Printing named range only
  • Guest
Replies
10
Views
252K
Don Guillett
D
B
Music sample attached to worksheet
  • Bill Lawrence
Replies
5
Views
42K
Don Guillett
D
M
Pulling MTD totals
  • MMcCullar
Replies
2
Views
36K
MMcCullar
M
G
Converting Month/Date/Year data & sorting by month/date only
  • Guest
Replies
4
Views
52K
Guest
G
K
Finding the lowest price in a row
  • Karen
Replies
13
Views
258K
Frank Kabel
F
M
Reversing Sign on Column of Data (Positive to Negative) (Negative to Postive)
  • M Stokes
Replies
1
Views
149K
Frank Kabel
F
J
Help Using Countif
  • John Galt
Replies
3
Views
268K
Max
M
M
Reversing sign (+ to -) (- to +)
  • M Stokes
Replies
4
Views
233K
Gord Dibben
G
A
Grouping using two columns of data...
  • AlexanderG
Replies
1
Views
53K
Frank Kabel
F
B
"Time between" calculated over midnight
  • Brad
Replies
5
Views
95K
Daniel.M
D
M
TIME and IF function
  • Mediaexcel
Replies
2
Views
430K
Mediaexcel
M
C
Calculated Item in Pivot Table
  • Christian Staffe
Replies
3
Views
69K
Debra Dalgleish
D
J
Auto open a spreadsheet
  • John
Replies
2
Views
23K
Guest
G
A
help with "if" function
  • Andy Knowles
Replies
2
Views
37K
Alan
A
C
Using lookup function to summarise data in a sheet
  • Col
Replies
4
Views
87K
onedaywhen
O
R
Conditional Formatting and File Size
  • Richard
Replies
3
Views
87K
Frank Kabel
F
G
Buger or ....? about Networkdays function
  • Guest
Replies
2
Views
71K
Guest
G
S
Starting new month
  • Steved
Replies
8
Views
130K
Steved
S
G
Calculated Start_DateTime and End_DateTime
  • Guest
Replies
4
Views
44K
Guest
G
G
Time interval overlap with other time interval
  • Guest
Replies
2
Views
161K
Max
M
D
Column counter
  • David L
Replies
2
Views
79K
JE McGimpsey
J
C
Formula for Worksheet
  • cbscotty
Replies
3
Views
75K
[email protected]
C
M
how to apply distinct (like in oracle sql) to count the rows of the same value as one
  • malay_ko
Replies
2
Views
32K
malay_ko
M
C
Percentile Help!!!!!
  • Carmela
Replies
1
Views
143K
Michael R Middleton
M
G
Time in hours.hundredths
  • Guest
Replies
2
Views
224K
Guest
G
B
v lookups
  • bob1988
Replies
4
Views
88K
Alan Beban
A
Y
Help, I know there is a simple way...
  • Yuccalab
Replies
1
Views
78K
Ken Wright
K
K
worksheet function
  • Kelly
Replies
5
Views
25K
Ragdyer
R
L
how to reference sheetname
  • LAM Chi-fung
Replies
2
Views
67K
JE McGimpsey
J
S
Calculate 5 out of 6 columns
  • sonar
Replies
7
Views
173K
Frank Kabel
F
K
worksheet function
  • kelly
Replies
1
Views
25K
Frank Kabel
F
F
Help
  • Fernando Duran
Replies
3
Views
68K
JE McGimpsey
J
F
week number in a month
  • Frank Kabel
Replies
8
Views
22K
pwz
P
G
Doubts about the VLOOKUP function
  • Guest
Replies
6
Views
102K
Chip Pearson
C
B
flip lines
  • boogie
Replies
1
Views
49K
Marin Kostov
M
D
Newline within a formula
  • Daner
Replies
1
Views
177K
Aladin Akyurek
A
D
Format individual characters within a formula
  • Daner
Replies
1
Views
161K
JE McGimpsey
J
S
Query
  • shantanu
Replies
2
Views
39K
JE McGimpsey
J
J
Count #'s
  • Jason
Replies
1
Views
50K
JE McGimpsey
J
S
Calendar
  • Steved
Replies
1
Views
351K
Gilles Desjardins
G
J
Macro help - changing to general format?
  • John
Replies
1
Views
47K
JE McGimpsey
J
You must log in or register to post here.
Back
Top