Microsoft Excel Worksheet Functions

D
=&'', "& or concentrate formula
  • Dylan @ UAFC
Replies
4
Views
187K
Gord Dibben
G
A
Look up function
  • Anna
Replies
2
Views
197K
LiAD
L
M
Vlookup maximums
  • Mike P
Replies
1
Views
358K
JBeaucaire
J
M
count formula
  • mdcgpw
Replies
2
Views
451K
Gary''s Student
G
P
how do I Perminatly Format Comment Boxes in my Woorkbook?
  • pageisbusy
Replies
3
Views
131K
Gord Dibben
G
B
How to show file creation date in a worksheet cell
  • Big Sean
Replies
3
Views
456K
Gord Dibben
G
A
Need to add different vaules based on qauntity, is this possible?
  • atoubia
Replies
3
Views
231K
Pete_UK
P
C
Getting a value from another worksheet, in a copied cell?
  • circuit_breaker
Replies
4
Views
38K
Gord Dibben
G
D
Match?
  • dadmdp
Replies
5
Views
220K
Pete_UK
P
V
inserting rows for month end dates.!
  • via135
Replies
12
Views
873K
via135
V
D
Protection
  • dpal
Replies
1
Views
204K
Dave Peterson
D
S
Help with dynamic array lookup based on a single reference cell ..
  • SPStevo
Replies
2
Views
567K
T. Valko
T
E
text to date format
  • EMREMEV
Replies
3
Views
259K
EMREMEV
E
R
Find all and Concatenate
  • Rob
Replies
1
Views
195K
Otto Moehrbach
O
A
how do I look up a value and return more than one result?
  • amiller
Replies
2
Views
292K
T. Valko
T
D
summing columns
  • drakey
Replies
5
Views
574K
Brotherharry
B
R
How do I count nonblanks in column A when I filter by column B
  • RP3
Replies
5
Views
316K
Pete_UK
P
T
equals merged cells
  • TGags
Replies
2
Views
335K
David Biddulph
D
M
Extract a string from a cell
  • MrLarrier
Replies
3
Views
349K
David Biddulph
D
P
COUNTA?
  • Paul
Replies
3
Views
144K
Paul
P
M
Need help comparing data from different URL's.
  • marketingninja
Replies
2
Views
100K
marketingninja
M
J
Can this be done?
  • james.b.ivey
Replies
6
Views
44K
Pete_UK
P
R
Count Unique accross mulitple columns
  • Rob Drummond, Jr
Replies
3
Views
496K
Rob Drummond, Jr
R
C
Divide by zero error
  • Chris
Replies
3
Views
377K
Chris
C
B
using a conditional suffix in text function format syntax=text(value,format_text)
  • Brotherharry
Replies
1
Views
206K
JE McGimpsey
J
D
Row extractor
  • datamanipulator
Replies
4
Views
34K
datamanipulator
D
A
Custom format show < +/-500 as zero not blank
  • AnneM
Replies
2
Views
155K
AnneM
A
R
Compare number to range; find highest positive difference
  • RBW
Replies
6
Views
515K
RBW
R
P
Sumproduct excluding duplicates with added condition??
  • Peta
Replies
7
Views
115K
Peta
P
G
Hiding Rows
  • Graham Moore
Replies
5
Views
773K
JBeaucaire
J
E
database query
  • Excel sheet password
Replies
1
Views
180K
Billy Liddel
B
R
Hide #N/As with Cell Indexing/Matching
  • Rob
Replies
5
Views
712K
Pete_UK
P
R
Formula: How do I create a "rolling" sum in excel?
  • Rhianne
Replies
7
Views
384K
JBeaucaire
J
D
copy, paste and transpose formula's into work sheets
  • Derro
Replies
2
Views
220K
Derro
D
J
Calendar, if paid on date, not count prior
  • Jake F
Replies
2
Views
172K
Roger Govier
R
E
Applying a | delimiter to separate a series of Zip codes
  • Ed
Replies
7
Views
196K
Ed
E
D
Find specific value in array of array formula
  • DzednConfsd
Replies
2
Views
44K
Suleman Peerzade
S
J
Sumproduct with conditions - urgent help needed
  • JANA
Replies
2
Views
180K
Venkatesan
V
T
Compare value to range, return matched value
  • TKD
Replies
2
Views
288K
TKD
T
S
Data Sort
  • Steven
Replies
1
Views
128K
Debra Dalgleish
D
B
Sumif across Multiple sheets
  • beenlosteverywhere
Replies
2
Views
368K
beenlosteverywhere
B
B
Select a variable range
  • Bluecat
Replies
7
Views
20K
Bluecat
B
D
Link Cells
  • drnlds
Replies
5
Views
165K
Pete_UK
P
S
Compare data in 2 workbooks and highlight differences in red
  • Sherry
Replies
4
Views
244K
Gord Dibben
G
T
Pivot Table grouping fields by Dept
  • Terri B
Replies
1
Views
181K
Debra Dalgleish
D
R
dealing with time
  • Rhydderch
Replies
4
Views
400K
Rhydderch
R
Q
Which formula(s) should I use???
  • Questions from cold CT
Replies
8
Views
666K
Questions from cold CT
Q
S
Count nonblank cells based on another column
  • SandyB
Replies
1
Views
259K
Elkar
E
V
Linking spreadsheets and returning value to "0" if no info
  • vtrud
Replies
6
Views
382K
vtrud
V
L
Copy Worksheet wont copy objects.
  • Lincoln De Kalb
Replies
7
Views
233K
Lincoln De Kalb
L
You must log in or register to post here.
Back
Top