Microsoft Excel Worksheet Functions

H
Refernce 2 sheets & same columns & rows
  • H/A
Replies
8
Views
685K
Ashish Mathur
A
P
Cursor color
  • Pierre
Replies
2
Views
334K
Pierre
P
B
CountIf or leave blank
  • bcags7
Replies
3
Views
188K
Jacob Skaria
J
D
IF formula is greater than X use it, if not use X
  • dschneider3
Replies
10
Views
540K
Joe User
J
T
Sum data in a column if multi creteria met
  • tywlam
Replies
3
Views
461K
tywlam
T
W
calculate percent between 10.0 and 12.0 for data in multiple sheet
  • wissam
2
Replies
20
Views
1M
wissam
W
G
Month Function on UK dates formats (dd/mm/yyy)
  • Gene Moirao
Replies
2
Views
317K
Fred Smith
F
B
Selecting nonadjacent columns?
  • Barnsie
Replies
1
Views
50K
Dave Peterson
D
J
how do i find data from worksheets in excel
  • James
Replies
1
Views
241K
T. Valko
T
B
help with formulas
  • Bradly
Replies
2
Views
152K
Ashish Mathur
A
T
Subtotal percents in pivot table
  • tlc
Replies
1
Views
235K
Ashish Mathur
A
T
enter data in 1 cell and produce a number in another cell
  • Towboat Girl
Replies
1
Views
146K
T. Valko
T
K
Lookup and return value
  • Krista
Replies
8
Views
579K
Ashish Mathur
A
J
countifs criteria includes date range
  • JayH
Replies
4
Views
414K
Ashish Mathur
A
D
date extraction
  • Donna
Replies
2
Views
53K
Gord Dibben
G
E
countif strikethrough
  • ericahughes
Replies
1
Views
273K
Gary''s Student
G
L
Inserting Lines Makes Formula Inactive
  • lktx
Replies
7
Views
633K
lktx
L
T
How do I set up sub-headings in Excel?
  • travel junkie
Replies
1
Views
290K
Gord Dibben
G
J
Pulling Tab Name of a Different Tab Than What I'm Working In
  • Jon Ratzel
Replies
7
Views
624K
T. Valko
T
E
what is ^ function
  • Excel
Replies
3
Views
96K
Don Guillett
D
A
How do I markup a column of numbers without adding a column?
  • Afreshb
Replies
4
Views
149K
Dave Peterson
D
Z
bold text of referenced cell show in formula cell
  • zabcikranch
Replies
1
Views
277K
Gord Dibben
G
A
cell resizing
  • azwah
Replies
2
Views
35K
Gord Dibben
G
E
keeping conditional formatting after paste
  • ericahughes
Replies
2
Views
181K
Gord Dibben
G
T
Flexible formula for linking to externa Files
  • Tami
Replies
2
Views
156K
Dave Peterson
D
B
Result based on two criteria
  • Ben12956
Replies
3
Views
187K
T. Valko
T
L
Trimming letters in an Excel field
  • Lady_Dee
Replies
2
Views
267K
David Biddulph
D
R
Running Total, Opening & Closing Acct Balance in Cash Book
  • rushdhih
Replies
1
Views
219K
Fred Smith
F
J
How do you do an IF statement in Excel comparing three columns
  • JB
Replies
1
Views
186K
Gary''s Student
G
N
Merging Excel Sheet with Excel Sheet (Just like in MS Word!)
  • Neon520
Replies
3
Views
253K
Neon520
N
A
Print Dialog Box
  • AmyD
Replies
1
Views
37K
Dave Peterson
D
R
Advancing the Date Function?
  • Rupert T
Replies
2
Views
51K
Fred Smith
F
L
2007 Excel Protecting a cell
  • LindaAlex
Replies
3
Views
52K
LindaAlex
L
J
How do I modify a database in Excel 2007?
  • j.cleland
Replies
1
Views
17K
Otto Moehrbach
O
Z
FIND A VALUE FROM CROSPONDING COLUM AND MULTIPLE CROSSPENDING ROW
  • Zia Butt
Replies
3
Views
385K
Jacob Skaria
J
J
Count a value excluding duplicates depending on a set criteria
  • Jum
Replies
1
Views
216K
T. Valko
T
M
How to separate Excel Workbooks into new files
  • mokdeeo
Replies
0
Views
185K
mokdeeo
M
K
Formula help needed
  • Karen
Replies
7
Views
297K
Karen
K
P
Convert Month, Week, Year to date
  • Pete Hay
Replies
2
Views
412K
Fred Smith
F
M
VLOOKUP Returning a #N/A
  • MORRIPJ
Replies
2
Views
234K
Gord Dibben
G
A
Vlookup Plus...?
  • Ando
Replies
2
Views
375K
Ando
A
M
= LOOKUP(9.99999999999999E+307,A1:H1)
  • Mark
Replies
8
Views
89K
Mark
M
S
Find position number of third space
  • Steve Stad
Replies
6
Views
364K
T. Valko
T
A
can not see anything in drop down list
  • assistme
Replies
1
Views
189K
Gord Dibben
G
C
Prevent formula calculation from overriding validation
  • CindyMc
Replies
2
Views
259K
Luke M
L
G
Please help me -urgent
  • ganga
Replies
1
Views
170K
Don Guillett
D
G
when i type 5 then it shows.006
  • gauri
Replies
2
Views
22K
Luke M
L
J
Day formula
  • JICDB
Replies
4
Views
303K
Mike H
M
E
Macro formatting last row
  • Erin
Replies
3
Views
100K
Erin
E
B
Problem - hidden cell names in worksheet
  • Bigger
Replies
2
Views
232K
Bigger
B
You must log in or register to post here.
Back
Top