Microsoft Excel Worksheet Functions

K
SUMPRODUCT AND LEFT
  • K
Replies
6
Views
344K
K
K
P
simple formula
  • Paul
Replies
2
Views
93K
Rick Rothstein \(MVP - VB\)
R
C
Conditional Formatting, Date
  • chickalina
Replies
4
Views
191K
JuanMarin
J
B
returning calculation based on number
  • byrddog75
Replies
3
Views
104K
Tim Zych
T
M
Inserting rows automatically.
  • Ms. Oliver
Replies
2
Views
210K
Lars-Åke Aspelin
L
K
XIRR Function - #NUM error
  • KevinGH
Replies
4
Views
339K
Ron Rosenfeld
R
R
converting hourly values into daily values
  • Reza
Replies
4
Views
453K
Reza
R
Y
OLD PROBLEM without SOLUTION , part ||
  • ytayta555
Replies
1
Views
352K
ytayta555
Y
D
#n/a in table data table output
  • dave
Replies
2
Views
37K
dave
D
P
Percent Function Help
  • Pauline
Replies
11
Views
1M
Spiky
S
B
converting hour values to day mean values
  • Baffe
Replies
6
Views
304K
Max
M
K
Referencing Cells in a Summary page
  • Katintn
Replies
5
Views
545K
Katintn
K
M
Pivot Tables - Can you just list data and not SUM
  • mike
Replies
2
Views
122K
Debra Dalgleish
D
H
match 2 columns and return value of another
  • Haz
Replies
1
Views
255K
Don Guillett
D
J
SUMPRODUCT question
  • Jock
Replies
3
Views
242K
Per Jessen
P
P
exact differnce between 2 dates & time networkdays give round off
  • panks
Replies
1
Views
124K
Bob Phillips
B
A
Conditional Formatting - 3 Rules - Excel 2000
  • AT
Replies
5
Views
305K
Max
M
K
Insert Row - Stop Automatic Formula Update
  • Kevin
Replies
1
Views
196K
Dennis
D
C
Random numbers from several ranges
  • ChrisSafety
Replies
3
Views
437K
Jarek Kujawa
J
S
Can you change normal numbers to ordinal numbers ?
  • sergio789
Replies
1
Views
75K
T. Valko
T
R
Multiple Questions about adding different cells
  • Redsphynx
Replies
8
Views
636K
Redsphynx
R
M
removing duplicate entries in multiple worksheets
  • monkeytrader
Replies
1
Views
230K
Teethless mama
T
D
Adding multiple cell totals
  • D
Replies
2
Views
20K
D
D
F
Pivot tables
  • Farid
Replies
3
Views
380K
ryguy7272
R
D
comparing data in different rows
  • Daniel
Replies
4
Views
273K
Max
M
L
vlookup MAYBE???
  • lost and confused in excel-land
Replies
3
Views
241K
Max
M
B
Multiple value lookups from a table to select & sum data from colu
  • brettster999
Replies
6
Views
436K
Max
M
G
converting question; function, formula, or coding?
  • gtrask
Replies
4
Views
238K
Pete_UK
P
S
DSUM Criteria - find exact match only
  • Sandy
Replies
1
Views
205K
Peo Sjoblom
P
P
Perform a calculation on same cell across many worksheets
  • Pat Adams
Replies
1
Views
309K
Gord Dibben
G
C
formula ending with a letter
  • Cynthia
Replies
3
Views
36K
Gord Dibben
G
C
Countif w/semicolon separated values AND Filter
  • crazymfr
Replies
1
Views
292K
T. Valko
T
C
Countif w/semicolon separated values
  • crazymfr
Replies
4
Views
346K
T. Valko
T
J
Calculating totals of material with feet and inches
  • Julleanna
Replies
2
Views
159K
Gary Brown
G
B
countif from different worksheets
  • BeefDr
Replies
2
Views
280K
BeefDr
B
H
Summing across multiple worksheets
  • HL
Replies
3
Views
189K
Bob Phillips
B
L
combine or if
  • littlelouise1
Replies
4
Views
39K
Dave Peterson
D
P
Calculating eligibility dates
  • PH@tic
Replies
4
Views
116K
PH@tic
P
J
Differences between Dates
  • Jack
Replies
5
Views
467K
JBoyer
J
C
mutiple if statements that then compute a value
  • cmac
Replies
1
Views
150K
Pete_UK
P
B
How to count...
  • Briana
Replies
2
Views
67K
Pete_UK
P
B
HELP!!! Text count?
  • Briana
Replies
1
Views
86K
Pete_UK
P
T
Hide sheets
  • Tia
Replies
3
Views
232K
Otto Moehrbach
O
H
Still problems with calculation of time
  • H. Nissen
Replies
5
Views
488K
H. Nissen
H
C
Error of slope taking into account error of the data points
  • cer144
Replies
5
Views
156K
Pete_UK
P
P
Linked Lists / Data Validation - Excel 97
  • Phendrena
Replies
1
Views
136K
Gary Brown
G
R
Autopopulate text from multiple tabs into list.
  • Rewbie
Replies
2
Views
260K
Otto Moehrbach
O
L
Help with blank cells when concatenating
  • LM
Replies
11
Views
392K
Spiky
S
S
SUMIF FUNCTION
  • Susan
Replies
5
Views
594K
Max
M
A
Dynamic Table
  • Agarb Carvalho
Replies
1
Views
72K
Gary Brown
G
You must log in or register to post here.
Back
Top