Microsoft Excel Worksheet Functions

Post thread
Z
Satisfying two conditions?
  • Zuo
Replies
8
Views
497
Fred Smith
F
R
what should be simple
  • Rene
Replies
4
Views
426
Bob Phillips
B
S
Show matching data in several worksheets
  • Steve
Replies
4
Views
461
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
348
Gary Brown
G
P
11 months and 1 day from a given date
  • pk
Replies
6
Views
486
Ashish Mathur
A
E
Count first and last characters
  • Elton Law
Replies
3
Views
421
Ashish Mathur
A
U
copying a formula down wards
  • UKMAN
Replies
10
Views
843
Ashish Mathur
A
S
Help Needed with Dynamic CountIF
  • Steve
Replies
4
Views
538
Steve
S
R
Change a cells value with a function
  • Ryan H
Replies
4
Views
353
Ryan H
R
J
Automatically hide/unhide rows
  • JStiehl
Replies
5
Views
958
JStiehl
J
C
Referencing relative to a formula reference
  • Csaba Gabor
Replies
3
Views
460
Bob Phillips
B
D
Date + relative number reference
  • Derek M
Replies
3
Views
377
Derek M
D
A
Despite formula I use (for example SUM) result is always zero.
  • Anida
Replies
4
Views
483
Dave Peterson
D
S
Excel Formulas
  • Shona
Replies
3
Views
470
Shona
S
M
How to Sum infinite formula
  • minyeh
Replies
7
Views
698
minyeh
M
E
Finding matches in two columns
  • Erik
Replies
4
Views
451
T. Valko
T
L
IF function
  • Lost Cluster
Replies
4
Views
449
FSt1
F
S
SUMPRODUCT
  • Skinman
Replies
3
Views
489
T. Valko
T
R
Referencing formula using Indirect
  • Raj
Replies
4
Views
606
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
660
Bob Phillips
B
A
List the UNIQUE certain fields from the database
  • Andri
Replies
5
Views
463
Dana DeLouis
D
G
Sumproduct with mixed data?
  • gooders
Replies
6
Views
646
T. Valko
T
D
how do I copy the last 20 entries in an expanding list
  • DJA
Replies
4
Views
496
Teethless mama
T
J
Percentages in Pivotal
  • JoeM
Replies
3
Views
462
Ashish Mathur
A
M
How do I use a percentage formula?
  • MeursaultO
Replies
2
Views
442
Ashish Mathur
A
A
Reference: forum discussion dated 17-18April2010
  • Andri
Replies
3
Views
376
Ashish Mathur
A
T
how to remove all formatting
  • Tom
Replies
14
Views
680
XLGeek
X
R
Drill down via page fields
  • Roland Grothe
Replies
1
Views
576
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
726
Dave Peterson
D
T
Rounding Seconds in 4/21/2010 4:30:23 PM
  • Tom Langley
Replies
3
Views
522
Joe User
J
B
Head scratchin for hours.... Help with a formula please...
  • Bill Needham
Replies
6
Views
460
T. Valko
T
E
Count the frequency for every change in numbers
  • Elton Law
Replies
6
Views
520
Elton Law
E
N
Saving & Removing VB Code from WB
  • NoodNutt
Replies
6
Views
506
NoodNutt
N
P
Vlookup and Indirect
  • Puppies72
Replies
0
Views
464
Puppies72
P
D
Daily totals from a monthly log
  • Dhardy
Replies
1
Views
601
Teethless mama
T
A
to CONCATENATE from the smallest date with at least 2 criteria
  • Andri
Replies
17
Views
661
Andri
A
J
Shared Excel File
  • jkcates
Replies
1
Views
398
Gord Dibben
G
J
Creating a formula
  • Jupiter53132
Replies
1
Views
269
Teethless mama
T
M
Locking Worksheet Security Name
  • Mumsy
Replies
1
Views
296
Mike H
M
M
Pre-Populating Fields
  • MP
Replies
2
Views
292
Teethless mama
T
O
Word lists
  • overthehill lady
Replies
3
Views
347
Teethless mama
T
M
Need a code
  • MAX
Replies
1
Views
325
Luke M
L
F
VLOOKUP and IF together
  • FR
Replies
3
Views
484
Don Guillett
D
A
Help me (Vlookup)
  • Amin
Replies
6
Views
450
L. Howard Kittle
L
S
VLookup between date ranges ?
  • Steve
Replies
6
Views
3K
Steve
S
G
COUNTIF Formula
  • Gyles
Replies
1
Views
354
Jacob Skaria
J
A
Formulas do not update
  • AZSteve
Replies
2
Views
522
AZSteve
A
Back
Top