Microsoft Excel Worksheet Functions

Post thread
M
Formula, text and currency in same cell
  • mike
Replies
2
Views
3K
driller
D
B
Conditional Formatting Function for Anniversary Dates
  • blucajun
Replies
5
Views
1K
Sandy Mann
S
J
rulers in excel
  • jones
Replies
1
Views
352
Harlan Grove
H
T
Nested IF?
  • Toria
Replies
3
Views
280
Harlan Grove
H
G
Lookup table with duplicate 'lookup_values'
  • Greggers
Replies
7
Views
410
Max
M
S
SumIf
  • Shams
Replies
4
Views
418
Bob Phillips
B
D
DAYS360 + 2 If Functions
  • Dixie
Replies
1
Views
503
Bob Phillips
B
X
Getting round the sensitivity of "sumif" formula
  • Xueling
Replies
1
Views
357
Bob Phillips
B
P
WEEKNUM calculations for week stating with Tuesday
  • P C Verma
Replies
7
Views
480
Stefi
S
G
Excel link with Word
  • gboll
Replies
3
Views
359
ryguy7272
R
T
creating formulas for sequential numbers in excel
  • tacks
Replies
4
Views
3K
tacks
T
C
Conditional format -> another cell
  • CT
Replies
1
Views
243
T. Valko
T
D
referencing worksheet tabs
  • davsco
Replies
1
Views
387
T. Valko
T
H
Divide by Zero Error
  • hkslater
Replies
6
Views
509
T. Valko
T
A
Hlookup and sum noncontiguous numbers
  • Amy
Replies
1
Views
786
Max
M
J
Excel
  • jrufus
Replies
1
Views
235
Meebers
M
J
SUMIF
  • JBoyer
Replies
4
Views
447
JBoyer
J
A
excel formula
  • AkitaMom
Replies
4
Views
209
AkitaMom
A
A
Adding text columns
  • ARS_MEL
Replies
1
Views
272
Dave Peterson
D
W
Worksheet showing # col headings. How to chg to letters?
  • wavesmm
Replies
1
Views
338
Mike H
M
T
Extracting values from a single dynamic cell to a list daily
  • Terry
Replies
1
Views
420
Otto Moehrbach
O
L
Date Formula
  • Lynn H.
Replies
3
Views
201
RinTinTin
R
S
Ignore zero in subtotal formula
  • Sarah (OGI)
Replies
2
Views
3K
RinTinTin
R
C
Desperate for help with a VLOOKUP
  • chris
Replies
5
Views
562
Spiky
S
N
HOW DO I CREATE A DROPDOWN PICK LIST FROM A VLOOKUP with multiple
  • NSH
Replies
1
Views
539
Spiky
S
R
count only certain cells
  • Robert-Alpha
Replies
2
Views
371
Mike H
M
R
Data validation: want input restricted to date value or N/A
  • Rachel Garrett
Replies
2
Views
2K
Rachel Garrett
R
A
Summing across multiple sheets using a changeable reference cell
  • ajnmx
Replies
2
Views
441
ajnmx
A
B
VLookup returning with "NA"
  • Bridget
Replies
4
Views
477
Bridget
B
N
Looking for a formula
  • Natalie
Replies
4
Views
273
Sandy Mann
S
B
receive one value using two or more criteria
  • billdad
Replies
2
Views
288
Dave
D
T
Inserting rows in a protected sheet - Office 2003
  • Todd A
Replies
2
Views
468
Todd A
T
C
vlookup returns NA after a second value returned the same
  • Carolina
Replies
1
Views
476
Carolina
C
A
Sumif as a fuction of If using multiple criteria
  • AMB
Replies
2
Views
501
PCLIVE
P
D
#Value in named range
  • Dkline
Replies
4
Views
558
Dkline
D
P
If Then formula help needed
  • Paula
Replies
3
Views
319
Paula
P
V
Split the cell
  • Vanja
Replies
2
Views
394
Vanja
V
A
Finding the percentage
  • Anthony P.
Replies
4
Views
428
Anthony P.
A
C
Sorry for the repost, but still need some advice
  • chris
Replies
2
Views
370
Don Guillett
D
B
Formating Total Number of Days
  • Big Tony
Replies
6
Views
524
Ron Rosenfeld
R
D
Shortcut Key Date Format
  • Daniel L. Lieberman
Replies
2
Views
433
Daniel L. Lieberman
D
B
GetPivotData from OLAP Cube Cell Referencing Formula.
  • Bazy2k
Replies
1
Views
3K
Debra Dalgleish
D
S
Minusing 17.5% off a column of figures
  • Sue
Replies
2
Views
364
Mike H
M
S
Monthly subtotals
  • Segovia
Replies
1
Views
313
Pete_UK
P
K
Return null
  • Karen
Replies
3
Views
375
Dennis
D
D
lease commitments
  • Desperatesusy
Replies
2
Views
456
Desperatesusy
D
T
formula to add time elapsed
  • twills44
Replies
1
Views
396
JE McGimpsey
J
W
Average of select range of numbers
  • W Palermo
Replies
2
Views
424
T. Valko
T
J
Counting bold cells in table rows
  • John
Replies
2
Views
416
Gord Dibben
G
C
IF/AND Formula Problem
  • CT
Replies
9
Views
468
Max
M
Back
Top