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
805
Pete_UK
P
S
Formula for multiple match in seperate columns
  • Sinner
Replies
0
Views
726
Sinner
S
M
manipulating text
  • Me
Replies
1
Views
823
carlo
C
G
CountIF functions...
  • Gord
Replies
0
Views
757
Gord
G
R
Sorting
  • Richard
Replies
1
Views
848
Pete_UK
P
T
Formula for Filtering Part Numbers
  • tiziano1
Replies
1
Views
876
Mangesh
M
B
Where is Excel's FILENAME(path) string function?
  • baobob
Replies
2
Views
812
Pete_UK
P
A
Sep05=Sep 5, 2007 instead of Sep 2005
  • Alan Calan
Replies
1
Views
753
Pete_UK
P
B
? How to pull system date then set it to previous sunday
  • _Bigred
Replies
3
Views
909
Pete_UK
P
B
Looping / find
  • Brian
Replies
1
Views
775
Pete_UK
P
T
Excel 2003 Copying Relative Formulas Responds Like Absolute Formulas
  • Techy Wannabe
Replies
0
Views
894
Techy Wannabe
T
T
finding the maximum number of rows used in a range of columns
  • tmarsh
Replies
0
Views
733
[email protected]
T
M
Help, Excel Files Being Wiped Out: Data Lost or Corrupt
  • Mister Softie
Replies
0
Views
752
Mister Softie
M
V
Count if
  • venkateswaran.v
Replies
1
Views
863
Pete_UK
P
K
Help!!!!
  • Krish
Replies
1
Views
872
Pete_UK
P
E
countif problem
  • elaine_chan2
Replies
3
Views
818
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
772
Harlan Grove
H
G
Dates Math
  • Gord
Replies
3
Views
1K
Pete_UK
P
B
setting a range
  • bernd
Replies
1
Views
741
Pete_UK
P
G
Applying random changes to a list of numbers
  • greg.jobs
Replies
9
Views
1K
David Biddulph
D
G
Is there a formula to transpose numbers, e.g. change 36 to 63
  • greg.jobs
Replies
10
Views
1K
Ron Rosenfeld
R
C
Removing HTML from EXCEL?
  • Crackles McFarly
Replies
7
Views
1K
Pete_UK
P
M
How do I auto run my macro upon open of file....Workbook_Open() is NOT working?
  • meghantrus
Replies
3
Views
924
FrankSinatra
F
C
How do you truncate 2.22 to just 0.22?
  • Crackles McFarly
Replies
3
Views
760
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
859
[email protected]
B
M
Printing Color-Coded Worksheet in Black & White Mode in Excel 2003
  • Mister Softie
Replies
1
Views
849
Dave Peterson
D
T
specifying named range with a lookup
  • TSW632
Replies
3
Views
788
TSW632
T
M
COUPNCD & Bond pricing
  • Mathieu Fortin
Replies
0
Views
890
Mathieu Fortin
M
Z
Sum or SubTotal?
  • Zach
Replies
1
Views
698
Mangesh
M
A
Last value in column range <> 0 problem/question
  • aztecbrainsurgeon
Replies
1
Views
761
[email protected]
A
F
Locating/Highlighting differences in column
  • FHamidzade
Replies
0
Views
667
[email protected]
F
K
Need a function that would show the date correctly in concatenation
  • Kompu Kid
Replies
5
Views
875
Pete_UK
P
C
How do you Increment Time by varrying times???
  • Crackles McFarly
Replies
6
Views
873
Gord Dibben
G
Z
COUNTIF?
  • Zach
Replies
2
Views
858
Zach
Z
A
Adding set rows
  • alanpaulwilson
Replies
1
Views
810
andycat
A
S
Excel Matrix
  • Sal
Replies
1
Views
823
Pete_UK
P
B
What function returns the sheet name?
  • baobob
Replies
5
Views
1K
Harlan Grove
H
W
Entering a number
  • WSB
Replies
3
Views
782
Pete_UK
P
S
CopyFromRecordset Problem Options
  • sunzj
Replies
0
Views
859
sunzj
S
C
Estimate date
  • CD27
Replies
2
Views
776
CD27
C
A
Explain Circular References
  • Arcadian
Replies
3
Views
841
Harlan Grove
H
Z
Average of Numbers
  • Zach
Replies
4
Views
907
Dave Thomas
D
E
Index/Match on multiple columns
  • Evon
Replies
1
Views
1K
DtTall
D
T
Checking formula type (reference to other worksheet or not)
  • topola
Replies
1
Views
809
DtTall
D
D
Combine two worksheets into PivotTable
  • DtTall
Replies
0
Views
831
DtTall
D
D
DATEDIF() The hidden function - You may find it useful
  • Dave Thomas
Replies
1
Views
894
Pete_UK
P
R
Comparison of text
  • Richard Rosell
Replies
2
Views
770
Richard Rosell
R
Top