Microsoft Excel Worksheet Functions

J
Subtracting Dates
  • jaxstraww
Replies
7
Views
113K
Fred Smith
F
T
calculate total items meeting criteria in range with multiple shee
  • twototango
Replies
2
Views
285K
twototango
T
R
How do I lookup a worksheet name in excel?
  • RJL007
Replies
2
Views
110K
Rick Rothstein \(MVP - VB\)
R
C
?? VLookup ??
  • Charles
Replies
2
Views
456K
Dave
D
D
Conditional Formating =mod($a2,2) = not(mod($a2,2))
  • DawnTreader
Replies
3
Views
146K
Pete_UK
P
T
Formatting cells
  • Tom J
Replies
2
Views
43K
OssieMac
O
A
date calculation
  • Ann
Replies
3
Views
171K
Ann
A
P
MAX TEXT ON A MASSEGE?
  • Papin
Replies
1
Views
207K
Papin
P
A
count date ranges
  • Ann
Replies
3
Views
259K
Max
M
T
Lookup Issue due to formatting
  • The Intern
Replies
5
Views
446K
T. Valko
T
S
How do i name a range of data in excel
  • scooter
Replies
1
Views
118K
Peo Sjoblom
P
P
Show text massege when formula result is true
  • Papin
Replies
6
Views
106K
Reitanos
R
E
Find function
  • Eric @ BP-EVV
Replies
6
Views
333K
Ron Rosenfeld
R
S
Sumproduct multiple criteria
  • Scott Kieta
Replies
6
Views
336K
Max
M
V
finding 75 days before current date
  • vikkib
Replies
3
Views
135K
Rick Rothstein \(MVP - VB\)
R
C
Monster of a formula!!
  • CSmith
Replies
4
Views
459K
Rick Rothstein \(MVP - VB\)
R
E
Trying to build reference to external, web-based sheets
  • Error trying to sort in a Macro
Replies
2
Views
161K
Error trying to sort in a Macro
E
A
date > date function
  • Ann
Replies
9
Views
353K
Ann
A
J
Sumif across mutiple sheets
  • jwang036
Replies
3
Views
494K
Bob Phillips
B
B
Highlighting cells in one column from a formula valuein another co
  • Brian H
Replies
4
Views
101K
Brian H
B
L
Worksheet autocalc with min function in error
  • Loretta
Replies
2
Views
281K
Niek Otten
N
J
IF formula results not displaying
  • JC
Replies
1
Views
200K
LanceB
L
T
calculate total number of items that meet 2 over multiple sheets
  • twototango
Replies
5
Views
408K
Bob Phillips
B
A
unique records in specified range
  • adimar
Replies
5
Views
395K
adimar
A
S
Return the filtered value into a specific cell
  • Sal
Replies
4
Views
761K
Sal
S
K
what function/formula do I use?
  • kate
Replies
2
Views
233K
kate
K
S
Hyperlink varaible substitution - How To
  • Sledge Bacon
Replies
10
Views
701K
JLatham
J
S
countif & subtotal functions
  • sot
Replies
3
Views
71K
PCLIVE
P
C
Removing Spaces In Cells
  • Chris
Replies
9
Views
358K
Pete_UK
P
L
is there a way to show what each cell links to?
  • liz
Replies
1
Views
281K
Mike H
M
P
Request for formula to refer some letters from Cell
  • PERANISH
Replies
8
Views
216K
Ron Rosenfeld
R
G
Adding new data to tables and charts in excel sheets from 97/2003
  • gill
Replies
1
Views
145K
Spiky
S
D
Excel-how to link source workbook to copy of destination workbook
  • D Lynn
Replies
1
Views
175K
Spiky
S
H
Advanced Probability.
  • HelpMePlease
Replies
9
Views
139K
Gary''s Student
G
B
offset function in defining name
  • BorisS
Replies
1
Views
207K
Bernie Deitrick
B
J
Conditionally highlight a row on a cell content
  • John
Replies
1
Views
154K
Spiky
S
B
problem naming range
  • BorisS
Replies
4
Views
308K
Roger Govier
R
K
filtering problems
  • KW
Replies
1
Views
49K
Roger Govier
R
G
First populated cell in row array/ Last populated cell in row arra
  • Guest
Replies
7
Views
311K
Support Request
S
O
Alpha column lables
  • Oly User
Replies
2
Views
393K
Oly User
O
S
How to round a number up or down
  • Sabrina
Replies
3
Views
480K
David Biddulph
D
U
VLOOKUP based on a formula result
  • ufo_pilot
Replies
1
Views
223K
Dave
D
D
daily trade blotter
  • Day Trader
Replies
6
Views
89K
Don Guillett
D
D
Please help
  • Dawnavyn
Replies
1
Views
89K
Peo Sjoblom
P
J
Countif & Sumif
  • JulesHR
Replies
7
Views
250K
Bernie Deitrick
B
B
Half way there with "IFAND"
  • Bill S
Replies
0
Views
128K
Bill S
B
A
date range additions
  • Ann
Replies
6
Views
169K
Ann
A
S
Deleting Duplicate Records across multiple sheets
  • saschmeling
Replies
1
Views
237K
ryguy7272
R
A
Sum function when the values in an xls are color coded
  • Angeles
Replies
2
Views
155K
Angeles
A
J
Converting COUNTIFS to 2003 format
  • JMVenhaus
Replies
6
Views
197K
Ron Coderre
R
You must log in or register to post here.
Back
Top