Microsoft Excel Worksheet Functions

G
Extract last and next-to-last entries in a range
  • Guest
Replies
18
Views
1M
Biff
B
M
Populate required cells prior to saving
  • mhart210
Replies
4
Views
114K
mhart210
M
J
Matching max in a subgroup with corresponding data pair
  • jconta
Replies
2
Views
188K
Herbert Seidenberg
H
B
Roundup Function
  • brown_toby
Replies
3
Views
182K
Bearacade
B
G
How do I do conditional formatting?
  • Guest
Replies
1
Views
101K
Bob Phillips
B
B
Compare 2 columns and choose one and enter answer in third column
  • Betsy
Replies
1
Views
114K
Betsy
B
G
Multiplying ounces for PO
  • Guest
Replies
2
Views
437K
Guest
G
G
How to set a back ground picture in an exel file
  • Guest
Replies
2
Views
261K
Gord Dibben
G
G
Determinig Population membership percentages
  • Guest
Replies
1
Views
33K
Guest
G
D
Where are Bitwise Operators
  • Dennis W. Bulgrien
Replies
1
Views
147K
Dennis W. Bulgrien
D
S
A #DIV/0! With IRR Function
  • Sh0t2bts
Replies
2
Views
361K
[email protected]
J
G
How do I obtain the Average Values between 2 dates?
  • gimiv
Replies
5
Views
637K
Domenic
D
C
If, then question
  • Cacoe
Replies
3
Views
60K
Cacoe
C
N
How do I concatenate two currency cells to show a price range?
  • nevermore627
Replies
5
Views
410K
Mark Lincoln
M
B
VLOOKUP Problem
  • brown_toby
Replies
6
Views
518K
Guest
G
Z
Need to modify lookup function
  • zheng4
Replies
0
Views
177K
zheng4
Z
S
Creating a formula to populate information from multiple cells in another workbook
  • Sullycanpara
Replies
8
Views
214K
RagDyeR
R
G
How can I do SUMIF AND OR
  • Gazzr
Replies
3
Views
93K
RagDyeR
R
G
can I put units in MS excel like 200 mm in formulae ?
  • Guest
Replies
1
Views
262K
Guest
G
G
How do I enter a formula that counts the duration spent
  • Guest
Replies
1
Views
61K
Pete_UK
P
G
count the mean in few date but on de date it has various data
  • Guest
Replies
1
Views
221K
Guest
G
D
Averaging Cells from another workbook
  • drvortex
Replies
2
Views
280K
drvortex
D
J
remove negative from number
  • jermsalerms
Replies
5
Views
215K
jermsalerms
J
G
Dont know Excel Function
  • Guest
Replies
1
Views
458K
[email protected]
B
G
subtotal and sumif
  • Guest
Replies
2
Views
267K
Guest
G
G
HOW to calculate the interest paid between 2 custom periods?
  • Guest
Replies
1
Views
133K
Guest
G
P
Calculating Paycheck to Include Overtime
  • PaxtonPoe
Replies
6
Views
476K
Guest
G
A
Totals of each product in a new worksheet
  • andymaw11
Replies
2
Views
113K
Scoops
S
A
Using ISTEXT across separate Spreadsheets
  • Adrena1in
Replies
1
Views
192K
Adrena1in
A
G
Convert numbers 1,2,3,etc to A,B,C,etc.
  • Guest
Replies
2
Views
137K
Guest
G
G
Create new inventorylist from stocklist
  • Guest
Replies
2
Views
134K
Guest
G
G
Excel - Time display
  • Guest
Replies
4
Views
195K
Guest
G
G
HOW DO I COUNT CELLS WITH DATA BY COLUMN?
  • Guest
Replies
2
Views
222K
Franz Verga
F
G
How to paste a image (signature) in a cell in Excel?
  • Guest
Replies
1
Views
41K
Ken Johnson
K
B
correlation p values
  • becd
Replies
3
Views
63K
becd
B
B
How can I total just the numbers in a column and ignore non-numeric strings?
  • Bud
Replies
1
Views
118K
Bud
B
G
How can I auto highlight a cell
  • Guest
Replies
1
Views
122K
Biff
B
G
How can I always ROUND UP to the nearest multipal of 5 in excl
  • Guest
Replies
4
Views
162K
Guest
G
G
How to calculate future cost of roof
  • Guest
Replies
3
Views
430K
[email protected]
J
G
How do I create a template for excel 2000?
  • Guest
Replies
1
Views
77K
Ragdyer
R
M
Sorting into different worksheets from a unique value
  • Maria
Replies
12
Views
330K
Guest
G
G
Does Excel support Alphanumberic formulas?
  • Guest
Replies
1
Views
141K
Ragdyer
R
G
how do i clear data in excel and not lose the formula
  • Guest
Replies
1
Views
115K
Gord Dibben
G
G
Help with SUMPRODUCT?
  • Gazzr
Replies
4
Views
43K
Ragdyer
R
G
If alternative
  • Guest
Replies
4
Views
325K
daddylonglegs
D
G
formulas
  • Guest
Replies
4
Views
180K
Guest
G
G
Can I display a cell based on a calculation (eg M(14/2)?
  • Guest
Replies
3
Views
64K
Ragdyer
R
G
formula for a # in a column of #'s that's closest to a certain val
  • Guest
Replies
10
Views
300K
Domenic
D
G
How do i make cells in one worksheet copy certain data to another
  • Guest
Replies
3
Views
343K
Guest
G
G
Allow users to edit ranges for VBA objects
  • Guest
Replies
6
Views
308K
Guest
G
You must log in or register to post here.
Back
Top