TheMSsForum.com: The Microsoft Software Forum

TheMSsForum.com

view full version: back to formated view
2801: No Data Analysis item in Excel Tools menu. Now what?
2802: sumproduct formula on steroids
2803: Converting time into military time
2804: Password Protection for Individual Worksheets ???
2805: Search multiple worksheets and return value based on phone number
2806: Colouring text in VLOOKUP formula
2807: Function Values Not Refreshing
2808: Search range
2809: Can I copy my protection settings from 1 workbook to another?
2810: look up functions
2811: SumIf with OR criteria
2812: SUMIF nesting an AND function
2813: drop downs and hyperlinks
2814: Consolidate Data From Vertical Format to Horizontal.
2815: Cap Sensitive Countif
2816: loan repayment calculation for 101 months
2817: calculate average date
2818: COUNT function
2819: Finding the position of the i-th non blank cell in a vertical range
2820: Special Date Function
2821: Binary integer non-linear programming excel solver premium
2822: Binary integer non-linear programming excel solver premium
2823: Changing the color of the data auto filter buttons
2824: I have a question
2825: Copying a row based on date
2826: Spreadsheet help --
2827: Formula Question
2828: Workbook - Read Only
2829: Toggle Cell Colour Conditionally
2830: timed events
2831: MS SQL Server Joins Concept
2832: lookup two arguments
2833: How do I delete existing data from a drop down menu list?
2834: Copying Sheets
2835: Adding Times
2836: Converting Numbers to Months
2837: how to clear data
2838: How to work with Many Worksheets
2839: MIN Function with arguments
2840: List
2841: SUMPRODUCT
2842: Comparing lists of data
2843: Complex Sumif
2844: how to set up formula with more than 1 result
2845: Pivot Table Unique ref
2846: how do i winsorize data in excel
2847: calculate difference between 2 dates
2848: Separate Text into numbers and alphabets
2849: Excel help
2850: Character limit in textbox
2851: Interpolation/vlookup question.
2852: Interpolation/vlookup question.
2853: If formaula ODD and EVEN
2854: Alphanumeric Sorting - numeric alpha numeric
2855: Data Validation Restriction Referencing other Workbook
2856: Average formula
2857: Cell Conditions
2858: workday calendar
2859: listing permutations
2860: Hide function: "Cannot shift objects off screen"?
2861: horizontal scroll bar
2862: Moving data from one worksheet to another...
2863: need to set up a formula to pick random numbers
2864: sheet reference
2865: Divide a range by a corresponding range
2866: Is there a way
2867: sorting data
2868: Why Link updates option in Edit menu is disactive?
2869: Sumproduct Issue
2870: Formula to Compute Overtime hours
2871: protecting cells by password
2872: Calculate Accrual Date
2873: autofill
2874: fill data across worksheets
2875: Default value in Drop down menu and automatic selections
2876: Changing cell addresses to recently added names in existing formul
2877: IF function to return date content of another cell
2878: Taking a total number of employees that meet certain conditions
2879: Leading Apostrophe
2880: VLOOKUP Range
2881: Information match formula
2882: Right function to use
2883: Making a date go red, if date passes todays date.
2884: I need to change 4/21/1998 dates to 21/4/1998 HOW?
2885: working with multiple consolidation ranges.
2886: Random Values
2887: Workdays
2888: Auto Numbering Test Scores and want ties to count the same
2889: converting numbers
2890: Formula between sheets.
2891: Excel Help
2892: My comments on my excel spreadsheets print as black squares why?
2893: Time Format Help Needed (Excel)
2894: Calculate a Date
2895: 4 digits required for a number
2896: How can I show and print repeated row labels/data in a Pivot?
2897: How delete to end of file; comp keeps adding rows; over 3000!
2898: Bi-weekly date dilema
2899: Counting dates with Conditional Formatting
2900: YEAR TO DATE SUM
2901: i lost my worksheet in excel
2902: List and subtotal selected items, then print separate item list
2903: How to keep font color when referencing Sheets in the same workboo
2904: Is there an easy way to delete empty columns?
2905: Excel Function Question??
2906: Help with Sumproduct Formula with Pivot Table Data
2907: subtract 2 cells and get blank instead of 0.0
2908: 360-day Year Based Payment & Amortization Calculations?
2909: How to I sum data from one sheet based off mulitple variables?
2910: drop down list function help
2911: VLOOKUP and OFFSET
2912: Filter Data using a drop-down list
2913: I am trying to create a formula
2914: Calculate number of Mondays betweeb 2 dates
2915: Hide Drop Down Arrows in Table Headers
2916: Excel 07 / Data Validation / List /
2917: Autofill Format
2918: sumproduct basic help
2919: how to know the original creator of one excel?
2920: Excel macro which prompts for input and moves to a cell - repeated
2921: IF function question
2922: IN EXCEL: R1,243.00 CONVERTING TO ONE THOUSAND, TWO HUNDRED AND FO
2923: More Conditional Formatting in Excel 2007
2924: financial spreadshee
2925: Calculating quarters of a year.
2926: how do I add a row when the second last one is used
2927: Arrow keys scroll the page instead of navigating through boxes
2928: Average weekly maximum
2929: Multiple State and product based analysis project
2930: Conditional Formating?
2931: Allow "List" to work in a locked sheet
2932: SumIf and CountIf Multiple Criteria
2933: How sum numbers in the same cell and entry
2934: AutoFilter Cut/Copy not working with Name Range
2935: IF function
2936: Script Not working
2937: countif criteria sg
2938: Why doesn't the alignment dialog box come up like the book shows?
2939: Print 100 Sheets
2940: Sorting in locked sheets
2941: Auto formatting
2942: Adding up the number of times a month is in a column
2943: Rank then sort then pastelink
2944: named ranges question
2945: Similiar data on two different sheets - how to ID what is differen
2946: Problem with HLookup. Not sure if it is a bug or not
2947: split single cells
2948: Viewing formulas for Print in Microsoft Office 2007
2949: Performing date functions after getting cell address
2950: Side to side scroll slide missing
2951: text substitution
2952: Conditional formatting on 2nd cell
2953: SHOW AUDIT ARROWS
2954: vba constant value for "Unicode Text" in PasteSpecial function
2955: Find if value exits in array
2956: text substitution
2957: sumif formulas
2958: How do I show amount of time in minutes and seconds?
2959: How to consolidate multi-row data into a single row?
2960: Workbook Name Edited in Cell
2961: How do I match using partial or approximate values?
2962: Creating new worksheets using data from a single sheet
2963: Totaling cells in multiple worksheets
2964: multiple validations
2965: Add "/" to a date string
2966: Calculating the distance customers live from a branch office
2967: Substitutions
2968: conditional if statement
2969: Count number of 2008 invoices for customers
2970: Excel statistics
2971: Formula Result is "V6", need Excel to use cell "V6", not the resul
2972: cell formula for using progressive information in other cells
2973: Cell format to use for calculation
2974: Can I use copy function in an if statement?
2975: boolean question
2976: date boolean function
2977: Lookup duplicate items in a list
2978: Filter Data
2979: How to auto insert date in one cell when another is changed
2980: notify of entered criteria
2981: Using a combo box for more than one group of cells
2982: How to verify selected data from drop-down list?
2983: Statistical - text function (counting)
2984: Lookup Conditional Scenario - urgent (I have can't figure this out
2985: Combine 2 formulas
2986: allow insert rows = false for only some of the worksheet
2987: Protect formulas which reference to unlocked cells in protected s.
2988: copy formula as is to new cell in an if statement
2989: Custom HEX or BASE 33 Sequence
2990: How to populate a cell with numeric value based on text
2991: multiple value lookup
2992: Workbook Name in Cell
2993: 3d References
2994: adding a percentage to a column of numbers
2995: consecutive numbering
2996: range of numbers
2997: When you hit Save on a template, how can you save as worksheet?
2998: Duplicates
2999: I need something similar to an IF formula
3000: lookup specific value in a column and show it in a new cell
3001: How to set "alignment wrap" as default?
3002: Using STDEV to evaluate a subset of a population
3003: Emailing an Excel Worksheet
3004: Count instances based on two criteria
3005: Deleting Rows Between Empty Cells
3006: If and Then
3007: Referencing Last Cell
3008: SUMIF with two condition from two ranges
3009: Macro or formula for dates
3010: Excel formula questin
3011: Find a theme in a article in a single cell
3012: age
3013: change dob
3014: randomize a set of numbers in 1 column that are located in another
3015: how do i add commas in a single cell?
3016: Insert a specific address from a list if the contents of cell A1=x
3017: Match and return functions
3018: Calculating Average Length of Service
3019: SumProduct or sumif
3020: Formula - stop the update
3021: Changing formula totals
3022: Return Last Value in a Row formula
3023: Time countdown...
3024: drop-down list
3025: Test if a date falls within a given range of dates in Excel?
3026: duplicate dates
3027: Index backwards
3028: Conditional averaging gives wrong result
3029: Problem with Copying a Simple formula
3030: Removing blank cells in rows of data
3031: Summing large number of non contiguous cells evenly distributed
3032: Conditional formatting
3033: Header Scroll
3034: Percentile Analysis Across 2 Columns
3035: Unable to highlight an unprotected cell on a protected sheet.
3036: copy one macro to another workbook
3037: XIRR #NAME? error - Toolpak IS installed
3038: SUMPRODUCT - Count Various criteria in same column (exclude other)
3039: Random help please
3040: DCOUNT Question
3041: Counting text cells then multiplying by a value in another column
3042: Transposing multiple columns to rows
3043: countifs Text and Dates
3044: scroll with arrow keys problem
3045: Data Entry with forms
3046: Please HELP!!!!
3047: can't roundup sum
3048: How to group e-mail adresess based on domain name?
3049: Excel formula question
3050: Need help with a formula
3051: Please help with vlookup function
3052: Please help with vlookup function
3053: Search Excel form (Formula?)
3054: Where can I get a template for 3-column (green) ledger paper?
3055: Check number within a range
3056: I've forgotten the password to unprotect a workbook in Excel.
3057: Linking Question
3058: conditional formatting
3059: dynamic vlookup
3060: Macro_AND function
3061: Protect cells
3062: time tracking formula (trying again)
3063: I need to switch currencies based on a pull-down selection
3064: Finding and extracting text in a cell, splitting into smaller chun
3065: View Locked Cells?
3066: how do Excel options need to be set to make formulas convert
3067: Import Spreadsheet w. Formulas/Functions into SharePoint List
3068: Excel 2007 External Data Links and Subtotals
3069: lookup function to meet two conditions
3070: look ups
3071: Function works in one cell but not another
3072: countif or sumproduct?
3073: Round up whole sheet
3074: excel 2007 right click edit query
3075: Changing font colors
3076: Replace input cell data using Vlookup
3077: sumif? countif?
3078: Reference to a Variable Part of a Cell
3079: I NEED TO USE A LOOKUP FUNCT. TO RETRIEVE A PICTURE FROM A HYPERL
3080: area of a rectangle having two sides equal and two sides diffferen
3081: Change lower case to upper case
3082: Sorting Information
3083: how to extract digits from a row of numbers
3084: Calculate minutes between dates based on 9hr work days
3085: match formula question with isna
3086: Excel 2007 Ribbon
3087: match formula question
3088: Recommended solution
3089: Formula copies when only answer is wanted
3090: Help with Formula
3091: Combine daily data from different worksheets
3092: Conditional Function
3093: is there a formula for FV with UNEQUAL payments
3094: date formula
3095: Non Prinatble fill
3096: Combining duplicate row data
3097: automatically Add numbered rows in sequence from a given number
3098: Formatting Excel
3099: projecting time and date from hours entered
3100: Menu Delete greyed out
3101: Have worksheet changes cascade down?
3102: Formula to determine 10 business days
3103: Sort by even and odd digits and copy to separate worksheet
3104: How can I sort & print specific information from table.
3105: Formulas
3106: Removing an alpha characture from a column of numbers
3107: Summing based off different columns
3108: Need Help to Select certain Data from my spread sheet.
3109: Sum only if cells are not blank in adjacent column
3110: Sorting with Sheet Protection On
3111: How can i get 1 value to display another value when selected
3112: instruction on how to make a 24 HOUR TIME COLUMN
3113: time tracking formula needed
3114: PivotTable Rank - Excel 2007
3115: Counting with more than one criteria
3116: unable to open workbook
3117: Pivot table active dropdown
3118: Count if with multiple column criteria
3119: Compare two columns
3120: Auto Filter - Add visible cells
3121: Copy/paste from many worksheets in the same spreadsheet into one r
3122: Evaluate boolean values as 1 or 0
3123: COUNTIF Function with variables
3124: how to unproctect the sheet if password is not remember?
3125: lookup function
3126: Lists
3127: Paste Link between Worksheets
3128: I need a Line of Credit Calculator
3129: Finding the solution to an Exel problem.
3130: Excel Round
3131: Calculating Information
3132: Sum values in one row dependent on a value in a different row
3133: How do I omit a blank cell from a calculation??
3134: Why is my Excel chart printing as a 1.5 inch rectangle?
3135: If function
3136: vlookup to sum quantities based on dates and specific person
3137: cannot convert text string into value
3138: sumproduct text
3139: For Each Sheet in Range - Sort Descending
3140: Trouble in Dragging the cell
3141: Cell Formatting
3142: ME, STRANGE SUMMATION
3143: Cell formatting
3144: Date Format
3145: Data Validation Lists
3146: Run macro according to value of a cell
3147: Index/Match or Vlookup
3148: Command Button
3149: Can Anyone Help me with this
3150: Help