Microsoft Excel Worksheet Functions

S
SUMPRODUCT - Exclude LAST Row of Matched Criteria (Month & Year)
  • Sam via OfficeKB.com
Replies
10
Views
923K
Sam via OfficeKB.com
S
G
Calcing DOB
  • Guest
Replies
4
Views
317K
Gord Dibben
G
J
Spaces
  • jamalhakem
Replies
4
Views
170K
David Biddulph
D
M
Formula in comments?
  • Manju
Replies
4
Views
537K
Manju
M
T
changing a Sumproduct formula please
  • Tester
Replies
3
Views
566K
Max
M
G
convert weekday date to the next sunday date
  • Guest
Replies
1
Views
263K
Niek Otten
N
G
How to calculate how many meet min and max criteria
  • Guest
Replies
1
Views
199K
Bob Phillips
B
M
horizontal sumif help
  • Marcelo
Replies
2
Views
312K
Guest
G
G
How do I count values w/ criteria located in more than one column
  • Guest
Replies
3
Views
437K
Guest
G
G
array formula with if and hlookup
  • Guest
Replies
5
Views
354K
Max
M
G
How do I return a mileage value from a row and column value
  • Guest
Replies
4
Views
469K
Guest
G
G
Problem with sorting 19th century dates
  • Guest
Replies
2
Views
393K
Guest
G
G
Setting up MS Excel form
  • Guest
Replies
1
Views
63K
Guest
G
G
Shorten Formula
  • Guest
Replies
2
Views
106K
Guest
G
G
Can Excel headers automatically look to a cell for data? &[B2]
  • Guest
Replies
1
Views
275K
Gord Dibben
G
G
downloading megastat software
  • Guest
Replies
1
Views
139K
Peo Sjoblom
P
G
formula series (newbie)
  • Guest
Replies
2
Views
70K
Ragdyer
R
G
Formula too long
  • Guest
Replies
2
Views
94K
Guest
G
G
How do i assign value to 3 cells =E41, =H41, = B41 by typing 41
  • Guest
Replies
4
Views
195K
Ragdyer
R
G
Comparing two ranges and the positions of duplicates
  • Guest
Replies
2
Views
319K
Roger Govier
R
B
Index and Match Formula
  • Barbara Schneier
Replies
4
Views
131K
Barbara Schneier
B
G
Linking cells between worksheet - from column to row
  • Guest
Replies
2
Views
72K
Guest
G
G
Ensure LOOkUP does not return #N/A
  • Guest
Replies
1
Views
295K
Guest
G
G
only INTEGER INPUT IN CELL
  • Guest
Replies
2
Views
68K
Paul B
P
G
Save Date & Time
  • Guest
Replies
3
Views
197K
Nick Hodge
N
G
How do I deal with a "Too many different cell formats".
  • Guest
Replies
1
Views
202K
Nick Hodge
N
G
Fixing the number of Col and rows.
  • Guest
Replies
1
Views
49K
Guest
G
G
Multiple Condition Text Return
  • Gymclass14 via OfficeKB.com
Replies
1
Views
150K
T. Valko
T
2
How do I count the number of filtered rows
  • 2D Rick
Replies
2
Views
285K
2D Rick
2
G
Why does conditional formatting remain static?
  • Guest
Replies
3
Views
391K
Peo Sjoblom
P
G
Values Returning Text
  • Gymclass14 via OfficeKB.com
Replies
4
Views
63K
CLR
C
G
Formula to return lowest value of 3 datapoints
  • Guest
Replies
3
Views
395K
Don Guillett
D
G
how to force a lookup
  • Guest
Replies
1
Views
266K
Guest
G
G
Formula Replication
  • Guest
Replies
8
Views
383K
David Biddulph
D
H
CUBE Functions in Excel 2007
  • Hans Preuer
Replies
1
Views
300K
Andreas Flockermann [BonaVista Systems]
A
J
Days between
  • Joseph N.
Replies
3
Views
371K
Ron Rosenfeld
R
N
adding numbers shown in cells, not what is actually in cell - help!!!
  • nelsonsdavis
Replies
2
Views
136K
RagDyeR
R
G
Timesheet Validation
  • GrahamB
Replies
2
Views
354K
GrahamB
G
J
New Running Total for each worksheet
  • Jeff
Replies
1
Views
340K
RagDyeR
R
G
ARRAY?, CONSTANT?, INDIRECT?, CONSTITUATE?
  • Guest
Replies
13
Views
803K
Guest
G
G
Importing specific data into an Excel workbook
  • Guest
Replies
1
Views
227K
Peo Sjoblom
P
G
Filtering sheet data in another sheet
  • Guest
Replies
3
Views
155K
Guest
G
S
Place a Dynamic Date + a Certain Time in a Cell
  • Sean
Replies
3
Views
362K
Guest
G
G
print area across the freeze panes area
  • Guest
Replies
2
Views
366K
Gord Dibben
G
G
Set the time and date for editing a cell
  • Guest
Replies
2
Views
197K
CLR
C
G
If statements and conditions - again!! new prob
  • Guest
Replies
2
Views
175K
Don Guillett
D
R
Average function
  • Rubix
Replies
3
Views
124K
Rubix
R
G
How to replace ... with a 0
  • Guest
Replies
1
Views
19K
Corey
C
G
If function returns #REF!, want it to return 0
  • Guest
Replies
2
Views
472K
MartinW
M
G
How do I create calculated items on pivot table reports?
  • Guest
Replies
1
Views
201K
Debra Dalgleish
D
You must log in or register to post here.
Back
Top