Excel Functions

Post thread
J
Compaing two worksheets
  • Julian Glass
Replies
0
Views
1K
Julian Glass
J
N
IF Function question
  • nwhusker
Replies
1
Views
1K
Mangesh
M
N
Filtering a list box from a cell value
  • NoodNutt
Replies
0
Views
1K
NoodNutt
N
J
Sound if color reached
  • Johnny1r
Replies
0
Views
1K
Johnny1r
J
T
Normdist for reliability?
  • Trs80
Replies
0
Views
1K
Trs80
T
R
Selection
  • Richard
Replies
2
Views
1K
NoodNutt
N
T
Error 1004: 'Unable to get the Atan2 property of the WorksheetFunction class'
  • Thomas Lindberg
Replies
0
Views
1K
Thomas Lindberg
T
D
search returns error when substring not found
  • David Schwartz
Replies
3
Views
992
Pete_UK
P
A
Excel Crashes when using the Transpose Function
  • Ajit
Replies
0
Views
990
Ajit
A
D
Calculating averages over multiple sheets (excluding zeros)
  • David Schuler
Replies
4
Views
983
David Schuler
D
E
Index/Match on multiple columns
  • Evon
Replies
1
Views
920
DtTall
D
M
Can sumif detect text strings or detect if a dollar sign $ is in a cell?
  • MollyDavis
Replies
4
Views
900
Ken Wright
K
G
Is there a formula to transpose numbers, e.g. change 36 to 63
  • greg.jobs
Replies
10
Views
874
Ron Rosenfeld
R
J
Page Breaks VBA, Excel 2000 & 2003
  • jfcby
Replies
2
Views
862
jfcby
J
C
Removing HTML from EXCEL?
  • Crackles McFarly
Replies
7
Views
856
Pete_UK
P
S
Using sumproduct while skipping cells in the array
  • shanen
Replies
4
Views
848
Roger Govier
R
B
What function returns the sheet name?
  • baobob
Replies
5
Views
844
Harlan Grove
H
G
Applying random changes to a list of numbers
  • greg.jobs
Replies
9
Views
834
David Biddulph
D
R
creating an array
  • Richard
Replies
3
Views
811
T. Valko
T
B
calculating week # and day #
  • bj
Replies
1
Views
803
Art Farrell
A
B
SUMIF Criteria
  • bbrd
Replies
4
Views
800
Harlan Grove
H
N
index lookup and array constant
  • Nicawette
Replies
4
Views
791
Max
M
G
Dates Math
  • Gord
Replies
3
Views
779
Pete_UK
P
T
Excel 2003 Copying Relative Formulas Responds Like Absolute Formulas
  • Techy Wannabe
Replies
0
Views
762
Techy Wannabe
T
M
COUPNCD & Bond pricing
  • Mathieu Fortin
Replies
0
Views
754
Mathieu Fortin
M
R
Need help linking into worksheets on workbooks
  • rfisher33
Replies
2
Views
743
Pete_UK
P
B
? How to pull system date then set it to previous sunday
  • _Bigred
Replies
3
Views
742
Pete_UK
P
J
Multiple For Each Next Statements, Excel 2000 & 2003
  • jfcby
Replies
8
Views
740
Pete_UK
P
M
How do I auto run my macro upon open of file....Workbook_Open() is NOT working?
  • meghantrus
Replies
3
Views
727
FrankSinatra
F
F
V Lookup using 2 criteria
  • fergal
Replies
1
Views
724
JS
J
M
Printing Color-Coded Worksheet in Black & White Mode in Excel 2003
  • Mister Softie
Replies
1
Views
723
Dave Peterson
D
V
Count if
  • venkateswaran.v
Replies
1
Views
721
Pete_UK
P
S
CopyFromRecordset Problem Options
  • sunzj
Replies
0
Views
720
sunzj
S
Z
Average of Numbers
  • Zach
Replies
4
Views
714
Dave Thomas
D
D
Combine two worksheets into PivotTable
  • DtTall
Replies
0
Views
714
DtTall
D
K
Help!!!!
  • Krish
Replies
1
Views
707
Pete_UK
P
M
how can I use vba code and flags to place data in a cell on a specific day?
  • meghantrus
Replies
0
Views
706
[email protected]
M
R
referencing
  • Richard
Replies
1
Views
703
JE McGimpsey
J
G
PDF'ing in MS Excel 2003: Avoiding having each Excel tab saved as separate PDF file
  • global risk appetite
Replies
1
Views
702
[email protected]
B
9
SUMIF if cell value is > previous cell value in range
  • 9105st
Replies
0
Views
702
[email protected]
9
A
Index Match lookup function returns #N/A error ... sometimes
  • AC
Replies
0
Views
701
AC
A
D
DATEDIF() The hidden function - You may find it useful
  • Dave Thomas
Replies
1
Views
700
Pete_UK
P
J
Selection AutoFill, Excel 2000 & 2003
  • jfcby
Replies
1
Views
698
Mladen_Dj
M
Z
FORMATTING function ?
  • Zorian
Replies
0
Views
695
Zorian
Z
T
Formula for Filtering Part Numbers
  • tiziano1
Replies
1
Views
695
Mangesh
M
Z
COUNTIF?
  • Zach
Replies
2
Views
695
Zach
Z
R
Sorting
  • Richard
Replies
1
Views
691
Pete_UK
P
S
Pivot Table - Reference is not valid
  • Sinner
Replies
0
Views
691
Sinner
S
C
brainteaser: change a value by 90 (but answer must lie between 0-180 )
  • Chris.Holland16
Replies
5
Views
684
Ron Rosenfeld
R
T
Checking formula type (reference to other worksheet or not)
  • topola
Replies
1
Views
681
DtTall
D
Top