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

view full version: back to formated view

6651: Nested COUNTIF?
6652: Renaming sheets with part of original name
6653: Open Dialog Box
6654: Problem with sumproduct, countif functions..
6655: Print Value and Formula View worksheets
6656: Worksheet Protection
6657: What equation will total number of cells with specific words?
6658: How can I count the number of cells with a particular color/shade
6659: Look up
6660: Is there a way
6661: Unique Selection of Data
6662: Calculation Problem
6663: find duplicates and concatenate
6664: Excel Won't Calculate
6665: find duplicates and concatenate
6666: Blurred Vision
6667: Update DAte Automatically
6668: Compare to two sheets in one excel file to evaluate and combine where
6669: if then formula
6670: Formula Help
6671: Double Match - version 2
6672: Please help matching data from one table to another
6673: If/Then Statement help
6674: convert meters to feet/inches
6675: Convert text to columns
6676: Time Format
6677: Pivot Table Column Label: Multiple color font on selected word?
6678: Extracting data from a sku for shipping
6679: Array / Function HELP!!!
6680: Outlook/Excel
6681: one qustion
6682: Help with countif and sumif functions
6683: non-VBA Alternative to SUBTITUTE function
6684: COUNTIF for multiples of 3
6685: Column and cell identificatiion
6686: What would cause the comment box to resize and move on it's own?
6687: Update column H based upon content in column B
6688: Weekly Worksheets from others merged into one summary sheet
6689: COUNTIF Function
6690: how can you insert a version number in excel ?
6691: Separate address numbers from street name
6692: Pushing my luck, Sumproduct based on current data
6693: Macro to re-protect sheet w/ original password after pasting values
6694: IF AND problem
6695: shared workbook - macros using advanced filter - substiitution nee
6696: How do I create a button on a spreadsheet ?
6697: Automatically hide column or row if a cell value meets criteria
6698: How can I make a vLookup dynamic?
6699: Average values in only last 6 columns
6700: How to? Create random letters and numbers in a cell
6701: Cell recognition
6702: Linking certain cells from Multiple files in a folder onto a summa
6703: Vlookup with a difference
6704: Dependent lists in other workbooks
6705: Formula erros =#N/A
6706: find a certain name ????????
6707: Data Validation - Tabs
6708: How do I insert the file name as my Worksheet name in the tab?
6709: vlookup displaying value of 0
6710: Change import cell reference
6711: Hiding zero values but being able to display 12am
6712: entering dates results in subtraction of numbers
6713: grouping error in Excel 2003/2007 Pivot table connect to offline c
6714: Sum and "N/A"
6715: How to separate names and addresses in a spreadsheet
6716: Separating names & addresses in a spreadsheet
6717: How to establish a maximum and minimum value to a cell
6718: Data Validation Not Erroring with List
6719: table of # of rows with unique combos of values in 4 separated col
6720: Looking up a value within a range of 3 letter or number codes...
6721: Array Formula
6722: Indirect function in Excel 2007
6723: Need help writing a formula
6724: need help summing text in column
6725: Not sure what function to use to return records that fit criteria
6726: Finding non zero value in a group of cells
6727: How do I use case sensitive VLOOKUP?
6728: Relative sheet referencing in excel formulas
6729: Double Match
6730: ONE ROW WON'T SORT
6731: Sum Items in Column B if Item In clumn A corresponds to Page 2.
6732: Unprotecting a worksheet
6733: Sort Data Items in Pivot Table
6734: Dates
6735: How to replace a cell's formula with a non-zero calculated value?
6736: GetPivotData
6737: find a string of nth occurance & pick next 3 words
6738: Need Help with Date Format
6739: QUARTILE Function on Sorted Data
6740: QUARTILE Function on Sorted Data
6741: row heading to show on all pages
6742: Identifying cells that add up to a certain amount
6743: Excel Formula-Positive to Negatie
6744: Conditional formatting dates in 2007
6745: Sum of subset of an array
6746: Excel -- Can't undo [Read-Only] Files.
6747: Locking Cells
6748: Match function
6749: If Function and the dreaded #VALUE
6750: second or third match in vlookup() or Match()
6751: Simple Aging Column
6752: dget vs vlookup
6753: group items in pivot table
6754: vlookup on close file
6755: alarm on a date cell
6756: Formula Help
6757: selecting columns to change format
6758: Navigation
6759: Display a message
6760: Using IF Function
6761: setting comment defaults
6762: Activating macro on enter.
6763: VBA function Procedures....
6764: Find & Replace Q
6765: Re: Capitalizing Text
6766: How do I freeze formulas when cutting and pasting other cells?
6767: Nested If Using TODAY Function
6768: Help with IF or VLOOKUP (I'm not sure which formula to use)
6769: help with a if function question
6770: VBA functions and Procedures....
6771: protecting cells
6772: sumproduct and vlookup
6773: Formula to multiply only a portion of a cell number?
6774: Vlookup not working consistently
6775: reference every 19 rows
6776: LOOKUP Help
6777: COUNTIF AND
6778: IF function question
6779: Capitalizing Text
6780: Dotted lines for projections in graph
6781: what function or formula can I use
6782: Extracting text from a string
6783: Can I request user in input variable value within formula?
6784: can a function return part of it's result in italics?
6785: Macro for shading
6786: Matching Data
6787: Vlookup in Excel 2003
6788: alarm on a date cell?
6789: Changing the apperance of values
6790: Sequential match
6791: paste values in blank cell
6792: NETWORKDAYS XL2007 problem with calculating Banking Days in a mont
6793: Excel
6794: how can i analyze data to get the levy-stable distribution stats?
6795: Round in Excel 2007
6796: VLOOKUP in Excel 2003
6797: Indirect & offset formulae - Urgent
6798: Summing values in a database against certain criteria
6799: =?Utf-8?Q?how_to_add_a_=22+=22_to_a_number_in_?=
6800: Four User Defined Functions - probably one similar answer
6801: SUMPRODUCT or do I need something else???
6802: converting numerical data in one cell to word data in another cell
6803: Please help me with VLOOKUP AP
6804: can i insert a picture with a if statement
6805: VLOOKUP Formula Returns the Wrong Results.
6806: Link problem
6807: upper case letters
6808: Grouping Dates in a Pivot table for years that are not calendar ye
6809: How do I perform time calculation formuals in excel
6810: Comparing two columns of numbers
6811: Date function
6812: Cell coloring when the value is an integer and within said range
6813: VAT formula
6814: Calculating the difference between hours
6815: sum of visable cells in filtered range
6816: reuest formula for auto update status & status date
6817: sheet formulas and strings
6818: How do I find (not delete) duplicates in multiple spreadsheets?
6819: if condition with data validation list
6820: Produce a financial sensitivity analysis graph in Excel 2007
6821: How do i get an automatic refresh of a worksheet in excel
6822: Frequency Function
6823: Match Multiple Criteria & Return Numeric Labels across single row
6824: set up absolute for 10% discount, then add in 22% gratuity
6825: Countif formula problem
6826: referring to sheet in another file
6827: Filtering Time Cards
6828: Is this even possible?
6829: How do I enter 1635 and see 4:35 PM in the cell?
6830: day of Month
6831: Good post
6832: Formula to display column widths?
6833: check box, copy / paste or insert / delete row
6834: Formula to display data if it meets multiple criteria
6835: referring to a sheet in another file
6836: Inserting rows in a protected sheet - Office 2003
6837: syntax for countif when cells fall within a numerical range
6838: Microsoft Excel 2003
6839: Calculate Follow-Up Dates - Please help ASAP
6840: Unsharing a workbook in Excel 2007
6841: Cell Change to Comment
6842: Problems creating a result based on 2 cells being true..
6843: return text value found most frequently in a column
6844: insert cells in alternating rows?
6845: SUMPRUDUCT 3 Pieces of Criteria
6846: Hiding columns based on row 4 criteria
6847: SUM+IF Array formula
6848: Pull data from various worksheet
6849: Drop dwn menu. Formula to count selection frm menu in anoth cell?
6850: IF Statement based on cell color
6851: indirect w/ vlookup = #REF error
6852: Search for a partial number
6853: Consolidating Sales Data to Summary Worksheet
6854: VLOOKUP
6855: Drop down box
6856: pivot table subtotals
6857: Summing Multiple Columns
6858: random letter generation
6859: Find position of first non-matching character
6860: Vlookup areas?
6861: Trying to work with files copied from Office 2004 (MAC) in Office
6862: Combine 2 sheets into 1 that will update w/new data
6863: Is It Possible To Have... After A Button Press A Message Pops Up ?
6864: Multi YTD Summary
6865: Solver for budgeting
6866: sorting source data linked to another sheet
6867: Problem with IF function
6868: Problem with Concatenate - Results are too long for CSV
6869: Need to count dates in a spreadsheet
6870: Import Spreadsheet into Access
6871: Activating cells with checkbox
6872: IF with multiple formula/variable
6873: change rows to columns/columns to rows
6874: Escalation Formula
6875: If Formula
6876: display the cell ref a matching number is in
6877: Replacing a list of codes with names
6878: Finding first number in a row
6879: Marco To Save Column A7 As A .txt File.
6880: How to sum a variable number of items
6881: sumif function
6882: Multiple condition countif for excel 2003
6883: How do I lookup a worksheet name in excel?
6884: StopWatch Macros
6885: ?? VLookup ??
6886: date calculation
6887: Change 1234567890 to 123-456-7890
6888: button in a cell to activate a macro
6889: Formatting cells
6890: MAX TEXT ON A MASSEGE?
6891: How do i name a range of data in excel
6892: Show text massege when formula result is true
6893: finding 75 days before current date
6894: Subtracting Dates
6895: Worksheet autocalc with min function in error
6896: loan amortization schedule - skiped months
6897: alphnumeric if then statements?
6898: IF formula results not displaying
6899: Nesting Eroor - more than 64
6900: Why do i lose EOMONTH on file close
6901: calculate total items meeting criteria in range with multiple shee
6902: Highlighting cells in one column from a formula valuein another co
6903: is there a way to show what each cell links to?
6904: Trying to build reference to external, web-based sheets
6905: VLOOKUP based on a formula result
6906: problem naming range
6907: what function/formula do I use?
6908: Please help
6909: offset function in defining name
6910: Alpha column lables
6911: filtering problems
6912: Monster of a formula!!
6913: FORMATING ONE SHEET TO MOVE U TO ANOTHER
6914: Removing Spaces In Cells
6915: Date - Help
6916: Sum function when the values in an xls are color coded
6917: date > date function
6918: daily trade blotter
6919: List of cells that contain a particular word
6920: Formula help
6921: how to delete the little red arrow in excell work sheet block
6922: Converting COUNTIFS to 2003 format
6923: Find function
6924: if negative figure
6925: Listox
6926: countif & subtotal functions
6927: Sum if function
6928: Request for formula to refer some letters from Cell
6929: IF Cell A1 = Home, Cell A2 should change to 123
6930: Sum with special requirement
6931: Linking two whole worksheets
6932: calculate total number of items that meet 2 over multiple sheets
6933: Counting highest values within groups of four
6934: Adding new data to tables and charts in excel sheets from 97/2003
6935: cell reference in sumifs
6936: Excel-how to link source workbook to copy of destination workbook
6937: multiple cell reference from sheet to sheet
6938: Conditionally highlight a row on a cell content
6939: Conditional formatting using If
6940: count date ranges
6941: unique records in specified range
6942: Sumproduct multiple criteria
6943: Conditional Formating =mod($a2,2) = not(mod($a2,2))
6944: Counting cells with colored font
6945: How to round a number up or down
6946: date range additions
6947: Excel formula / IF function
6948: #DIV/0! errors
6949: Display next to last results
6950: Sending Email with Worksheet Content
6951: If Statement with Two Different Logical Test
6952: if then statement based on another column
6953: Summing distinct columns
6954: incorrect calculation
6955: if then count sum
6956: formating movement without changing text
6957: Advanced Probability.
6958: Reviewing Large IF Statements - Any Tools available?
6959: if then based on date range
6960: CountIf
6961: If, greater than
6962: percentage range
6963: keeping text format in linked cells
6964: Linking Texts from on sheet to another while maintaining formattin
6965: Using Worksheet Name in Code/Formula
6966: IF/Then Theory between two or more tabs.
6967: using slope function with non contiguous cells
6968: formula for conditional formatting
6969: Prediction
6970: Consoildation of data for upload
6971: format_text
6972: Sumif across mutiple sheets
6973: Macro button that others can see
6974: control end in a macro
6975: How can I automatically replace the error #N/A with 0 in Excel?
6976: cell cursor outline color?
6977: As of date formula in a footer
6978: Countif Function Help
6979: Countif Problem
6980: Linking my worksheets
6981: JULIAN DATES?
6982: Complex IF formula w/ time
6983: How do I find my worksheet tabs?
6984: Avoiding #Value errors when referencing DB Tables
6985: Countif & Sumif
6986: thru form update data store in excel
6987: Macro Button Problem
6988: repeated value
6989: Lookup first in column
6990: Calculating waiting times
6991: can anyone give me all the functions in the excel worksheet with
6992: SUM function
6993: Multiplying then adding Two Rows of Numbers
6994: How to create a Exchange Currency Rate into Excel
6995: Total OVT on monthly basis
6996: Formatting Dates
6997: importing multiple values from a spreadsheet
6998: Report duplicate rows
6999: Placing Col & Row identifiers into a cell as text
7000: 4 day work week