Microsoft Excel Worksheet Functions

Post thread
L
Multiple Condition SumProduct Ques.
  • LdoubleE80
Replies
3
Views
412
LdoubleE80
L
M
Dozens formula
  • Mark
Replies
3
Views
291
Dave R.
D
M
TIME and IF Function: over 23:59:59
  • Mediaexcel
Replies
1
Views
289
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
626
Gord Dibben
G
L
IRR/XIRR
  • Liz
Replies
1
Views
838
Harlan Grove
H
G
sumif; conditional sum
  • Guest
Replies
3
Views
493
Nancy
N
A
Excel 2000 function compatibility
  • Araten
Replies
2
Views
562
George Nicholson
G
J
AVG not including '0' or value or blank cells.
  • JEM
Replies
6
Views
662
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
406
Don Guillett
D
M
Pulling MTD totals
  • MMcCullar
Replies
2
Views
382
MMcCullar
M
G
Converting Month/Date/Year data & sorting by month/date only
  • Guest
Replies
4
Views
814
Guest
G
K
Finding the lowest price in a row
  • Karen
Replies
13
Views
682
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
541
Max
M
M
Reversing sign (+ to -) (- to +)
  • M Stokes
Replies
4
Views
645
Gord Dibben
G
A
Grouping using two columns of data...
  • AlexanderG
Replies
1
Views
285
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
344
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
485
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
402
Guest
G
S
Starting new month
  • Steved
Replies
8
Views
701
Steved
S
G
Calculated Start_DateTime and End_DateTime
  • Guest
Replies
4
Views
322
Guest
G
G
Time interval overlap with other time interval
  • Guest
Replies
2
Views
995
Max
M
D
Column counter
  • David L
Replies
2
Views
364
JE McGimpsey
J
C
Formula for Worksheet
  • cbscotty
Replies
3
Views
401
[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
517
malay_ko
M
C
Percentile Help!!!!!
  • Carmela
Replies
1
Views
560
Michael R Middleton
M
G
Time in hours.hundredths
  • Guest
Replies
2
Views
2K
Guest
G
B
v lookups
  • bob1988
Replies
4
Views
340
Alan Beban
A
Y
Help, I know there is a simple way...
  • Yuccalab
Replies
1
Views
379
Ken Wright
K
K
worksheet function
  • Kelly
Replies
5
Views
312
Ragdyer
R
L
how to reference sheetname
  • LAM Chi-fung
Replies
2
Views
493
JE McGimpsey
J
S
Calculate 5 out of 6 columns
  • sonar
Replies
7
Views
450
Frank Kabel
F
K
worksheet function
  • kelly
Replies
1
Views
237
Frank Kabel
F
F
Help
  • Fernando Duran
Replies
3
Views
202
JE McGimpsey
J
F
week number in a month
  • Frank Kabel
Replies
8
Views
642
pwz
P
G
Doubts about the VLOOKUP function
  • Guest
Replies
6
Views
695
Chip Pearson
C
B
flip lines
  • boogie
Replies
1
Views
297
Marin Kostov
M
D
Newline within a formula
  • Daner
Replies
1
Views
528
Aladin Akyurek
A
D
Format individual characters within a formula
  • Daner
Replies
1
Views
558
JE McGimpsey
J
S
Query
  • shantanu
Replies
2
Views
310
JE McGimpsey
J
J
Count #'s
  • Jason
Replies
1
Views
323
JE McGimpsey
J
S
Calendar
  • Steved
Replies
1
Views
398
Gilles Desjardins
G
J
Macro help - changing to general format?
  • John
Replies
1
Views
261
JE McGimpsey
J
Back
Top