Microsoft Excel Worksheet Functions

J
Find and match totals Genius Req. this should be easier to read
  • James
Replies
1
Views
118K
Myrna Larson
M
V
filter unique data using functions
  • vrijbergen
Replies
2
Views
29K
Myrna Larson
M
G
count cells that contain text entries
  • Guest
Replies
2
Views
101K
Harlan Grove
H
G
headers across printed pages
  • Guest
Replies
2
Views
128K
nospam
N
L
Additional Sumproduct Criterias
  • lacosta
Replies
3
Views
29K
lacosta
L
G
format row of cells to highlight least amount
  • Guest
Replies
1
Views
72K
JE McGimpsey
J
G
=SUM((B7+2),IF($D7>0.Workday,($D7+E$8,Holidays!$C4:$C11$),''''))
  • Guest
Replies
2
Views
24K
JE McGimpsey
J
R
"Average" function query
  • Robin Blackwell
Replies
3
Views
315K
[email protected]
J
G
pulling numbers from hhh:mm:ss
  • Guest
Replies
2
Views
65K
Guest
G
G
conditional formulas
  • Guest
Replies
2
Views
325K
Biff
B
G
Pull data from yyyymmmmdd.xls
  • Guest
Replies
1
Views
37K
Guest
G
P
giving points by a result (function)
  • Perttu O.
Replies
2
Views
53K
Perttu O.
P
G
PERMUT function
  • Guest
Replies
2
Views
373K
Harlan Grove
H
J
How to select a range whose name is entered in a cell.
  • JD Ami
Replies
3
Views
56K
JD Ami
J
G
How do I calculate an employee timesheet in Excel?
  • Guest
Replies
1
Views
443K
Paul B
P
G
SUMIF function in "Price quote with tax calculation" templae
  • Guest
Replies
6
Views
478K
Guest
G
G
how do you calculate the 5th square root in MS Excel?
  • Guest
Replies
2
Views
609K
GeorgeF
G
G
Looking up a value from an array table
  • Guest
Replies
1
Views
78K
Morrigan
M
G
Concatenate cells with carriage returns
  • Guest
Replies
1
Views
338K
Guest
G
G
Replace a number with text
  • Guest
Replies
1
Views
44K
Roger Govier
R
G
Is there a way to protect individual cells in a worksheet?
  • Guest
Replies
1
Views
86K
Paul B
P
G
Why is worksheet being saved as scrap? why does it have the .shs?
  • Guest
Replies
1
Views
177K
Jeni Q
J
G
Error when opening a saved worksheet
  • Guest
Replies
2
Views
113K
Guest
G
G
EXCEL - need help with IF for dates on schedule
  • Guest
Replies
1
Views
77K
Guest
G
G
Fourier Series
  • Guest
Replies
1
Views
219K
Bernard Liengme
B
G
Combine cells
  • Guest
Replies
4
Views
111K
Guest
G
S
Help, need to make field go red or green
  • smoran
Replies
1
Views
77K
JE McGimpsey
J
S
Finding (Multiple) Highest Values in Column
  • Shay Hurley
Replies
1
Views
158K
Domenic
D
G
Cell Format
  • Guest
Replies
1
Views
52K
JE McGimpsey
J
G
how can i get formulas in excel to copy and paste?
  • Guest
Replies
1
Views
82K
Shay
S
G
CONDITIONAL FORMAT
  • Guest
Replies
4
Views
99K
Guest
G
L
Make new column using partial text in another cell
  • lmrippey
Replies
2
Views
356K
lmrippey
L
G
TOTALS
  • Guest
Replies
1
Views
48K
Shay
S
G
how do i transfer a spreadsheet list of names onto an document
  • Guest
Replies
1
Views
98K
Guest
G
G
random number generation
  • Guest
Replies
7
Views
233K
Guest
G
G
Adding a Single Cell total from Seperate sheets
  • GccTxs
Replies
3
Views
400K
Max
M
G
Range function
  • Guest
Replies
1
Views
36K
Max
M
G
Protecting Multiple Sheet
  • Guest
Replies
2
Views
108K
dominicb
D
G
Excel Worksheets
  • Guest
Replies
9
Views
445K
Harlan Grove
H
G
Add formula based on a fixed number
  • Guest
Replies
2
Views
57K
Guest
G
G
count number of cells
  • Guest
Replies
4
Views
491K
Biff
B
G
how do I sumif using 3 reference columns?
  • Guest
Replies
3
Views
340K
Aladin Akyurek
A
R
Index - Offset - Match Issues
  • Ray Wright
Replies
4
Views
138K
Ray Wright
R
R
Random numbers generation with conditions.
  • ramana
Replies
3
Views
261K
ramana
R
G
how do I sum using 3 reference columns?
  • Guest
Replies
3
Views
403K
Myrna Larson
M
G
How do I sort a column of computed variables in EXCEL?
  • Guest
Replies
2
Views
64K
Paul B
P
C
Parsing 124A into 124
  • Christophe
Replies
4
Views
97K
Harlan Grove
H
G
Box-Jenkins techniques & Time Series
  • Guest
Replies
3
Views
290K
[email protected]
D
G
If functions for dates
  • Guest
Replies
2
Views
110K
Guest
G
G
Allow the use of the fx wizard within the fx wizard for nesting
  • Guest
Replies
1
Views
70K
Bernard Liengme
B
You must log in or register to post here.
Back
Top