Microsoft Excel Worksheet Functions

M
Opening multiple templets in two monitors
  • Morgan
Replies
3
Views
208K
Gord Dibben
G
S
How to get SUMPRODUCT on filtered cells
  • Sam.D
Replies
1
Views
116K
Gary''s Student
G
D
Summarizing with multiple conditions - Formula solution needed
  • Daniel
Replies
2
Views
218K
Max
M
R
Need Formula to solve my problem
  • romen
Replies
1
Views
191K
Stefi
S
A
Excel date intervals look up
  • adam smith
Replies
1
Views
257K
Jacob Skaria
J
K
Find value in a Range of Cells and perform Conditional Formatting
  • Kamlesh
Replies
6
Views
420K
Kamlesh
K
T
USING "IF" STATEMENTS FOR MONTHS OF YEAR(IF 1=JANUARY)
  • Tina
Replies
6
Views
421K
Rick Rothstein
R
K
Excel 2002 always rounds up automatically
  • Kent
Replies
2
Views
20K
Kent
K
J
Sum
  • J Walia
Replies
2
Views
66K
Jacob Skaria
J
D
Deleting worksheets in a macro
  • Donna
Replies
2
Views
177K
Jacob Skaria
J
P
help with Conditional formatting pairs of cells
  • Parish Pete
Replies
1
Views
151K
Ando
A
S
Vlookup, sumproduct, if, sumif... erggg!
  • Serendipity
Replies
1
Views
259K
Don Guillett
D
R
Conditional Sumproduct() Based on the Time of the Day
  • Rob
Replies
3
Views
264K
Bob Phillips
B
D
Import external data into Excel 2007 so I can subtotal it
  • Denise
Replies
2
Views
222K
Ashish Mathur
A
P
How to add time from multiple cells & date Cells & machine type c
  • Peter Gonzalez
Replies
3
Views
217K
Ashish Mathur
A
B
NEED FORMULA HELP
  • brushtec
Replies
1
Views
153K
Lars-Åke Aspelin
L
P
Function for odd even numbers
  • petedacook
Replies
4
Views
527K
Rick Rothstein
R
S
Max number of consectutive blanks in a range
  • Steve
Replies
7
Views
350K
T. Valko
T
A
reference sheet number not name
  • Al
Replies
1
Views
160K
Gary''s Student
G
Y
Calculated Item in Pivot table
  • Yogesh Gupta
Replies
1
Views
116K
Debra Dalgleish
D
S
Calculate total metric based on sum of metric over specific time f
  • StaceyB
Replies
1
Views
239K
Bernard Liengme
B
J
I have a file that is 4mb. Cleared all formating...still big
  • JDH
Replies
4
Views
52K
Gord Dibben
G
U
Why doesn't "Replace" function find value I know exists?
  • UHAAdminAsst
Replies
3
Views
125K
Gord Dibben
G
G
Date Functions & Formatting
  • goskerz
Replies
6
Views
298K
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
202K
Don Guillett
D
D
SEARCH
  • DaveMoore
Replies
1
Views
158K
Don Guillett
D
G
Find last cell in a column, Delete its contents and make it active
  • George
Replies
5
Views
607K
Don Guillett
D
M
Usage of Data Validation with If Condition
  • Mujeeb ur Rehman, FBL-GRW-PK
Replies
4
Views
372K
Ashish Mathur
A
V
Time Calculation and formulas needed (2 questions)
  • --Viewpoint
Replies
2
Views
281K
--Viewpoint
V
G
Use if functions with dates
  • glitterbug99
Replies
1
Views
230K
Dave Peterson
D
F
Pivot Table Fields not showing
  • Fritz
Replies
2
Views
158K
Roger Govier
R
P
How do I reference a worksheet name through a formula?
  • pv6901
Replies
3
Views
335K
Mike H
M
L
protect cells in excel, but also allow a search in those cells?
  • LindaAlex
Replies
2
Views
68K
LindaAlex
L
R
Can I invert a matrix in Excel 2007?
  • Roger Hn
Replies
2
Views
250K
Dave Peterson
D
R
formatting excel date list
  • rslc
Replies
5
Views
464K
Pete_UK
P
K
Need help to change a cell color based on conditions
  • Ken
Replies
1
Views
250K
shail
S
T
Returning multiple instances of the same lookup value
  • tw22
Replies
0
Views
222K
tw22
T
A
Creating Visual Excel Cell Alerts
  • alchemist
Replies
5
Views
225K
CellShocked
C
Y
Preventing double entry formula
  • Yoli
Replies
4
Views
190K
Ashish Mathur
A
H
Assigning a macro to a button
  • hberg
Replies
1
Views
70K
Chip Pearson
C
B
HOW CAN I IMPLEMENT SUMIF(D1:D6,">AVERAGE(D1:D6)")
  • Bill Friedman
Replies
1
Views
91K
bapeltzer
B
R
Combo List in Excel
  • Renee
Replies
1
Views
219K
Gord Dibben
G
R
Summing Data
  • rfhorn
Replies
3
Views
472K
rfhorn
R
P
MATCH search with text and numbers
  • Patryk
Replies
1
Views
246K
Teethless mama
T
C
Error message needed if incorrect Date Of Birth (DOB) entered
  • Craig
Replies
4
Views
349K
Craig
C
D
parent/child relationship between rows?
  • Doug
Replies
3
Views
256K
Eva
E
D
exclude certain cells from series fill
  • Doug
Replies
1
Views
163K
Gord Dibben
G
G
links to a second workbook doesn't work if origin not open
  • Gerardo
Replies
4
Views
59K
Timmy
T
B
remove contain from rows B thur J
  • bill boch
Replies
2
Views
252K
Eduardo
E
V
bitwise functions
  • vbano
Replies
3
Views
275K
Joe User
J
You must log in or register to post here.
Back
Top