TheMSsForum.com: The Microsoft Software Forum
TheMSsForum.com
The MSS Forum
‹
Archive Home
‹
Excel Misc Archive
‹
Page 20
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
6651:
Opening .csv-files in Excel
6652:
File name and path formula in Excel 2003
6653:
Highlighting Data Exceptions
6654:
summing time
6655:
Disable Esc-key - macro
6656:
Excel validation drop-down list view enlargement
6657:
Fault macro security warning
6658:
why result 77.1 * 850 shown 100000 in excel 2007?
6659:
Federal Tax Calculation
6660:
Conditional Formatting
6661:
Conditional format - blank vs. 0
6662:
MS Query to Access table errors "do not have necessary permissions
6663:
Negative Numbers in Brackets
6664:
Workbook_Open in ThisWorkbook.module
6665:
Data validation
6666:
sort by code
6667:
embedded documents in excel
6668:
Excel Printer
6669:
turn off excel cell modifications?
6670:
Excel cell to reference tab name
6671:
Want formula to turn to value by itself
6672:
Saved Files Not Opening Cross-Platform
6673:
Exporting event data with hyperlinks into calendar
6674:
Open Screens in full view
6675:
Help with calculating time
6676:
Need help converting .txt(notepad) file to Excel (2000)
6677:
.TMP files are corrupting my folders
6678:
Worksheet Design for Automation
6679:
counting duplicates
6680:
record macro "That name is not valid."
6681:
sums
6682:
personal.xlsb locked for editing when i open a 2nd excel window
6683:
VBA Loop Help
6684:
Random selection method
6685:
Between Two Numbers...
6686:
Cell Format - Date
6687:
How can I remove old items in a drilldown box in a pivot table?
6688:
Reading data arrays from multiple data files in excel
6689:
Repeat headers only when data existss
6690:
how so i convert a comma delimited file to an .xls file
6691:
Would this be an array or...?
6692:
How do I get the Page Setup to apply to all the worksheets?
6693:
how do i convert a comma delimited file to an .xls file
6694:
Need help importing links in automatically
6695:
Forcing to Uppercase
6696:
Entering Time
6697:
Need help with importing in a series of links automatically
6698:
cell in copied worksheet displays formula and not value
6699:
Error and Save as question
6700:
Pesky spaces
6701:
Cell View Whiting Out?
6702:
conditional formating with len
6703:
Is there a key combo to toggle between worksheets?
6704:
Editing Links
6705:
Word to Excel!
6706:
paste special as text to excel 2007 ( sp1 updated)
6707:
Importing data with Text Wizard
6708:
Chart graph from worksheet but need to exceed 256 columns
6709:
Delted file
6710:
shading data in rows
6711:
Pivot Table
6712:
Excel program remains open after closing file
6713:
Time Calculations
6714:
probably an easy question
6715:
I need help password protecting a worksheet
6716:
how do i enable macro in Excel and Access at the same time
6717:
Duplicate lists!!!
6718:
Looking for a Macro or other tool to create a Workbook Content Sheet
6719:
"if" statement help... please!!??
6720:
SUMPRODUCT can I use to get data from 2 worksheets in same wkBK
6721:
Lose custom toobar settings
6722:
Macros in excel
6723:
Convert table to single column
6724:
MS Office multiuser edition?
6725:
Security warning for no reason
6726:
Searching data within sheets
6727:
Encryption
6728:
Autofilter to filter out non-numeric rows
6729:
set print area
6730:
Table of Contents
6731:
Pivot with percentages
6732:
The last filled cell in a range
6733:
Counting non blanks with SUMPRODUCT?
6734:
Getting Duplicates
6735:
Boks to cross off
6736:
Scatter Plot with Trendline and equation
6737:
Import from Excel into database using jet in VB.net
6738:
Excel 2007 - Macro Not Available
6739:
Carriage Return By Replace() function
6740:
Sorting VBA problem
6741:
Schedule within a worksheet
6742:
Automate text import wizard in a protected sheet
6743:
MS Web Components
6744:
Data points
6745:
Countif Statement for 2 columns
6746:
Cell changes by itself
6747:
Trying to list tab/worksheet names in a summary worksheet
6748:
Expert Style Tips To Instantly Transform Your Figure
6749:
Highlighting Minimum value
6750:
MS Excel number question
6751:
Date and time differences revisited
6752:
Zeros at the first of the number
6753:
Need to use only 14 characters in cell
6754:
VB Debug Reset
6755:
Excel:Swap cell contents-including cell groups-betwen 2 locations
6756:
Wrong Frequency for Histograms
6757:
Formula to sum text and return number
6758:
Excel 2002
6759:
macro security settings
6760:
Excel Spreadsheet / Yahoo store
6761:
The multiple regression tool - linear or non-linear regression?
6762:
Automatic Drop-down of Dropdown list
6763:
How do I split a column?
6764:
LEN = 0; ISBLANK = FALSE
6765:
The mouse gives me a box saying 'what's this?' can I stop it?
6766:
file using pivot tables is too large
6767:
PasteSpecial Error 1004?
6768:
Pivot Table counting values
6769:
Patterns in graphic fills not available in Excel 07?
6770:
How eliminate repeating data?
6771:
IF Statement to input initials
6772:
Calendar Lookup
6773:
Difference betweeen Windows and Office Clipboards?
6774:
Permutation Builder
6775:
Password Removal
6776:
How do I combine two worksheets in EXCEL 2003
6777:
Locked property when pasting from a different session of Excel
6778:
Data Validation
6779:
Date Entry in 1 Cell with result populating for entire week in ano
6780:
Circular reference, Maximum number of formulas
6781:
Data Validation error
6782:
How May I create a form
6783:
How can you round a number to the nearest 900?
6784:
How do I round a number to the nearest 900?
6785:
Weighted Average Within Sort/Subtotal
6786:
CountIf using every other column
6787:
VBA
6788:
page break preview
6789:
conditional formatting of other suggestion
6790:
Average of a list with high and low ignored
6791:
Error message opening Excel file
6792:
conditional formatting
6793:
Get rid of small squares in column
6794:
What is the size constraint of the Excel 2007 solver?
6795:
Rewrite name in new format
6796:
Protect sheet with permissions?
6797:
Excel functions - need some guidance.
6798:
Finding errors or not.....
6799:
Excel 2003 - Drop Down list based on another cell value
6800:
Data Validation list dependent on contents of another cell
6801:
VB Macro and Excel 2003 to Excel 2000
6802:
Collapse Rows?
6803:
Removing Both Duplicates from a list
6804:
Sorting Data
6805:
Problem dragging formulas
6806:
How to make columns absolute
6807:
how to programmatically access excel services dialog in excel 2007
6808:
Printing selected area
6809:
can I make a tab in an excel document uneditable?
6810:
Working on Excel
6811:
Sorting rows into a row
6812:
Rounding numbers so that they are divisable by 3
6813:
MDI Confusion
6814:
wrapping text from a fomula
6815:
Multiple Rows Into One
6816:
Shading
6817:
Not enough room to enter dates
6818:
Fixed font formats
6819:
SORTING WITHOUT CHANGE IN FORMAT
6820:
Insert date in formula
6821:
Countif formula
6822:
Disable/Enable Macros Message box in Excel2007
6823:
how to delete a row index when row is blank
6824:
macro help
6825:
excel formula
6826:
Excessive Rows In 2007 to 2003
6827:
sumif problem
6828:
How to print Circled Invalid Data
6829:
Object does not exist.
6830:
Custom Tool Bars - Restoration or Saving
6831:
Count entries in a range that match a certain criteria within data
6832:
Excess rows/columns
6833:
Excel Formula
6834:
Select data to imput to macro
6835:
User Tracking
6836:
AUTO_OPEN
6837:
Select data to imput to macro
6838:
+ or - ?
6839:
Deleting all empty raws and columns.
6840:
Excel doesn't seem to save changes. Anyone ever had this happen?
6841:
Microsoft Excel has encountered a problem and needs to close......
6842:
How to create a "formulaire"
6843:
Pareto chart
6844:
A way to change information?
6845:
costing values
6846:
How can I perform calculations in Excel using time?
6847:
show apostrophe / single quote in cell
6848:
how to sort by last word in a cell?
6849:
How can I change the color that shows what I have selected
6850:
Forecast Formula help
6851:
Sum up values from a list to a second location.
6852:
Hlp w/Easy Formula
6853:
IF Formula to return monthly salaries
6854:
Compare last octet of IP address
6855:
Using IF statements with Hyperlink function?
6856:
Can 409 row height be exceeded?
6857:
SumIF(??) at Date and Item Change
6858:
If Statement - Date Calculations
6859:
If Statement - Date Calculations
6860:
Using "--" as an array formula shortcut / alternative
6861:
Formula
6862:
conditional formatting
6863:
View Problem Excel 2003
6864:
Simple Formula Question
6865:
XY Scatter Chart Updates
6866:
Formatting/Totalling Macro with varying rows of data
6867:
Copy Formula Question
6868:
SUMPRODUCT Can I use less than or equal to with this function
6869:
formula to calculate out of 3 cells choose highest number
6870:
combine column data
6871:
Highlight a max number
6872:
Count if - 2 conditions
6873:
Attaching a document to a cell - Is this possible?
6874:
Format Pivot Table
6875:
Hyperlink
6876:
conditional formatting in 07
6877:
Merge three fields into one
6878:
Combining Colums
6879:
How to pull all values instead of first value
6880:
Transfer data from one file to another
6881:
can you lock a list button in an excel spreadsheet?
6882:
Make my figures divisable by 3
6883:
word addresses
6884:
Viewing the worksheets
6885:
Slow opening files
6886:
workbook links
6887:
How to make an absolute reference to an excel 2007 table column
6888:
data Validation Dependent List Error
6889:
Can't uncheck boxes in Pivot Table dropdowns
6890:
How do I find a duplicate entry on an Excel spreadsheet?
6891:
Hyperlink - New Tab vs New Window
6892:
How to make row height and column width equal
6893:
Timeseries Trend Equations--Units?
6894:
Conditional sums - counting unique
6895:
colors
6896:
Linear regression weighting 1/x
6897:
dates
6898:
Wrap text
6899:
Custom Number Formats
6900:
Template Help
6901:
How a cell can be addressed with variable file-column?
6902:
Date Menace
6903:
How to count the number of months between 2 periods?
6904:
PDFMaker and Compile Errors
6905:
Print preview in Excel 2003 locks computer
6906:
run-time error 13: Type mismatch?
6907:
formula
6908:
Dangerous fillcolor change, saving 2007 to 97-2003
6909:
Worksheet Protection & Comments/Colours
6910:
How can i add multiple links within a workbook?
6911:
Word Wrap and extending cell/row/column size
6912:
excel 2002 to excel 2007
6913:
sumif
6914:
Value in the last cell of a moving column
6915:
Lists and restricting inputs to cells
6916:
Conditional Formatting
6917:
server based spreadsheet
6918:
Seperating Workbooks So I Can View Side by side
6919:
"IF" question
6920:
Adjusting comment box size by Macro
6921:
Making Cells so no one can edit
6922:
Cloudmark
6923:
Multiplying one cell by a column
6924:
Source Data Inaccurate on Chart
6925:
ISNUMBER QUESTION
6926:
formatting MAC Addresses
6927:
Validation List/Formula Question
6928:
Changing Font color based on font type or size
6929:
Literal quotation marks retained from a formula
6930:
Installed Addin file opens when it shouldn't
6931:
Merging multiple workbooks with crosslinked formulas into single f
6932:
Increasing all values in spreadsheet by same percentage.
6933:
Sumproduct question
6934:
Date Formats in Text Box
6935:
How can we create a watermark that shows when copied?
6936:
Jumping Scroll
6937:
IF Statement question
6938:
Upper or Lower case
6939:
Transpose several columns to one long column
6940:
Copy to Clipboard - Distinct List
6941:
Indenting Disabled when Sheet is Protected
6942:
calculating due dates and february differences
6943:
Link to MS-Access Query
6944:
Excel '03 opening with Office '07
6945:
Random Number Selection
6946:
Print layout
6947:
Command button to move completed action item
6948:
Is there a formula that returns the number at the bottom of a list
6949:
Very slow reaction time
6950:
I am unable to insert, move, copy a worksheet
6951:
Having some difficulty with summing cells
6952:
Additional info withthe POP up Calendar.
6953:
how to use wild card in if funtion
6954:
2007 Assigning Range Names in one spreadsheet/worksheet
6955:
Excel Formula
6956:
closing a 2007 worksheet
6957:
Dialog Boxes
6958:
Excel-AutoCad compatibility
6959:
Formula
6960:
VACCRUED VACATION / DISPLAYED
6961:
Simple Logical problem
6962:
CountBlank with a reset?
6963:
Rounding error is conditional on brackets
6964:
Converting weeks to periods
6965:
Automatically updating data between worksheets.
6966:
Excel - Want to sort by formula value without losing formula
6967:
Excel 2007 Enable Macro Prompt
6968:
Creating a calculated field in a Pivot Table
6969:
Sorting by line when multiple lines correspond to it?
6970:
Error on Refresh Data Import from Access
6971:
Another Question!!
6972:
Lists
6973:
Decimals?
6974:
Taskbar display order
6975:
Can I change default check boxes on protect sheet?
6976:
filtering
6977:
Headings
6978:
Careful mergin of data
6979:
Conditional Formatting Basics
6980:
Excel 2003 being backward compatible
6981:
How do I get Random pairings in Excel?
6982:
Create account with regular income - How?
6983:
Re-usable form
6984:
Sales Pipeline
6985:
Highlight a cell within a percentage range only?
6986:
calculating multiple scenarios
6987:
Filter for Unique Values not working
6988:
Adding pick calendars to cells
6989:
Paste Special - Formulas - Multiply
6990:
Saving a Worksheet
6991:
matching data from 3 different sources
6992:
how can I automatically add following dates in a column in Excel
6993:
Setting up an Out of Office reply in another user's Outlook
6994:
How can I edit a protected cell to enter a value manually and then
6995:
Look up values in multiple cells and sum
6996:
Specific IF statement problem
6997:
+/- in sheet2 based on conditions and dynamic rows in sheet1
6998:
% of fixed sum in pivot table
6999:
How do I enable a disabled or damaged Excel program?
7000:
Table formatting - First 3 columns