Microsoft Excel Worksheet Functions

Post thread
C
Can you calculate the number of years between two dates in Excel 0
  • Christina
Replies
4
Views
18K
Shane Devenshire
S
J
Mac Auto-filter
  • John
Replies
1
Views
400
Shane Devenshire
S
S
Data Validation Custom with V Lookup
  • Scott R
Replies
6
Views
928
T. Valko
T
J
Sumproduct with autofilter
  • John
Replies
1
Views
451
T. Valko
T
C
Help!
  • Christina
Replies
6
Views
481
Pete_UK
P
E
Sum for two criteria
  • Ernie Fenwick
Replies
3
Views
348
Max
M
T
97 Pop-Up Calendar
  • Tia
Replies
1
Views
359
Gord Dibben
G
J
Break Up Data
  • Jennifer
Replies
1
Views
284
Spiky
S
G
Preventing row numbers from sorting
  • Gary
Replies
4
Views
350
Gord Dibben
G
W
Once a column is marked as $, how do I change it back?
  • wpbvin
Replies
2
Views
284
Gord Dibben
G
T
How to set worksheets to print in different order in the same file
  • Tamall
Replies
1
Views
360
Gord Dibben
G
Q
Can I pass network logon name to a cell in a spreadsheet?
  • Quality Plan
Replies
3
Views
376
Gord Dibben
G
P
Multiple conditions
  • Picman
Replies
12
Views
625
Picman
P
R
Returning a value from the cell next to my match
  • Ron
Replies
2
Views
471
Gord Dibben
G
B
Counting Numbers
  • Buffalo
Replies
4
Views
462
Rick Rothstein
R
T
Hyperlinks stopped working
  • tom
Replies
4
Views
483
Gord Dibben
G
M
rows to repeat at the top
  • Meebers
Replies
4
Views
687
Meebers
M
S
Is there a way to find the max in a set of data that meet a certaincriteria w/o using an array formu
  • SK08
Replies
7
Views
518
Harlan Grove
H
E
Array with Sum and multiply
  • Eric
Replies
12
Views
716
Harlan Grove
H
G
VLOOKUP Issue
  • Guest
Replies
2
Views
397
Jessica
J
R
VLOOKUP - Referencing seperate workbook getting #N/A erros
  • Reddo
Replies
2
Views
443
xlmate
X
C
Pull Information from one sheet to another
  • Christina
Replies
1
Views
459
Max
M
S
Is there any way to auto-insert a row?
  • Shawn
Replies
4
Views
2K
xlmate
X
E
Extract specified fields with criteria from Excel.cvs workbook
  • EricB
Replies
3
Views
424
Max
M
S
scroll function not working in excel 2007
  • scrool problem
Replies
1
Views
522
Spiky
S
C
trying to copy a worksheet containing named ranges to anotherworksheet
  • cil9mxm
Replies
1
Views
444
Spiky
S
K
Selecting Pivot Table Raw Data
  • Karen
Replies
2
Views
488
Karen
K
L
Change last number to 9
  • Laura Lee Day
Replies
3
Views
345
Mike H
M
B
EXCEL WILL CLOSE IF I CLICK PAGE
  • Bamabo12
Replies
1
Views
212
Mike H
M
N
can I split a worksheet then have the 2 sections work independent
  • Nik
Replies
1
Views
347
Sheeloo
S
E
Hyperlinks to show on top left corner of screen
  • Elisabeth
Replies
4
Views
741
Gary''s Student
G
T
converting ssn's
  • tisaman
Replies
12
Views
1K
Rick Rothstein
R
G
cross referencing 2 workbooks at same time
  • GezCam
Replies
3
Views
410
Shane Devenshire
S
O
is this not working because i am using 03?
  • out of my depth
Replies
1
Views
365
Bob Phillips
B
D
Non working time
  • durbat2
Replies
4
Views
456
Bob Phillips
B
D
Copying Formula
  • dorinn
Replies
8
Views
326
David Biddulph
D
I
Index Help
  • iRon924
Replies
2
Views
311
iron924
I
J
worksheets
  • Joanne
Replies
3
Views
325
Mohamed Attia
M
R
Tracking Changes
  • Rich Mogy
Replies
2
Views
384
Mohamed Attia
M
B
Mortgage with Quarterly Capitalisation & Monthly Payments
  • Beth
Replies
7
Views
2K
Junge
J
S
creating checkboxes and radio buttons in excel
  • Sandeep
Replies
1
Views
457
Joel
J
D
Excel 2003 bank ledger spreadsheet background fill shading
  • Dan
Replies
4
Views
2K
David Biddulph
D
A
If formula result = 0, do not display-leave cell blank
  • ASG
Replies
3
Views
30K
Pete_UK
P
K
Count if formula error
  • Kate83
Replies
5
Views
569
Shane Devenshire
S
U
Function to return a range of cells from a PivotTable
  • ubundom
Replies
2
Views
497
Shane Devenshire
S
P
[Statistical functions] Function to return result from Z table?
  • plh
Replies
4
Views
618
plh
P
M
IF function problems
  • mmcap
Replies
9
Views
511
mmcap
M
D
Counting cells that are shaded in black?
  • Denise
Replies
5
Views
629
T. Valko
T
R
formula to add 6 months to a date entered on one worksheet, in ano
  • Ron
Replies
2
Views
386
Rick Rothstein
R
T
drop down list dependant of previous selection
  • The Fru Fru
Replies
1
Views
509
Shane Devenshire
S
Back
Top