Microsoft Excel Worksheet Functions

Post thread
Z
Satisfying two conditions?
  • Zuo
Replies
8
Views
538
Fred Smith
F
R
what should be simple
  • Rene
Replies
4
Views
457
Bob Phillips
B
S
Show matching data in several worksheets
  • Steve
Replies
4
Views
490
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
354
Gary Brown
G
P
11 months and 1 day from a given date
  • pk
Replies
6
Views
513
Ashish Mathur
A
E
Count first and last characters
  • Elton Law
Replies
3
Views
430
Ashish Mathur
A
U
copying a formula down wards
  • UKMAN
Replies
10
Views
872
Ashish Mathur
A
S
Help Needed with Dynamic CountIF
  • Steve
Replies
4
Views
559
Steve
S
R
Change a cells value with a function
  • Ryan H
Replies
4
Views
370
Ryan H
R
J
Automatically hide/unhide rows
  • JStiehl
Replies
5
Views
1K
JStiehl
J
C
Referencing relative to a formula reference
  • Csaba Gabor
Replies
3
Views
487
Bob Phillips
B
D
Date + relative number reference
  • Derek M
Replies
3
Views
398
Derek M
D
A
Despite formula I use (for example SUM) result is always zero.
  • Anida
Replies
4
Views
520
Dave Peterson
D
S
Excel Formulas
  • Shona
Replies
3
Views
484
Shona
S
M
How to Sum infinite formula
  • minyeh
Replies
7
Views
724
minyeh
M
E
Finding matches in two columns
  • Erik
Replies
4
Views
484
T. Valko
T
L
IF function
  • Lost Cluster
Replies
4
Views
484
FSt1
F
S
SUMPRODUCT
  • Skinman
Replies
3
Views
510
T. Valko
T
R
Referencing formula using Indirect
  • Raj
Replies
4
Views
647
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
687
Bob Phillips
B
A
List the UNIQUE certain fields from the database
  • Andri
Replies
5
Views
498
Dana DeLouis
D
G
Sumproduct with mixed data?
  • gooders
Replies
6
Views
678
T. Valko
T
D
how do I copy the last 20 entries in an expanding list
  • DJA
Replies
4
Views
507
Teethless mama
T
J
Percentages in Pivotal
  • JoeM
Replies
3
Views
484
Ashish Mathur
A
M
How do I use a percentage formula?
  • MeursaultO
Replies
2
Views
456
Ashish Mathur
A
A
Reference: forum discussion dated 17-18April2010
  • Andri
Replies
3
Views
385
Ashish Mathur
A
T
how to remove all formatting
  • Tom
Replies
14
Views
707
XLGeek
X
R
Drill down via page fields
  • Roland Grothe
Replies
1
Views
590
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
751
Dave Peterson
D
T
Rounding Seconds in 4/21/2010 4:30:23 PM
  • Tom Langley
Replies
3
Views
555
Joe User
J
B
Head scratchin for hours.... Help with a formula please...
  • Bill Needham
Replies
6
Views
487
T. Valko
T
E
Count the frequency for every change in numbers
  • Elton Law
Replies
6
Views
552
Elton Law
E
N
Saving & Removing VB Code from WB
  • NoodNutt
Replies
6
Views
521
NoodNutt
N
P
Vlookup and Indirect
  • Puppies72
Replies
0
Views
517
Puppies72
P
D
Daily totals from a monthly log
  • Dhardy
Replies
1
Views
612
Teethless mama
T
A
to CONCATENATE from the smallest date with at least 2 criteria
  • Andri
Replies
17
Views
731
Andri
A
J
Shared Excel File
  • jkcates
Replies
1
Views
407
Gord Dibben
G
J
Creating a formula
  • Jupiter53132
Replies
1
Views
281
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
350
Teethless mama
T
M
Need a code
  • MAX
Replies
1
Views
342
Luke M
L
F
VLOOKUP and IF together
  • FR
Replies
3
Views
548
Don Guillett
D
A
Help me (Vlookup)
  • Amin
Replies
6
Views
460
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
560
AZSteve
A
Back
Top