Microsoft Excel Worksheet Functions

J
Dividing by zero
  • jvega
Replies
12
Views
224K
Dave
D
A
pivot table subtotals
  • Ann
Replies
3
Views
384K
ShaneDevenshire
S
J
Lookup Formula
  • JES
Replies
3
Views
275K
RagDyer
R
K
COUNTIF AND
  • Kara
Replies
9
Views
80K
PCLIVE
P
H
Sum? IF? function
  • handyaccountant
Replies
3
Views
305K
Marcelo
M
B
Formula Help
  • Buckeyes08
Replies
2
Views
86K
Brad
B
M
MATCH function?
  • mwam423
Replies
3
Views
56K
mwam423
M
M
TABLE function?
  • Mike C
Replies
2
Views
144K
Niek Otten
N
T
sorting out rows
  • Tom
Replies
2
Views
222K
ShaneDevenshire
S
P
Separating characters from a cell so I can sort on them
  • Princess Caroline
Replies
6
Views
84K
Rick Rothstein \(MVP - VB\)
R
M
Stop automatic formatting of cells (number, text, date, etc)
  • Marcela
Replies
4
Views
319K
Marcela
M
R
Can I save different sets of sort criteria for a spreadsheet?
  • rcntc
Replies
2
Views
77K
Meebers
M
J
Splitting complex string into 3 numbers with a formula - Please help!
  • Jason
Replies
8
Views
256K
Rick Rothstein \(MVP - VB\)
R
P
rate with different pmv
  • pth
Replies
3
Views
432K
pth
P
L
Static Count blank
  • Luke
Replies
13
Views
716K
T. Valko
T
P
Choose merged cell and sum data
  • PWK
Replies
1
Views
51K
PWK
P
D
SUMIF nesting ???
  • Dave
Replies
3
Views
299K
Dave
D
S
update formula in column when another cell formula is changed
  • Susanelm
Replies
1
Views
375K
Bernard Liengme
B
J
Data Validation Input Message Box too small
  • Joe
Replies
2
Views
227K
Debra Dalgleish
D
T
Date - Help
  • trevor
Replies
7
Views
589K
trevor
T
J
Matching 2nd & 3rd values
  • johan.retief
Replies
1
Views
188K
Mike H
M
L
IF THEN
  • LB
Replies
2
Views
112K
Brad
B
M
How can I break up a worksheet into weeks?
  • MinConst
Replies
3
Views
191K
ward376
W
A
How do i subtract 3 hrs from now()?
  • Andy
Replies
7
Views
124K
Bob Phillips
B
S
Decimal Time Subtractions
  • Steved
Replies
3
Views
65K
Stefi
S
T
STDEV (1st, 2nd, 3rd) and excluding datapoints
  • Tom
Replies
1
Views
341K
joeu2004
J
E
Calculate current time + 7 hours and skipping weekends
  • Eric
Replies
3
Views
376K
Ron Rosenfeld
R
M
Vlookup using concatenated column indexes
  • Matt
Replies
7
Views
569K
Max
M
L
Data Validation
  • leimst
Replies
1
Views
249K
Max
M
M
if then statements
  • Mercy
Replies
2
Views
298K
Mercy
M
J
VLookup & Match?
  • Jason
Replies
1
Views
194K
Max
M
J
Find repeated text in a text document in Excel
  • JE
Replies
2
Views
66K
Ron Rosenfeld
R
S
Conditional formatting
  • staffrmj
Replies
8
Views
633K
staffrmj
S
B
Auto delete a row after 5 weeks in Excel
  • Bill unsavvy
Replies
1
Views
62K
Dave
D
J
workbook protection
  • jolowe
Replies
3
Views
234K
Shane Devenshire
S
D
Display conditional formatting if cell value equals an integer
  • David
Replies
1
Views
75K
T. Valko
T
R
double click on cell that have link, Excel will jump to the refere
  • RW
Replies
1
Views
487K
Gord Dibben
G
R
combine information from multiple file into many different files.
  • RW
Replies
2
Views
310K
RW
R
J
Lookup & Give Specified Info. in Specified column
  • Jason
Replies
1
Views
185K
Max
M
D
Index...
  • Dave
Replies
10
Views
20K
Harlan Grove
H
M
Difficulty with IMPOWER() Worksheet Function
  • monir
Replies
7
Views
597K
Harlan Grove
H
D
Lookup question
  • dtb
Replies
1
Views
26K
Max
M
J
Double column lookup formula Help
  • JE
Replies
2
Views
204K
T. Valko
T
A
How do I highlight cells in a worksheet having a particular value?
  • Alok
Replies
1
Views
67K
Peo Sjoblom
P
J
Dynamic Sheet Name in Vlookup
  • John
Replies
6
Views
757K
John
J
M
Express a large number in fewer digits $1,264,567.50 = $1.3 M
  • Mumpa
Replies
2
Views
27K
Mumpa
M
E
Get lower half of a column of numbers
  • EllenM
Replies
2
Views
40K
EllenM
E
A
Sorting dates and inserting rows
  • Andy
Replies
3
Views
85K
Gord Dibben
G
T
display contents of cell if adjacent cell equals
  • Travis
Replies
1
Views
339K
Gary''s Student
G
S
sum of cells in new worksheet
  • Sharon
Replies
1
Views
58K
Gary''s Student
G
You must log in or register to post here.
Back
Top