TheMSsForum.com: The Microsoft Software Forum
TheMSsForum.com
The MSS Forum
‹
Archive Home
‹
Worksheet Archive
‹
Page 8
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
2451:
Excel send emails
2452:
function to add time totals over 24 hours
2453:
advanced 'if' multiply
2454:
Locking cells but keeping Grouping Function available
2455:
Help, I need a formula for work.
2456:
VLOOKUP with 2 Conditions
2457:
Goal Seek using Time
2458:
Excel functions do not execute
2459:
Finding Used time for Payroll
2460:
Dynamic Time.
2461:
how do i calculte race night odds
2462:
Concatenate group of cells
2463:
ADDATION OF DEGREE / MINUTES/SECOND
2464:
RANDOM NUMBER GENERATION.
2465:
Negative numbers
2466:
Negative numbers
2467:
Locking a worksheet, but sill fill in informaiton
2468:
Forecasting
2469:
Count text then add results
2470:
Change number to word
2471:
Why put a plus sign after = sign in a formula
2472:
Convert time to text
2473:
Conditional Formatting Non-Adjacent Columns
2474:
Excell
2475:
Question about a formula for time ..
2476:
Formula is correct, but result will not show
2477:
In Excel how do i get the cursor to tab down without the keyboard
2478:
How do I remove a watermark in Excel
2479:
Cleaning up spread sheets
2480:
average with out rounding up in a group of cells
2481:
MATCH() Function and Blanks
2482:
Need (Excel) formula to make Mark sheet with Automatic Grading
2483:
Count Max values in a range
2484:
Is the RANBETWEEN function certified randomness?
2485:
Is there a better way to do this?
2486:
model help
2487:
Equation for total benefit costs = an additional __% of salary?
2488:
Lost and Completely frustrated
2489:
xirr
2490:
Match or Lookup formula help please
2491:
Please Help.
2492:
Case Select
2493:
how to roundup
2494:
find and replace data
2495:
Max census of patients in any hr
2496:
Help with Functions
2497:
Cursor
2498:
How do I find duplicate numbers in a data?
2499:
Duplicate Function
2500:
Use ROUND to return an average date
2501:
Match or Lookup help please...
2502:
text exceeds allowed number of characters per cell
2503:
Multiple Sumifs
2504:
Vlookup stops working???
2505:
Excel drop down menus
2506:
count function
2507:
Return an average date
2508:
How to print file path in footer as default option for all files?
2509:
Countif excluding hidden rows
2510:
How do I 'count' the number of entrances in filtered cells?
2511:
I have dual monitors, how can I view excel workbooks side by side
2512:
consolidate and compare workbooks in excel
2513:
not sure if i'm using the right thing
2514:
emailing excel worksheet from excel program d/n work? how to fix?
2515:
Inserting new row
2516:
how do i do profit formulas
2517:
IF - And - Then Statement question
2518:
formula help
2519:
Search Formual Error
2520:
Formula
2521:
Add Seconds to Date - Time Field
2522:
need help with conditional data
2523:
Need a formula to determine if date falls within a date range then
2524:
Count Duplicate Numbers
2525:
Vlookup look up the remark
2526:
SUMIF with 2 creteria one Name one DAte
2527:
Time is locked to General format
2528:
Using Survey Monkey
2529:
Forms-Scroll Bar function in Excel 2007
2530:
Find total number of unique model numbers
2531:
Formulas
2532:
Rolling figure to a cell
2533:
Vlookup Formula Help
2534:
Manipulating Text to create HLOOKUP
2535:
if and sum, 2nd try.
2536:
How can I display formula values instead of the formula?
2537:
MS OFFICE EDITION 2003
2538:
IF statement
2539:
Formula w/two columns to add the greater number
2540:
Top Ten Lists with a twist (or three).
2541:
Recording changes in cell value
2542:
Fill cell based on # of days
2543:
Conditional Data Validation
2544:
Extract all text without spaces and special characters
2545:
Can I reduce (101.25) to only what's *right* of decimal? (25)
2546:
Splitting Worksheet
2547:
Formula to find and list duplicates
2548:
Sum and skipping cells
2549:
Match/Vlookup/Hlookup ?
2550:
Hyperlink not staying Active
2551:
Formula adjust for inserted row above current row
2552:
Use horizontal lookup with pivot table
2553:
Import a "custom list" from another user
2554:
I am getting formula displayed in some cells rather than the resul
2555:
Decimals on a date calculation
2556:
Frequency of Serial Number
2557:
Excel Worksheet functions
2558:
linking rows
2559:
export from 07 excel to outlook contacts
2560:
If(AND) Statement
2561:
Initiate a trigger for clearing a list of check boxes?
2562:
lookup a category for a part that contains a start and end value
2563:
ListBox Drop Down Font Size
2564:
Macros
2565:
How do I use feet and inches (including fractions of inches)
2566:
Add contents of two cells when a tick box is ticked
2567:
Add values based on multiple criteria
2568:
cell indicator flag
2569:
Pivot table updation
2570:
Mulitple if function
2571:
Unprotecting worksheet/workbook in Excel 2007
2572:
Find value within a range and extrapolating....(tiered commission)
2573:
Summing multiple account #s in one cell, by referencing
2574:
How do i edit links automatically?
2575:
Expire count down
2576:
conditional formating If A1 or B1 is blank then C1 (Font Colour Ch
2577:
why does when i drag a formula in excel gives the same value?
2578:
working on a cell formula
2579:
Identify numbers that only occur once in a column.
2580:
Excel 2007 Combining two tables
2581:
Hyperlink Update
2582:
Attempting to Copy a IF Function
2583:
Multiple Vlookup
2584:
What does this formula mean?
2585:
Using SMALL Function with select data
2586:
Pulling partial information from a cell
2587:
Fill Down reference of even number rows
2588:
unsorted lookup
2589:
Combining functions: Subtraction and IF
2590:
VLookup multiple values - sum returned values into single cell
2591:
value error
2592:
Help in color index function
2593:
Number of days in a quarter between two date ranges
2594:
Unable to activate "total row" in design tab
2595:
Average time values
2596:
How do I add a control check box to control other checkboxes?
2597:
sumif or sum production - 3 or more criteria
2598:
Mix text and numbers with leading zeros
2599:
text as a number
2600:
Conditional Formatting of Checklist with several date variables
2601:
In a formula or function, what do the symbols "" mean.
2602:
How to use OFFSET to determine DUPLICATES in a list?
2603:
Last Friday of the month
2604:
Hybrid vlookup - sum function
2605:
converting vertical inches in tank to gallons (have manual chart)
2606:
return first value greater than zero
2607:
Using Conditional Format/Icon Set With Dates
2608:
sum a range based on criteria in rowdata and column name
2609:
Shading Cells based on Date
2610:
Formula Query
2611:
Toggle Button
2612:
Why result = 4
2613:
Vlookup with either/or
2614:
A mysterious if function to return a specific balance?
2615:
Address can not be more than 30 characters
2616:
how do i convert a flat rate into a reducing rate?
2617:
Looking for alpha characters in a field
2618:
Last closing stock number
2619:
Average formula
2620:
Drop down tabs that can auto fill certain information?
2621:
Using LOOKUP without values in ascending order
2622:
Concatenate with carriage return- how to remove blanks?
2623:
counta and or if
2624:
How can make a formula to add add the nominators and denominators
2625:
looking a value in an array text values
2626:
Conditional formating formula
2627:
Match based on calculated value
2628:
summing times
2629:
COUNTIF Across multiple worksheets for "x"
2630:
VLOOKUP returns unwanted/wrong values
2631:
Create a drop down that adds up a price
2632:
Formula to search for a word and put that entire row in a list
2633:
Vlookup problem
2634:
Complicated Countif application
2635:
VLOOKUP using FALSE returning blanks and #N/A
2636:
Data Validation w/o Cell Content Deletion
2637:
Array Formulas
2638:
IF question or MACRO ? Which to use
2639:
Assigning a word to a number
2640:
Detailed Function (or Macro) Needed... Help
2641:
Calculate days in a month
2642:
COUNTIF with OR
2643:
nested vlookups
2644:
number
2645:
Showing the cell to the Left when certain criteria are met
2646:
VLookup help Office 2003 Professional
2647:
Getting "Creat List" function on excel 2002
2648:
Compatibility Mode to Excel 2007
2649:
how do I lock the first tab of multiple worksheets
2650:
Count/Sum based on mutiple criteria
2651:
Saving a value in another cell
2652:
Financial Numbers not properly adding
2653:
Function needed
2654:
Worksheet Total and Macro
2655:
Text Formula
2656:
Dividing multiple cells by 1000
2657:
INDEX MATCH formula
2658:
Rounding in Excel
2659:
Assign a number to a word
2660:
Find and Replace one row only
2661:
How to create multiple lists each comprising data from previous li
2662:
Alternate Row Shading (Visible Rows Only)
2663:
HOW DO I CREATE MULTIPLE LISTS
2664:
Sum Indirect Using R1C1 Style
2665:
Display a cell to the left with some changes
2666:
Sorting and maintaining formula integrity
2667:
Setting Preferences for Multiple Worksheets
2668:
HEADER and FOOTER
2669:
if questions
2670:
Need an Excel formula
2671:
Blocking/Disabling selected worksheet
2672:
cross referencing
2673:
Count values from Pivot Table
2674:
Adding up a column of percents
2675:
Average formula limitation
2676:
Update Source data in a formula
2677:
some type of IF function
2678:
Adding Cell to the left
2679:
ASSIGN NUMBER SCORES TO LETTER GRADES
2680:
Format Time as Text
2681:
Using SUMPRODUCT with a VLOOKUP
2682:
Text entry into excel
2683:
Help with If statement to subtract time (follow up)
2684:
sum of info in a range based on dates
2685:
allow a user to edit ranges in a protected worksheet
2686:
What is the formulae to find out a %
2687:
Paste Special Comments
2688:
IF formula returning a colored cell
2689:
Nested IF too long - other suggestions?
2690:
Lookups???
2691:
To list down all SN (Serial Number)
2692:
Help with a formula and cell referencing.
2693:
Average values in date range
2694:
exel formula for numbers to text
2695:
Excel - viewing hidden rows
2696:
Find top 5 highest values/percentage within a table
2697:
Vlookup - maybe?!
2698:
DELET PERTICULER WORD FROM THE EXCEL SHEET
2699:
HEADER & FOOTER
2700:
Creating DDE link to DDE server in Excel 2007
2701:
How I find specific character??
2702:
Need help with function please
2703:
subtraction issues
2704:
checkbox to work when emailed
2705:
Display File Name in Cell
2706:
RE: using if statement to subtract 24 hours from time still shows as a negative time from both responses under 24 hours
2707:
Excel Warning
2708:
using if statement to subtract 24 hours from time
2709:
Sales Report
2710:
Cells w/ user defined function do not auto update
2711:
The FV function
2712:
Formula Needed
2713:
VBA Password
2714:
Excel Formula Needed
2715:
Strange Problem in EXCEL
2716:
Please help with Column to row formatting
2717:
vlookup from another worksheet
2718:
How do I Keep a Combo Box "Focused" on difrferent cells.
2719:
Convert 29.08 hours (shown in decimal form) to time shown in "hh:m
2720:
Volunteer scheduler
2721:
now that i have formatted the text to "proper" ...
2722:
What is the formula for cumulative year to date totals in Excel?
2723:
Linking 2 excel workbooks
2724:
Placing external data in a worksheet
2725:
Compare 2 worksheets all 6 columns in each worksheet
2726:
how to count blanks before today's date?
2727:
Lookup and copy multiple values
2728:
CHOOSE e MAIL SERVICE
2729:
Exclude Lines in the calculations on a spread sheet
2730:
compare cells and sum if equal
2731:
3 LookUp Variables One Result
2732:
IFERROR
2733:
Turn a four digit number into pounds & pence
2734:
Two dimensional look up
2735:
checkbox, then taking information from one sheet to another sheet
2736:
Globally available defined names?
2737:
Help Please calculating date range - Other posts didn't help
2738:
Reference a variable declared in VBA
2739:
How do I create a time trend summary from monthly worksheets?
2740:
User is not prompted to update links when opening spreadsheet
2741:
Conditional formatting excluding empty cells
2742:
Formating text in a calculation
2743:
Multiple Level "and" fucntion help!
2744:
Binary integer non-linear programming excel solver
2745:
How to keep Status count visible?
2746:
Function disappearing in spreadsheet
2747:
How can you search by column or row within a spreadsheet?
2748:
How do I Go To a Row or Column?
2749:
Excel 2007 tmp files filling up drive with XLSM files
2750:
Highlight Cell Based Upon Referenced Cell Data
2751:
Performing calculations if a value is between A and B
2752:
Date format diplays incorrectly
2753:
How do I count MTD coloms?
2754:
how to return the latest result...
2755:
To make the excel file in shared folder to be editable by every us
2756:
autofill button is not appearing when I select cells in Excel 2007
2757:
Formula to pick up blank cell names
2758:
comparing 3 columns
2759:
I can't insert column in Excell file! Help please
2760:
LookUp (Date) Value from Forecast Data
2761:
Help with Conditional Formatting
2762:
formula for "on time" departure.
2763:
If to determine lessor of three values
2764:
SumProduct
2765:
Comment Function
2766:
Summing a number only once...
2767:
Hyplinking Question
2768:
HOW TO CREATE A MACRO!!!
2769:
looking up multiple values in an arrray
2770:
Function returns itself vice results
2771:
Formula help!
2772:
cells
2773:
Help!Excel will not calculate formulas- Not in manual calculation
2774:
auto sum feature
2775:
Gathering Count by date
2776:
Counting non blanks different from ""
2777:
Summing a number only once
2778:
cannot Move or Copy a worksheet
2779:
wraping columns
2780:
Adding a percentage to a figure
2781:
Simple Addition Function
2782:
Can't subtotal data from query
2783:
Combining MATCH & LOOKUP formulas
2784:
Turn off or not include lines in a calculation
2785:
Most current date
2786:
Pulling Data that falls within a specific date range?
2787:
Filter & Sort
2788:
CONDITIONAL FORMATTING
2789:
Replace nonprinting character
2790:
VLOOKUP Tables
2791:
Rolling YTD/YTD Dynamic Function
2792:
Sum Formula based on color
2793:
Rate formula in Excel
2794:
Concatenate Text... with spaces
2795:
MATCH Function - 2 Dimension Arrays
2796:
excel 2007 getting errors with mround
2797:
Tracker
2798:
Excell word formula
2799:
Excel 2007 conditional formatting & cell colour.
2800:
Vlookup limitation