Microsoft Excel Worksheet Functions

A
If Statments: Want TRUE if a value = any of the given values
  • Augabog
Replies
4
Views
57K
Augabog
A
R
Comparing multiple columns in two sheets
  • robotman
Replies
1
Views
156K
Lori
L
G
Problem with LOOKUP function
  • Guest
Replies
5
Views
699K
T. Valko
T
G
Index Match not working
  • Guest
Replies
2
Views
92K
Guest
G
G
Use find to select entire rows with a cell with that value
  • Guest
Replies
2
Views
176K
Guest
G
G
Using IF and MIN
  • Guest
Replies
4
Views
380K
Bob Phillips
B
G
date formula
  • Guest
Replies
5
Views
326K
T. Valko
T
G
which function do i need?
  • Guest
Replies
1
Views
83K
Guest
G
K
Approximate matches with vlookup?
  • Keith R
Replies
2
Views
314K
T. Valko
T
G
XIRR
  • Guest
Replies
3
Views
468K
Ron Rosenfeld
R
S
Sumproduct (I think?)
  • Sandy
Replies
5
Views
351K
Sandy
S
G
Number of Months and Days between 2 dates?
  • Guest
Replies
3
Views
87K
JE McGimpsey
J
G
How do i "Sort" my Excel 2007 worksheet
  • Guest
Replies
3
Views
45K
Guest
G
M
sum/division calculation involving vlookup with array?
  • markx
Replies
2
Views
407K
markx
M
G
Macros gets disabled by default
  • Guest
Replies
1
Views
321K
Guest
G
G
Countif
  • Guest
Replies
2
Views
74K
Peo Sjoblom
P
M
Max (A1:A1), relating to other cells
  • Mark Solesbury
Replies
2
Views
199K
Pete_UK
P
J
Multiple CountIF in 1 function
  • JS
Replies
1
Views
212K
Peo Sjoblom
P
G
how to link excel worksheets with a reference (indexed) key field.
  • Guest
Replies
1
Views
70K
Guest
G
G
Is it poss to have a double array in Excel 2003?
  • Guest
Replies
2
Views
61K
Guest
G
S
Count Number of Duplicate Occurances
  • Scott Halper
Replies
7
Views
208K
Scott Halper
S
P
Bar Graph
  • pago_boss
Replies
1
Views
120K
Guest
G
U
ctrl + tab (first in, first out history) with excel sheets?
  • urlwolf
Replies
4
Views
299K
Guest
G
G
Excel: # in a cell if a # is repeated in a row
  • Guest
Replies
2
Views
51K
Guest
G
G
Keyboard Shortcut for right-click on sheet tab
  • Guest
Replies
2
Views
216K
Guest
G
G
Hlookup for row 3 and 4
  • Guest
Replies
2
Views
204K
Guest
G
G
=(INDIRECT(ADDRESS(ROW(),#))) with SUMPRODUCT returning #VALUE!
  • Guest
Replies
7
Views
162K
Guest
G
G
saving macros in personal workbook
  • Guest
Replies
1
Views
212K
Guest
G
G
Finding the date using the number of the week in a year
  • Guest
Replies
2
Views
321K
Guest
G
G
Condition on Time
  • Guest
Replies
8
Views
155K
Guest
G
G
shade cells based on conditions - i have more than 3 conditions
  • Guest
Replies
3
Views
332K
T. Valko
T
G
How to determine the values from a list?
  • Guest
Replies
7
Views
896K
Guest
G
G
How to search my past question ?
  • Guest
Replies
1
Views
35K
T. Valko
T
W
How to avoid duplicate string value input in one column?
  • Wavelet
Replies
1
Views
100K
T. Valko
T
G
Multiplying specific data within a range to get column totals
  • Guest
Replies
2
Views
360K
Guest
G
G
A partial transpostion
  • Guest
Replies
2
Views
59K
Guest
G
P
Countif time
  • Pete_UK
Replies
4
Views
65K
S.C
S
G
VLLOKUP AND SPACES
  • Guest
Replies
3
Views
148K
T. Valko
T
G
SumIF column A = x and Column B = x OR x
  • Guest
Replies
2
Views
359K
Guest
G
G
Convert phone to ***
  • Guest
Replies
2
Views
81K
Guest
G
G
Multiple workbook sheet numbers!
  • Guest
Replies
4
Views
84K
Dave Peterson
D
G
IF Logical Function & Blank Cells
  • Guest
Replies
1
Views
82K
JE McGimpsey
J
S
Insert Incremental sheet names in a workbook
  • Sinner
Replies
2
Views
312K
Dave Peterson
D
G
Goal Seek Bias
  • Guest
Replies
1
Views
202K
Mike Middleton
M
G
ROUNDUP NUMBER
  • Guest
Replies
2
Views
459K
Ron Rosenfeld
R
G
How to use trim finction in array
  • Guest
Replies
3
Views
369K
JE McGimpsey
J
G
How do I convert a list of date of births into age in Excel?
  • Guest
Replies
6
Views
306K
Guest
G
G
I need a cell to equal have of what I put in
  • Guest
Replies
3
Views
117K
JE McGimpsey
J
G
how do i use macros to work out commissions
  • Guest
Replies
2
Views
114K
JE McGimpsey
J
G
copying formula
  • Guest
Replies
8
Views
412K
Guest
G
You must log in or register to post here.
Back
Top