Microsoft Excel Worksheet Functions

Post thread
N
transposing across different worksheets
  • Nick P
Replies
3
Views
454
Max
M
H
Refernce 2 sheets & same columns & rows
  • H/A
Replies
8
Views
689
Ashish Mathur
A
P
Cursor color
  • Pierre
Replies
2
Views
1K
Pierre
P
B
CountIf or leave blank
  • bcags7
Replies
3
Views
669
Jacob Skaria
J
D
IF formula is greater than X use it, if not use X
  • dschneider3
Replies
10
Views
557
Joe User
J
T
Sum data in a column if multi creteria met
  • tywlam
Replies
3
Views
500
tywlam
T
W
calculate percent between 10.0 and 12.0 for data in multiple sheet
  • wissam
2
Replies
20
Views
1K
wissam
W
G
Month Function on UK dates formats (dd/mm/yyy)
  • Gene Moirao
Replies
2
Views
450
Fred Smith
F
B
Selecting nonadjacent columns?
  • Barnsie
Replies
1
Views
422
Dave Peterson
D
J
how do i find data from worksheets in excel
  • James
Replies
1
Views
365
T. Valko
T
B
help with formulas
  • Bradly
Replies
2
Views
321
Ashish Mathur
A
T
Subtotal percents in pivot table
  • tlc
Replies
1
Views
456
Ashish Mathur
A
T
enter data in 1 cell and produce a number in another cell
  • Towboat Girl
Replies
1
Views
410
T. Valko
T
K
Lookup and return value
  • Krista
Replies
8
Views
645
Ashish Mathur
A
J
countifs criteria includes date range
  • JayH
Replies
4
Views
959
Ashish Mathur
A
D
date extraction
  • Donna
Replies
2
Views
388
Gord Dibben
G
E
countif strikethrough
  • ericahughes
Replies
1
Views
4K
Gary''s Student
G
L
Inserting Lines Makes Formula Inactive
  • lktx
Replies
7
Views
531
lktx
L
T
How do I set up sub-headings in Excel?
  • travel junkie
Replies
1
Views
2K
Gord Dibben
G
J
Pulling Tab Name of a Different Tab Than What I'm Working In
  • Jon Ratzel
Replies
7
Views
548
T. Valko
T
E
what is ^ function
  • Excel
Replies
3
Views
246
Don Guillett
D
A
How do I markup a column of numbers without adding a column?
  • Afreshb
Replies
4
Views
421
Dave Peterson
D
Z
bold text of referenced cell show in formula cell
  • zabcikranch
Replies
1
Views
826
Gord Dibben
G
A
cell resizing
  • azwah
Replies
2
Views
375
Gord Dibben
G
E
keeping conditional formatting after paste
  • ericahughes
Replies
2
Views
400
Gord Dibben
G
T
Flexible formula for linking to externa Files
  • Tami
Replies
2
Views
358
Dave Peterson
D
B
Result based on two criteria
  • Ben12956
Replies
3
Views
373
T. Valko
T
L
Trimming letters in an Excel field
  • Lady_Dee
Replies
2
Views
523
David Biddulph
D
R
Running Total, Opening & Closing Acct Balance in Cash Book
  • rushdhih
Replies
1
Views
1K
Fred Smith
F
J
How do you do an IF statement in Excel comparing three columns
  • JB
Replies
1
Views
455
Gary''s Student
G
N
Merging Excel Sheet with Excel Sheet (Just like in MS Word!)
  • Neon520
Replies
3
Views
691
Neon520
N
A
Print Dialog Box
  • AmyD
Replies
1
Views
358
Dave Peterson
D
R
Advancing the Date Function?
  • Rupert T
Replies
2
Views
359
Fred Smith
F
L
2007 Excel Protecting a cell
  • LindaAlex
Replies
3
Views
322
LindaAlex
L
J
How do I modify a database in Excel 2007?
  • j.cleland
Replies
1
Views
285
Otto Moehrbach
O
Z
FIND A VALUE FROM CROSPONDING COLUM AND MULTIPLE CROSSPENDING ROW
  • Zia Butt
Replies
3
Views
499
Jacob Skaria
J
J
Count a value excluding duplicates depending on a set criteria
  • Jum
Replies
1
Views
1K
T. Valko
T
M
How to separate Excel Workbooks into new files
  • mokdeeo
Replies
0
Views
558
mokdeeo
M
K
Formula help needed
  • Karen
Replies
7
Views
488
Karen
K
P
Convert Month, Week, Year to date
  • Pete Hay
Replies
2
Views
1K
Fred Smith
F
M
VLOOKUP Returning a #N/A
  • MORRIPJ
Replies
2
Views
404
Gord Dibben
G
A
Vlookup Plus...?
  • Ando
Replies
2
Views
543
Ando
A
M
= LOOKUP(9.99999999999999E+307,A1:H1)
  • Mark
Replies
8
Views
3K
Mark
M
S
Find position number of third space
  • Steve Stad
Replies
6
Views
2K
T. Valko
T
A
can not see anything in drop down list
  • assistme
Replies
1
Views
315
Gord Dibben
G
C
Prevent formula calculation from overriding validation
  • CindyMc
Replies
2
Views
499
Luke M
L
G
Please help me -urgent
  • ganga
Replies
1
Views
389
Don Guillett
D
G
when i type 5 then it shows.006
  • gauri
Replies
2
Views
319
Luke M
L
J
Day formula
  • JICDB
Replies
4
Views
610
Mike H
M
E
Macro formatting last row
  • Erin
Replies
3
Views
432
Erin
E
Back
Top