TheMSsForum.com: The Microsoft Software Forum
TheMSsForum.com
The MSS Forum
‹
Archive Home
‹
Excel Misc Archive
‹
Page 14
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
4551:
SAVE AS: Webpage
4552:
Another conditional formatting question.
4553:
Evaluating a start and an end date
4554:
customer style across sheets
4555:
custom format
4556:
lookup/match/index help
4557:
Annual leave
4558:
style button
4559:
Future Value
4560:
Empty content after a calculation
4561:
SUMIF for Text
4562:
Calculate date difference exclude Wkend
4563:
Count Numeric Value with condition
4564:
Aging Report
4565:
Using Application.FileDialog(msoFileDialogFolderPicker)
4566:
How to do it in excel?
4567:
Autosum function not working
4568:
Save as PDF 2007
4569:
Deleting the ' character
4570:
Mulipule Columns & VBA
4571:
How to create a Read Only + No one can save
4572:
Date time difference
4573:
how do I sort excel 03 sheet by date order?
4574:
How do I exclude a detail measure value and only view Grand Total
4575:
Multiple users with Excel workbook
4576:
Formula Help - Not sure which one I need! SUMIF I think?!
4577:
Inserting metal values using data validation
4578:
User wise hide column
4579:
Conditional
4580:
counting coloured fields
4581:
Dependant Lists (Data Validation)
4582:
counting age groups
4583:
Format cells
4584:
How to determine the value?
4585:
LOST IN A CELL???
4586:
Combo Box Forms vs Active X
4587:
Help with formula
4588:
Estabelecendo um contador
4589:
Grand Totals
4590:
Merged Cells when copying a table from Word to Excel
4591:
send hyperlink image with excel file
4592:
Send file as attachment
4593:
how to setup a excel sheet to be protect after save and close file
4594:
F2 stops mouse scrolling
4595:
Using Excel as a database and textfield
4596:
Protect sheets in one go
4597:
Goal Seek
4598:
reomove blanks in list
4599:
Move or copy
4600:
How do I populate a cell with data from a cell in another workshe.
4601:
Chart Help
4602:
Vlookup if #N/A then enter enter data in cell I4
4603:
Display Home Toolbar Permanently
4604:
Linking sheets in a
4605:
How can i limit the # of rows printed per page?
4606:
Recovering work
4607:
Need help
4608:
Moving Between Specific Cells
4609:
vlookup with indirect function
4610:
Linking Check Boxes
4611:
How do i turn the merge cell option back on?
4612:
Excel 2007 Crashes when using outline/grouping
4613:
Merged Cells
4614:
Stock Quotes #VALUE for some entires on update
4615:
sum(if...) help needed!
4616:
Autofilter by month & year when I have a column full of dates ??
4617:
need help???
4618:
Use of Combined IF and AND statements
4619:
how do you do the abrivation of navada
4620:
#VALUE! from Function()
4621:
2003 Excel
4622:
How do I change default vertical text alignment in Excel 2003?
4623:
Document contains macros message
4624:
Excel Spreadshhet will not close, runs in the background
4625:
some missing gridlines
4626:
subtotal label
4627:
transfering data from one sheet to another(merging)
4628:
Calculating the mode of a criteria-based range
4629:
Active cell with a "crosshair" indicator ?
4630:
Scrolling slow jerky not smooth anymore....
4631:
Sort all cells except one?
4632:
If formula
4633:
Update Links in Excel 2003
4634:
PPT to EXCEL: Calculating numbers in a table...
4635:
what is compatibility mode and how do you get it off
4636:
Is the object linked, or embedded?
4637:
change change cell reference to Absolute reference
4638:
Line/Bar combo chart: issues
4639:
Finding replicate data accidentally entered into a worksheet
4640:
Pulling data from a Web based program
4641:
Using wildcards in criteria for sumifs functions
4642:
TWO ACCOUNT MATCH
4643:
error message handling #N/A
4644:
Hyperlinks quit working
4645:
Picture problems in custom header
4646:
How to Make '1' appear as '01'
4647:
How to return mulitple values based on the contents of another cel
4648:
DATA VALIDATION LISTING UNIQUES
4649:
Get part of text in a Cell
4650:
How do I set up sequential numbers (for a reciept) inExcel
4651:
Make a report with more lines that you can see on the screen
4652:
Graph Question
4653:
row counter tool for excel 2003
4654:
If Formula Question
4655:
Opening files from HTTP - authenticated session
4656:
How do I use a formula result in another formula
4657:
Calendar pop-up on a date field??
4658:
COMPATIBILITY
4659:
hello!
4660:
F2 Key not working in Excel 2007
4661:
Formula Expansion
4662:
Time function
4663:
IF statement
4664:
Counting characters in Excel
4665:
Missing information in autofilter drop down Excel 97
4666:
CSV file
4667:
Various Interpolation types in Excel
4668:
VLOOKUP always returning the same value!
4669:
How to enter a name in one cell, and have it return their sales $.
4670:
Execl Toolbars update
4671:
Filter External Data
4672:
HELP HELP HELP Deadline coming. Linking Worksheets
4673:
percentage question
4674:
Copying Hyperlink to a Cell with Text
4675:
data validation error alert does not work
4676:
Conditional formatting Help!
4677:
Sum Function
4678:
creaet a graph from the hours of a time field
4679:
toggle total row
4680:
Export excel to txt with specified column placement
4681:
How can I formulate a reconciliation?
4682:
Bar of Pie Chart - 2nd Series
4683:
Transpose not working rows to columns
4684:
DVD List template
4685:
pivot tables -how do I show a percentage if I only have figures
4686:
I'm trying to time series Excel data, how?
4687:
Workbook with macro unvisable in VBE
4688:
Web Query for Large Spreadsheet
4689:
Send a letter via e-mail merge to several people?
4690:
stock broker stmt to excel
4691:
Subtracting Time
4692:
Transferring Data from 1 table to another
4693:
hyperlink error
4694:
Split Data in One Column Into Two
4695:
Pivoting Several Sheets
4696:
How do I show the query name in the worksheet over the data cells
4697:
Locking Formula - Whole Column
4698:
How to permanently activate Macros?
4699:
Force iteration in workbook
4700:
ATTRIBUTES
4701:
Hide column header or first field in a list
4702:
returning values from an unsorted list.
4703:
Transposing data from consecutive rows into non-consecutive rows
4704:
Help make a macro variable
4705:
Macro
4706:
How do I get a number return for each cell keystroke in Excel?
4707:
Conditional Formulas
4708:
count cf cells displaying condition 3
4709:
Creating a master spreadsheet
4710:
Cannot get date format I want
4711:
collecting data from multiple sheets
4712:
Rows to Columns
4713:
Calculate birth date from age
4714:
Links
4715:
Adding different value error bars to each column of the SAME serie
4716:
Automating deleting rows
4717:
Selecting shapes with unknown names
4718:
When I enter 14 the cell shows 20
4719:
counting multiple criteria in one column
4720:
Urgently help needed - dropdown box does not show up
4721:
Validating Values Within Sets of Groups in a Column
4722:
#VALUE!
4723:
SUMPRODUCT returns #VALUE error
4724:
xls to mysql
4725:
Protect a Formula
4726:
#VALUE! Error/conditional counting
4727:
Conditional formatting on a function
4728:
EXCEL 2007 SEND AS ATTACHMENT BUT RECIPIENT ONLY RECEIVES ATTACHME
4729:
XP V Vista
4730:
partial sum of a column, according to another column value...
4731:
Random Column
4732:
Charts that printed fine in 2003 don't print right in 2007?
4733:
Dynamically updating sheet upon data Refresh All?
4734:
Tabbing through to check boxes?
4735:
Protection
4736:
Excel formula result 0
4737:
Timesheet Overtime Calulations - Excel 2002
4738:
Excell 2003 format cells
4739:
RTF to XLS format converter
4740:
How do I disable save prompt when exiting a sheet?
4741:
need help with merging 2 sheets
4742:
excel database?
4743:
Forms Checkbox & Protection - Excel 2003
4744:
How do you export excel data to a PDA, Palm device ?
4745:
sharing auto-correction in two different machines
4746:
excel 2002
4747:
How do I view animation on excel spreadsheet
4748:
In Excel 2007 how do I customize a button on toolbar
4749:
Which cell did my formula find?
4750:
how do I write a request to 'Save As' Macro
4751:
remove advanced filter on a spreadsheet
4752:
Formula Cells
4753:
Excel - what happened to Web/Refresh?
4754:
How to Keep my Format ??
4755:
columns to rows flip
4756:
Time with entering data in the corresponding cell
4757:
keep cells together
4758:
Loop through userform
4759:
Referencing an Excel Name from a different Workbook
4760:
Referencing an Excel Name from a different Workbook
4761:
Application.Volatile Not Working Timely
4762:
excel
4763:
Custom Text Box In A Form For Selecting A Range!
4764:
row counter tool for excel 2003
4765:
Question on Formula Audit function
4766:
Urgent
4767:
Macro driven record locator.
4768:
Formula needed
4769:
CHANGING FONT IN CHECK BOX
4770:
selecting multiple cells in Excel 2007
4771:
How can i copy the values derived from find and replace?
4772:
ARRRGGH - need help with a formula
4773:
how do you calculate an age-specific mortality rate?
4774:
button for style
4775:
cell style across all sheets
4776:
custom formatting
4777:
finding a formula to help with dates.
4778:
Simple input/display question
4779:
Sound with excel
4780:
How do i set up a 3d reference where one cell reference is dynamic
4781:
One particular worksheet always automatically opens when opening E
4782:
locking a sheet
4783:
Cannot open excel file directly
4784:
drop-down listbox disappeared
4785:
HOW DO I MULTIPLY BY A VALUE NOT MORE THAN A CERTAIN NUMBER
4786:
{h}:mm to display x hours and x minutes
4787:
Exporting Data from Oracle 11i to XL 2007 (TSV)
4788:
Tracking accrued sick time with excel
4789:
Disable copying of cells
4790:
VLOOKUP help?
4791:
Find Max of Summed Values
4792:
Data Table Help
4793:
how do i turn cells into rows using excell. thanks
4794:
data validations - drop list boxes
4795:
display a conditional format in a range from another column
4796:
can I import a nexus database in excel? how?
4797:
Losing Excel Personal settings
4798:
turning a worksheet inside out
4799:
highlight cell contain the value and text with formula
4800:
i cant use my mouse to scroll through my excel workbook
4801:
Validation and comboboxes
4802:
AutoComplete vs. Section Headers
4803:
HELP - the file links cannot be updated!
4804:
table on excel sheet
4805:
Generating a cell reference within a formula
4806:
need the excel formula to find 4% of 449.95
4807:
how do I plot a logistic curve
4808:
test a range of dollar amounts to assign a commission value
4809:
Split transactions in excel budget/register
4810:
I am unable to copy a worksheet
4811:
The last two entries in a range won't sort
4812:
Macro to repeat 2 contiguous rows to top of each page
4813:
Consolidate data to summary sheet
4814:
macro to repeat non contiguous rows at top in Print
4815:
Copy row on 2+ w'ksheets and paste to successive rows on new w/sh
4816:
how 2 merge 2 tables (worksheets)
4817:
Edit Data Validation 2003
4818:
how do i plot a logistic curve?
4819:
Pivottable: Show value as a percent of Subtotal
4820:
Document reference numbers in excel....How !!??
4821:
Macro for copy and paste values
4822:
Workbook size
4823:
Format question
4824:
Expanding/Collapse pivot table rows from Analysis Server cube
4825:
Sales tax VAT
4826:
Worksheet reference in validation
4827:
highlighting highest value cells
4828:
How to convert german format numbers to british format
4829:
Sum "Fomula Values"
4830:
in-cell comment
4831:
cannot access autocorrect options in Excel 2007
4832:
Text or numbers to hh:mm
4833:
outlook appointment labels colour from excel
4834:
more condition
4835:
word frequency counting
4836:
More condition
4837:
Down arrow jumps cursor to end of cell text
4838:
"Locked for Editing" error on a non-protected file
4839:
need some help with pivot
4840:
AutoFilter Tabs
4841:
Date Conversion
4842:
printing on 1 piece of paper
4843:
Excel 2007 Scroll Bars
4844:
What does this mean - =Sum-($C$22:E22)
4845:
How does one select multiple drawn objects in Excel 2007?
4846:
Pivot table value (field settings)
4847:
Count/sumproduct
4848:
OLE Objects
4849:
Formulas referencing different sheets in workbook
4850:
2003 formulas crash 2007
4851:
Sheets Names in Formulas
4852:
trouble opening excel documents
4853:
Sorting odd numbers
4854:
Can I conditionally format a line based on a cell value
4855:
how do i set up date alarms/alerts
4856:
Change the sort order of the filter
4857:
random sampling
4858:
formula to consecutively number the same cell in different wokshee
4859:
visual basic compile error in excel 2003
4860:
buttons on graphs?
4861:
REAL TIME CLOCK
4862:
Time-calculation question
4863:
open xml file in Excel
4864:
Completely removing security message about macros from spreadsheet
4865:
Pivot Table- Show Data % of
4866:
Excel "Windows in Taskbar" check box
4867:
Remove duplicate "new window"
4868:
Green flag in cell
4869:
control box
4870:
Date & Time Format
4871:
e-mail one worksheet as an attachment
4872:
VLookup help
4873:
Is there a way to disable a macro based on the value of a cell?
4874:
Copy in Excel 2003 Paste in Word 2003
4875:
Copy column in Excel and paste horizontally in Word.
4876:
Sort Data
4877:
Change . to represent :
4878:
Data Forms
4879:
Data Validation Input Message Box Position Frozen
4880:
Retun greatest # of cells between nonzero
4881:
Password Protecting a worksheet
4882:
Conditional formatting on a function
4883:
save as macro
4884:
in excel how do you total 1 cell on 25 different tabs?
4885:
cannot paste in Excel or word.
4886:
Error Message
4887:
Countif
4888:
Excel Open Blank Sheet
4889:
How to determine the optimized correlation between 2 sets of data?
4890:
Tab color problem
4891:
Using Unique Values in as a combobox value list
4892:
Delete spaces
4893:
Looping through 2 workbooks
4894:
Select Option button unhide row
4895:
Excel 2002: Can I compare 4 cells at one time ?
4896:
Automatically expand cells to match the data contained
4897:
White Alice Communications System
4898:
Can I change the cell highlighting colour?
4899:
Track Changes in Excell
4900:
Copy and paste - filtered data