Microsoft Excel Worksheet Functions

Post thread
C
Testing a cell value for a specific weekday.
  • CellShocked
Replies
3
Views
730
Claus Busch
C
M
How to ignore a column of numbers in Grand Total for rows
  • Michael Lester
Replies
1
Views
826
Michael Lester
M
G
Can I add a range and then divide that sum by a specific value?
  • Gordon Shumway
Replies
2
Views
605
Gordon Shumway
G
D
Copy columns, but not hidden ones
  • Duncs
Replies
3
Views
798
Claus Busch
C
D
VLOOKUP, a table with text and numerics
  • duncan.edment
Replies
7
Views
981
Claus Busch
C
R
How to reset excel worksheet form lilstbox and combo box
  • ramseyprescott
Replies
2
Views
613
[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
750
[email protected]
B
W
2 dimensional date sort
  • Walter Briscoe
Replies
1
Views
787
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
714
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
656
[email protected]
L
M
NumberFormat for small non-zero numbers?
  • maury.markowitz
Replies
2
Views
728
joeu2004
J
M
NumberFormat instead of an IF
  • maury.markowitz
Replies
2
Views
464
[email protected]
M
N
date & Time
  • naresh vadlamudi
Replies
1
Views
573
Claus Busch
C
N
COUNTING THE SAME VALUES IN A SHEET
  • naga rajan
Replies
3
Views
599
Claus Busch
C
S
Protect and Edit Object
  • sandjclarke
Replies
1
Views
839
GS
G
A
sorting noncontiguous data with exceptions
  • al drah
Replies
3
Views
767
plinius
P
R
copying column multiple times
  • rakeshbrraag
Replies
0
Views
634
rakeshbrraag
R
T
Display yesterday's date but only for weekdays?
  • totalnatal
Replies
7
Views
962
[email protected]
R
S
names dates & amounts stated multiple times in document
  • sml421
Replies
0
Views
680
sml421
S
G
Remove punctuation mark, Split cells & average accross column
  • Gautam Bhut
Replies
4
Views
878
Gautam Bhut
G
P
LOOKUP function??
  • paul.mullan
Replies
4
Views
637
[email protected]
P
J
Countif with two criteria
  • jc9972003
Replies
2
Views
646
[email protected]
J
K
Help Needed : how do i compute this?
  • kazanami
Replies
0
Views
504
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
429
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
490
[email protected]
C
J
Table "What If" Set Up If I Change One Or Two Variables
  • John Johnston
Replies
2
Views
447
[email protected]
K
J
Calculating time for 3rd shift
  • jc9972003
Replies
4
Views
953
[email protected]
J
J
Extract the 2 Lowest %
  • jc9972003
Replies
3
Views
656
[email protected]
J
T
Computer Properties
  • tuli
Replies
1
Views
587
GS
G
B
Club Accounts
  • Bampah
Replies
2
Views
1K
Cimjet
C
T
range definition by cells numbers
  • tuli
Replies
3
Views
586
tuli
T
D
Logical formatting for multiple values
  • Danielle
Replies
1
Views
717
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
1K
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
883
[email protected]
J
J
Convert number to text as displayed
  • johnscpierce
Replies
3
Views
848
[email protected]
L
Y
#value error for sumproduct using RIGHT cmd
  • yabi
Replies
0
Views
799
yabi
Y
W
Distribution of capital contribution
  • wabbleknee
Replies
4
Views
754
wabbleknee
W
M
Show latest date
  • McClellan
Replies
4
Views
705
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
736
[email protected]
J
M
Calculating aggregate donation sums for a list of names
  • Melizma
Replies
0
Views
692
Melizma
M
Back
Top