Excel Functions

Post thread
F
V Lookup using 2 criteria
  • fergal
Replies
1
Views
724
JS
J
S
Using Vlookup with MS Query
  • SPF40
Replies
0
Views
255
SPF40
S
S
Using sumproduct while skipping cells in the array
  • shanen
Replies
4
Views
848
Roger Govier
R
G
Using Max Min with Array Formula issues with negative numbers
  • Greg
Replies
5
Views
421
Greg
G
L
Using Index with text
  • Luther Gunter Jr.
Replies
1
Views
199
[email protected]
T
L
Using IF statement on part of text content of a cell?
  • lkqwesr
Replies
2
Views
393
[email protected]
L
D
Using Excel Trend Function in VB
  • Dick Arscott
Replies
1
Views
583
Jerry W. Lewis
J
G
using Dynamic Range and Unique values only
  • GregDAngelo
Replies
1
Views
391
Herbert Seidenberg
H
A
Using Counting #N/A
  • anandasim
Replies
4
Views
276
anandasim
A
P
Using a pair of variables to find a match in a second table
  • pauljen
Replies
0
Views
301
[email protected]
P
J
Userform Listbox Problem, Excel 2000 & 2003
  • jfcby
Replies
0
Views
624
jfcby
J
P
User defined functions without using VBA.
  • phongdk
Replies
1
Views
374
[email protected]
P
S
Use the value of a cell as the sheet name in a cell formula
  • Simon H
Replies
1
Views
361
Jerry W. Lewis
J
M
Use of OFFSET function
  • mahadevan.swamy
Replies
0
Views
673
[email protected]
M
F
Use of ANd in work sheet
  • Frank
Replies
1
Views
288
Harlan Grove
H
L
Update cell value based on name and specific date
  • Leo1111
Replies
0
Views
2K
Leo1111
L
J
Unwanted text using Data | Subtotal
  • JRF
Replies
0
Views
295
JRF
J
B
Unlock a Project
  • Bruno
Replies
1
Views
281
Chrissy
C
T
Unique Number
  • Thomas Cox
Replies
1
Views
311
Roman
R
T
Unique Number
  • Thomas Cox
Replies
1
Views
333
Jerry W. Lewis
J
C
Understanding the results using array arguments in a nested If() function
  • CJ
Replies
3
Views
393
Jerry W. Lewis
J
E
Unchanged workbook prompting to save when closing
  • excelnut1954
Replies
1
Views
505
Murray
M
M
Un-merge cells
  • Mark
Replies
3
Views
210
Jerry W. Lewis
J
D
Two Condition "Countif" with a Twist
  • Dave
Replies
1
Views
355
Jerry W. Lewis
J
L
Trying to combine two functions
  • Lance
Replies
1
Views
248
pape
P
L
tricky excel formula
  • lemus
Replies
0
Views
321
lemus
L
R
transposing row
  • Rey
Replies
0
Views
244
Rey
R
E
TRANSPOSE not exactly what I want
  • enash
Replies
0
Views
270
[email protected]
E
H
Transfering information from 1 cell to another
  • Ha_Ha
Replies
1
Views
217
garr
G
A
Totalling x columns based on value of a cell
  • annysjunkmail
Replies
1
Views
306
[email protected]
W
D
Total Area Formula
  • David Engle
Replies
0
Views
274
David Engle
D
T
Too Many IF Statements!
  • tiziano1
Replies
2
Views
645
Harlan Grove
H
B
Time to hours
  • BF
Replies
1
Views
195
Ian Gilmore
I
D
Time Format ?
  • DW
Replies
1
Views
299
Jerry W. Lewis
J
T
Time data validation and total time
  • Tony James
Replies
1
Views
460
Tony James
T
B
This function works for small figures but not for large
  • Bob H
Replies
0
Views
2K
Bob H
B
C
The RATE function
  • Charles van Doornewaard
Replies
1
Views
647
Clive Saunders
C
H
Text vs. Numbers in a data series
  • Hurleymc
Replies
0
Views
255
Hurleymc
H
S
Text upside down!
  • stevewy
Replies
4
Views
2K
Dave Peterson
D
S
Text combining
  • SWEENEYfd
Replies
1
Views
370
Max
M
R
TESTING A RANGE OF CELLS
  • Richard
Replies
3
Views
647
Don Guillett
D
R
templates
  • Raymond
Replies
0
Views
183
Raymond
R
R
Template wizard
  • Ron
Replies
0
Views
433
Ron
R
T
Tell excel to skip part of a macro?
  • TimkenSteve
Replies
1
Views
475
[email protected]
P
S
Taking totals based on Background colour
  • Sandip Shah
Replies
1
Views
448
Sandip Shah
S
P
table (with complex formula)
  • Pokey
Replies
0
Views
284
Pokey
P
R
syntax correction
  • Richard
Replies
0
Views
573
Richard
R
A
Synchronising 2 files in different places
  • Acadabra
Replies
1
Views
293
Scott Johnson
S
B
Sumproductto a variable row.
  • Brian
Replies
6
Views
261
Jonathan Rynd
J
I
sumproduct returning odd results
  • iccrew98
Replies
1
Views
2K
Pete_UK
P
Top