Microsoft Excel Worksheet Functions

B
compare rows for a match and sum the matches
  • Bert
Replies
1
Views
13K
Glenn
G
P
Regex Syllables, Harlan Grove?
  • PJ
Replies
4
Views
281K
PJ
P
G
Trailing zeros
  • Gatz
Replies
5
Views
311K
Gatz
G
P
Why would a vlookup function stop working in excel 2003?
  • Patti
Replies
3
Views
170K
Gord Dibben
G
T
How do I calc the time difference in hh:mm for shift work?
  • TomS
Replies
10
Views
510K
Fred Smith
F
A
How to convert time expressed as a decimal to actual hours or minu
  • ascottbag-hcm
Replies
8
Views
489K
Jacqueline
J
A
How to average random cells with out counting zero?
  • Alex
Replies
1
Views
207K
Luke M
L
L
Excel Function
  • Lisa at UD
Replies
2
Views
87K
Gary''s Student
G
C
Change Color on rows, after an IF Funtion is answered
  • Cornelia
Replies
4
Views
429K
Cornelia
C
C
VLOOKUP PROBLEM
  • CLEM
Replies
2
Views
252K
CLEM
C
V
How does a module of VB work in a Worksheet?
  • VJ Sharma
Replies
1
Views
141K
Trev B
T
M
Data Tools - Consolidate Excel 2007
  • Melanie
Replies
11
Views
625K
Melanie
M
P
2 conditions for IF function?
  • Porky79
Replies
4
Views
113K
Porky79
P
P
How do I create a custom button that combines format settings?
  • PhillipB
Replies
1
Views
183K
PhillipB
P
F
Mark certain cells
  • frederico roldao
Replies
6
Views
206K
frederico roldao
F
L
Sumproduct - multiple Sum ifs
  • Louja
Replies
4
Views
112K
bosco_yip
B
H
how do i add same prefix any text or number to the large datas?
  • how do i add same prefix any text or num
Replies
1
Views
140K
Jacob Skaria
J
E
Allow Delete cells but not rows
  • Elton Law
Replies
1
Views
159K
Jacob Skaria
J
D
How to get timein hh:mm format
  • Devan
Replies
3
Views
145K
Jacob Skaria
J
F
How do I lock a section of cells in place
  • Fenig D.
Replies
1
Views
104K
Gav123
G
S
VLOOKUP Errors with Date formats
  • Sam
Replies
1
Views
161K
Conan Kelly
C
J
Getting data by calling out date
  • Jafferi
Replies
2
Views
101K
Jacob Skaria
J
D
Extract value from a text string
  • Dinesh
Replies
11
Views
1M
T. Valko
T
N
Convolution
  • Neal Carron
Replies
6
Views
485K
Dana DeLouis
D
C
count month when date is in day/month/year format
  • ccKennedy
Replies
6
Views
515K
Fred Smith
F
J
Sum a range that IS NOT NULL
  • JKELSTONE
Replies
4
Views
120K
T. Valko
T
P
formulas
  • painterman
Replies
1
Views
21K
JKELSTONE
J
B
Leap Year
  • BadBoy
Replies
7
Views
677K
JoeU2004
J
S
Pivot Tables: Excel 2003 vs Excel 2007
  • Scott
Replies
2
Views
258K
Roger Govier
R
B
Nested formula Value error
  • Beth
Replies
4
Views
394K
Dave Peterson
D
T
Bold a line
  • Thomas Roos
Replies
3
Views
81K
Rick Rothstein
R
T
Lookup Dynamic Value in a Table
  • Thomas M.
Replies
8
Views
351K
Thomas M.
T
H
How to convert "read only" to a working sheet?
  • HOWARDJASONRUBINOFSKY
Replies
1
Views
129K
Harlan Grove
H
M
Countif
  • Master T
Replies
4
Views
246K
Harlan Grove
H
K
Check for a word
  • Kashyap
Replies
18
Views
273K
Glenn
G
K
excel opens right justified
  • Kelly
Replies
8
Views
523K
Dave
D
L
calculate fractions using dates
  • lemonscented
Replies
6
Views
288K
Rick Rothstein
R
J
combining COUNTIF and OR functions
  • Josh Craig
Replies
3
Views
275K
T. Valko
T
B
Hide Alternate Rows temporarily to Edit worksheet
  • Bridget~
Replies
2
Views
36K
Luke M
L
T
Split screens
  • Tammyg
Replies
1
Views
141K
Luke M
L
O
Excel conditional format only if all cells contain values?
  • offdah3z
Replies
3
Views
318K
David Biddulph
D
M
How do I create an Inventory list using Excel
  • Michelle
Replies
1
Views
27K
Glenn
G
T
V LOOKUP
  • twins160
Replies
2
Views
80K
David Biddulph
D
M
Largest number 2
  • MAX
Replies
3
Views
209K
John
J
M
Largest number
  • MAX
Replies
4
Views
356K
Eduardo
E
C
Multiple cells to look up and return values to another spreadsheet
  • cas
Replies
1
Views
72K
[email protected]
V
S
conditional formatting is not avaible
  • Seth.Schwarzkopf
Replies
1
Views
130K
Gav123
G
F
to pull out information from certain cells of hundred identical wo
  • Frank Situmorang
Replies
7
Views
550K
Dave Peterson
D
L
count number of dates falling in the next seven days
  • Louisa
Replies
5
Views
489K
Jacob Skaria
J
E
Display time in text
  • Elton Law
Replies
5
Views
206K
Jacob Skaria
J
You must log in or register to post here.
Back
Top