TheMSsForum.com: The Microsoft Software Forum
TheMSsForum.com
The MSS Forum
‹
Archive Home
‹
Excel Misc Archive
‹
Page 84
Archive
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
view full version:
back to formated view
29051:
Saving Excel "read only" files to RW-CD
29052:
Need Macro for concatenating multiple worksheet
29053:
Removing unwanted digits
29054:
DROPDOWN LIST AND CHECK BOX
29055:
Excel Solver / Math Problem
29056:
FORMATTING DATES IN FORMULAS
29057:
if A is x then B is y
29058:
select random value in a range of cells
29059:
return a negative value
29060:
How to make it so only specific words can be typed in a cell
29061:
V Lookup and word Table
29062:
How do I sum the lowest n numbers in an array with n variable?
29063:
Conditional locking of cells for individual rows
29064:
Highlight highest / lowest number in a row
29065:
Colours
29066:
Grouping records
29067:
Please Help!! Excel 2000
29068:
Counting occurances
29069:
Where can I get a work rota template for excel?
29070:
Showcase Query Login
29071:
Excel Page Footers
29072:
Setting a string variable as the file name
29073:
conditional formatting
29074:
file name :2
29075:
Importing from access to excel
29076:
print user ID on a document
29077:
Excel Axis Breaks
29078:
Data Missing from Excel Cell When Query through C#
29079:
pay slip
29080:
new wiki site proves to be helpfull
29081:
"Request for Information" Template
29082:
Template for Certified or Wage Decision Payrolls
29083:
Sending Pivot Table Only
29084:
Drop-Down List
29085:
File Error: Data may have been lost.
29086:
load a CSV file and have it take all fields as text
29087:
Sum Function
29088:
Display of Active Cell in MS Excel 2007
29089:
Enable Command Button base on UserName
29090:
Problem with Absolute reference
29091:
If Statements with Dates
29092:
Convert text "date" (DDMMMYY) to datetime value of YYYY-MM-DD - ho
29093:
Search range for text not in another range
29094:
Excel/Windows cannot find the file I clicked on to open it
29095:
Pivot Table Newbie
29096:
Table of Contents
29097:
using VLookup with two variables to get results
29098:
Auto Hide Columns when...
29099:
custom numbers
29100:
Need help in creating a Script for Users
29101:
SUMPRODUCT Formula quirky....
29102:
custom number format
29103:
using Excel 2003 protected sheets with older versions of Excel
29104:
plotting using macros
29105:
graphical indicator
29106:
Help...Code to copy sheet from closed workbook
29107:
Formula Question
29108:
Y-Axis question
29109:
Please help! pivot tables
29110:
View all entries in Validation List
29111:
grouping
29112:
"Do Not Show Again" option for message box
29113:
MS template
29114:
3 months planner
29115:
Measuring Average Changes
29116:
Printing gridlines half-tone
29117:
using hlookup with sum/choose?
29118:
Recovering an Excel File
29119:
Compare and Return Results
29120:
Scenarios
29121:
Import password protected data from web into excel
29122:
I would like a cell to show a + or - sign before number.
29123:
Could not find dll VBE6INTL.DLL on opening Excel 2007
29124:
iteration
29125:
AutoFilter and row count
29126:
How do I display a message when a cell has a certain value??
29127:
Store Active Workbook
29128:
sheet background color suddenly changed to light green from normal
29129:
can i delete cells dependant on the result from a formula
29130:
Formula and #VALUE
29131:
Optimzed View based on screen
29132:
Excel 2002 SP3: Update?
29133:
With a formula in a cell, what is the warning symbol for?
29134:
Link or Calculate?
29135:
Links to another workbook returning 0
29136:
Showing top ten and then "others" in a pivot table
29137:
"Live" Advanced Filter (for unique records)
29138:
how to format alarm in excel cell
29139:
Essbase for Excel Add-in Errors
29140:
Macro to paste worksheets in another workbook
29141:
Formula for calculating the last four weeks
29142:
Excel Temporary Files Location
29143:
Inserting Excel worksheets
29144:
Copy data to filtered column
29145:
Adding a note/comment
29146:
Data validation
29147:
Y Axis Auto updatem Max, Min and Scale
29148:
Problems with Auto Filter
29149:
automating months
29150:
ErlBTraffic function
29151:
how to extract numbers from imported cell with text and numbers?
29152:
Conditional List (auto filtered)
29153:
Count widgets between two dates - Excel 2003
29154:
suppress warning and locate cube in a pivot table from olap cube
29155:
Create pivot table from pivot table
29156:
PACKING ARRANGEMENTS
29157:
Finding Info from Column A and Removing it from Column B
29158:
Paging down through spreadsheet displaying data on full screen
29159:
Is there any way?
29160:
Hyperlinks
29161:
circular references
29162:
Making a worksheet default
29163:
Easy way to Hide & Show Rows and update associated macros
29164:
COUNTIF
29165:
Dorp-Down Formatting
29166:
how to get rid of #N/A when not use on vlookup
29167:
If date in column T is +7 then column C is Bold Red
29168:
Problem with Macro
29169:
Speadsheets only caluclates some formulas.
29170:
can I change the color of the "Comment Indicator" from red to ...
29171:
How do I find certain items in worksheet?
29172:
Find in Column A and Remove from Column B
29173:
running total and average of that total after 3 events
29174:
Changing attributes
29175:
Return 0 if result of formula is lower than 0.5
29176:
Seperating Text from Columns
29177:
right click on excel cell a tool bar comes up - how to eliminat
29178:
HLOOKUP, VLOOKUP, MATCH, INDEX - Help with the Right Solution!
29179:
How to look up a value?
29180:
Format a text cell for searching
29181:
Send worksheet by E-Mail
29182:
Selecting occupied cell over empty ones
29183:
Need Comparison Formula
29184:
Cell References/Names
29185:
AM / PM Cells
29186:
Freezing 2 columns at once
29187:
Drop-Downs - Display another value
29188:
Conditional merge
29189:
Constant calculations
29190:
Shifting rows into columns
29191:
VBA Code to Change the Tab Name
29192:
how best to handle longish text fields in excel?
29193:
Tabulating Multiple Surveys in Excel
29194:
datavalidation conditional list
29195:
Formula needed - is this possible?
29196:
Replacing Values in a Spreadsheet
29197:
Sorting
29198:
top rows of worksheet behind task bars
29199:
Calculate mode
29200:
Help with formula
29201:
Count If formula question
29202:
how do i sort formated (colour) field in excel?
29203:
borders in excel not printing in Excel 2007
29204:
Automatic Array updates
29205:
combine details on rows
29206:
subscript
29207:
Set the number of characters in a column
29208:
password protect a single sheet
29209:
Averaging a running total
29210:
Need VBA Code to Let User Define Active Sheet
29211:
sumif - looking to find text
29212:
How to Copy Field Values to Group Subtotals row
29213:
How to modify toolbar button in excel?
29214:
SUMIF when using a range with critera
29215:
Excel 2000 column question
29216:
Formula Bar
29217:
sorting by dates -- parameters?
29218:
Change font colour
29219:
Yes No
29220:
How to break apart a Decimal formatted number?
29221:
Combo Box
29222:
Restricted Worksheet
29223:
email as attachment
29224:
Data Validation
29225:
Run macro if cell value changes
29226:
Copying Spreadsheet with Cell References Into A Different Workbook
29227:
Check Boxes In Excel
29228:
Counting based on location & dates
29229:
restoring default fill colors, & saving with a custom color scheme
29230:
How do I ignore the "Number stored as text" error message permane.
29231:
Create Tabs
29232:
Subtracting Dates
29233:
Convert function to value
29234:
Freeze Panes in Excel 2007
29235:
Line chart with negative numbers - X-axis problem
29236:
documents very slow to open in excel 2007
29237:
Find in Column A and Remove from Column B
29238:
An incrementing serial number in each new document
29239:
I need help printing a long graph on more than one page...HELP!
29240:
Running a macro on cell value change
29241:
excell
29242:
index / lookup / match / text formula
29243:
How can I calculate the R and P values together
29244:
Default number format
29245:
Using a range name in formula
29246:
subtract from a cell if another cell is occupied
29247:
How to avoid sending write protected files via Outlook.
29248:
If - easy question
29249:
Pivot Table with Data Added Monthly
29250:
Match Columns Not Working - Formatting?
29251:
toolbar button to insert symbol
29252:
Excel Viewer causes problems saving shared spreadsheet
29253:
2007 Print Preview Changes Zoom
29254:
how do I create a checkbook register in excell
29255:
Countif with 2 criteria
29256:
averaging a running total
29257:
Seperating Text from Columns
29258:
Problem with Macro
29259:
Vertical Formula Bar
29260:
Copy formula in excel
29261:
Closing only one excel workbook
29262:
Calendar in Excel 2003
29263:
Open Excel ... Select WorkSheet
29264:
visual basic user form date format dd/mm/yy not mm/dd/yy
29265:
Add Totals for Last 12 Months
29266:
date formula
29267:
Excel 2007 to Web
29268:
Combine Cells without Concenate or &
29269:
How do I combine two speadsheets into one pivot table
29270:
Macro won't run
29271:
Setting up Popup-Task type reminders In Excell 2003.
29272:
Format a cell
29273:
Auto Filter Issues
29274:
Combine Cells
29275:
Does anyone know how to place a footer on just last page?
29276:
Copy an XCEL sheet?
29277:
How do I format cell for displaying value in lakhs ?
29278:
autofill issue
29279:
Attaching rows to one row when sorting
29280:
Enabling Visual Basic in Excel 2007
29281:
Search a Row and return Header Row Data
29282:
Excel 2007 slow to copy entire sheet
29283:
Using Count Function on Filtered List
29284:
Long time to open spreadsheet (running Excel 2007)
29285:
...I would like Cell A1 to be the same color as Cell X11...
29286:
How can I "Shift + Enter" text in Excel?
29287:
I lost my tabs
29288:
retrieve an old file erased by saving a new file with same name
29289:
Adding the cell if text is contained within
29290:
Adding data sequentially
29291:
Vlookup
29292:
Counting from list entries
29293:
text from column to a list
29294:
how do I make callto: work in excell 2003 with XP SP2
29295:
Protected Number
29296:
How to open Excel list in Word for mail merge/labels?
29297:
DropdownList/AutoFillUpList
29298:
associate a program to open a hyperlink?
29299:
Unable to access unprotected columns on a protected sheet....somet
29300:
worksheet references for a macro and VBA
29301:
Nested IF error
29302:
changing data entries
29303:
Opens file with a 1 on end
29304:
Multiple documents open, but only seeing one
29305:
Is there templates for nonprofit organizations for shelters
29306:
Help - Conditional Sum!!
29307:
HOW CAN I PREVENT DUPLICATE ENTRIES WITHIN A WORKBOOK, i.e. job #
29308:
Mailmerge data source in Excel with picture
29309:
Excel Charts
29310:
Erasing a Formula?
29311:
date formula
29312:
Naming Ranges for data exporting
29313:
Leading Zero with Function
29314:
See Results of Formula rather than the Formula Itself
29315:
Excel 2007 xlsx files open as Read-Only in Excel 2003 after Compat
29316:
return financial period if value between 2 dates
29317:
Scrolling excel page using down and up arrow
29318:
Calculate difference in Times
29319:
link excel cell to SQL database
29320:
How to prevent General format from using scientific notation?
29321:
VBA Script to Rename Tab Name to Whatever Name is in Cell A1
29322:
if / exact problem
29323:
Selected Outlook contacts to excel
29324:
Data Filter Keystrokes
29325:
Auomatically updatting formula when cell is not blank
29326:
Problem printing multiple worksheets
29327:
Finding Info from sheet 1 and removing only those rows from sheet
29328:
Want Excel to not print blank rows.
29329:
Start Cells with Specific Value
29330:
rounding
29331:
Automating Subtotal
29332:
Date Macro
29333:
Cell contents not recognised untill clicked
29334:
grid lines printing with blank cells
29335:
Sorting by color Excel 2007
29336:
Formula Problem
29337:
post data to create a chart
29338:
distributing an Excel custom button
29339:
Showing the permutations of 5 text columns in one column
29340:
Rounding errors when a "5" is the third decimal place using formul
29341:
List Box problems
29342:
Paste Worksheets in Another Workbook
29343:
How to change worksheet using keys?
29344:
Undue Cntrol+Z suddenly doesn't work..
29345:
Conditional Formatting - 2 conditions
29346:
Opening a file with User Input
29347:
Formula help: VLOOKUP in a combination...
29348:
Running formula before an empty column(cell)
29349:
Lookup Multiple Pieces of Data...
29350:
Co-ordinates
29351:
Saving a pre-determined range of cells as text?
29352:
I need to remove the row tip
29353:
Out of memory exception
29354:
Simple Excel VB problem
29355:
Fill Blank cells in a range
29356:
Theory on test equating and linking
29357:
Does Excel 2003 have CDF feature in its histogram plotting function?
29358:
Does plots have interpolations in Excel?
29359:
how to make Excel application GUI look better?
29360:
Need help converting MS Access to Excel
29361:
XL2007 vs XL203 speed
29362:
Posts not getting picked up
29363:
Sumif problem
29364:
Excel 2007: How do I disable the 'Do you wish to save changes to...' when I close an un changed file?
29365:
Excel Grouping and Hide
29366:
Index & Match - Black Cells
29367:
Email from Excel - help no spam - genuine business work
29368:
Using a single cell value to repopulate multiple cells
29369:
How do I stop totals showing from a copied formula?
29370:
importing csv files- entire record goes into each column
29371:
The opposite of the "sort" function
29372:
Salary data entry - circular reference a better way
29373:
Color Filling a Cell
29374:
print gridlines when using fill color
29375:
I need help!!!! Please help me someone!!?!?!
29376:
executing a function?
29377:
Copy filtered data
29378:
Military time...
29379:
Adjusting Macro
29380:
"Personal.xls" Page
29381:
sumproduct and IF criteria??
29382:
Averaging subtotals
29383:
Timed message box
29384:
(IF) formula help!
29385:
How to convert text 'Jun-30-2007' to date format?
29386:
VBA - error message "Code excecution has been interupted"
29387:
why i cant copy sheets in excel workbook
29388:
Find & Replace in Text Box
29389:
Sounds
29390:
Can Excel evaluate one cell and return the information in another?
29391:
Publish xls sheets for persons without MS Office/Excel
29392:
Date Functions
29393:
form serial number
29394:
Can excel calculate Mahalanobis distance?
29395:
Show gridlines or cell borders on top of a picture
29396:
Multiple People Accessing Same File
29397:
Retrieve data from Drop Down List
29398:
formula to check multiple conditions
29399:
Formula Help
29400:
wages - multiply hours and minutes by number of hours worked