Microsoft Excel Worksheet Functions

N
How do I display results of a summation in the following format?
  • Nh2
Replies
2
Views
137K
Jacob Skaria
J
S
Return a name in the same row
  • Scott J
Replies
3
Views
346K
Scott J
S
J
conditonal format A2 using value in another cell C2
  • Joe
Replies
1
Views
192K
Jacob Skaria
J
G
Random #VALUE! error in simple SUM formula results
  • Greg in CO
Replies
3
Views
429K
Ronmac
R
B
OFFICE 7
  • Bob Reddy
Replies
3
Views
176K
Rij_racer
R
A
Find Function behaving differently in different spreadsheets
  • Anchor
Replies
1
Views
241K
JBeaucaire
J
F
Conditional Formatting on Autoshape
  • Freshman
Replies
4
Views
521K
Freshman
F
S
link values from same cell of 20 worksheets into column on one she
  • Stingraynut
Replies
3
Views
285K
T. Valko
T
J
Referencing the latest entry in a column
  • John
Replies
1
Views
52K
Jacob Skaria
J
P
How to count with values from multiple columns?
  • PF
Replies
5
Views
250K
Jacob Skaria
J
H
Conditional format to highlight only cells with formula, not const
  • hkbarnett
Replies
2
Views
344K
T. Valko
T
F
drop down list
  • free24
Replies
3
Views
434K
Ashish Mathur
A
W
Hide Rows or Columns with +/- button above row/column label headin
  • WA
Replies
2
Views
274K
Ashish Mathur
A
S
I have a column of numbers, some negative, some positive
  • Skip
Replies
3
Views
339K
Skip
S
R
Fun with SUMPRODUCT
  • rweiss
Replies
14
Views
469K
rweiss
R
A
have one sheet update others in workbook
  • ashadiana
Replies
1
Views
193K
Gord Dibben
G
V
How to stop scrolling in side by side comparison?
  • vdotMN
Replies
2
Views
297K
Gord Dibben
G
G
Need formula to return exact match
  • gootroots
Replies
8
Views
940K
Gotroots
G
C
Pricing Chart
  • chippette
Replies
3
Views
218K
chippette
C
R
Concatenate email addresses
  • Renegade
Replies
3
Views
218K
Rick Rothstein
R
L
Amount Owing
  • LAM
Replies
1
Views
100K
Luke M
L
D
Pivot Table Problem
  • DCO
Replies
1
Views
67K
Shane Devenshire
S
S
Excel MATCH Function
  • Sal
Replies
1
Views
170K
Gary''s Student
G
T
Timesheets
  • Thomas 49
Replies
2
Views
245K
Amish
A
S
If (Vlookup >0) working, but what if Vlookup cell does not exist
  • Steve
Replies
18
Views
938K
Steve
S
K
In excel change color of a range of cells based on a cell value
  • kwitt
Replies
1
Views
300K
Squeaky
S
F
Complex conditional summing - array COUNT works, array SUM gives#VALUE
  • fatcatfan
Replies
4
Views
510K
T. Valko
T
B
Reference constant cells in different files from a master workbook
  • Byron
Replies
1
Views
290K
Squeaky
S
F
Pulling data from another workbook
  • Frustrated
Replies
2
Views
113K
Tom Hutchins
T
J
Vlookup when lookup criteria is not an exact match
  • jtoy
Replies
2
Views
370K
Jacob Skaria
J
B
my first excel experience (share portfolio)
  • barbarebop
Replies
2
Views
455K
barbarebop
B
P
IF statement based on need to recalculate
  • pdberger
Replies
1
Views
182K
Squeaky
S
J
Sum Multiple Criteria
  • JCS
Replies
7
Views
291K
JCS
J
C
Averageif is not working
  • Curtis
Replies
2
Views
385K
Squeaky
S
N
date text to change colour when it gets over six months
  • Nessa
Replies
1
Views
186K
Jacob Skaria
J
R
True false function for alpha data
  • R Y
Replies
7
Views
532K
David Biddulph
D
K
calculating number of days belonging to each month within a given week
  • kate zareba
Replies
2
Views
280K
JLatham
J
U
Hours and sum of hours
  • u650431
Replies
2
Views
293K
Jacob Skaria
J
N
Vlookup with AND, OR IF statements
  • Novawitt
Replies
1
Views
98K
Pete_UK
P
S
I have a worksheet
  • Skip
Replies
1
Views
265K
Pete_UK
P
G
Fill down conditional formatting series
  • gootroots
Replies
6
Views
199K
Gotroots
G
I
i want to set conditional format to cells containing odd numbers
  • ian c
Replies
4
Views
218K
Ms-Exl-Learner
M
C
Date is displaying 00-Jan-00 when I type in 11/16/09.
  • Clark
Replies
3
Views
46K
David Biddulph
D
G
Multiple formats in a cell
  • Gridlock
Replies
2
Views
273K
Ron Rosenfeld
R
B
How can I use the * wildcard in an array formula
  • Bruce
Replies
4
Views
570K
Ashish Mathur
A
S
find a data in a list that have a few hit
  • ssa
Replies
1
Views
191K
Jacob Skaria
J
S
Need to separate multiple numbers in one cell
  • sierra spiegel
Replies
3
Views
242K
Ashish Mathur
A
R
Excluding Cells From Avg Cals Due to Info in different col
  • redstar_
Replies
6
Views
543K
Jacob Skaria
J
D
COUNTIF FORMULA ISSUES - NEED FORMULA CORRECTED
  • Debbi
Replies
2
Views
232K
T. Valko
T
K
Converting 0 values to Blanks
  • kepetersen3405
Replies
5
Views
448K
minyeh
M
You must log in or register to post here.
Back
Top