TheMSsForum.com: The Microsoft Software Forum
TheMSsForum.com
The MSS Forum
‹
Archive Home
‹
Worksheet Archive
‹
Page 10
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
view full version:
back to formated view
3151:
How to add (sum) a row cells with letter(s) aside or without numbe
3152:
Monday Following
3153:
Auto run macro
3154:
How to count number of characters in xl cell for publisher merge
3155:
formula to find "missing" data
3156:
Is a cell a formula or value?
3157:
Create a conditional formula that results in another calculation
3158:
How can excel generate every unique pair from a set of numbers?
3159:
Formatting xl cells
3160:
How to retain last number in a cell
3161:
Subtotal Formula
3162:
How can I change an #N/A error to display other text?
3163:
Index Match 2 columns 1 row
3164:
how do I place an image (jpeg) onto an Excel worksheet?
3165:
How do I use NOW so that each cell displays a different time?
3166:
Problem with Self signed Certificate
3167:
define cell
3168:
Pivot table
3169:
round up (ends with...)
3170:
How to expand Index/Match formula
3171:
Add-In Program
3172:
Drop down list
3173:
Protecting Code in Visual Basic Editor (Excel 2003)
3174:
Look up a value from a row after verifying two other values
3175:
Change formula based upon value of a different cell
3176:
function result losing leading zeros
3177:
Counting Formula
3178:
Date to Pre Fill
3179:
How do I copy numeric section of cell from alpha-numeric cell
3180:
Can anyone help - I am sure there is a easy way to do this
3181:
Formula problem with decimal
3182:
Save a cells selection as a set, group, or block
3183:
Formula not working and I am extremely confused
3184:
Count but with conditions
3185:
visible rowindex
3186:
Excel Automatic Date Insert
3187:
How do I copy exact page counts in Excel?
3188:
Counting Multiple Addresses
3189:
EXCEL 2000
3190:
Format of cells for VLOOKUP
3191:
Formatting cells
3192:
count instance
3193:
SUMIF where CRITERIA is looking for a string occurence in the value,
3194:
Macro - Whats wrong?
3195:
Optimize a sumproduct function (or find another solution)
3196:
how if and vlook up is used
3197:
Formula constants?
3198:
Looking up multiple values and returning one corresponding value
3199:
Using excel as a database
3200:
Group a set of 'time'
3201:
Vlookup/match?
3202:
Match and Index for Tables
3203:
Make a cell display the contents of a shape
3204:
Lookup_returning any value..
3205:
Need help with Excel Formula
3206:
problem solver question
3207:
2003 macro generates compiler error on 2007
3208:
returning multiple cell values from a vlookup
3209:
IF
3210:
Formatting Time
3211:
IF + IF?
3212:
Lookup based on two variables and return a third
3213:
too many cell formats
3214:
Excel check box making list
3215:
using a formula to create an ordered purchase order
3216:
Working an If formula
3217:
Validation on cell
3218:
Calendar List to Calendar format
3219:
similar names - two spreadsheets
3220:
updating cell data and keep from overwriting
3221:
Choose 2 of 6 optional units for grade - formula question
3222:
vlookup returning zeros
3223:
Conditional Page Break
3224:
if formula - multi criteria
3225:
Add cell "50+55+50+50" to give answer 205
3226:
Cumulative labor calculation
3227:
splitting and formating a number series into date/time
3228:
hyperlink to other sw(exe) and open with parameters
3229:
How do you rename table headers in a query using Offic 07?
3230:
How to restrict user to input only one of multiple cells
3231:
Calculate hours worked minus a half hour for lunch
3232:
Hyperlink Relative Reference
3233:
Complex SUMPRODUCT/VLOOKUP/SUMIF
3234:
Need blank if no values in range getting value at the mo'
3235:
Keep all cells in a column unique? No cells identical
3236:
IF question
3237:
sumif maybe?
3238:
how to find out if a row is hidden
3239:
NEED INFO to the left of rqd cell
3240:
Lookup_finding all the corresponding cell...
3241:
fromula to get data from multiple sheets
3242:
URGENT! how count how often a vlaue occurs within a range of value
3243:
Creating pivot table to Existing worksheet
3244:
Excel
3245:
Percentage formula needed
3246:
Validation List 27.08.08
3247:
Sumif function?
3248:
What are the COUNT or other options ...
3249:
Max function
3250:
Non-Array Play to Eliminate Blank Cells
3251:
Finding last cell with a value and then adding to another
3252:
how do I apply formatting from one worksheet to a whole workbook?
3253:
Seperating hyperlink address from viewable text
3254:
Concatenate a VLOOKUP
3255:
Worksheet calculation different from calculator's
3256:
SUMIFS including hidden rows
3257:
Convert to Binary and Break out results
3258:
Searching A List
3259:
what formula can i use to find a specific value?
3260:
Consolidating a Matching List
3261:
Just a bad day in Excel
3262:
Calling Bernie Deitrick
3263:
how do i do interest roll up calculation in excel
3264:
Calendar resizes when workbook is closed
3265:
IF and Then Formula Help Needed Please
3266:
Copying Named Range
3267:
Multiple IF Formula Question
3268:
Reference a number from one cell in the text of another cell?
3269:
Macro - How to not copy blank criteria?
3270:
Finding a calculated Value across Columns
3271:
nesting sumproduct with subtotal
3272:
LOOKUP/IF Formula Help!!
3273:
Hyperlink link_location error
3274:
Look up, not down
3275:
Formula Help
3276:
find max..
3277:
Finding lowest price
3278:
Creating a Calculated Field From a Running Total Field
3279:
Curious Phenomenon...Vlookup not matching
3280:
Keep data in fields if no update while updating
3281:
Simple IF , maybe, for names in columns
3282:
Active Cell Color
3283:
Find the last number entered
3284:
countaif
3285:
soma gebraica
3286:
Row Protection
3287:
Lookup question
3288:
HLOOKUP
3289:
Count the number of times specific text appears in a column
3290:
How do I set a static date?
3291:
Average
3292:
if statements returning dates
3293:
Time in Excel
3294:
How to extract capitalized group in text string
3295:
Forumla that Looks up a range of output from one cell
3296:
vlookups and if statement
3297:
Pivot Table Format
3298:
Multiple "IF"'s
3299:
Pivot Table Design
3300:
How do I compute effective yield in Excel when there is a balloon
3301:
Sorting information
3302:
Using CTRL to select cells for a formula
3303:
Referencing another worksheet
3304:
RANDBETWEEN
3305:
please advise the solution
3306:
Beginning of Year
3307:
Copy a formula to the right increasing the rows from another works
3308:
Drop Down List
3309:
Need ideas on which formula(s) to use in this situation
3310:
Moving / Emailing Macro Workbooks with Custom Toolbars
3311:
Ignore NA in a formula when I type it in a cell
3312:
Ignore blanks in multiplication formula
3313:
Count range of data
3314:
Stock quotes in Excel
3315:
Need to rename table columns in excel from a query
3316:
returning a text value using a formula
3317:
Import External Data by Date
3318:
Column reference in Vlookup formula
3319:
cell fill
3320:
single entry across multible sheets in workbook
3321:
Protecting Functions within a cell
3322:
Call Center Talk Times
3323:
Wouldn't know what to call it!
3324:
Fill in a formula within a worksheet
3325:
Save Prompts
3326:
What does "Cannot empty the clipboard" mean?
3327:
Return top ten amounts
3328:
Counting cells with multiple criteria
3329:
Calculating Sortino Ration (Downside Deviation)
3330:
SUMPRODUCT Function Compare Date
3331:
Prevent data from typing in another cell in a saved template?
3332:
Take part data from two fields and auto fill into 3rd field
3333:
Selecting data by date differences
3334:
i want to create an IF formula to bring back one of four results .
3335:
Indirect
3336:
Restricted Access
3337:
How do I use lookup for this case ?
3338:
Using the IF Command
3339:
Dealing with column headers
3340:
Creating a Questinaire with filtered responses
3341:
Fill a word form clicking on an excel cell
3342:
Using values from macro to userform
3343:
How do I stop "global" hyperlinks changing to "local" links?
3344:
Split text to compare
3345:
Creating checkable boxes w/o the check box forms tool
3346:
Row header
3347:
COUNT IF
3348:
Lookup question
3349:
NETWORKDAY + Excel 2007 + Excel 2003
3350:
duration
3351:
Help with IF function
3352:
Rows to Columns
3353:
Dividing a list into thirds
3354:
How to Create % cell and apply changes to worksheet
3355:
How do i create formula in words from amounts
3356:
trying to create a way to link summary page to subsequent workshee
3357:
Can't figure out a formula
3358:
Conditional Formatting for an entire row or column?
3359:
Rest of the Year Calculation
3360:
Indirect(NamedRange) inside Sumproduct
3361:
Subtract 30 minutes from Formula
3362:
Changing Multiple Formulas
3363:
How to change a date from 19990812 to 08-12-1999?
3364:
Modify a Formula
3365:
Excel Formula using colors
3366:
link from other source file is not working
3367:
Uploading ASCI
3368:
Can you subtotal data in rows?
3369:
Sumproduct/SumIf
3370:
Sorting columns alphabetically
3371:
IF Formula Help Please
3372:
array formula
3373:
How do I link with certain aspects?
3374:
HOW PUT WORD-ART IN THE BACKGROUND AND WRITE OVER IT
3375:
Wrong result from formula - please evaluate
3376:
Workbook will not update after pasting data
3377:
What is the formula for compounding interest with annual additions
3378:
Compare column in 2 documents
3379:
Un protect sheet
3380:
Vlookup question
3381:
Rank Tie
3382:
Start, Finish including break time
3383:
When inserting column I get "cannot shift object off sheet"
3384:
Automatically Entering Values
3385:
Sum
3386:
Help with changing a formula
3387:
formula help
3388:
Adding results from a If formula-Short in time
3389:
auto step sum
3390:
Using If then to change cell colors in Excel 2007
3391:
Need a formula to cut rows from a validation list
3392:
Sorting data in columns
3393:
Multiple criteria
3394:
Autofill link to another sheet
3395:
how can I disable "cutting cells" and "drag and drop "in excel ?
3396:
Sorted Data
3397:
Excluding Repeating Numbers Help!1
3398:
Autofill Question
3399:
Search for tabs from a cell value
3400:
Worksheet Functions
3401:
CountIF or Sum IF Questin
3402:
avoid nested IFs with another function
3403:
Comparing/Matching two columns
3404:
vlookup doesn't work
3405:
Locking worksheet labels and box sizes
3406:
sum cells
3407:
a formula to search for names in columns and then add the figures
3408:
excel 2007 pivot table wizard
3409:
Repeating Asterisk
3410:
Asterisk
3411:
vlookup not working
3412:
Is there a time zone conversion function in Excel?
3413:
Multiple Worksheet reference in a formula
3414:
find a correspond betwen the same words in two sheets diferents
3415:
creating a popup answer for an average range of cells
3416:
Date if before or after 15th of month
3417:
comment
3418:
Protection of single cell
3419:
Scroll bar not responding
3420:
Validate a total of a row
3421:
predetermined answer in next cell
3422:
Average Time - With a Twist
3423:
SUMPRODUCT or COUNTIF
3424:
If, then Formulas
3425:
Excel/Web
3426:
create a formula based on cell color
3427:
replace always opens a window
3428:
Pop up menus in cells fed by lists in another workbook
3429:
Averaging Time
3430:
Averaging Time
3431:
Moving to a new sheet.
3432:
add multiple returns using vlookup
3433:
Format issue to linked cells
3434:
Calculating the Median Price Sold
3435:
Making a new master comment
3436:
Averaging Time
3437:
Function to take today's date less someone's b-day to get their ag
3438:
Averaging Time
3439:
how do i get columns in Excell to auto-adjust
3440:
I am new to pivot tables..
3441:
confining workspace to a limited number of columns
3442:
Color of tracked changes
3443:
SUMIFs for particular cells in blocks of data
3444:
Returning Data to an empty Cell
3445:
Sumif with Conditionale formatting of a cell
3446:
Custom Formatting
3447:
Find the First of the Month after 60 days
3448:
More Help
3449:
Macro - Next blank row
3450:
scroll bars
3451:
Numbering Worksheets
3452:
Convert time in number of seconds
3453:
Calculate the difference between two times and show dd:hh:mm:ss
3454:
can i link an exel cell to outlook alarm
3455:
Donot allow user to change name of the worksheet
3456:
Workbook open event
3457:
Complex Formulas possibly using IF
3458:
formula to enter data into a blank cell
3459:
Calculating an average
3460:
Return values from table
3461:
Reference the last cell in a column
3462:
How do I combine 2 sets of dates using concatenate function?
3463:
Left Function Question Help!
3464:
counting items within a date range
3465:
nested IF statements
3466:
Unique Records Help
3467:
Vlookup issue
3468:
Logical AND with SUM
3469:
How do I recover excel 2002 files after a system recovery ran
3470:
vlookup
3471:
Populate a cell if values in cell 1 and cell 2 match cell 3 and 4
3472:
How to count cells that do not contain "-"
3473:
Returning data
3474:
Formula Help
3475:
CountIf cell referencing
3476:
Conditional Formating Using Office 2007
3477:
Fill down function not working correctly and producing weird resul
3478:
Multiple ifs and formulas
3479:
ActiveX Combobox and LinkedCell
3480:
Hyperlink to another worksheet to a absolute cell
3481:
Formula to total text in range, if true to condition
3482:
#N/A Error unexplained
3483:
Sum Function not working right
3484:
Finding the next dayof the week after a certain date.
3485:
Excel 2007 - Outline not displaying all nested subtotals
3486:
'TABLE' array function
3487:
Text to Columns wizard greyed out
3488:
formula Help
3489:
IF Function and ignore if
3490:
j
3491:
Equally combining two unequal groups
3492:
data swap
3493:
Merging Date Columns
3494:
macro confusion
3495:
number and text in cell for formula
3496:
work sheet
3497:
Need possible combinations of 7 unique characters.
3498:
how to convert a numeric value in text
3499:
Vlookup on long threads
3500:
Help with Nested Range counts