Microsoft Excel Worksheet Functions

R
what should be simple
  • Rene
Replies
4
Views
452K
Bob Phillips
B
S
Show matching data in several worksheets
  • Steve
Replies
4
Views
302K
Max
M
A
Fill/Extend Series adding decimal points to some numbers
  • awalker
Replies
1
Views
415K
Pete_UK
P
T
limit comments to only 600 words
  • Tim
Replies
2
Views
182K
Gary Brown
G
P
11 months and 1 day from a given date
  • pk
Replies
6
Views
176K
Ashish Mathur
A
E
Count first and last characters
  • Elton Law
Replies
3
Views
112K
Ashish Mathur
A
U
copying a formula down wards
  • UKMAN
Replies
10
Views
146K
Ashish Mathur
A
S
Help Needed with Dynamic CountIF
  • Steve
Replies
4
Views
430K
Steve
S
R
Change a cells value with a function
  • Ryan H
Replies
4
Views
203K
Ryan H
R
J
Automatically hide/unhide rows
  • JStiehl
Replies
5
Views
601K
JStiehl
J
C
Referencing relative to a formula reference
  • Csaba Gabor
Replies
3
Views
431K
Bob Phillips
B
D
Date + relative number reference
  • Derek M
Replies
3
Views
333K
Derek M
D
A
Despite formula I use (for example SUM) result is always zero.
  • Anida
Replies
4
Views
430K
Dave Peterson
D
S
Excel Formulas
  • Shona
Replies
3
Views
116K
Shona
S
M
How to Sum infinite formula
  • minyeh
Replies
7
Views
505K
minyeh
M
E
Finding matches in two columns
  • Erik
Replies
4
Views
298K
T. Valko
T
L
IF function
  • Lost Cluster
Replies
4
Views
262K
FSt1
F
S
SUMPRODUCT
  • Skinman
Replies
3
Views
362K
T. Valko
T
R
Referencing formula using Indirect
  • Raj
Replies
4
Views
487K
Raj
R
D
IFERROR in Excel 2007
  • Dirrk
Replies
5
Views
283K
Danny Rocks
D
E
Find second to last value in cell
  • Eric_G
Replies
4
Views
318K
Bob Phillips
B
A
List the UNIQUE certain fields from the database
  • Andri
Replies
5
Views
443K
Dana DeLouis
D
G
Sumproduct with mixed data?
  • gooders
Replies
6
Views
386K
T. Valko
T
D
how do I copy the last 20 entries in an expanding list
  • DJA
Replies
4
Views
92K
Teethless mama
T
J
Percentages in Pivotal
  • JoeM
Replies
3
Views
333K
Ashish Mathur
A
M
How do I use a percentage formula?
  • MeursaultO
Replies
2
Views
214K
Ashish Mathur
A
A
Reference: forum discussion dated 17-18April2010
  • Andri
Replies
3
Views
94K
Ashish Mathur
A
T
how to remove all formatting
  • Tom
Replies
14
Views
355K
XLGeek
X
R
Drill down via page fields
  • Roland Grothe
Replies
1
Views
158K
Herbert Seidenberg
H
G
how to sum cells and ignore the #div/0! 's ?
  • Guest
Replies
6
Views
475K
abdul gaffoor
A
G
VLOOKUP in VBA
  • G.P.N.L. c.v.a.
Replies
7
Views
296K
Dave Peterson
D
T
Rounding Seconds in 4/21/2010 4:30:23 PM
  • Tom Langley
Replies
3
Views
388K
Joe User
J
B
Head scratchin for hours.... Help with a formula please...
  • Bill Needham
Replies
6
Views
91K
T. Valko
T
E
Count the frequency for every change in numbers
  • Elton Law
Replies
6
Views
283K
Elton Law
E
N
Saving & Removing VB Code from WB
  • NoodNutt
Replies
6
Views
561K
NoodNutt
N
P
Vlookup and Indirect
  • Puppies72
Replies
0
Views
257K
Puppies72
P
D
Daily totals from a monthly log
  • Dhardy
Replies
1
Views
247K
Teethless mama
T
A
to CONCATENATE from the smallest date with at least 2 criteria
  • Andri
Replies
17
Views
595K
Andri
A
J
Shared Excel File
  • jkcates
Replies
1
Views
92K
Gord Dibben
G
J
Creating a formula
  • Jupiter53132
Replies
1
Views
194K
Teethless mama
T
M
Locking Worksheet Security Name
  • Mumsy
Replies
1
Views
61K
Mike H
M
M
Pre-Populating Fields
  • MP
Replies
2
Views
38K
Teethless mama
T
O
Word lists
  • overthehill lady
Replies
3
Views
321K
Teethless mama
T
M
Need a code
  • MAX
Replies
1
Views
141K
Luke M
L
F
VLOOKUP and IF together
  • FR
Replies
3
Views
458K
Don Guillett
D
A
Help me (Vlookup)
  • Amin
Replies
6
Views
327K
L. Howard Kittle
L
S
VLookup between date ranges ?
  • Steve
Replies
6
Views
189K
Steve
S
G
COUNTIF Formula
  • Gyles
Replies
1
Views
77K
Jacob Skaria
J
A
Formulas do not update
  • AZSteve
Replies
2
Views
185K
AZSteve
A
T
Getting the average from a column using date constrants
  • Trevor.
Replies
8
Views
371K
Trevor.
T
You must log in or register to post here.
Back
Top