Microsoft Excel Worksheet Functions

G
Multiple lookup function
  • Guest
Replies
2
Views
90K
SteveG
S
G
a formular to remove spaces in a numeric cell (Phone No)
  • Guest
Replies
7
Views
315K
Guest
G
G
making copied cells change with change in original cell
  • Guest
Replies
2
Views
66K
Maistrye
M
J
Summing based on criteria
  • jspizman
Replies
1
Views
48K
Guest
G
M
separating names
  • mikeyVo
Replies
2
Views
79K
Guest
G
V
Sorting to get the latest of a kind
  • varkeychaya
Replies
2
Views
59K
Guest
G
G
How do I count nonblank cells that meet criteria in another cell?
  • Guest
Replies
13
Views
923K
David Biddulph
D
G
MS Query
  • Guest
Replies
2
Views
152K
Guest
G
G
How to sort the data entered in different columns (columnwise)
  • Guest
Replies
2
Views
87K
varkeychaya
V
K
Lookup_Validation
  • kdoan
Replies
2
Views
39K
kdoan
K
G
determining & returning least and greatest dates
  • Guest
Replies
3
Views
325K
Guest
G
G
Vertical Lookup from a List
  • Guest
Replies
5
Views
79K
Guest
G
G
Validation list that also allows user entry?
  • Guest
Replies
6
Views
77K
Guest
G
S
Help with Networkdays Calculation
  • Scoooter
Replies
2
Views
123K
Scoooter
S
G
Question on functions various Excel versions support
  • Guest
Replies
3
Views
281K
Dave Peterson
D
S
Count coloured cells in a range
  • sizz1
Replies
3
Views
251K
Alberto Pinto
A
G
LOOKUP 2 DIFFERENT VALUES AT ONE TIME AND RETURN A VALUE
  • Guest
Replies
2
Views
407K
Guest
G
B
Use cell value as reference to sheet in formula?
  • bluegnu
Replies
4
Views
225K
bluegnu
B
G
IF(AND(etc., etc. ... problem
  • Guest
Replies
2
Views
62K
Guest
G
G
insert a picture based on a formula
  • Guest
Replies
1
Views
56K
Bernie Deitrick
B
T
Problem with formulas
  • tufftoy
Replies
4
Views
619K
Guest
G
G
Excel should have 300 columns, for use aluminium smelter industry
  • Guest
Replies
1
Views
46K
Guest
G
C
Criteria for Countif
  • coa01gsb
Replies
4
Views
109K
David Biddulph
D
P
Text to Coloumns, by consecutive capital letters
  • paperclip
Replies
2
Views
241K
paperclip
P
N
Variable range in MAX-function
  • nsv
Replies
3
Views
136K
nsv
N
G
convert yards
  • Guest
Replies
2
Views
284K
Guest
G
G
Default Tab Stops for Template
  • Guest
Replies
3
Views
56K
Ian
I
J
Please help... only have 20 mins
  • jamkul
Replies
1
Views
30K
coa01gsb
C
J
What formula!?!?!
  • jamkul
Replies
2
Views
78K
jamkul
J
J
Creating a highlighting formula
  • JustinKredible
Replies
2
Views
89K
Dav
D
G
Cell protection
  • Guest
Replies
5
Views
112K
Scoops
S
G
how to return multiple results in vlookup?
  • Guest
Replies
3
Views
128K
[email protected]
B
G
using vlookup between two separate sheets
  • Guest
Replies
4
Views
72K
Mikeopolo
M
G
Fiveif statements in a formula
  • Guest
Replies
1
Views
329K
Biff
B
G
find hidden data in worksheet
  • Guest
Replies
19
Views
465K
Guest
G
G
Using an Excel VB-made form in cell-specific conditions.
  • Guest
Replies
2
Views
242K
Die_Another_Day
D
G
Reference external worksheet whose name is in a cell
  • Guest
Replies
1
Views
162K
Die_Another_Day
D
B
Unable to get examples to work for lookup etc
  • BrandonC
Replies
6
Views
141K
Guest
G
G
combine two macros
  • Guest
Replies
1
Views
77K
Die_Another_Day
D
G
how to use work date function
  • Guest
Replies
1
Views
19K
Paul B
P
G
How do I create a random number generator in excel?
  • Guest
Replies
2
Views
234K
Alan
A
G
How do I get correct results when LOOKUP with calculated numbers
  • Guest
Replies
2
Views
629K
Guest
G
B
return previous date from list
  • barbetta3141
Replies
5
Views
584K
[email protected]
B
R
Tough one - Sum and IF with multiple referencing (array)
  • ronlim
Replies
5
Views
779K
Domenic
D
M
Refering to Cells
  • madh83
Replies
3
Views
155K
Guest
G
B
If then color of cell
  • bumble78
Replies
6
Views
391K
Guest
G
G
Formula question
  • Guest
Replies
1
Views
80K
Guest
G
G
Top 5 plus Other in Pivot table
  • Guest
Replies
1
Views
197K
Guest
G
D
Simple Game and Puzzle - Very Difficult to Implement
  • dmb490
Replies
1
Views
52K
Maistrye
M
B
array formula: return next date from list
  • barbetta3141
Replies
2
Views
272K
Maistrye
M
You must log in or register to post here.
Back
Top