Microsoft Excel Worksheet Functions

Post thread
M
Concatenate path and file string for external reference
  • Michael
Replies
4
Views
4K
Pete_UK
P
D
=&'', "& or concentrate formula
  • Dylan @ UAFC
Replies
4
Views
1K
Gord Dibben
G
A
Look up function
  • Anna
Replies
2
Views
338
LiAD
L
M
Vlookup maximums
  • Mike P
Replies
1
Views
620
JBeaucaire
J
M
count formula
  • mdcgpw
Replies
2
Views
328
Gary''s Student
G
P
how do I Perminatly Format Comment Boxes in my Woorkbook?
  • pageisbusy
Replies
3
Views
288
Gord Dibben
G
B
How to show file creation date in a worksheet cell
  • Big Sean
Replies
3
Views
1K
Gord Dibben
G
A
Need to add different vaules based on qauntity, is this possible?
  • atoubia
Replies
3
Views
413
Pete_UK
P
C
Getting a value from another worksheet, in a copied cell?
  • circuit_breaker
Replies
4
Views
339
Gord Dibben
G
D
Match?
  • dadmdp
Replies
5
Views
444
Pete_UK
P
V
inserting rows for month end dates.!
  • via135
Replies
12
Views
665
via135
V
D
Protection
  • dpal
Replies
1
Views
295
Dave Peterson
D
S
Help with dynamic array lookup based on a single reference cell ..
  • SPStevo
Replies
2
Views
2K
T. Valko
T
E
text to date format
  • EMREMEV
Replies
3
Views
352
EMREMEV
E
R
Find all and Concatenate
  • Rob
Replies
1
Views
377
Otto Moehrbach
O
A
how do I look up a value and return more than one result?
  • amiller
Replies
2
Views
536
T. Valko
T
D
summing columns
  • drakey
Replies
5
Views
329
Brotherharry
B
R
How do I count nonblanks in column A when I filter by column B
  • RP3
Replies
5
Views
528
Pete_UK
P
T
equals merged cells
  • TGags
Replies
2
Views
572
David Biddulph
D
M
Extract a string from a cell
  • MrLarrier
Replies
3
Views
395
David Biddulph
D
P
COUNTA?
  • Paul
Replies
3
Views
389
Paul
P
M
Need help comparing data from different URL's.
  • marketingninja
Replies
2
Views
407
marketingninja
M
J
Can this be done?
  • james.b.ivey
Replies
6
Views
354
Pete_UK
P
R
Count Unique accross mulitple columns
  • Rob Drummond, Jr
Replies
3
Views
647
Rob Drummond, Jr
R
C
Divide by zero error
  • Chris
Replies
3
Views
4K
Chris
C
B
using a conditional suffix in text function format syntax=text(value,format_text)
  • Brotherharry
Replies
1
Views
923
JE McGimpsey
J
D
Row extractor
  • datamanipulator
Replies
4
Views
361
datamanipulator
D
A
Custom format show < +/-500 as zero not blank
  • AnneM
Replies
2
Views
458
AnneM
A
R
Compare number to range; find highest positive difference
  • RBW
Replies
6
Views
861
RBW
R
P
Sumproduct excluding duplicates with added condition??
  • Peta
Replies
7
Views
1K
Peta
P
G
Hiding Rows
  • Graham Moore
Replies
5
Views
585
JBeaucaire
J
E
database query
  • Excel sheet password
Replies
1
Views
259
Billy Liddel
B
R
Hide #N/As with Cell Indexing/Matching
  • Rob
Replies
5
Views
521
Pete_UK
P
R
Formula: How do I create a "rolling" sum in excel?
  • Rhianne
Replies
7
Views
4K
JBeaucaire
J
D
copy, paste and transpose formula's into work sheets
  • Derro
Replies
2
Views
2K
Derro
D
J
Calendar, if paid on date, not count prior
  • Jake F
Replies
2
Views
391
Roger Govier
R
E
Applying a | delimiter to separate a series of Zip codes
  • Ed
Replies
7
Views
403
Ed
E
D
Find specific value in array of array formula
  • DzednConfsd
Replies
2
Views
739
Suleman Peerzade
S
J
Sumproduct with conditions - urgent help needed
  • JANA
Replies
2
Views
385
Venkatesan
V
T
Compare value to range, return matched value
  • TKD
Replies
2
Views
672
TKD
T
S
Data Sort
  • Steven
Replies
1
Views
388
Debra Dalgleish
D
B
Sumif across Multiple sheets
  • beenlosteverywhere
Replies
2
Views
1K
beenlosteverywhere
B
B
Select a variable range
  • Bluecat
Replies
7
Views
395
Bluecat
B
D
Link Cells
  • drnlds
Replies
5
Views
389
Pete_UK
P
S
Compare data in 2 workbooks and highlight differences in red
  • Sherry
Replies
4
Views
2K
Gord Dibben
G
T
Pivot Table grouping fields by Dept
  • Terri B
Replies
1
Views
431
Debra Dalgleish
D
R
dealing with time
  • Rhydderch
Replies
4
Views
482
Rhydderch
R
Q
Which formula(s) should I use???
  • Questions from cold CT
Replies
8
Views
451
Questions from cold CT
Q
S
Count nonblank cells based on another column
  • SandyB
Replies
1
Views
451
Elkar
E
V
Linking spreadsheets and returning value to "0" if no info
  • vtrud
Replies
6
Views
383
vtrud
V
Back
Top