Microsoft Excel Worksheet Functions

T
How to lock worksheet formatting?
  • TANDEX
Replies
1
Views
43K
Guest
G
G
Search a Column by text length
  • Guest
Replies
2
Views
57K
Guest
G
G
Visual Basic code available for all open workbooks
  • Guest
Replies
5
Views
121K
Chip Pearson
C
G
Averages and Counts from different columns
  • Guest
2
Replies
21
Views
19K
Guest
G
G
Dates/Amounts calcs
  • Guest
Replies
4
Views
51K
Guest
G
G
How do I set an automatic date stamp into a cell in Excel?
  • Guest
Replies
1
Views
76K
Bob Phillips
B
S
Undo a array
  • Scott Calkins via OfficeKB.com
Replies
3
Views
228K
Scott Calkins via OfficeKB.com
S
G
why does ON = Ambiguous in substitution formula?
  • Guest
Replies
5
Views
187K
Guest
G
G
COUNT NON-BLANK CELLS WITH REFERENCE TO ANOTHER COLUMN
  • Guest
Replies
1
Views
225K
Guest
G
G
Countif with cell reference
  • Guest
Replies
2
Views
101K
Guest
G
T
Sumproduct with a vLookup, multiple criteria
  • Tom F
Replies
3
Views
242K
Tom F
T
G
Working time and days
  • Guest
Replies
5
Views
316K
Bob Phillips
B
D
Conditional Average Ignoring Blanks
  • Dirk Friedrichs via OfficeKB.com
Replies
2
Views
32K
Dirk Friedrichs via OfficeKB.com
D
G
Number anagram
  • Guest
Replies
5
Views
139K
Guest
G
G
Printing from email without Word/Excel
  • Guest
Replies
1
Views
43K
Guest
G
G
Retrieving a Reference
  • Guest
Replies
4
Views
94K
Guest
G
C
Concatenate text and numbers?
  • CLR
Replies
8
Views
279K
Dave Peterson
D
G
Trailing spaces in Pivot tables
  • Guest
Replies
1
Views
102K
Tom Ogilvy
T
M
Deleting ALL duplicates using Pearson's code
  • mike.wilson8
Replies
2
Views
50K
Bernie Deitrick
B
S
Countin Dates
  • Steve J
Replies
4
Views
93K
Daniel.M
D
J
Protect sheet and allow grouping of columns
  • Job
Replies
2
Views
158K
Job
J
G
Lookup problems
  • Guest
Replies
1
Views
36K
Guest
G
W
VB find (true false)
  • Wildman
Replies
6
Views
84K
Bob Phillips
B
G
Excel formulas are slow to update
  • Guest
Replies
2
Views
30K
Aladin Akyurek
A
G
using cells.numberformat
  • Guest
Replies
2
Views
96K
Bob Phillips
B
G
adding worksheets with conditions
  • Guest
Replies
4
Views
222K
Guest
G
G
Simplify formula
  • Guest
2
Replies
37
Views
3M
Harlan Grove
H
G
how to convert rpt files to xls
  • Guest
Replies
1
Views
440K
Harlan Grove
H
U
Unwanted character
  • user
Replies
2
Views
55K
David McRitchie
D
A
Subtracting numbers
  • Annette
Replies
3
Views
100K
CLR
C
G
how do I get excel to ignore blank cells in formulas
  • Guest
Replies
1
Views
276K
Biff
B
M
Unwanted character
  • martina.mangan
Replies
2
Views
75K
Guest
G
K
Fomatting part of a formula to be Bold font
  • KimberlyC
Replies
7
Views
377K
[email protected]
H
H
Wildcard MATCH() breaks on long (?) strings
  • Hash
Replies
6
Views
600K
[email protected]
H
G
DCOUNT in Excel
  • Guest
Replies
1
Views
64K
Peo Sjoblom
P
G
Excel 2002: I get formulae displaying in cells rather than value
  • Guest
Replies
2
Views
123K
Dave Peterson
D
G
Formula/function
  • Guest
Replies
3
Views
116K
Bob Phillips
B
G
how to convert julian date to regular calendar date
  • Guest
Replies
5
Views
311K
Max
M
G
# of occurrences
  • gbeard
Replies
1
Views
46K
JE McGimpsey
J
G
protect from printing
  • Guest
Replies
1
Views
62K
JE McGimpsey
J
G
Importing data from a different workbook
  • Guest
Replies
1
Views
45K
David McRitchie
D
G
Calculation for Ebay worksheet.
  • greggin via OfficeKB.com
Replies
3
Views
305K
greggin via OfficeKB.com
G
G
How to use functions in one cell to get text in another cell
  • Guest
Replies
8
Views
274K
Ken Wright
K
G
sort by more than 3 columns
  • Guest
Replies
3
Views
18K
Guest
G
F
Search string with multiple criteria
  • fLiPMoD£
Replies
2
Views
93K
Harlan Grove
H
G
convert Julian date
  • Guest
Replies
3
Views
172K
Guest
G
G
Excel add-in
  • Guest
Replies
5
Views
216K
Bob Phillips
B
G
compare two columns and remove duplicates
  • Guest
Replies
3
Views
21K
David McRitchie
D
G
Indent within a row
  • Guest
Replies
3
Views
70K
David McRitchie
D
G
Block entries
  • Guest
Replies
2
Views
107K
Guest
G
You must log in or register to post here.
Back
Top