Microsoft Excel Worksheet Functions

Post thread
N
Edit formula over a range
  • Nate
Replies
1
Views
393
Pete_UK
P
Q
sumif any text is criteria
  • Question, Mark
Replies
4
Views
415
Ashish Mathur
A
L
Std Dev of Aged Inventory
  • LB
Replies
3
Views
546
JoeU2004
J
S
Search a name in one sheet and entry it into another sheet
  • Shilpi
Replies
4
Views
469
Shilpi
S
S
Auto-adjust formulas
  • se7098
Replies
3
Views
471
Ashish Mathur
A
L
Automatically add a column to summary sheet if another worksheet i
  • Living Design
Replies
2
Views
594
Living Design
L
I
repeating the answer in A2 cell to A3:A20
  • Igneshwara reddy
Replies
3
Views
455
T. Valko
T
M
repeat row labels in pivot table
  • mhead
Replies
2
Views
4K
Fred Smith
F
I
Determine decimal
  • Ithaca
Replies
5
Views
514
Ithaca
I
E
How do I locate cells that contain a certain text?
  • EZ-XLS
Replies
2
Views
512
Don Guillett
D
S
Lookup 2 values and return a third
  • Sh
Replies
1
Views
679
Bernard Liengme
B
M
COUNT and SUM (please help!)
  • Mrs T.
Replies
11
Views
657
Mrs T.
M
P
Hiding Formula Answers in Specific Cells
  • pen
Replies
1
Views
394
Pete_UK
P
R
days and time functions
  • raogv
Replies
6
Views
267
John_Franco
J
E
How can I stack worksheets (I have 30 worksheets)
  • Eastendkid
Replies
3
Views
590
Dave Peterson
D
A
Countif range contains part of a value
  • antwaan
Replies
10
Views
7K
Glenn
G
J
ifblank function
  • jones.derek
Replies
5
Views
527
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
535
Using the date functions
U
P
Conditional formula based on 2 pre-conditions
  • PSmith
Replies
4
Views
374
PSmith
P
A
How do I get my Excel 2007 worksheet to go beyond 65536 rows?
  • Alan
Replies
1
Views
1K
Bernard Liengme
B
G
=sum
  • gma
Replies
5
Views
366
gma
G
M
COUNT and SUM
  • Mrs T.
Replies
5
Views
471
Ashish Mathur
A
J
Removing Mulitple Carriage Returns Within a Concantenate Formula
  • Jane
Replies
2
Views
518
Jacob Skaria
J
M
copy conditional format without using format painter
  • MsConfused
Replies
2
Views
3K
MsConfused
M
B
return second or third word in a cell
  • birdgirl31
Replies
10
Views
1K
Jacob Skaria
J
L
Background and Calendar
  • lbdas311
Replies
2
Views
362
TechGuy
T
K
How to set up a devilery schedule calendar from excel database
  • KKL 2009
Replies
2
Views
3K
TechGuy
T
J
Formula/Sum Question
  • Jon the Contractor
Replies
2
Views
349
T. Valko
T
M
Sheet direction, extract data from comment
  • MFS
Replies
2
Views
430
Ashish Mathur
A
D
Displaying Cell Formulas (without using Tools/Options/View-Formula
  • DSMessenger
Replies
6
Views
635
Ashish Mathur
A
W
Duplicating check boxes with formulas
  • wcollatz
Replies
1
Views
427
joel
J
J
Problem with VLOOKUP
  • Jarek
Replies
4
Views
462
Jarek
J
I
Need a fresh pair of eyes
  • ibvalentine
Replies
11
Views
507
John
J
M
count across 3 columns
  • Mrs T.
Replies
8
Views
679
T. Valko
T
C
Column Titles
  • CHUCK G.
Replies
2
Views
416
JoeU2004
J
K
address of first and last number in a row
  • Kobus
Replies
5
Views
541
T. Valko
T
A
Duplicate Difficulties
  • :: Amy ::
Replies
5
Views
516
Dennis Tucker
D
Z
Counting the number of occurrences...
  • Zakhary
Replies
2
Views
582
T. Valko
T
H
How to reference last non-blank cell value from a column cells?
  • Hal J
Replies
2
Views
3K
T. Valko
T
D
Display Multiple Worksheets
  • docfat
Replies
4
Views
403
Jacob Skaria
J
S
How do I get my shortcuts to stay on the Quick Access Toolbar?
  • sledhead
Replies
1
Views
410
Jacob Skaria
J
F
Can anyone
  • fi.or.jp.de
Replies
4
Views
390
Bernie Deitrick
B
L
Macro to apply parsing rules for strings and list the substrings
  • Luciano Paulino da Silva
2
Replies
24
Views
1K
Ron Rosenfeld
R
B
information automatically changes
  • Blythe PD
Replies
2
Views
277
Dennis Tucker
D
M
COUNTIF Function Provides Text Feedback, Not Values
  • Michael S. Nelson
Replies
4
Views
527
Jacob Skaria
J
G
Conditional Formatting Problem - Dynamic Formula??
  • GoBucks
Replies
2
Views
933
GoBucks
G
Z
When there is a tie for "MAX" values...
  • Zakhary
Replies
6
Views
607
Rick Rothstein
R
T
Another table lookup question
  • TFTAJLLYMXZP
Replies
1
Views
357
[email protected]
T
M
counting in columns
  • Mrs T.
Replies
15
Views
630
T. Valko
T
D
convert [h]:mm:ss to real number that I can use as a multiplier
  • Dean
Replies
3
Views
1K
Fred Smith
F
Back
Top