Microsoft Excel Worksheet Functions

G
How do I display the tab name in a formula
  • Guest
Replies
1
Views
122K
Anne Troy
A
G
Is there a way to transpose and invert the order of data in Excel.
  • Guest
Replies
1
Views
109K
KL
K
G
How to convert the dates from the YY:DD forma to MM/dd/YYYY format
  • Guest
Replies
4
Views
287K
Roger Govier
R
J
Time functions, how do I work out number of hours
  • jeanette.rimmer
Replies
2
Views
149K
jeanette.rimmer
J
G
How do I limit what text is displayed?
  • Guest
Replies
4
Views
400K
Guest
G
G
format method
  • Guest
Replies
1
Views
99K
Guest
G
G
Searching TEXT in formulae, rather than results of formulae
  • Guest
Replies
1
Views
25K
Niek Otten
N
G
A SIMPLER FORMULA TO GET A REFERENCE OF WHICH COLUMN IS POPULATED
  • Guest
Replies
7
Views
1M
Krishnakumar
K
G
lookup function 1
  • Guest
Replies
4
Views
52K
Guest
G
G
details of month
  • Guest
Replies
9
Views
175K
Krishnakumar
K
G
To have the cell blank please
  • Guest
Replies
5
Views
140K
Guest
G
G
Sumproduct
  • Guest
Replies
4
Views
174K
Guest
G
G
Value 0
  • Guest
Replies
3
Views
122K
Guest
G
S
Is there a formula for IF a cell CONTAINS certain text...
  • spiffytj
Replies
1
Views
59K
Anne Troy
A
G
Turn off cursor from automatically highlighting cells in Excel?
  • Guest
Replies
1
Views
167K
Anne Troy
A
G
I have forgotten my password and have no excess
  • Guest
Replies
1
Views
37K
Anne Troy
A
G
Finding the first blank or zero value
  • Guest
Replies
1
Views
44K
Peo Sjoblom
P
G
Function to calculate the number of years, months and days between
  • Guest
Replies
2
Views
506K
Guest
G
C
Can data from one ws transfer to another IF cell has text?
  • Ccp
Replies
3
Views
148K
Ccp
C
S
Incrementing a worksheet number in a formula
  • sylvester1501
Replies
1
Views
43K
Biff
B
G
our cost to customers cost
  • Guest
Replies
2
Views
47K
Guest
G
G
get total hours from 2 dates
  • Guest
Replies
1
Views
104K
Biff
B
G
How do I open multiple hidden worksheets all at once?
  • Guest
Replies
2
Views
81K
Guest
G
G
How to calculate values in multiple values with multi conditions
  • Guest
Replies
2
Views
113K
Guest
G
M
problem with msn money stock quote add in
  • mjcondon
Replies
2
Views
229K
Guest
G
E
lookup value froma filtered list
  • Eric
Replies
4
Views
58K
Eric
E
G
Column of check boxes
  • Guest
Replies
2
Views
90K
Eric
E
G
solving for all possible combinations of a set of numbers
  • Guest
Replies
10
Views
371K
Max
M
G
conditional autofill???please?
  • Guest
Replies
1
Views
34K
ScottO
S
G
Create a button in excel that can open an outlook appointment?
  • Guest
Replies
1
Views
126K
Guest
G
G
Is there a function that will return the page number?
  • Guest
Replies
1
Views
98K
Guest
G
G
reduce a balance from severel cells
  • Guest
Replies
1
Views
139K
Guest
G
G
How to Add a Calculation to a Pivot Table ?
  • Guest
Replies
3
Views
25K
Debra Dalgleish
D
G
Count Not Appearing when using AutoFilter?
  • Guest
Replies
3
Views
258K
Debra Dalgleish
D
G
Set a cell to have a pop-up calendar for date selection in Excel?
  • Guest
Replies
2
Views
50K
Gord Dibben
G
G
Limit of # of tabs
  • Guest
Replies
3
Views
136K
Gord Dibben
G
G
I need to put text after the value of a referenced cell (=B4'MS')
  • Guest
Replies
2
Views
50K
Gord Dibben
G
G
mapping with excel
  • Guest
Replies
1
Views
94K
Gord Dibben
G
G
vlook up
  • Guest
Replies
1
Views
214K
KL
K
G
To show blank please
  • Guest
Replies
2
Views
40K
Guest
G
G
vlookup returning sum
  • Guest
Replies
1
Views
48K
Trevor Shuttleworth
T
G
Conditional Filtering
  • Guest
Replies
2
Views
19K
Guest
G
G
I Need to Count Number of Entries Based on Two Criteria
  • Guest
Replies
3
Views
26K
optionbase1
O
G
Sum & copy color format...?
  • Guest
Replies
1
Views
186K
optionbase1
O
S
Sum Count of Single Criteria in Multiple Non-Adjacent columns
  • Sam via OfficeKB.com
Replies
9
Views
555K
Sam via OfficeKB.com
S
G
How do you...
  • Guest
Replies
3
Views
61K
cgarrett1999
C
G
???is there a way to keep one row in view while scrolling down???
  • Guest
Replies
1
Views
107K
CLR
C
G
How do I Provide a specific result given multiple criteria?
  • Guest
Replies
1
Views
32K
Barb Reinhardt
B
S
Arithmetical Mode of Criteria in Multiple Non-Adjacent columns
  • Sam via OfficeKB.com
Replies
4
Views
559K
Sam via OfficeKB.com
S
A
If statement
  • Annette
Replies
2
Views
43K
Annette
A
You must log in or register to post here.
Back
Top