Microsoft Excel Worksheet Functions

M
How to ignore a column of numbers in Grand Total for rows
  • Michael Lester
Replies
1
Views
354K
Michael Lester
M
G
Can I add a range and then divide that sum by a specific value?
  • Gordon Shumway
Replies
2
Views
119K
Gordon Shumway
G
D
Copy columns, but not hidden ones
  • Duncs
Replies
3
Views
514K
Claus Busch
C
D
VLOOKUP, a table with text and numerics
  • duncan.edment
Replies
7
Views
400K
Claus Busch
C
R
How to reset excel worksheet form lilstbox and combo box
  • ramseyprescott
Replies
2
Views
230K
[email protected]
R
D
Learning arrays.
  • David Farber
Replies
13
Views
850K
David Farber
D
B
Calculate total by row number
  • brianfosterblack
Replies
4
Views
995K
[email protected]
B
W
2 dimensional date sort
  • Walter Briscoe
Replies
1
Views
305K
Claus Busch
C
E
% of difference between two numbers
  • exeldumb
Replies
6
Views
420K
joeu2004
J
J
Countifs with different restrictions
  • joppert87
Replies
1
Views
279K
Claus Busch
C
S
Grouping above in Excel 2007
  • SJKM
Replies
10
Views
493K
jbates88
J
L
How do I assign "Apple" to a cell reference in this evaluate code?
  • lhkittle
Replies
2
Views
169K
[email protected]
L
M
NumberFormat for small non-zero numbers?
  • maury.markowitz
Replies
2
Views
525K
joeu2004
J
M
NumberFormat instead of an IF
  • maury.markowitz
Replies
2
Views
138K
[email protected]
M
N
date & Time
  • naresh vadlamudi
Replies
1
Views
195K
Claus Busch
C
N
COUNTING THE SAME VALUES IN A SHEET
  • naga rajan
Replies
3
Views
263K
Claus Busch
C
S
Protect and Edit Object
  • sandjclarke
Replies
1
Views
315K
GS
G
A
sorting noncontiguous data with exceptions
  • al drah
Replies
3
Views
384K
plinius
P
R
copying column multiple times
  • rakeshbrraag
Replies
0
Views
223K
rakeshbrraag
R
T
Display yesterday's date but only for weekdays?
  • totalnatal
Replies
7
Views
363K
[email protected]
R
S
names dates & amounts stated multiple times in document
  • sml421
Replies
0
Views
165K
sml421
S
G
Remove punctuation mark, Split cells & average accross column
  • Gautam Bhut
Replies
4
Views
294K
Gautam Bhut
G
P
LOOKUP function??
  • paul.mullan
Replies
4
Views
296K
[email protected]
P
J
Countif with two criteria
  • jc9972003
Replies
2
Views
414K
[email protected]
J
K
Help Needed : how do i compute this?
  • kazanami
Replies
0
Views
188K
kazanami
K
M
Convert Number to Text for Index/Match
  • mark.wolven
Replies
1
Views
340K
isabelle
I
P
Sort column beginning with blank?
  • Pete
Replies
1
Views
318K
Pete
P
J
INDEX MATCH SMALL
  • jc9972003
Replies
12
Views
791K
[email protected]
J
C
Adding a letter to the start of each cell
  • Colin Hayes
Replies
6
Views
133K
[email protected]
C
J
Table "What If" Set Up If I Change One Or Two Variables
  • John Johnston
Replies
2
Views
109K
[email protected]
K
J
Calculating time for 3rd shift
  • jc9972003
Replies
4
Views
553K
[email protected]
J
J
Extract the 2 Lowest %
  • jc9972003
Replies
3
Views
335K
[email protected]
J
T
Computer Properties
  • tuli
Replies
1
Views
82K
GS
G
B
Club Accounts
  • Bampah
Replies
2
Views
129K
Cimjet
C
T
range definition by cells numbers
  • tuli
Replies
3
Views
537K
tuli
T
D
Logical formatting for multiple values
  • Danielle
Replies
1
Views
281K
Claus Busch
C
R
Split astring using Capital letter as identifier
  • Raj
Replies
12
Views
957K
ColonelFlounders
C
C
VLOOKUP return cell location and hyperlink
  • Cammy
Replies
0
Views
251K
Cammy
C
A
RANK, duplicate ranking but no gaps in rank
  • arron laing
Replies
5
Views
254K
Bobby777
B
J
Extract first and last login time for each day only
  • jc9972003
Replies
6
Views
509K
[email protected]
J
J
Convert number to text as displayed
  • johnscpierce
Replies
3
Views
355K
[email protected]
L
Y
#value error for sumproduct using RIGHT cmd
  • yabi
Replies
0
Views
349K
yabi
Y
W
Distribution of capital contribution
  • wabbleknee
Replies
4
Views
263K
wabbleknee
W
M
Show latest date
  • McClellan
Replies
4
Views
302K
Don Guillett
D
J
How to sum more than 30 cells
  • jmcclain
Replies
9
Views
637K
[email protected]
L
W
Machine-readable passport calculations
  • Walter Briscoe
Replies
7
Views
2M
azedine1
A
A
Benford law option available in Microsoft Excel
  • Auditor
Replies
3
Views
97K
[email protected]
S
J
Extract Date formula Only
  • jc9972003
Replies
4
Views
249K
[email protected]
J
M
Calculating aggregate donation sums for a list of names
  • Melizma
Replies
0
Views
187K
Melizma
M
K
Compare 2 lists and return value
  • KENSONE
Replies
2
Views
279K
pclive
P
You must log in or register to post here.
Back
Top