Microsoft Excel Worksheet Functions

Q
sumif any text is criteria
  • Question, Mark
Replies
4
Views
138K
Ashish Mathur
A
L
Std Dev of Aged Inventory
  • LB
Replies
3
Views
33K
JoeU2004
J
S
Search a name in one sheet and entry it into another sheet
  • Shilpi
Replies
4
Views
337K
Shilpi
S
S
Auto-adjust formulas
  • se7098
Replies
3
Views
131K
Ashish Mathur
A
L
Automatically add a column to summary sheet if another worksheet i
  • Living Design
Replies
2
Views
249K
Living Design
L
I
repeating the answer in A2 cell to A3:A20
  • Igneshwara reddy
Replies
3
Views
450K
T. Valko
T
M
repeat row labels in pivot table
  • mhead
Replies
2
Views
282K
Fred Smith
F
I
Determine decimal
  • Ithaca
Replies
5
Views
476K
Ithaca
I
E
How do I locate cells that contain a certain text?
  • EZ-XLS
Replies
2
Views
173K
Don Guillett
D
S
Lookup 2 values and return a third
  • Sh
Replies
1
Views
200K
Bernard Liengme
B
M
COUNT and SUM (please help!)
  • Mrs T.
Replies
11
Views
835K
Mrs T.
M
P
Hiding Formula Answers in Specific Cells
  • pen
Replies
1
Views
321K
Pete_UK
P
R
days and time functions
  • raogv
Replies
6
Views
141K
John_Franco
J
E
How can I stack worksheets (I have 30 worksheets)
  • Eastendkid
Replies
3
Views
222K
Dave Peterson
D
A
Countif range contains part of a value
  • antwaan
Replies
10
Views
421K
Glenn
G
J
ifblank function
  • jones.derek
Replies
5
Views
41K
Glenn
G
U
To work out how many days, weeks, months to I retire on 20 Sep 201
  • Using the date functions
Replies
8
Views
417K
Using the date functions
U
P
Conditional formula based on 2 pre-conditions
  • PSmith
Replies
4
Views
161K
PSmith
P
A
How do I get my Excel 2007 worksheet to go beyond 65536 rows?
  • Alan
Replies
1
Views
337K
Bernard Liengme
B
G
=sum
  • gma
Replies
5
Views
198K
gma
G
M
COUNT and SUM
  • Mrs T.
Replies
5
Views
587K
Ashish Mathur
A
J
Removing Mulitple Carriage Returns Within a Concantenate Formula
  • Jane
Replies
2
Views
178K
Jacob Skaria
J
M
copy conditional format without using format painter
  • MsConfused
Replies
2
Views
291K
MsConfused
M
B
return second or third word in a cell
  • birdgirl31
Replies
10
Views
555K
Jacob Skaria
J
L
Background and Calendar
  • lbdas311
Replies
2
Views
36K
TechGuy
T
K
How to set up a devilery schedule calendar from excel database
  • KKL 2009
Replies
2
Views
151K
TechGuy
T
J
Formula/Sum Question
  • Jon the Contractor
Replies
2
Views
172K
T. Valko
T
M
Sheet direction, extract data from comment
  • MFS
Replies
2
Views
116K
Ashish Mathur
A
D
Displaying Cell Formulas (without using Tools/Options/View-Formula
  • DSMessenger
Replies
6
Views
258K
Ashish Mathur
A
W
Duplicating check boxes with formulas
  • wcollatz
Replies
1
Views
175K
joel
J
J
Problem with VLOOKUP
  • Jarek
Replies
4
Views
463K
Jarek
J
I
Need a fresh pair of eyes
  • ibvalentine
Replies
11
Views
118K
John
J
M
count across 3 columns
  • Mrs T.
Replies
8
Views
447K
T. Valko
T
C
Column Titles
  • CHUCK G.
Replies
2
Views
128K
JoeU2004
J
K
address of first and last number in a row
  • Kobus
Replies
5
Views
432K
T. Valko
T
A
Duplicate Difficulties
  • :: Amy ::
Replies
5
Views
314K
Dennis Tucker
D
Z
Counting the number of occurrences...
  • Zakhary
Replies
2
Views
324K
T. Valko
T
H
How to reference last non-blank cell value from a column cells?
  • Hal J
Replies
2
Views
367K
T. Valko
T
D
Display Multiple Worksheets
  • docfat
Replies
4
Views
76K
Jacob Skaria
J
S
How do I get my shortcuts to stay on the Quick Access Toolbar?
  • sledhead
Replies
1
Views
199K
Jacob Skaria
J
F
Can anyone
  • fi.or.jp.de
Replies
4
Views
404K
Bernie Deitrick
B
L
Macro to apply parsing rules for strings and list the substrings
  • Luciano Paulino da Silva
2
Replies
24
Views
1M
Ron Rosenfeld
R
B
information automatically changes
  • Blythe PD
Replies
2
Views
36K
Dennis Tucker
D
M
COUNTIF Function Provides Text Feedback, Not Values
  • Michael S. Nelson
Replies
4
Views
174K
Jacob Skaria
J
G
Conditional Formatting Problem - Dynamic Formula??
  • GoBucks
Replies
2
Views
332K
GoBucks
G
Z
When there is a tie for "MAX" values...
  • Zakhary
Replies
6
Views
543K
Rick Rothstein
R
T
Another table lookup question
  • TFTAJLLYMXZP
Replies
1
Views
150K
[email protected]
T
M
counting in columns
  • Mrs T.
Replies
15
Views
906K
T. Valko
T
D
convert [h]:mm:ss to real number that I can use as a multiplier
  • Dean
Replies
3
Views
326K
Fred Smith
F
G
How to clear multiple cells of input data in Excel simultaneously
  • Guest
Replies
12
Views
439K
Dave Peterson
D
You must log in or register to post here.
Back
Top