TheMSsForum.com >> Worksheet >> Archive Page 72 - The Microsoft Software Forum

view full version: back to formated view

24851: Assistance with Formula
24852: What are the formulas behind the YIELDDISC function?
24853: Using Formula based Cell Content Return Unique Consecutive Duplicate Values
24854: Copy/Paste error
24855: Times in Excel
24856: Method 'Copy' of object'_Worksheet failed
24857: How to convert amount into deniminations, in excell
24858: MATCH A NUMBER AS THE SUM OF VALUES IN A COLUMN
24859: Excell help !
24860: Difficult function
24861: How to arrange excel tabs alphabeticaly
24862: get a value from multiple criteria combinations
24863: Vlookup from left to right.
24864: lookup
24865: condition formatting with formula
24866: Vijay 2
24867: Invoice number
24868: Formula help
24869: Sorting Cells on letters and numbers and placing result in one of 3 columns
24870: The '" -- " before a function
24871: copying VLOOKUP w/o changing formula
24872: How can I get my spreadsheets to open faster?
24873: macro for duplicate values
24874: If statement for timezones
24875: Sumproduct - two+ criteria
24876: Why do I get #NA as my result when I write a vlookup formula?
24877: Page break problems
24878: Can 3810 and 3819 and 3806 be joined into one cell
24879: Converting Numbers to Date Format
24880: Hyperlink directly to a contact in Outlook?
24881: Need help with Adding Decimals
24882: Is there an array size limit for MMULT or MINVERSE in excel 2007?
24883: How to set date format between different location?
24884: 15th of prior month
24885: Data Link and VLookup Problem
24886: Date - 12 weeks
24887: Number Format
24888: Text or Object boxes and tab sequence
24889: Multiple cond's for SUMIF or VLookup
24890: Grouping or joining rows
24891: How do i automaticaly number consecutive forms
24892: Counting DD:HH:MM NETWORKDAYS and Hours
24893: The Kth element in a text list
24894: What do these markings (--) do in a formula?
24895: IF(AND) error message
24896: Copy unsaved worksheet "Book" to a Saved workfile
24897: Insert Current Date when cell is empty??
24898: converting military time
24899: Nested if
24900: Insert stock quotes
24901: Cell value becomes filepath to insert picture,jpg or object
24902: Sort headings?
24903: Excel 2002 VLOOKUP Weird
24904: help with the "if" commando
24905: SUMPRODUCT rounding up values
24906: Match & combine rows from 2 worksheets
24907: Conditional Formatting based on entire column
24908: how do I automatically sequence the month
24909: Difference between 2 workdheets
24910: Calculating months
24911: Formula to determine number of current records by week
24912: The IF function but with 3 values
24913: Average throughout the sheets
24914: Lookup Function
24915: Indirect worksheet function
24916: Another Visual Basic/Dependant Cells issue
24917: Calculating time and negative time
24918: Maybe this is a simple question
24919: unique values within groups
24920: Visual Basic Question
24921: Dependant Lists Question
24922: MIN date from multiple different worksheets in a workbook
24923: creating a reconciling list of items not matched between two files
24924: Will excel generate one-tailed confidence intervals for Poisson distribution?
24925: Is correlation matrix univariate or multivariate?
24926: Excel error: Undefined Function 'InStrRev' in Expression
24927: Loan Amortization
24928: fill columns by introduction of data
24929: Average based on the previous row
24930: SumIf function with Multiple cell references
24931: Add-In functions not available Analysis Services add-in.
24932: Comparing spreadsheets
24933: Sharing Violation!
24934: Average throughout the sheets
24935: Can you reference a worksheet outside of the workbook you're in?
24936: Help w/Lookup Function
24937: excel footer
24938: ASAP - need help with formula!
24939: How can I find duplicate occurances of three cells in rows?
24940: Seperating buy Tabs
24941: Extract value from Specific Cell
24942: format a column
24943: Conditional Formatting - due date
24944: Sumproduct?
24945: Whats the new "Template Wizard with Data Tracking"?
24946: need to lookup group of same numbers in spread sheet
24947: Beginning of Pay Period for Bi-Weekly Timesheet
24948: Help with conditional formula...
24949: help with function
24950: Max Function
24951: Finding duplicate entries
24952: Sum-large on excell mobile (pocket PC)
24953: Vlookup for multiple row data
24954: Barcode Check Digits
24955: Percentage within a range
24956: Help with correcting writing a formula
24957: Referring to multiple worksheets
24958: Re: 2007 EC Excel - Access User Conference
24959: Finding last column in non-contiguous range
24960: RE: Finding last column in range
24961: XL Solver
24962: Excel 2007
24963: How can I get worksheets' names in spreadsheet
24964: Can't make hyperlink function work for hyperlink to website
24965: MAX/MIN in range potantially including text
24966: VLOOKUP How do I ?
24967: formula needed
24968: Incorporating INDEX function into Array Formula (CNTRL-SHIFT-ENTER
24969: A number autofill !!
24970: Avg IF
24971: hyperlink lookup from tabel
24972: How do I convert a date of birth to an age?
24973: linking several cells into one
24974: Count & Sum Consecutive (2x) appearance of Specific Numeric Values
24975: Return Unique Consecutive Duplicate Values across Single Row
24976: Conditional formatting confusion
24977: INDEX and Scanning a Data Set in Excel
24978: Average/Sumif based on several columns
24979: darts challenge sheets
24980: Average/Sumif based on several columns
24981: Excel 2003 - negative following the number
24982: Using a Wildcard (*) in formula accessing sheets in workbook.
24983: IF function - need FALSE to return a blank cell, not 0
24984: Question about use of Poisson probabilities
24985: Making too much of a formula
24986: access partition function
24987: Pictures don't move when I sort list
24988: need help please.....
24989: Extract data from a table
24990: Need 3D formula for a range of numbers across several worksheets
24991: Sumproduct based which also weights data based on date
24992: Re counting
24993: Displaying multiple matches
24994: Why does this formula clog my spreadsheet?
24995: remove a dash in my column
24996: keeping the fill color I've selected as the default
24997: Finding this month's cell
24998: Trim cells to a character
24999: Show Comment when in the cell
25000: SUMIF Won't Work for Me
25001: Ranking on several fields
25002: dmin
25003: automatic formatting phone numbers in excel
25004: Specific Days in a NOW() formula Q
25005: Count in two columns
25006: Cells with a total automatically connects to Intenet when highlig.
25007: Nested "IF" With "And"and "OR" functions
25008: locking vlookup formulas
25009: locking hyperlinks address
25010: Excel cumipmt doesnt work even with analysis tool pack added in
25011: Calculate the difference between ages, show as yy mm
25012: SumProduct making things work slow
25013: pivot reports
25014: MVP HELP NEEDED !
25015: how do i do a consecutive hexidecimal count
25016: My IF statement won't work for my formula
25017: Help with joining two macros together
25018: excel
25019: Looking for numbers in page range
25020: VLOOKUP??
25021: how can i find cells which contain certain text?
25022: How do I create a dynamic range in a macro
25023: Compare Two Columns
25024: Excel 2003 - assigning colors to cells
25025: white space deletion
25026: Lookup funtion: column index number (third parameter)
25027: Date format error in Excel
25028: How to get compound annual growth rates in pivot tables.
25029: Autoformat Excel, every other line shadowed
25030: Two VLookups in one arguement
25031: Rows in Excel
25032: Pulling info from other spreadsheets based on a set of criteria...
25033: Custom number formatting
25034: Move entire row to another worksheet based on drop list selection
25035: Complex Lookup
25036: pulling data into a master sheet from multiple worksheets
25037: Formula INDEX/MATCH
25038: automatic month/date in a column
25039: Triming a number
25040: Data validation to force cell population
25041: Macro hot button in Spreadsheet
25042: Formula
25043: How to compare two numeric column in same worksheet
25044: Email notification including specific cell data
25045: I would like to take time from "A1" and add 14 hours to it.
25046: COUNTA function causing syntax error in macro...
25047: how do i get a pop up message on saving or exiting a document?
25048: Lock cell reference in formula, even when moved with click & drag
25049: Basic bar graphs using rept function - Printing problems
25050: Share workbook with protection
25051: Unhide Main Menu Bar
25052: Calculate time (excluding weekend (48 hrs))
25053: Does Excel 2003 have a function to calculate how long money will l
25054: Autofilling incremental numbers in a formula
25055: entering formulas gross margin % divide by Week Total Sales
25056: MS Query question
25057: Taking out string part which represents date
25058: Amortisation with a lump sum principal payment during term
25059: Vlookup function
25060: Find Character in Text and put value in next column
25061: Is there a way to auto insert words in Excel like youcan in Word?
25062: Using another cell in a formula
25063: How do I digitally sign a cell in an excel spreadsheet?
25064: Don't include errors in average
25065: adding a new sheet to a formulated workbook
25066: looking for a way to repeat a formula pattern within a cell
25067: Listbox Selection Displays the Column.
25068: Listbox Selection Displays the Column.
25069: Listbox Selection Displays the Column.
25070: Listbox Selection Displays the Column.
25071: VLOOKUP Looking In Different Workbook Confusion
25072: Excel Formulas "Not Greater than"
25073: Inserting a static date into a function
25074: Enlarging Excel field
25075: Formula to Split First and Last Names
25076: data ranking
25077: Tooltip for macro button in a worksheet
25078: charts
25079: Excel VBA Sumproduct
25080: Percent of Growth Formula
25081: Merging 2 sets of data
25082: Data Validation Question
25083: Excel functions
25084: help in writing a formula
25085: formula to pull name and amount
25086: Formula help!
25087: manipulating cells with symbols and numbers
25088: PERSO.XLS IS HIDDEN FILE, HOW DO YOU OPEN IT
25089: Split 2 names within a cell in excel
25090: Calculate Time Difference and Change Font Colour
25091: How do it set up a SUMIF equation with 2 conditions
25092: If function limitation
25093: go to
25094: URGENT PLEASE! Filtering a Pivot Table further
25095: Formulae with Text
25096: Lookup formula
25097: Slow Spread Sheet
25098: Sum one column based on the unique value in another column
25099: Can anyone tell me what is wrong with this formula please?!
25100: pulling data from one sheet and listing selected data in another
25101: Data input based on date list?
25102: Using SumProduct on multiple lines
25103: SOMPRODUCT
25104: Iserrfunction
25105: Using rank to select top marks
25106: leading 0 (zero)
25107: Iserror not working as expected
25108: Can I make a formula which follows a specific cell?
25109: Need some help in re-organising data from external source
25110: How to have cell values of 0 showing as blank
25111: Re Change 5 week days to 7 days in this formula
25112: IF function
25113: Excel functions
25114: Help with Queries
25115: rounding figures to nearest thousand
25116: Use autofit to row height.But row does not expand 2 cover content
25117: Macro Help
25118: Have a running total when an option is picked.
25119: Material Requirements Plan (MRP) and Capacity Requirements Plan (C
25120: Running Average ? and Divide by 0 error!
25121: How to find the Expected Value of a PDF
25122: Data table function
25123: Macro help
25124: Dropdown Lists and alternative cell references
25125: add numbers if they meet criteria...?
25126: compare name lists
25127: Table function question
25128: subtotal functions
25129: Sumproduct - Pulling info based on lenght of time between dates
25130: Refreshing Pivot Tables in a Shared Workbook
25131: Analysis Cubes add-in for Excel 2003 - Two Problems
25132: Font size for Comments
25133: received "a=formula" instead of =formula after exporting data - wh
25134: List FullFilePath and File name
25135: Help with adding 10%
25136: Returning Cell Contents of One Cell Based On Another Cell
25137: Performance Measures and Conditional Formatting
25138: Help with an Index Match Array
25139: Formulas
25140: Macro help in veryifying data
25141: Lookup?
25142: Total multiple worksheets into totals worksheet
25143: lookup problem.
25144: Display section of worksheet
25145: consolodating info from different sheets with different info
25146: Counting Text as a Number
25147: new colors in 2007
25148: Extracting Info From Within A Text String
25149: Weeks of Supply Function
25150: How do I display chosen filter in a cell below
25151: weighting data
25152: Counting Multiple Instances
25153: Multiple If (Lookup?) Statement
25154: simplify a macro
25155: slow INSERT in excel 2007?
25156: Hvordan udvides Excel 2007 med Kolloner udover sidste kollonne
25157: Lookups in Excel on Data from Access not working
25158: SUMIF/PRODUCT & DATES
25159: Macro Error
25160: conditional formating - dragging a cond. format over an entire col
25161: Joining dates and text in formula
25162: Eliminating 0 values when using the Small formula
25163: Index function?
25164: Formula based on text value..
25165: Re: Track time to resolution (without including after hours on weekdays and weekends)
25166: Excel Page Formatting
25167: IF NOT THEN
25168: Sumproduct assistance - need multiple ANDs and ORs
25169: Activate hyperlinks in multiple Excel cells?
25170: synchronizing data on multiple spreadsheets
25171: IRR & XIRR - Different Results
25172: Insert "SAVE" Button in Excel
25173: Last row that contains data in a column
25174: Can I convert numbers to text in Excel?
25175: If statement with some sort of lookup function
25176: vlookup. HELP
25177: 2007 EC Excel / Access User Conference
25178: TODAY()
25179: Days per month for calculating storage days
25180: help with formula
25181: Exception with EXCEL 2007 API
25182: Drill to Details - is there user friendly way to delete the sheet
25183: Conditional Formatting
25184: how to copy only values and formats of worksheets to new workbook
25185: FIFI Method
25186: Making Text into Numbers, for Pivot Table Cubes
25187: Formula
25188: Using 'OR' with validated data
25189: Inverse Tangent in excel formulae
25190: left function
25191: excel worksheet
25192: I want to populate the role of the person,when i select the name
25193: Make a count based on Drop Down Option
25194: Searching by an User Form
25195: Merging two Cells without losing info
25196: Automatically copy formulas/functions to inserted rows.
25197: Help tonight?!! select rows based on cell value in a column
25198: nested IF AND too cumbersome
25199: keep the results as positive numbers
25200: Convert Binary to Decimal using IF and Sum Functions?