Microsoft Excel Worksheet Functions

Post thread
L
Multiple Condition SumProduct Ques.
  • LdoubleE80
Replies
3
Views
401
LdoubleE80
L
M
Dozens formula
  • Mark
Replies
3
Views
290
Dave R.
D
M
TIME and IF Function: over 23:59:59
  • Mediaexcel
Replies
1
Views
285
Jason Morin
J
B
Count if for # for how many cells contain a specific date range
  • Bryan
Replies
4
Views
2K
Dave R.
D
J
Formatting Palette
  • Jeff
Replies
3
Views
623
Gord Dibben
G
L
IRR/XIRR
  • Liz
Replies
1
Views
834
Harlan Grove
H
G
sumif; conditional sum
  • Guest
Replies
3
Views
492
Nancy
N
A
Excel 2000 function compatibility
  • Araten
Replies
2
Views
560
George Nicholson
G
J
AVG not including '0' or value or blank cells.
  • JEM
Replies
6
Views
660
Harlan Grove
H
G
Printing named range only
  • Guest
Replies
10
Views
428
Don Guillett
D
B
Music sample attached to worksheet
  • Bill Lawrence
Replies
5
Views
404
Don Guillett
D
M
Pulling MTD totals
  • MMcCullar
Replies
2
Views
381
MMcCullar
M
G
Converting Month/Date/Year data & sorting by month/date only
  • Guest
Replies
4
Views
806
Guest
G
K
Finding the lowest price in a row
  • Karen
Replies
13
Views
665
Frank Kabel
F
M
Reversing Sign on Column of Data (Positive to Negative) (Negative to Postive)
  • M Stokes
Replies
1
Views
1K
Frank Kabel
F
J
Help Using Countif
  • John Galt
Replies
3
Views
527
Max
M
M
Reversing sign (+ to -) (- to +)
  • M Stokes
Replies
4
Views
621
Gord Dibben
G
A
Grouping using two columns of data...
  • AlexanderG
Replies
1
Views
284
Frank Kabel
F
B
"Time between" calculated over midnight
  • Brad
Replies
5
Views
699
Daniel.M
D
M
TIME and IF function
  • Mediaexcel
Replies
2
Views
6K
Mediaexcel
M
C
Calculated Item in Pivot Table
  • Christian Staffe
Replies
3
Views
3K
Debra Dalgleish
D
J
Auto open a spreadsheet
  • John
Replies
2
Views
340
Guest
G
A
help with "if" function
  • Andy Knowles
Replies
2
Views
258
Alan
A
C
Using lookup function to summarise data in a sheet
  • Col
Replies
4
Views
481
onedaywhen
O
R
Conditional Formatting and File Size
  • Richard
Replies
3
Views
5K
Frank Kabel
F
G
Buger or ....? about Networkdays function
  • Guest
Replies
2
Views
401
Guest
G
S
Starting new month
  • Steved
Replies
8
Views
699
Steved
S
G
Calculated Start_DateTime and End_DateTime
  • Guest
Replies
4
Views
321
Guest
G
G
Time interval overlap with other time interval
  • Guest
Replies
2
Views
979
Max
M
D
Column counter
  • David L
Replies
2
Views
362
JE McGimpsey
J
C
Formula for Worksheet
  • cbscotty
Replies
3
Views
399
[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
516
malay_ko
M
C
Percentile Help!!!!!
  • Carmela
Replies
1
Views
556
Michael R Middleton
M
G
Time in hours.hundredths
  • Guest
Replies
2
Views
2K
Guest
G
B
v lookups
  • bob1988
Replies
4
Views
337
Alan Beban
A
Y
Help, I know there is a simple way...
  • Yuccalab
Replies
1
Views
377
Ken Wright
K
K
worksheet function
  • Kelly
Replies
5
Views
305
Ragdyer
R
L
how to reference sheetname
  • LAM Chi-fung
Replies
2
Views
492
JE McGimpsey
J
S
Calculate 5 out of 6 columns
  • sonar
Replies
7
Views
445
Frank Kabel
F
K
worksheet function
  • kelly
Replies
1
Views
236
Frank Kabel
F
F
Help
  • Fernando Duran
Replies
3
Views
201
JE McGimpsey
J
F
week number in a month
  • Frank Kabel
Replies
8
Views
641
pwz
P
G
Doubts about the VLOOKUP function
  • Guest
Replies
6
Views
689
Chip Pearson
C
B
flip lines
  • boogie
Replies
1
Views
293
Marin Kostov
M
D
Newline within a formula
  • Daner
Replies
1
Views
521
Aladin Akyurek
A
D
Format individual characters within a formula
  • Daner
Replies
1
Views
555
JE McGimpsey
J
S
Query
  • shantanu
Replies
2
Views
308
JE McGimpsey
J
J
Count #'s
  • Jason
Replies
1
Views
323
JE McGimpsey
J
S
Calendar
  • Steved
Replies
1
Views
388
Gilles Desjardins
G
J
Macro help - changing to general format?
  • John
Replies
1
Views
260
JE McGimpsey
J
Back
Top