Excel Functions

Post thread
R
Match & Index Combined Row & Multiple extractions
  • Ronald Cayne
Replies
7
Views
621
Ronald Cayne
R
J
Open a file by clicking a button ???
  • Just4fun
Replies
0
Views
306
Just4fun
J
R
Lookup and Bold Values
  • Rob
Replies
0
Views
341
Rob
R
R
transposing row
  • Rey
Replies
0
Views
329
Rey
R
Q
list lookup
  • Quark
Replies
2
Views
437
Quark
Q
C
vlookup
  • chris hawkins
Replies
0
Views
302
chris hawkins
C
R
RUNNING TOTAL QUESTION
  • rudyeb
Replies
1
Views
372
Quark
Q
J
Referencing Database tables with excel functions
  • J. I. Howell
Replies
8
Views
622
Gerrit-Jan Linker
G
R
Rounding a formula result?
  • rudyeb
Replies
2
Views
415
Gerrit-Jan Linker
G
K
Calculating Working Days In Month
  • Kevan G
Replies
2
Views
525
Gerrit-Jan Linker
G
E
Date in Cell
  • ExcelConfussed
Replies
2
Views
431
Gerrit-Jan Linker
G
D
Last row of data table varies from month to month
  • DFStoneJr
Replies
1
Views
390
Gerrit-Jan Linker
G
N
Multiple variables in IF statement(s)..
  • Nathan323
Replies
0
Views
407
Nathan323
N
D
Using Excel Trend Function in VB
  • Dick Arscott
Replies
1
Views
692
Jerry W. Lewis
J
M
rows between maximum and minimum
  • Mika
Replies
2
Views
396
Mika
M
A
how to do it?
  • aiden
Replies
1
Views
327
Harlan Grove
H
D
Why are the ascii-characters in Excel not the same as in a Word.doc
  • danny
Replies
1
Views
362
Harlan Grove
H
H
Protect and hide
  • homework_seattle
Replies
0
Views
281
homework_seattle
H
E
Wrong or Correct display in a Cell
  • ExcelConfussed
Replies
1
Views
364
Harlan Grove
H
J
VLOOKUP and Multiple Table_arrays.
  • JB
Replies
0
Views
358
JB
J
T
Sum the last 12 columns ?
  • TroyB
Replies
1
Views
412
Harlan Grove
H
N
Is concatenate what I need?
  • Neil Grantham
Replies
2
Views
492
Neil Grantham
N
M
Cells automaticaly formatting for some reason
  • Mike Echo
Replies
0
Views
364
Mike Echo
M
G
Code instead of copy n' paste the conditional format by hand
  • Guest
Replies
1
Views
437
Guest
G
J
Conditional Array Functions
  • JR
Replies
1
Views
432
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
659
Gunjani
G
M
Summing number formatted visible data only
  • mondo
Replies
0
Views
326
mondo
M
G
Correlating/Combinig data from two worksheets
  • Gunjani
Replies
0
Views
424
Gunjani
G
S
Date Problem
  • Sandip Shah
Replies
1
Views
408
Jerry W. Lewis
J
M
VLOOKUP Problem
  • Mike Hogan
Replies
2
Views
424
Mike Hogan
M
M
If-formula without false part / put in cell operations / time limited spreadsheet
  • MW
Replies
1
Views
574
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
414
Jerry W. Lewis
J
S
Speeding up calculation by switching from arrays to db functions ??
  • scott23
Replies
2
Views
356
onedaywhen
O
C
referencing different worksheets
  • Calsonic
Replies
0
Views
421
Calsonic
C
Y
Replacing text with numbers
  • Yo
Replies
0
Views
453
Yo
Y
P
Referencing a worksheet name in a formula
  • PeteJ
Replies
1
Views
372
Jerry W. Lewis
J
R
vlookup
  • r.gardiner
Replies
0
Views
312
r.gardiner
R
K
PV and mixed rates and dates
  • Kristen
Replies
0
Views
500
Kristen
K
D
Help with SUMIF
  • Dafella
Replies
1
Views
469
Harlan Grove
H
L
multiple IF functions
  • Luc
Replies
1
Views
334
A.W.J. Ales
A
T
Excel - The Union of Ranges by OffSets
  • TKT-Tang
Replies
0
Views
359
TKT-Tang
T
P
conditional formatting
  • Peter McNamee
Replies
0
Views
346
Peter McNamee
P
P
Excel equivalent ov VAL function
  • Paul Lautman
Replies
5
Views
473
Jonathan Rynd
J
M
ISNUMBER problem
  • Mark
Replies
1
Views
330
Harlan Grove
H
B
Sumproductto a variable row.
  • Brian
Replies
6
Views
348
Jonathan Rynd
J
T
Excel - Count the number of Dates
  • TKT-Tang
Replies
3
Views
559
Jonathan Rynd
J
C
Combine two non-contiguous named ranges in new named range
  • Chris Adams
Replies
2
Views
651
Chris Adams
C
M
working out sums over a number of sheets
  • Mark
Replies
1
Views
372
TKT-Tang
T
Top