Microsoft Excel Worksheet Functions

Post thread
Z
Satisfying two conditions?
  • Zuo
Replies
8
Views
495
Fred Smith
F
R
what should be simple
  • Rene
Replies
4
Views
425
Bob Phillips
B
S
Show matching data in several worksheets
  • Steve
Replies
4
Views
459
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
347
Gary Brown
G
P
11 months and 1 day from a given date
  • pk
Replies
6
Views
484
Ashish Mathur
A
E
Count first and last characters
  • Elton Law
Replies
3
Views
420
Ashish Mathur
A
U
copying a formula down wards
  • UKMAN
Replies
10
Views
842
Ashish Mathur
A
S
Help Needed with Dynamic CountIF
  • Steve
Replies
4
Views
537
Steve
S
R
Change a cells value with a function
  • Ryan H
Replies
4
Views
352
Ryan H
R
J
Automatically hide/unhide rows
  • JStiehl
Replies
5
Views
956
JStiehl
J
C
Referencing relative to a formula reference
  • Csaba Gabor
Replies
3
Views
459
Bob Phillips
B
D
Date + relative number reference
  • Derek M
Replies
3
Views
375
Derek M
D
A
Despite formula I use (for example SUM) result is always zero.
  • Anida
Replies
4
Views
482
Dave Peterson
D
S
Excel Formulas
  • Shona
Replies
3
Views
469
Shona
S
M
How to Sum infinite formula
  • minyeh
Replies
7
Views
696
minyeh
M
E
Finding matches in two columns
  • Erik
Replies
4
Views
448
T. Valko
T
L
IF function
  • Lost Cluster
Replies
4
Views
447
FSt1
F
S
SUMPRODUCT
  • Skinman
Replies
3
Views
488
T. Valko
T
R
Referencing formula using Indirect
  • Raj
Replies
4
Views
605
Raj
R
D
IFERROR in Excel 2007
  • Dirrk
Replies
5
Views
895
Danny Rocks
D
E
Find second to last value in cell
  • Eric_G
Replies
4
Views
658
Bob Phillips
B
A
List the UNIQUE certain fields from the database
  • Andri
Replies
5
Views
461
Dana DeLouis
D
G
Sumproduct with mixed data?
  • gooders
Replies
6
Views
645
T. Valko
T
D
how do I copy the last 20 entries in an expanding list
  • DJA
Replies
4
Views
491
Teethless mama
T
J
Percentages in Pivotal
  • JoeM
Replies
3
Views
461
Ashish Mathur
A
M
How do I use a percentage formula?
  • MeursaultO
Replies
2
Views
440
Ashish Mathur
A
A
Reference: forum discussion dated 17-18April2010
  • Andri
Replies
3
Views
375
Ashish Mathur
A
T
how to remove all formatting
  • Tom
Replies
14
Views
679
XLGeek
X
R
Drill down via page fields
  • Roland Grothe
Replies
1
Views
574
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
723
Dave Peterson
D
T
Rounding Seconds in 4/21/2010 4:30:23 PM
  • Tom Langley
Replies
3
Views
520
Joe User
J
B
Head scratchin for hours.... Help with a formula please...
  • Bill Needham
Replies
6
Views
459
T. Valko
T
E
Count the frequency for every change in numbers
  • Elton Law
Replies
6
Views
519
Elton Law
E
N
Saving & Removing VB Code from WB
  • NoodNutt
Replies
6
Views
505
NoodNutt
N
P
Vlookup and Indirect
  • Puppies72
Replies
0
Views
462
Puppies72
P
D
Daily totals from a monthly log
  • Dhardy
Replies
1
Views
599
Teethless mama
T
A
to CONCATENATE from the smallest date with at least 2 criteria
  • Andri
Replies
17
Views
659
Andri
A
J
Shared Excel File
  • jkcates
Replies
1
Views
396
Gord Dibben
G
J
Creating a formula
  • Jupiter53132
Replies
1
Views
267
Teethless mama
T
M
Locking Worksheet Security Name
  • Mumsy
Replies
1
Views
294
Mike H
M
M
Pre-Populating Fields
  • MP
Replies
2
Views
291
Teethless mama
T
O
Word lists
  • overthehill lady
Replies
3
Views
346
Teethless mama
T
M
Need a code
  • MAX
Replies
1
Views
323
Luke M
L
F
VLOOKUP and IF together
  • FR
Replies
3
Views
476
Don Guillett
D
A
Help me (Vlookup)
  • Amin
Replies
6
Views
449
L. Howard Kittle
L
S
VLookup between date ranges ?
  • Steve
Replies
6
Views
3K
Steve
S
G
COUNTIF Formula
  • Gyles
Replies
1
Views
352
Jacob Skaria
J
A
Formulas do not update
  • AZSteve
Replies
2
Views
520
AZSteve
A
Back
Top