Microsoft Excel Worksheet Functions

A
Case Sensitive Counting & Filtering
  • Alain
Replies
1
Views
117K
Rick Rothstein
R
B
counting the number of occurences
  • Bradly
Replies
3
Views
190K
Bernd P
B
T
Formula mismatch in Excel 2003 & 2007
  • Terence D'Souza
Replies
2
Views
323K
Ashish Mathur
A
P
Subtotals in Excel 2007 TABLES
  • Pebbs
Replies
1
Views
212K
Ashish Mathur
A
M
Dsum excluding blanks
  • Michelle
Replies
1
Views
132K
Ashish Mathur
A
C
SUMIF date criteria
  • CSam
Replies
3
Views
227K
Ashish Mathur
A
C
Vlookup combined with Hlookup
  • Cornelius
Replies
7
Views
368K
T. Valko
T
E
How can I do this ??
  • Eric_in_EVV
Replies
5
Views
383K
Max
M
D
#VALUE! in cell
  • datub
Replies
4
Views
248K
Ms-Exl-Learner
M
R
Extract portion of cell contents
  • Rick
Replies
7
Views
428K
Rick
R
A
Return a range based on a variable
  • Art
Replies
4
Views
92K
Teethless mama
T
J
FInd common data in one column then add number in adjacent column
  • JT
Replies
3
Views
206K
Lance
L
Y
dependent drop down list
  • yowzers
Replies
1
Views
372K
Otto Moehrbach
O
K
Slow file with INDIRECT.EXT
  • KateB
Replies
1
Views
304K
ryguy7272
R
P
Calculating gross when net is known
  • placerpone
Replies
3
Views
156K
Fred Smith
F
B
Pivot Table GETPIVOTDATA
  • Buck
Replies
2
Views
367K
Eva
E
R
Excel Protect Function, while allowing macros
  • RK
Replies
2
Views
47K
Rik_UK
R
L
find and replace Excel 2007
  • Lynne
Replies
13
Views
269K
Kathy Kane
K
P
Data in columns convert to single line
  • PAR
Replies
1
Views
127K
PAR
P
L
counting the number of consecutive days 12-17-09
  • LEG
Replies
2
Views
333K
JLatham
J
S
if formula for time sheet. - help
  • srb911
Replies
1
Views
347K
srb911
S
C
i have a file with 50 worksheets, how can I print these names
  • chris felix
Replies
2
Views
142K
Jacob Skaria
J
E
LOOKUP across a whole table and not just first row or column
  • Eric_G
Replies
4
Views
459K
T. Valko
T
T
macro to disallow shading in certain columns
  • Tami
Replies
2
Views
215K
Tami
T
C
Return value based on certain criteria
  • C.
Replies
3
Views
390K
C.
C
N
Mode Function combined with a filter
  • Neolyth
Replies
1
Views
188K
Gary''s Student
G
A
HIKE %
  • AMIT BHOPAL
Replies
2
Views
67K
JLatham
J
D
Dynamic Range Defined by Value of Cell
  • Domenick
Replies
7
Views
228K
Otto Moehrbach
O
S
Macro to Clean Special characters for a Range
  • Satish
Replies
5
Views
285K
Satish
S
K
How to use SumProduct to count reference or something else?
  • klafert
Replies
3
Views
179K
Jacob Skaria
J
D
What is hubscore?
  • DS
Replies
1
Views
39K
Joe User
J
B
Compare my list to an existing list
  • Beep
Replies
1
Views
112K
Max
M
T
Conditiona format based on format of another cell
  • Tami
Replies
1
Views
231K
T. Valko
T
P
Deleting rows
  • Pepe Saldana
Replies
1
Views
181K
Rick Rothstein
R
B
Data Validation Question
  • Bob Myers
Replies
1
Views
235K
T. Valko
T
N
Separate first name, middle name and last name
  • NoviceUser
Replies
2
Views
389K
Ron Rosenfeld
R
N
Counting while diminishing
  • Nolan
Replies
1
Views
241K
Dave Peterson
D
Z
NEED FORMULA TO POINT TO TOP OF COLUMN IF NUMBER GREATER THAN ANOT
  • z942849
Replies
9
Views
699K
T. Valko
T
Z
NEED FORMULA TO PICK UP TOP OF A COLUMN WHEN CERTAIN CRITERIA MET
  • z942849
Replies
3
Views
343K
T. Valko
T
K
Subtotaling
  • Katie
Replies
3
Views
365K
Paul C
P
A
How do I add an integer to an existing integer?
  • Aaron
Replies
3
Views
43K
Bernd P
B
S
weight loss
  • Scoober
Replies
3
Views
298K
Eduardo
E
M
I want to save a copy of a wksht. but without any of the formulas
  • ms_gebhart
Replies
5
Views
375K
Pete_UK
P
A
Column
  • Alan
Replies
4
Views
133K
Teethless mama
T
T
Complex Lookup Question
  • TB@work
Replies
2
Views
127K
T. Valko
T
B
Averaging data across a date range
  • Barry
Replies
1
Views
187K
Bernard Liengme
B
S
Decimal
  • Sky
Replies
5
Views
459K
Joe User
J
S
Count number of dates between a specified period of time
  • Sodak
Replies
2
Views
274K
Gary''s Student
G
S
Q on LARGE function
  • Seanie
Replies
1
Views
79K
Bernie Deitrick
B
E
And function into If function
  • Eivind
Replies
4
Views
230K
Eduardo
E
You must log in or register to post here.
Back
Top