Microsoft Excel Worksheet Functions

Post thread
M
How to ignore a column of numbers in Grand Total for rows
  • Michael Lester
Replies
1
Views
734
Michael Lester
M
G
Can I add a range and then divide that sum by a specific value?
  • Gordon Shumway
Replies
2
Views
599
Gordon Shumway
G
D
Copy columns, but not hidden ones
  • Duncs
Replies
3
Views
716
Claus Busch
C
D
VLOOKUP, a table with text and numerics
  • duncan.edment
Replies
7
Views
875
Claus Busch
C
R
How to reset excel worksheet form lilstbox and combo box
  • ramseyprescott
Replies
2
Views
603
[email protected]
R
D
Learning arrays.
  • David Farber
Replies
13
Views
1K
David Farber
D
B
Calculate total by row number
  • brianfosterblack
Replies
4
Views
713
[email protected]
B
W
2 dimensional date sort
  • Walter Briscoe
Replies
1
Views
741
Claus Busch
C
E
% of difference between two numbers
  • exeldumb
Replies
6
Views
1K
joeu2004
J
J
Countifs with different restrictions
  • joppert87
Replies
1
Views
674
Claus Busch
C
S
Grouping above in Excel 2007
  • SJKM
Replies
10
Views
16K
jbates88
J
L
How do I assign "Apple" to a cell reference in this evaluate code?
  • lhkittle
Replies
2
Views
638
[email protected]
L
M
NumberFormat for small non-zero numbers?
  • maury.markowitz
Replies
2
Views
692
joeu2004
J
M
NumberFormat instead of an IF
  • maury.markowitz
Replies
2
Views
439
[email protected]
M
N
date & Time
  • naresh vadlamudi
Replies
1
Views
553
Claus Busch
C
N
COUNTING THE SAME VALUES IN A SHEET
  • naga rajan
Replies
3
Views
557
Claus Busch
C
S
Protect and Edit Object
  • sandjclarke
Replies
1
Views
826
GS
G
A
sorting noncontiguous data with exceptions
  • al drah
Replies
3
Views
740
plinius
P
R
copying column multiple times
  • rakeshbrraag
Replies
0
Views
623
rakeshbrraag
R
T
Display yesterday's date but only for weekdays?
  • totalnatal
Replies
7
Views
937
[email protected]
R
S
names dates & amounts stated multiple times in document
  • sml421
Replies
0
Views
658
sml421
S
G
Remove punctuation mark, Split cells & average accross column
  • Gautam Bhut
Replies
4
Views
829
Gautam Bhut
G
P
LOOKUP function??
  • paul.mullan
Replies
4
Views
601
[email protected]
P
J
Countif with two criteria
  • jc9972003
Replies
2
Views
624
[email protected]
J
K
Help Needed : how do i compute this?
  • kazanami
Replies
0
Views
490
kazanami
K
M
Convert Number to Text for Index/Match
  • mark.wolven
Replies
1
Views
1K
isabelle
I
P
Sort column beginning with blank?
  • Pete
Replies
1
Views
411
Pete
P
J
INDEX MATCH SMALL
  • jc9972003
Replies
12
Views
1K
[email protected]
J
C
Adding a letter to the start of each cell
  • Colin Hayes
Replies
6
Views
475
[email protected]
C
J
Table "What If" Set Up If I Change One Or Two Variables
  • John Johnston
Replies
2
Views
442
[email protected]
K
J
Calculating time for 3rd shift
  • jc9972003
Replies
4
Views
866
[email protected]
J
J
Extract the 2 Lowest %
  • jc9972003
Replies
3
Views
617
[email protected]
J
T
Computer Properties
  • tuli
Replies
1
Views
570
GS
G
B
Club Accounts
  • Bampah
Replies
2
Views
1K
Cimjet
C
T
range definition by cells numbers
  • tuli
Replies
3
Views
566
tuli
T
D
Logical formatting for multiple values
  • Danielle
Replies
1
Views
679
Claus Busch
C
R
Split astring using Capital letter as identifier
  • Raj
Replies
12
Views
7K
ColonelFlounders
C
C
VLOOKUP return cell location and hyperlink
  • Cammy
Replies
0
Views
997
Cammy
C
A
RANK, duplicate ranking but no gaps in rank
  • arron laing
Replies
5
Views
4K
Bobby777
B
J
Extract first and last login time for each day only
  • jc9972003
Replies
6
Views
865
[email protected]
J
J
Convert number to text as displayed
  • johnscpierce
Replies
3
Views
821
[email protected]
L
Y
#value error for sumproduct using RIGHT cmd
  • yabi
Replies
0
Views
757
yabi
Y
W
Distribution of capital contribution
  • wabbleknee
Replies
4
Views
699
wabbleknee
W
M
Show latest date
  • McClellan
Replies
4
Views
662
Don Guillett
D
J
How to sum more than 30 cells
  • jmcclain
Replies
9
Views
1K
[email protected]
L
W
Machine-readable passport calculations
  • Walter Briscoe
Replies
7
Views
11K
azedine1
A
A
Benford law option available in Microsoft Excel
  • Auditor
Replies
3
Views
2K
[email protected]
S
J
Extract Date formula Only
  • jc9972003
Replies
4
Views
705
[email protected]
J
M
Calculating aggregate donation sums for a list of names
  • Melizma
Replies
0
Views
665
Melizma
M
K
Compare 2 lists and return value
  • KENSONE
Replies
2
Views
583
pclive
P
Back
Top