Microsoft Excel Worksheet Functions

Post thread
Z
Satisfying two conditions?
  • Zuo
Replies
8
Views
511
Fred Smith
F
R
what should be simple
  • Rene
Replies
4
Views
435
Bob Phillips
B
S
Show matching data in several worksheets
  • Steve
Replies
4
Views
475
Max
M
A
Fill/Extend Series adding decimal points to some numbers
  • awalker
Replies
1
Views
2K
Pete_UK
P
T
limit comments to only 600 words
  • Tim
Replies
2
Views
349
Gary Brown
G
P
11 months and 1 day from a given date
  • pk
Replies
6
Views
502
Ashish Mathur
A
E
Count first and last characters
  • Elton Law
Replies
3
Views
422
Ashish Mathur
A
U
copying a formula down wards
  • UKMAN
Replies
10
Views
857
Ashish Mathur
A
S
Help Needed with Dynamic CountIF
  • Steve
Replies
4
Views
545
Steve
S
R
Change a cells value with a function
  • Ryan H
Replies
4
Views
362
Ryan H
R
J
Automatically hide/unhide rows
  • JStiehl
Replies
5
Views
961
JStiehl
J
C
Referencing relative to a formula reference
  • Csaba Gabor
Replies
3
Views
474
Bob Phillips
B
D
Date + relative number reference
  • Derek M
Replies
3
Views
382
Derek M
D
A
Despite formula I use (for example SUM) result is always zero.
  • Anida
Replies
4
Views
499
Dave Peterson
D
S
Excel Formulas
  • Shona
Replies
3
Views
472
Shona
S
M
How to Sum infinite formula
  • minyeh
Replies
7
Views
705
minyeh
M
E
Finding matches in two columns
  • Erik
Replies
4
Views
470
T. Valko
T
L
IF function
  • Lost Cluster
Replies
4
Views
458
FSt1
F
S
SUMPRODUCT
  • Skinman
Replies
3
Views
496
T. Valko
T
R
Referencing formula using Indirect
  • Raj
Replies
4
Views
625
Raj
R
D
IFERROR in Excel 2007
  • Dirrk
Replies
5
Views
896
Danny Rocks
D
E
Find second to last value in cell
  • Eric_G
Replies
4
Views
669
Bob Phillips
B
A
List the UNIQUE certain fields from the database
  • Andri
Replies
5
Views
470
Dana DeLouis
D
G
Sumproduct with mixed data?
  • gooders
Replies
6
Views
656
T. Valko
T
D
how do I copy the last 20 entries in an expanding list
  • DJA
Replies
4
Views
498
Teethless mama
T
J
Percentages in Pivotal
  • JoeM
Replies
3
Views
466
Ashish Mathur
A
M
How do I use a percentage formula?
  • MeursaultO
Replies
2
Views
449
Ashish Mathur
A
A
Reference: forum discussion dated 17-18April2010
  • Andri
Replies
3
Views
378
Ashish Mathur
A
T
how to remove all formatting
  • Tom
Replies
14
Views
690
XLGeek
X
R
Drill down via page fields
  • Roland Grothe
Replies
1
Views
581
Herbert Seidenberg
H
G
how to sum cells and ignore the #div/0! 's ?
  • Guest
Replies
6
Views
15K
abdul gaffoor
A
G
VLOOKUP in VBA
  • G.P.N.L. c.v.a.
Replies
7
Views
732
Dave Peterson
D
T
Rounding Seconds in 4/21/2010 4:30:23 PM
  • Tom Langley
Replies
3
Views
535
Joe User
J
B
Head scratchin for hours.... Help with a formula please...
  • Bill Needham
Replies
6
Views
468
T. Valko
T
E
Count the frequency for every change in numbers
  • Elton Law
Replies
6
Views
531
Elton Law
E
N
Saving & Removing VB Code from WB
  • NoodNutt
Replies
6
Views
510
NoodNutt
N
P
Vlookup and Indirect
  • Puppies72
Replies
0
Views
478
Puppies72
P
D
Daily totals from a monthly log
  • Dhardy
Replies
1
Views
606
Teethless mama
T
A
to CONCATENATE from the smallest date with at least 2 criteria
  • Andri
Replies
17
Views
670
Andri
A
J
Shared Excel File
  • jkcates
Replies
1
Views
404
Gord Dibben
G
J
Creating a formula
  • Jupiter53132
Replies
1
Views
274
Teethless mama
T
M
Locking Worksheet Security Name
  • Mumsy
Replies
1
Views
301
Mike H
M
M
Pre-Populating Fields
  • MP
Replies
2
Views
293
Teethless mama
T
O
Word lists
  • overthehill lady
Replies
3
Views
348
Teethless mama
T
M
Need a code
  • MAX
Replies
1
Views
335
Luke M
L
F
VLOOKUP and IF together
  • FR
Replies
3
Views
525
Don Guillett
D
A
Help me (Vlookup)
  • Amin
Replies
6
Views
453
L. Howard Kittle
L
S
VLookup between date ranges ?
  • Steve
Replies
6
Views
3K
Steve
S
G
COUNTIF Formula
  • Gyles
Replies
1
Views
357
Jacob Skaria
J
A
Formulas do not update
  • AZSteve
Replies
2
Views
537
AZSteve
A
Back
Top