Microsoft Excel Worksheet Functions

Post thread
N
Switch lookup function to another sheet
  • New2Macros
Replies
2
Views
482
Arvi Laanemets
A
M
Opening multiple templets in two monitors
  • Morgan
Replies
3
Views
415
Gord Dibben
G
S
How to get SUMPRODUCT on filtered cells
  • Sam.D
Replies
1
Views
411
Gary''s Student
G
D
Summarizing with multiple conditions - Formula solution needed
  • Daniel
Replies
2
Views
441
Max
M
R
Need Formula to solve my problem
  • romen
Replies
1
Views
420
Stefi
S
A
Excel date intervals look up
  • adam smith
Replies
1
Views
708
Jacob Skaria
J
K
Find value in a Range of Cells and perform Conditional Formatting
  • Kamlesh
Replies
6
Views
618
Kamlesh
K
T
USING "IF" STATEMENTS FOR MONTHS OF YEAR(IF 1=JANUARY)
  • Tina
Replies
6
Views
535
Rick Rothstein
R
K
Excel 2002 always rounds up automatically
  • Kent
Replies
2
Views
354
Kent
K
J
Sum
  • J Walia
Replies
2
Views
351
Jacob Skaria
J
D
Deleting worksheets in a macro
  • Donna
Replies
2
Views
438
Jacob Skaria
J
P
help with Conditional formatting pairs of cells
  • Parish Pete
Replies
1
Views
627
Ando
A
S
Vlookup, sumproduct, if, sumif... erggg!
  • Serendipity
Replies
1
Views
857
Don Guillett
D
R
Conditional Sumproduct() Based on the Time of the Day
  • Rob
Replies
3
Views
577
Bob Phillips
B
D
Import external data into Excel 2007 so I can subtotal it
  • Denise
Replies
2
Views
1K
Ashish Mathur
A
P
How to add time from multiple cells & date Cells & machine type c
  • Peter Gonzalez
Replies
3
Views
665
Ashish Mathur
A
B
NEED FORMULA HELP
  • brushtec
Replies
1
Views
348
Lars-Åke Aspelin
L
P
Function for odd even numbers
  • petedacook
Replies
4
Views
552
Rick Rothstein
R
S
Max number of consectutive blanks in a range
  • Steve
Replies
7
Views
517
T. Valko
T
A
reference sheet number not name
  • Al
Replies
1
Views
8K
Gary''s Student
G
Y
Calculated Item in Pivot table
  • Yogesh Gupta
Replies
1
Views
1K
Debra Dalgleish
D
S
Calculate total metric based on sum of metric over specific time f
  • StaceyB
Replies
1
Views
838
Bernard Liengme
B
J
I have a file that is 4mb. Cleared all formating...still big
  • JDH
Replies
4
Views
390
Gord Dibben
G
U
Why doesn't "Replace" function find value I know exists?
  • UHAAdminAsst
Replies
3
Views
747
Gord Dibben
G
G
Date Functions & Formatting
  • goskerz
Replies
6
Views
546
Gord Dibben
G
N
move a row of data from one work sheet to another using a formula
  • Need formula help, Excel 2007, Thanks
Replies
1
Views
785
Don Guillett
D
D
SEARCH
  • DaveMoore
Replies
1
Views
371
Don Guillett
D
G
Find last cell in a column, Delete its contents and make it active
  • George
Replies
5
Views
587
Don Guillett
D
M
Usage of Data Validation with If Condition
  • Mujeeb ur Rehman, FBL-GRW-PK
Replies
4
Views
712
Ashish Mathur
A
V
Time Calculation and formulas needed (2 questions)
  • --Viewpoint
Replies
2
Views
456
--Viewpoint
V
G
Use if functions with dates
  • glitterbug99
Replies
1
Views
523
Dave Peterson
D
F
Pivot Table Fields not showing
  • Fritz
Replies
2
Views
11K
Roger Govier
R
P
How do I reference a worksheet name through a formula?
  • pv6901
Replies
3
Views
728
Mike H
M
L
protect cells in excel, but also allow a search in those cells?
  • LindaAlex
Replies
2
Views
891
LindaAlex
L
R
Can I invert a matrix in Excel 2007?
  • Roger Hn
Replies
2
Views
965
Dave Peterson
D
R
formatting excel date list
  • rslc
Replies
5
Views
583
Pete_UK
P
K
Need help to change a cell color based on conditions
  • Ken
Replies
1
Views
390
shail
S
T
Returning multiple instances of the same lookup value
  • tw22
Replies
0
Views
458
tw22
T
A
Creating Visual Excel Cell Alerts
  • alchemist
Replies
5
Views
632
CellShocked
C
Y
Preventing double entry formula
  • Yoli
Replies
4
Views
590
Ashish Mathur
A
H
Assigning a macro to a button
  • hberg
Replies
1
Views
395
Chip Pearson
C
B
HOW CAN I IMPLEMENT SUMIF(D1:D6,">AVERAGE(D1:D6)")
  • Bill Friedman
Replies
1
Views
363
bapeltzer
B
R
Combo List in Excel
  • Renee
Replies
1
Views
558
Gord Dibben
G
R
Summing Data
  • rfhorn
Replies
3
Views
480
rfhorn
R
P
MATCH search with text and numbers
  • Patryk
Replies
1
Views
394
Teethless mama
T
C
Error message needed if incorrect Date Of Birth (DOB) entered
  • Craig
Replies
4
Views
997
Craig
C
D
parent/child relationship between rows?
  • Doug
Replies
3
Views
776
Eva
E
D
exclude certain cells from series fill
  • Doug
Replies
1
Views
614
Gord Dibben
G
G
links to a second workbook doesn't work if origin not open
  • Gerardo
Replies
4
Views
557
Timmy
T
B
remove contain from rows B thur J
  • bill boch
Replies
2
Views
411
Eduardo
E
Back
Top