Excel Functions

Post thread
R
Match & Index Combined Row & Multiple extractions
  • Ronald Cayne
Replies
7
Views
515
Ronald Cayne
R
J
Open a file by clicking a button ???
  • Just4fun
Replies
0
Views
260
Just4fun
J
R
Lookup and Bold Values
  • Rob
Replies
0
Views
299
Rob
R
R
transposing row
  • Rey
Replies
0
Views
281
Rey
R
Q
list lookup
  • Quark
Replies
2
Views
339
Quark
Q
C
vlookup
  • chris hawkins
Replies
0
Views
256
chris hawkins
C
R
RUNNING TOTAL QUESTION
  • rudyeb
Replies
1
Views
303
Quark
Q
J
Referencing Database tables with excel functions
  • J. I. Howell
Replies
8
Views
516
Gerrit-Jan Linker
G
R
Rounding a formula result?
  • rudyeb
Replies
2
Views
346
Gerrit-Jan Linker
G
K
Calculating Working Days In Month
  • Kevan G
Replies
2
Views
458
Gerrit-Jan Linker
G
E
Date in Cell
  • ExcelConfussed
Replies
2
Views
350
Gerrit-Jan Linker
G
D
Last row of data table varies from month to month
  • DFStoneJr
Replies
1
Views
339
Gerrit-Jan Linker
G
N
Multiple variables in IF statement(s)..
  • Nathan323
Replies
0
Views
346
Nathan323
N
D
Using Excel Trend Function in VB
  • Dick Arscott
Replies
1
Views
617
Jerry W. Lewis
J
M
rows between maximum and minimum
  • Mika
Replies
2
Views
324
Mika
M
A
how to do it?
  • aiden
Replies
1
Views
266
Harlan Grove
H
D
Why are the ascii-characters in Excel not the same as in a Word.doc
  • danny
Replies
1
Views
312
Harlan Grove
H
H
Protect and hide
  • homework_seattle
Replies
0
Views
242
homework_seattle
H
E
Wrong or Correct display in a Cell
  • ExcelConfussed
Replies
1
Views
286
Harlan Grove
H
J
VLOOKUP and Multiple Table_arrays.
  • JB
Replies
0
Views
303
JB
J
T
Sum the last 12 columns ?
  • TroyB
Replies
1
Views
330
Harlan Grove
H
N
Is concatenate what I need?
  • Neil Grantham
Replies
2
Views
430
Neil Grantham
N
M
Cells automaticaly formatting for some reason
  • Mike Echo
Replies
0
Views
307
Mike Echo
M
G
Code instead of copy n' paste the conditional format by hand
  • Guest
Replies
1
Views
375
Guest
G
J
Conditional Array Functions
  • JR
Replies
1
Views
382
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
605
Gunjani
G
M
Summing number formatted visible data only
  • mondo
Replies
0
Views
277
mondo
M
G
Correlating/Combinig data from two worksheets
  • Gunjani
Replies
0
Views
362
Gunjani
G
S
Date Problem
  • Sandip Shah
Replies
1
Views
356
Jerry W. Lewis
J
M
VLOOKUP Problem
  • Mike Hogan
Replies
2
Views
355
Mike Hogan
M
M
If-formula without false part / put in cell operations / time limited spreadsheet
  • MW
Replies
1
Views
490
Jerry W. Lewis
J
M
Can sumif detect text strings or detect if a dollar sign $ is in a cell?
  • MollyDavis
Replies
4
Views
963
Ken Wright
K
M
Needing nested IF statement advice
  • matlocktm
Replies
1
Views
363
Jerry W. Lewis
J
S
Speeding up calculation by switching from arrays to db functions ??
  • scott23
Replies
2
Views
284
onedaywhen
O
C
referencing different worksheets
  • Calsonic
Replies
0
Views
356
Calsonic
C
Y
Replacing text with numbers
  • Yo
Replies
0
Views
394
Yo
Y
P
Referencing a worksheet name in a formula
  • PeteJ
Replies
1
Views
319
Jerry W. Lewis
J
R
vlookup
  • r.gardiner
Replies
0
Views
263
r.gardiner
R
K
PV and mixed rates and dates
  • Kristen
Replies
0
Views
412
Kristen
K
D
Help with SUMIF
  • Dafella
Replies
1
Views
396
Harlan Grove
H
L
multiple IF functions
  • Luc
Replies
1
Views
289
A.W.J. Ales
A
T
Excel - The Union of Ranges by OffSets
  • TKT-Tang
Replies
0
Views
304
TKT-Tang
T
P
conditional formatting
  • Peter McNamee
Replies
0
Views
299
Peter McNamee
P
P
Excel equivalent ov VAL function
  • Paul Lautman
Replies
5
Views
383
Jonathan Rynd
J
M
ISNUMBER problem
  • Mark
Replies
1
Views
268
Harlan Grove
H
B
Sumproductto a variable row.
  • Brian
Replies
6
Views
292
Jonathan Rynd
J
T
Excel - Count the number of Dates
  • TKT-Tang
Replies
3
Views
470
Jonathan Rynd
J
C
Combine two non-contiguous named ranges in new named range
  • Chris Adams
Replies
2
Views
577
Chris Adams
C
M
working out sums over a number of sheets
  • Mark
Replies
1
Views
306
TKT-Tang
T
Top