Excel Worksheets

Post thread
S
Help with dynamic array lookup based on a single reference cell ..
  • SPStevo
Replies
2
Views
431
T. Valko
T
E
text to date format
  • EMREMEV
Replies
3
Views
153
EMREMEV
E
S
automatic page breaks at every cell
  • Staceyglow
Replies
0
Views
395
Staceyglow
S
R
Find all and Concatenate
  • Rob
Replies
1
Views
254
Otto Moehrbach
O
A
how do I look up a value and return more than one result?
  • amiller
Replies
2
Views
440
T. Valko
T
D
summing columns
  • drakey
Replies
5
Views
552
Brotherharry
B
R
How do I count nonblanks in column A when I filter by column B
  • RP3
Replies
5
Views
412
Pete_UK
P
T
equals merged cells
  • TGags
Replies
2
Views
370
David Biddulph
D
M
Extract a string from a cell
  • MrLarrier
Replies
3
Views
468
David Biddulph
D
P
COUNTA?
  • Paul
Replies
3
Views
166
Paul
P
M
Need help comparing data from different URL's.
  • marketingninja
Replies
2
Views
160
marketingninja
M
J
Can this be done?
  • james.b.ivey
Replies
6
Views
218
Pete_UK
P
R
Count Unique accross mulitple columns
  • Rob Drummond, Jr
Replies
7
Views
776
Rob Drummond, Jr
R
C
Divide by zero error
  • Chris
Replies
3
Views
496
Chris
C
B
using a conditional suffix in text function format syntax=text(value,format_text)
  • Brotherharry
Replies
1
Views
321
JE McGimpsey
J
D
Row extractor
  • datamanipulator
Replies
4
Views
188
datamanipulator
D
A
Custom format show < +/-500 as zero not blank
  • AnneM
Replies
2
Views
356
AnneM
A
R
Compare number to range; find highest positive difference
  • RBW
Replies
6
Views
206
RBW
R
P
Sumproduct excluding duplicates with added condition??
  • Peta
Replies
7
Views
384
Peta
P
G
Hiding Rows
  • Graham Moore
Replies
5
Views
137
JBeaucaire
J
E
database query
  • Excel sheet password
Replies
1
Views
209
Billy Liddel
B
R
Hide #N/As with Cell Indexing/Matching
  • Rob
Replies
5
Views
456
Pete_UK
P
R
Formula: How do I create a "rolling" sum in excel?
  • Rhianne
Replies
7
Views
241
JBeaucaire
J
D
copy, paste and transpose formula's into work sheets
  • Derro
Replies
2
Views
341
Derro
D
N
Help with Solver
  • nikos_pap
Replies
0
Views
286
nikos_pap
N
M
margins do not fit the page error in a shared workbook
  • MsT4eva
Replies
0
Views
449
MsT4eva
M
J
Calendar, if paid on date, not count prior
  • Jake F
Replies
2
Views
313
Roger Govier
R
L
Chart Format issues
  • LiAD
Replies
0
Views
236
LiAD
L
J
Sumproduct with conditions - urgent help needed
  • JANA
Replies
3
Views
150
David Biddulph
D
E
Applying a | delimiter to separate a series of Zip codes
  • Ed
Replies
7
Views
203
Ed
E
D
Find specific value in array of array formula
  • DzednConfsd
Replies
2
Views
283
Suleman Peerzade
S
T
Compare value to range, return matched value
  • TKD
Replies
2
Views
389
TKD
T
S
Data Sort
  • Steven
Replies
1
Views
108
Debra Dalgleish
D
B
Sumif across Multiple sheets
  • beenlosteverywhere
Replies
2
Views
484
beenlosteverywhere
B
B
Select a variable range
  • Bluecat
Replies
7
Views
129
Bluecat
B
D
Link Cells
  • drnlds
Replies
5
Views
240
Pete_UK
P
S
Compare data in 2 workbooks and highlight differences in red
  • Sherry
Replies
4
Views
550
Gord Dibben
G
T
Pivot Table grouping fields by Dept
  • Terri B
Replies
1
Views
416
Debra Dalgleish
D
R
dealing with time
  • Rhydderch
Replies
5
Views
577
David Biddulph
D
Q
Which formula(s) should I use???
  • Questions from cold CT
Replies
9
Views
483
Questions from cold CT
Q
D
HELP! Search rule is case sensitive!!
  • Don
Replies
2
Views
330
David Biddulph
D
S
Count nonblank cells based on another column
  • SandyB
Replies
1
Views
541
Elkar
E
V
Linking spreadsheets and returning value to "0" if no info
  • vtrud
Replies
6
Views
167
vtrud
V
L
Copy Worksheet wont copy objects.
  • Lincoln De Kalb
Replies
7
Views
530
Lincoln De Kalb
L
H
Sumif??
  • Hope
Replies
9
Views
259
John
J
R
Auto Update worksheet references as new worksheets are added
  • Rick
Replies
1
Views
336
Gord Dibben
G
G
FORMULA ERRORS CAUSED BY SPACEBAR
  • Gator Girl
Replies
12
Views
467
Gator Girl
G
D
Countif using tab range
  • DEI
Replies
3
Views
259
Luke M
L
Z
If statement
  • Zack
Replies
1
Views
242
JBeaucaire
J
B
Unlocking Protected Cells
  • Biff
Replies
1
Views
273
Gord Dibben
G
Top