Excel Functions

Post thread
R
Match & Index Combined Row & Multiple extractions
  • Ronald Cayne
Replies
7
Views
586
Ronald Cayne
R
J
Open a file by clicking a button ???
  • Just4fun
Replies
0
Views
288
Just4fun
J
R
Lookup and Bold Values
  • Rob
Replies
0
Views
321
Rob
R
R
transposing row
  • Rey
Replies
0
Views
304
Rey
R
Q
list lookup
  • Quark
Replies
2
Views
410
Quark
Q
C
vlookup
  • chris hawkins
Replies
0
Views
288
chris hawkins
C
R
RUNNING TOTAL QUESTION
  • rudyeb
Replies
1
Views
350
Quark
Q
J
Referencing Database tables with excel functions
  • J. I. Howell
Replies
8
Views
572
Gerrit-Jan Linker
G
R
Rounding a formula result?
  • rudyeb
Replies
2
Views
395
Gerrit-Jan Linker
G
K
Calculating Working Days In Month
  • Kevan G
Replies
2
Views
500
Gerrit-Jan Linker
G
E
Date in Cell
  • ExcelConfussed
Replies
2
Views
408
Gerrit-Jan Linker
G
D
Last row of data table varies from month to month
  • DFStoneJr
Replies
1
Views
370
Gerrit-Jan Linker
G
N
Multiple variables in IF statement(s)..
  • Nathan323
Replies
0
Views
385
Nathan323
N
D
Using Excel Trend Function in VB
  • Dick Arscott
Replies
1
Views
660
Jerry W. Lewis
J
M
rows between maximum and minimum
  • Mika
Replies
2
Views
380
Mika
M
A
how to do it?
  • aiden
Replies
1
Views
305
Harlan Grove
H
D
Why are the ascii-characters in Excel not the same as in a Word.doc
  • danny
Replies
1
Views
342
Harlan Grove
H
H
Protect and hide
  • homework_seattle
Replies
0
Views
265
homework_seattle
H
E
Wrong or Correct display in a Cell
  • ExcelConfussed
Replies
1
Views
332
Harlan Grove
H
J
VLOOKUP and Multiple Table_arrays.
  • JB
Replies
0
Views
327
JB
J
T
Sum the last 12 columns ?
  • TroyB
Replies
1
Views
371
Harlan Grove
H
N
Is concatenate what I need?
  • Neil Grantham
Replies
2
Views
474
Neil Grantham
N
M
Cells automaticaly formatting for some reason
  • Mike Echo
Replies
0
Views
335
Mike Echo
M
G
Code instead of copy n' paste the conditional format by hand
  • Guest
Replies
1
Views
411
Guest
G
J
Conditional Array Functions
  • JR
Replies
1
Views
408
Jerry W. Lewis
J
G
SumProduct and excluding specific cells
  • Gunjani
Replies
1
Views
5K
Harlan Grove
H
G
Excluding Cells in Sumproduct
  • Gunjani
Replies
0
Views
625
Gunjani
G
M
Summing number formatted visible data only
  • mondo
Replies
0
Views
297
mondo
M
G
Correlating/Combinig data from two worksheets
  • Gunjani
Replies
0
Views
396
Gunjani
G
S
Date Problem
  • Sandip Shah
Replies
1
Views
389
Jerry W. Lewis
J
M
VLOOKUP Problem
  • Mike Hogan
Replies
2
Views
399
Mike Hogan
M
M
If-formula without false part / put in cell operations / time limited spreadsheet
  • MW
Replies
1
Views
535
Jerry W. Lewis
J
M
Can sumif detect text strings or detect if a dollar sign $ is in a cell?
  • MollyDavis
Replies
4
Views
1K
Ken Wright
K
M
Needing nested IF statement advice
  • matlocktm
Replies
1
Views
398
Jerry W. Lewis
J
S
Speeding up calculation by switching from arrays to db functions ??
  • scott23
Replies
2
Views
331
onedaywhen
O
C
referencing different worksheets
  • Calsonic
Replies
0
Views
399
Calsonic
C
Y
Replacing text with numbers
  • Yo
Replies
0
Views
422
Yo
Y
P
Referencing a worksheet name in a formula
  • PeteJ
Replies
1
Views
351
Jerry W. Lewis
J
R
vlookup
  • r.gardiner
Replies
0
Views
290
r.gardiner
R
K
PV and mixed rates and dates
  • Kristen
Replies
0
Views
471
Kristen
K
D
Help with SUMIF
  • Dafella
Replies
1
Views
439
Harlan Grove
H
L
multiple IF functions
  • Luc
Replies
1
Views
312
A.W.J. Ales
A
T
Excel - The Union of Ranges by OffSets
  • TKT-Tang
Replies
0
Views
334
TKT-Tang
T
P
conditional formatting
  • Peter McNamee
Replies
0
Views
329
Peter McNamee
P
P
Excel equivalent ov VAL function
  • Paul Lautman
Replies
5
Views
447
Jonathan Rynd
J
M
ISNUMBER problem
  • Mark
Replies
1
Views
308
Harlan Grove
H
B
Sumproductto a variable row.
  • Brian
Replies
6
Views
314
Jonathan Rynd
J
T
Excel - Count the number of Dates
  • TKT-Tang
Replies
3
Views
531
Jonathan Rynd
J
C
Combine two non-contiguous named ranges in new named range
  • Chris Adams
Replies
2
Views
624
Chris Adams
C
M
working out sums over a number of sheets
  • Mark
Replies
1
Views
348
TKT-Tang
T
Top