Excel Functions

Post thread
R
VAre Fractions allowed in VLookup Tables or must they be converedtedfor useage?
  • Realitygdk
Replies
2
Views
2K
[email protected]
R
D
search returns error when substring not found
  • David Schwartz
Replies
3
Views
1K
Pete_UK
P
B
??? pulling from another sheet IF..... ???
  • ~Bigred
Replies
1
Views
721
Pete_UK
P
S
Formula for multiple match in seperate columns
  • Sinner
Replies
0
Views
652
Sinner
S
M
manipulating text
  • Me
Replies
1
Views
723
carlo
C
G
CountIF functions...
  • Gord
Replies
0
Views
671
Gord
G
R
Sorting
  • Richard
Replies
1
Views
753
Pete_UK
P
T
Formula for Filtering Part Numbers
  • tiziano1
Replies
1
Views
765
Mangesh
M
B
Where is Excel's FILENAME(path) string function?
  • baobob
Replies
2
Views
706
Pete_UK
P
A
Sep05=Sep 5, 2007 instead of Sep 2005
  • Alan Calan
Replies
1
Views
659
Pete_UK
P
B
? How to pull system date then set it to previous sunday
  • _Bigred
Replies
3
Views
801
Pete_UK
P
B
Looping / find
  • Brian
Replies
1
Views
676
Pete_UK
P
T
Excel 2003 Copying Relative Formulas Responds Like Absolute Formulas
  • Techy Wannabe
Replies
0
Views
812
Techy Wannabe
T
T
finding the maximum number of rows used in a range of columns
  • tmarsh
Replies
0
Views
637
[email protected]
T
M
Help, Excel Files Being Wiped Out: Data Lost or Corrupt
  • Mister Softie
Replies
0
Views
661
Mister Softie
M
V
Count if
  • venkateswaran.v
Replies
1
Views
770
Pete_UK
P
K
Help!!!!
  • Krish
Replies
1
Views
767
Pete_UK
P
E
countif problem
  • elaine_chan2
Replies
3
Views
707
Pete_UK
P
A
Excel Crashes when using the Transpose Function
  • Ajit
Replies
0
Views
1K
Ajit
A
T
Too Many IF Statements!
  • tiziano1
Replies
2
Views
692
Harlan Grove
H
G
Dates Math
  • Gord
Replies
3
Views
863
Pete_UK
P
B
setting a range
  • bernd
Replies
1
Views
638
Pete_UK
P
G
Applying random changes to a list of numbers
  • greg.jobs
Replies
9
Views
933
David Biddulph
D
G
Is there a formula to transpose numbers, e.g. change 36 to 63
  • greg.jobs
Replies
10
Views
975
Ron Rosenfeld
R
C
Removing HTML from EXCEL?
  • Crackles McFarly
Replies
7
Views
935
Pete_UK
P
M
How do I auto run my macro upon open of file....Workbook_Open() is NOT working?
  • meghantrus
Replies
3
Views
800
FrankSinatra
F
C
How do you truncate 2.22 to just 0.22?
  • Crackles McFarly
Replies
3
Views
660
Crackles McFarly
C
G
PDF'ing in MS Excel 2003: Avoiding having each Excel tab saved as separate PDF file
  • global risk appetite
Replies
1
Views
757
[email protected]
B
M
Printing Color-Coded Worksheet in Black & White Mode in Excel 2003
  • Mister Softie
Replies
1
Views
780
Dave Peterson
D
T
specifying named range with a lookup
  • TSW632
Replies
3
Views
673
TSW632
T
M
COUPNCD & Bond pricing
  • Mathieu Fortin
Replies
0
Views
811
Mathieu Fortin
M
Z
Sum or SubTotal?
  • Zach
Replies
1
Views
593
Mangesh
M
A
Last value in column range <> 0 problem/question
  • aztecbrainsurgeon
Replies
1
Views
670
[email protected]
A
F
Locating/Highlighting differences in column
  • FHamidzade
Replies
0
Views
597
[email protected]
F
K
Need a function that would show the date correctly in concatenation
  • Kompu Kid
Replies
5
Views
745
Pete_UK
P
C
How do you Increment Time by varrying times???
  • Crackles McFarly
Replies
6
Views
751
Gord Dibben
G
Z
COUNTIF?
  • Zach
Replies
2
Views
752
Zach
Z
A
Adding set rows
  • alanpaulwilson
Replies
1
Views
724
andycat
A
S
Excel Matrix
  • Sal
Replies
1
Views
717
Pete_UK
P
B
What function returns the sheet name?
  • baobob
Replies
5
Views
905
Harlan Grove
H
W
Entering a number
  • WSB
Replies
3
Views
657
Pete_UK
P
S
CopyFromRecordset Problem Options
  • sunzj
Replies
0
Views
773
sunzj
S
C
Estimate date
  • CD27
Replies
2
Views
662
CD27
C
A
Explain Circular References
  • Arcadian
Replies
3
Views
726
Harlan Grove
H
Z
Average of Numbers
  • Zach
Replies
4
Views
776
Dave Thomas
D
E
Index/Match on multiple columns
  • Evon
Replies
1
Views
980
DtTall
D
T
Checking formula type (reference to other worksheet or not)
  • topola
Replies
1
Views
730
DtTall
D
D
Combine two worksheets into PivotTable
  • DtTall
Replies
0
Views
760
DtTall
D
D
DATEDIF() The hidden function - You may find it useful
  • Dave Thomas
Replies
1
Views
772
Pete_UK
P
R
Comparison of text
  • Richard Rosell
Replies
2
Views
651
Richard Rosell
R
Top