Microsoft Excel Worksheet Functions

G
Conditional formatting
  • Gilbert DE CEULAER
Replies
1
Views
17K
Luke M
L
D
Advanced Filter returning complete database not filtered results
  • DianeG
Replies
4
Views
503K
bpeltzer
B
K
Using same fomula to count AND and OR options / sumproduct
  • KCR
Replies
5
Views
364K
Bernard Liengme
B
Z
How to use AUTOFILTER to update FREQUENCY distribution
  • zerocred
Replies
7
Views
723K
zerocred
Z
K
How do i copy a vlookup formula into other cells going right
  • km440
Replies
1
Views
222K
Pete_UK
P
F
Giving "X" a numerical value.
  • floyd.anderson
Replies
7
Views
422K
Jarek Kujawa
J
C
count on 3 criteria
  • Chris Salcedo
Replies
3
Views
356K
Jarek Kujawa
J
P
Monthly job timings analysis - automation options?
  • Paul
Replies
2
Views
250K
Max
M
B
How can I insert a row in a source that links to a destination
  • Bob
Replies
1
Views
213K
Max
M
C
How to do if I would like to select from a list by using "IF" form
  • cara
Replies
3
Views
383K
T. Valko
T
C
MS Office 2003 Prof Ed SP2
  • Chinna122008
Replies
3
Views
315K
Chinna122008
C
A
reverse lookup function, index/match usage?
  • Ambie
Replies
3
Views
448K
T. Valko
T
B
Problem with MATCH () function . . .
  • Blue Max
Replies
2
Views
288K
Blue Max
B
N
Creating inout values for excel
  • nelly007
Replies
9
Views
261K
Max
M
D
Formula to look up duplicates
  • Dylan @ UAFC
Replies
1
Views
350K
Gord Dibben
G
S
VLOOKUP
  • sydney
Replies
2
Views
291K
Dylan @ UAFC
D
T
Count Percentages in a range
  • tldem
Replies
3
Views
350K
tldem
T
K
Find and Replace/Substitute Formulas
  • Kathy123
Replies
4
Views
131K
Pete_UK
P
G
how to get grand total in words in excel sheet
  • gangadhar
Replies
2
Views
83K
Gord Dibben
G
N
Subtotal
  • Nikki
Replies
3
Views
490K
Pete_UK
P
D
Absoult for auto fill
  • Dylan @ UAFC
Replies
1
Views
139K
Bernie Deitrick
B
S
IF functions with multiple results including blank
  • Steve
Replies
7
Views
529K
T. Valko
T
D
VLOOKUP Auto fill problem
  • Dylan @ UAFC
Replies
2
Views
499K
Fred Smith
F
D
I want to get and A to count as a 1 in Excel
  • dclayton
Replies
2
Views
147K
Glenn
G
J
Formual link to external workbook
  • JBW
Replies
2
Views
234K
Dave Peterson
D
S
Sumproduct repost
  • Sandy
Replies
8
Views
340K
[email protected]
G
J
Searching for records with multiple criteria
  • Jeff
Replies
7
Views
586K
Jeff
J
C
Indirect addressing for linked file
  • ChEBass
Replies
5
Views
267K
ChEBass
C
K
sum of text positions
  • Kevin
Replies
10
Views
952K
Ron Rosenfeld
R
P
Average exluding max and min values
  • Paul
Replies
11
Views
933K
T. Valko
T
T
Missing Macro
  • Tim at alliant
Replies
7
Views
799K
Tim at alliant
T
M
Using Pivot Table Data
  • Mervyn Thomas
Replies
2
Views
339K
Debra Dalgleish
D
J
Concatenation
  • jknapp1005
Replies
3
Views
413K
Chip Pearson
C
S
Pivot Table
  • Shaylee
Replies
1
Views
199K
Debra Dalgleish
D
T
protect worksheet but allow row deletion
  • Tia
Replies
3
Views
330K
Michael
M
N
Sum working days
  • NM
Replies
12
Views
864K
T. Valko
T
D
Formula Question
  • Davis
Replies
3
Views
189K
Davis
D
W
Latest value from table
  • WRC
Replies
3
Views
155K
T. Valko
T
J
Would if work?
  • just4ucreations
Replies
3
Views
63K
Eduardo
E
R
creating an IF macro in Excel 2003
  • Ronda
Replies
7
Views
289K
Gord Dibben
G
A
how do I merge two excel sheets from one excel workbook
  • Ash
Replies
5
Views
121K
Gord Dibben
G
Z
Assigning a variable
  • Zack
Replies
3
Views
309K
Pete_UK
P
S
Sumproduct
  • Sandy
Replies
2
Views
360K
xlm
X
B
Multiple criteria in autofilter
  • BASFMark
Replies
1
Views
370K
Michael
M
J
Sums
  • Jemma
Replies
6
Views
13K
Ron Rosenfeld
R
J
Adding Daily
  • Jess
Replies
4
Views
115K
David Biddulph
D
J
formula that will reference another worksheets info. same book
  • Jeff Wood
Replies
4
Views
60K
GuyHD
G
B
APY and Interest rate calculation
  • boba
Replies
1
Views
118K
[email protected]
J
J
Get rid of DIV/0 error message
  • Jeff
Replies
4
Views
193K
Pete_UK
P
W
How to shade cells based on formula of % growth/loss of last year?
  • WHintz67
Replies
1
Views
129K
muddan madhu
M
You must log in or register to post here.
Back
Top