Excel Worksheets

Post thread
S
Help with dynamic array lookup based on a single reference cell ..
  • SPStevo
Replies
2
Views
487
T. Valko
T
E
text to date format
  • EMREMEV
Replies
3
Views
174
EMREMEV
E
S
automatic page breaks at every cell
  • Staceyglow
Replies
0
Views
420
Staceyglow
S
R
Find all and Concatenate
  • Rob
Replies
1
Views
275
Otto Moehrbach
O
A
how do I look up a value and return more than one result?
  • amiller
Replies
2
Views
483
T. Valko
T
D
summing columns
  • drakey
Replies
5
Views
637
Brotherharry
B
R
How do I count nonblanks in column A when I filter by column B
  • RP3
Replies
5
Views
478
Pete_UK
P
T
equals merged cells
  • TGags
Replies
2
Views
404
David Biddulph
D
M
Extract a string from a cell
  • MrLarrier
Replies
3
Views
522
David Biddulph
D
P
COUNTA?
  • Paul
Replies
3
Views
187
Paul
P
M
Need help comparing data from different URL's.
  • marketingninja
Replies
2
Views
172
marketingninja
M
J
Can this be done?
  • james.b.ivey
Replies
6
Views
234
Pete_UK
P
R
Count Unique accross mulitple columns
  • Rob Drummond, Jr
Replies
7
Views
873
Rob Drummond, Jr
R
C
Divide by zero error
  • Chris
Replies
3
Views
558
Chris
C
B
using a conditional suffix in text function format syntax=text(value,format_text)
  • Brotherharry
Replies
1
Views
331
JE McGimpsey
J
D
Row extractor
  • datamanipulator
Replies
4
Views
209
datamanipulator
D
A
Custom format show < +/-500 as zero not blank
  • AnneM
Replies
2
Views
384
AnneM
A
R
Compare number to range; find highest positive difference
  • RBW
Replies
6
Views
229
RBW
R
P
Sumproduct excluding duplicates with added condition??
  • Peta
Replies
7
Views
407
Peta
P
G
Hiding Rows
  • Graham Moore
Replies
5
Views
157
JBeaucaire
J
E
database query
  • Excel sheet password
Replies
1
Views
223
Billy Liddel
B
R
Hide #N/As with Cell Indexing/Matching
  • Rob
Replies
5
Views
553
Pete_UK
P
R
Formula: How do I create a "rolling" sum in excel?
  • Rhianne
Replies
7
Views
263
JBeaucaire
J
D
copy, paste and transpose formula's into work sheets
  • Derro
Replies
2
Views
367
Derro
D
N
Help with Solver
  • nikos_pap
Replies
0
Views
309
nikos_pap
N
M
margins do not fit the page error in a shared workbook
  • MsT4eva
Replies
0
Views
467
MsT4eva
M
J
Calendar, if paid on date, not count prior
  • Jake F
Replies
2
Views
361
Roger Govier
R
L
Chart Format issues
  • LiAD
Replies
0
Views
251
LiAD
L
J
Sumproduct with conditions - urgent help needed
  • JANA
Replies
3
Views
174
David Biddulph
D
E
Applying a | delimiter to separate a series of Zip codes
  • Ed
Replies
7
Views
226
Ed
E
D
Find specific value in array of array formula
  • DzednConfsd
Replies
2
Views
298
Suleman Peerzade
S
T
Compare value to range, return matched value
  • TKD
Replies
2
Views
409
TKD
T
S
Data Sort
  • Steven
Replies
1
Views
125
Debra Dalgleish
D
B
Sumif across Multiple sheets
  • beenlosteverywhere
Replies
2
Views
544
beenlosteverywhere
B
B
Select a variable range
  • Bluecat
Replies
7
Views
154
Bluecat
B
D
Link Cells
  • drnlds
Replies
5
Views
263
Pete_UK
P
S
Compare data in 2 workbooks and highlight differences in red
  • Sherry
Replies
4
Views
613
Gord Dibben
G
T
Pivot Table grouping fields by Dept
  • Terri B
Replies
1
Views
484
Debra Dalgleish
D
R
dealing with time
  • Rhydderch
Replies
5
Views
650
David Biddulph
D
Q
Which formula(s) should I use???
  • Questions from cold CT
Replies
9
Views
518
Questions from cold CT
Q
D
HELP! Search rule is case sensitive!!
  • Don
Replies
2
Views
371
David Biddulph
D
S
Count nonblank cells based on another column
  • SandyB
Replies
1
Views
590
Elkar
E
V
Linking spreadsheets and returning value to "0" if no info
  • vtrud
Replies
6
Views
176
vtrud
V
L
Copy Worksheet wont copy objects.
  • Lincoln De Kalb
Replies
7
Views
559
Lincoln De Kalb
L
H
Sumif??
  • Hope
Replies
9
Views
281
John
J
R
Auto Update worksheet references as new worksheets are added
  • Rick
Replies
1
Views
366
Gord Dibben
G
G
FORMULA ERRORS CAUSED BY SPACEBAR
  • Gator Girl
Replies
12
Views
501
Gator Girl
G
D
Countif using tab range
  • DEI
Replies
3
Views
276
Luke M
L
Z
If statement
  • Zack
Replies
1
Views
265
JBeaucaire
J
B
Unlocking Protected Cells
  • Biff
Replies
1
Views
284
Gord Dibben
G
Top