Microsoft Excel Worksheet Functions

G
VLOOKUP returning wrong row
  • Guest
Replies
6
Views
668K
Guest
G
G
How do I sum cells that have values from a countif formula?
  • Guest
Replies
5
Views
131K
Trevor Shuttleworth
T
G
"Formula is too long"
  • Guest
Replies
1
Views
56K
Dave Peterson
D
G
sumproduct for latest date
  • Guest
Replies
9
Views
313K
Biff
B
G
Function to look up largest value whose record meets criteria?
  • Guest
Replies
5
Views
226K
Guest
G
G
Counting Help
  • Guest
Replies
2
Views
90K
Guest
G
G
calculating dates
  • Guest
Replies
1
Views
60K
Guest
G
G
How can I calculate the week number from a date, eg 21/06/05 = 26
  • Guest
Replies
2
Views
53K
Guest
G
G
Copy page format into an entire workbook
  • Guest
Replies
2
Views
99K
Guest
G
G
Macro Question
  • Guest
Replies
1
Views
44K
Bob Phillips
B
G
my code too long?
  • Guest
Replies
2
Views
89K
Guest
G
Y
Convert rows into 1 cell or 1 string
  • Yagnesh
Replies
5
Views
257K
Yagnesh
Y
G
how do I display $1,243,597 as $1,244 and $(324,567) as $(325)?
  • Guest
Replies
6
Views
120K
Bernie Deitrick
B
M
breaking up a phone number
  • maximus73
Replies
2
Views
102K
Lomax
L
G
Scrolling within a section of an excel worksheet
  • Guest
Replies
1
Views
89K
Guest
G
G
sumproduct from multiple sheets
  • Guest
Replies
3
Views
141K
RagDyer
R
G
retrieve cell formatting with IF(HLOOKUP) formula
  • Guest
Replies
2
Views
309K
Guest
G
G
Looking up values in a table
  • Guest
Replies
17
Views
986K
Guest
G
G
VBA, Excel - Find Range, Sort
  • Guest
Replies
3
Views
144K
Guest
G
G
add a formula to Excel
  • Guest
Replies
1
Views
191K
Guest
G
G
a function giving the interest rate for inv x for period y & bal z
  • Guest
Replies
1
Views
46K
Bernie Deitrick
B
J
Filter not working in a protected file
  • jijy
Replies
1
Views
70K
Ron de Bruin
R
G
Impossibility?
  • Guest
Replies
7
Views
78K
Guest
G
G
How do I get rid of the #/DIV/0! message
  • Guest
Replies
3
Views
59K
Harlan Grove
H
B
Counting Letters
  • Blink
Replies
2
Views
85K
Bob Phillips
B
G
New WorkBook
  • Guest
Replies
1
Views
115K
Ron de Bruin
R
G
Count returns for a period - year
  • Guest
Replies
1
Views
41K
Roger Govier
R
G
counting and matching
  • Guest
Replies
2
Views
229K
Guest
G
A
Adjusting Vlookup Values
  • addie
Replies
1
Views
24K
Roger Govier
R
T
advanced if?????
  • taran
Replies
5
Views
127K
taran
T
G
get a count of numbers whose value falls within a given range
  • Guest
Replies
5
Views
183K
Guest
G
G
How do I change the "comment" default location ?
  • Guest
Replies
1
Views
38K
Debra Dalgleish
D
G
Counting what's left in a list
  • Guest
Replies
2
Views
192K
Guest
G
G
Which function to use?
  • Guest
Replies
6
Views
141K
Roger Govier
R
G
Analysis
  • Guest
Replies
1
Views
34K
Guest
G
G
How do I calculate a future date in Excel?
  • Guest
Replies
2
Views
141K
Bernie Deitrick
B
G
nested Indirect to other WS
  • Guest
Replies
4
Views
51K
Guest
G
G
can you select rows in excel with a certain background color?
  • Guest
Replies
1
Views
78K
Ron de Bruin
R
G
Averaging Values in Auto Filter
  • Guest
Replies
1
Views
302K
Domenic
D
G
Automatically update links when server names change
  • Guest
Replies
1
Views
109K
tony h
T
G
help me write function?
  • Guest
Replies
5
Views
154K
Guest
G
G
How do I change the plus to a negative in a column of numbers?
  • Guest
Replies
2
Views
107K
Arvi Laanemets
A
G
Sumif function?
  • Guest
Replies
2
Views
147K
Guest
G
C
text argument in vlook up which has a ""
  • carlosgdlf
Replies
6
Views
161K
Ron Coderre
R
P
formula to count cells not blanK
  • pmarques
Replies
4
Views
144K
Bryan Hessey
B
L
How to : Comparing Two Ranges
  • lockwood7
Replies
3
Views
76K
lockwood7
L
G
Formula stays displayed in cell
  • Guest
Replies
4
Views
215K
Guest
G
G
Combining cell information
  • Guest
Replies
1
Views
73K
Guest
G
G
info in cel needs to propt other cels to automatically enter text
  • Guest
Replies
2
Views
115K
Guest
G
G
How to add numbers in a column dependant on their colour
  • Guest
Replies
2
Views
213K
Guest
G
You must log in or register to post here.
Back
Top