Microsoft Excel Worksheet Functions

Post thread
D
Unique count formula
  • Daniel Bonallack
Replies
3
Views
519
T. Valko
T
B
count if column A is 1-2 and column B is 03/02/08 to 03/09/08
  • bokey
Replies
4
Views
531
Peo Sjoblom
P
F
Copy parts of a data range into a new spreadsheet
  • forest8
Replies
4
Views
572
JLatham
J
C
text on worksheet with no gridlines
  • Carol
Replies
2
Views
437
BoniM
B
S
Overtime Calculation for Overtime
  • SilviaG
Replies
4
Views
847
joeu2004
J
E
multiple range array with ttest
  • erinlm
Replies
2
Views
2K
erinlm
E
S
Matching a column of new data to existing larger data set.
  • Sirjay
Replies
1
Views
338
Pete_UK
P
D
tieing copies together
  • dkb43
Replies
1
Views
386
Pete_UK
P
K
Sumproduct
  • krandall
Replies
1
Views
306
Pete_UK
P
C
Need help creating a formula that will auto post amts when marked.
  • Cindy E.
Replies
1
Views
330
Mike
M
B
Need help with formular on excel 2007
  • Buzz Local#30
Replies
3
Views
632
Pete_UK
P
S
adding the qty's of products from several worksheets.
  • Steve
Replies
3
Views
455
ryguy7272
R
J
Remove Merge and Center for entire spreadsheet
  • JE
Replies
3
Views
2K
ryguy7272
R
B
HLOOKUP across two spreadsheets
  • Beverly Darvill
Replies
3
Views
529
Beverly Darvill
B
U
SUMIF from multiple files
  • Unda
Replies
3
Views
1K
David Biddulph
D
S
Custom Format with different Criteria
  • Santhosh Mani
Replies
2
Views
430
Santhosh Mani
S
B
I still need help with formular?
  • Buzz Local#30
Replies
2
Views
391
Buzz Local#30
B
D
Calculated field in a pivot table?
  • Divya
Replies
3
Views
464
Dave Peterson
D
J
sum a range meeting conditions of row & column
  • jwang036
Replies
2
Views
501
jwang036
J
V
Conditional formatting based on another column
  • vidiotloserx
Replies
2
Views
486
[email protected]
V
B
Need Help with Excel2007
  • Buzz Local#30
Replies
1
Views
400
Fred Smith
F
J
need help on a formula
  • jrenglish86
Replies
2
Views
273
Fred Smith
F
R
Counting number of weeks to complete a task
  • roniaelm
Replies
7
Views
387
Ashish Mathur
A
Y
equivalent for function , please for help
  • ytayta555
Replies
5
Views
468
ytayta555
Y
T
how do I delete data in a cell without deleting formula?
  • tripy
Replies
1
Views
1K
Gord Dibben
G
E
How to find common strings of text then copy those rows elsewhere?
  • energyzone
Replies
6
Views
491
Mike H
M
D
Excel Workbooks
  • darlylj
Replies
2
Views
275
Gord Dibben
G
A
How to I sum different data from different sheets
  • Adrian
Replies
3
Views
616
Herbert Seidenberg
H
T
How do you convert an uncoded date (e.g., 20080304) to a date form
  • tenorofchange
Replies
5
Views
450
bosco_yip
B
K
Which Formula
  • kmaki
Replies
8
Views
501
Domenic
D
V
name typing
  • Vicky
Replies
2
Views
268
Max
M
J
WORKDAY resulting in #VALUE error
  • Joseph
Replies
3
Views
1K
Joseph
J
P
Auto filling information from Data List
  • Paul
Replies
2
Views
452
Paul
P
G
Using Matrix functions on complex numbers
  • Greg Conway
Replies
0
Views
1K
Greg Conway
G
L
add days to a date and return resulting date
  • LKONITZ
Replies
4
Views
546
Tyro
T
K
Open my Excel hyperlinks in Firefox
  • KerriS
Replies
3
Views
478
Martin Fishlock
M
D
Capitize first letter in sequence
  • dberger16
Replies
2
Views
406
Max
M
D
auto complete date
  • D
Replies
3
Views
372
Gord Dibben
G
B
ow do I lock up certain cells in a worksheet?
  • Buzz Local#30
Replies
1
Views
348
Gord Dibben
G
D
Finding count of unique number within a specific criteria?
  • Danni2004
Replies
7
Views
425
Domenic
D
A
F6--1-VLOOKUP
  • acmelton
Replies
1
Views
720
Teethless mama
T
O
Working with worksheets in the same workbook
  • ofcbill
Replies
1
Views
377
Per Jessen
P
A
Multiple pivot tables
  • abijames100
Replies
2
Views
354
Debra Dalgleish
D
J
Stop SumProduct formula from rounding up
  • Judy L
Replies
6
Views
657
Judy L
J
H
summarize list of expenses
  • Harold Good
Replies
1
Views
417
Herbert Seidenberg
H
T
IF-THEN & Conditional Format Label
  • Tampa-Terry
Replies
9
Views
456
Tampa-Terry
T
C
Fixed file location for lookup formula
  • Code Numpty
Replies
4
Views
360
Code Numpty
C
L
Wobbled countif and conditional format Results
  • Luke
Replies
9
Views
623
Max
M
M
VLOOKUP or maybe INDEX
  • mpenkala
Replies
2
Views
355
T. Valko
T
S
filter data
  • Sharkies
Replies
1
Views
290
Pete_UK
P
Back
Top