Microsoft Excel Worksheet Functions

G
How can I include the name of the tab in a header without typing .
  • Guest
Replies
1
Views
81K
Gord Dibben
G
G
Saving a file using a specific name in a cell
  • Guest
Replies
4
Views
378K
Gord Dibben
G
G
How can I do a "best match" for text entries?
  • Guest
Replies
1
Views
117K
Trevor Shuttleworth
T
G
What does ={TABLE(,J213)} in the fx Box Mean?
  • Guest
Replies
7
Views
307K
Guest
G
G
Check Box
  • Guest
Replies
1
Views
38K
Dave Peterson
D
G
convert a numerical currency into word format
  • Guest
Replies
1
Views
126K
Fredrik Wahlgren
F
G
finding the largest number from the last row and look up its name.
  • Guest
Replies
5
Views
857K
Max
M
G
Sub-total feature is unavailable in Office 2003 Excel
  • Guest
Replies
5
Views
94K
Peo Sjoblom
P
B
Incrementing formula by two rows
  • Ben Hur
Replies
1
Views
141K
Steve
S
G
Match function selecting first value it matches on exactly
  • Guest
Replies
1
Views
93K
Bernd Plumhoff
B
G
VLookup? Right function?
  • Guest
Replies
1
Views
42K
Biff
B
G
Can I use the contents of a cell to satisfy the result_vector arg.
  • Guest
Replies
3
Views
216K
RagDyer
R
G
Excel shifts to wrong worksheet automatically
  • Guest
Replies
1
Views
182K
dave
D
G
how do i open a 2003 file into an xp spreadsheet
  • Guest
Replies
2
Views
124K
Ken Wright
K
G
SUM a column with errors
  • Guest
Replies
3
Views
114K
Guest
G
G
Excel should allow a number formats of HEX, OCT and BIN.
  • Guest
Replies
3
Views
158K
Harlan Grove
H
G
Concatenating Dates
  • Guest
Replies
2
Views
94K
Guest
G
U
opening worksheet is "packing list"
  • usrofc
Replies
1
Views
114K
Gord Dibben
G
G
is there a more efficient formula than...
  • Guest
Replies
6
Views
110K
Ken Wright
K
G
How I show, automatically, the tab name on a cell, in Excel?
  • Guest
Replies
4
Views
80K
Sarah
S
G
"count if" function based on value of another cell
  • Guest
Replies
3
Views
69K
Bernie Deitrick
B
G
why do my spreadsheet gridlines only prints half way on the page?.
  • Guest
Replies
2
Views
492K
BobT
B
G
I entered 11/22/2004 in excel workbook and it keeps changing to ##
  • Guest
Replies
1
Views
78K
Peo Sjoblom
P
P
Check for errors
  • Pat
Replies
3
Views
319K
Peo Sjoblom
P
G
Excel should support DAYOFYEAR(year,month,day) returns julian dat.
  • Guest
Replies
1
Views
66K
Jason Morin
J
D
Worksheet Function - Find?
  • DAA
Replies
2
Views
129K
DAA
D
P
Formula presumes cells have data
  • Pat
Replies
1
Views
157K
Peo Sjoblom
P
G
How can I write a formula or an argument to highlight a date when.
  • Guest
Replies
1
Views
30K
Jason Morin
J
R
Can I put Pop up menus on Excel
  • Ricardo Munoz
Replies
2
Views
60K
Bob Phillips
B
G
What does a "plus" cursor mean (in lieu of the pointer?)? thanks
  • Guest
Replies
4
Views
176K
Peo Sjoblom
P
G
how do i set up a formulas with an if date?
  • Guest
Replies
3
Views
319K
Peo Sjoblom
P
G
unwanted number to date conversion while pasting data from web
  • Guest
Replies
1
Views
116K
Peo Sjoblom
P
G
converting to numbers
  • Guest
Replies
1
Views
78K
Peo Sjoblom
P
G
text splits down cells
  • Guest
Replies
1
Views
82K
Fred
F
P
Tje opposite appears to be happening
  • Pat
Replies
5
Views
276K
Bob Phillips
B
G
Use address function or other
  • Guest
Replies
1
Views
58K
Jason Morin
J
D
What's wrong with this vb?
  • DaveMoore
Replies
2
Views
81K
DaveMoore
D
G
Protect the formula but change result.
  • Guest
Replies
1
Views
66K
Bob Phillips
B
G
Match or vlookup?
  • Guest
Replies
1
Views
142K
Jerry W. Lewis
J
G
Multipart formula needed
  • Guest
Replies
2
Views
374K
Guest
G
P
find LAST match in column
  • Pantryman
Replies
7
Views
175K
Aladin Akyurek
A
G
Want to return a value based on a whether a number is within a ra.
  • Guest
Replies
3
Views
187K
JulieD
J
G
formula to extract specific data if match occurs
  • Guest
Replies
2
Views
143K
Aladin Akyurek
A
J
VLOOKUP or MATCH
  • Jaladino
Replies
1
Views
310K
David McRitchie
D
G
Learn formulas
  • Guest
Replies
1
Views
41K
David McRitchie
D
A
sumproduct function
  • Andreea Moyes via OfficeKB.com
Replies
3
Views
24K
Aladin Akyurek
A
G
problem working with time data imported from text file
  • Guest
Replies
1
Views
219K
Biff
B
V
weight formula
  • veronic633
Replies
4
Views
53K
Ragdyer
R
G
every nth cell by columns not rows....
  • Guest
Replies
1
Views
206K
Biff
B
G
Using COUNTIF with 2 criteria - SUMPRODUCT?
  • Guest
Replies
2
Views
50K
Guest
G
You must log in or register to post here.
Back
Top