Microsoft Excel Worksheet Functions

Post thread
L
Sum if cell = grey
  • LiAD
Replies
4
Views
7K
Gord Dibben
G
J
Need Help Deleting Blank Rows
  • JCG
Replies
3
Views
350
Gord Dibben
G
N
Rename Worksheet From Cell Data
  • navel151
Replies
6
Views
909
Gord Dibben
G
A
Reverse word
  • Amnon Wilensky
Replies
2
Views
398
Gord Dibben
G
Z
Copying data from 205 columns to 1 column
  • Zuo
Replies
4
Views
535
Max
M
L
Sumif contains formula
  • LiAD
Replies
4
Views
539
LiAD
L
C
Check Dynamic Named Range
  • Code Numpty
Replies
5
Views
376
Pete_UK
P
M
cell reference of a formula
  • Marzia
Replies
2
Views
443
[email protected]
A
T
Counting Values in a list
  • Tony Brooks
Replies
2
Views
415
Gary''s Student
G
B
How do I put in a formula in Exel to calculate a persons age?
  • boofire19
Replies
11
Views
1K
Duke Carey
D
A
"Convert Currency to Words in Indian Style"
  • atiq8961
Replies
2
Views
3K
atiq8961
A
S
How do I format cells in Excel to make 175/5 read 175?
  • SJR4347
Replies
2
Views
404
Fred Smith
F
J
Workbook pivot table design function
  • Jazz
Replies
6
Views
513
Max
M
B
Sumproduct formula problems
  • BeSmart
Replies
2
Views
637
BeSmart
B
B
Where to find XNPV and XIRR?
  • billbrandi
Replies
1
Views
479
Mike H
M
F
Formula Help-Excel 2007
  • formulaconfusion
Replies
2
Views
540
Stan Brown
S
N
Need Macro to Collect Multiple Worksheet Names
  • navel151
Replies
3
Views
630
Gord Dibben
G
L
help with formula =valuesA1
  • Larry
Replies
3
Views
256
Larry
L
C
Protecting Excel Formulas
  • Chris@Preston
Replies
2
Views
519
Gord Dibben
G
M
Desire Weekday returned in every 5th Cell
  • MMangen
Replies
1
Views
427
Lars-Åke Aspelin
L
G
Drop down menu
  • George
Replies
2
Views
337
Gord Dibben
G
B
Timesheet Calculation
  • blueriver
Replies
8
Views
532
WallyWallWhackr
W
S
Compound interest with premium growing
  • Simba
Replies
9
Views
726
Dana DeLouis
D
S
hOW TO USE eXCEL FUNCTION
  • SHIV JHA
Replies
2
Views
885
Teethless mama
T
P
COUNTIF across worksheets
  • pdberger
Replies
3
Views
723
Mike H
M
B
Sumproduct formula
  • BeSmart
Replies
6
Views
664
BeSmart
B
S
Sum in another cell with reference to another
  • Shirl
Replies
1
Views
447
Max
M
A
Calc sometimes off by a penny
  • Access Joe
Replies
5
Views
1K
Bernd P
B
R
Conditional Accounts receivable Aging Analysis
  • rushdhih
Replies
0
Views
2K
rushdhih
R
P
running time
  • pat67
Replies
1
Views
329
Bob Bridges
B
Q
Multiply a co;omn by a constant
  • Q
Replies
2
Views
763
T. Valko
T
F
Display information from other worksheet
  • Frustrated
Replies
1
Views
405
Otto Moehrbach
O
N
Function to Insert Text Into a Formula
  • navel151
Replies
3
Views
991
Pete_UK
P
G
Data entered from list automatically enters number in another cell
  • gbryce
Replies
4
Views
670
Pete_UK
P
J
Open Workbook at a certain time
  • jswalsh33
Replies
2
Views
396
Raz Boyarski
R
P
Lookup value with multiple criteria using data from 2 different sheets
  • pugazh
Replies
0
Views
640
pugazh
P
C
Nested Formulas v Named Formulas Any other solutions?
  • Code Numpty
Replies
10
Views
856
Code Numpty
C
R
HOW TO USE BAHTTEXT FORMULA
  • RAJEEV
Replies
2
Views
2K
mani mani
M
N
Reference text in a cell inside a formula to specify a sheet name
  • navel151
Replies
4
Views
13K
navel151
N
F
SUMIF
  • Fazli Wahid
Replies
2
Views
234
Ashish Mathur
A
C
Conditional/variable sum??
  • Costas Limassol
Replies
7
Views
570
Ashish Mathur
A
A
filtering: sometimes data below blank lines is &isnt available?
  • Allison
Replies
2
Views
422
Fred Smith
F
C
Help with Formula Please
  • Corca
Replies
5
Views
504
Fred Smith
F
S
% of subtotal in pivot tables
  • suziep
Replies
1
Views
568
Debra Dalgleish
D
P
2007 Pivot table Calculated field misbehaving
  • Pierre
Replies
1
Views
590
Debra Dalgleish
D
C
Help with a Formula Please
  • Corca
Replies
4
Views
393
Corca
C
B
match??
  • brownmre
Replies
1
Views
467
T. Valko
T
B
Formula Help
  • Brittany
Replies
1
Views
274
Brittany
B
D
Transfering data from a .pdf file to word and then to excel
  • David Bateman
Replies
1
Views
315
Gord Dibben
G
C
Automatically Transfer Info from one worksheet to another
  • coriander1209
Replies
1
Views
497
Gord Dibben
G
Back
Top