View Full Version : Microsoft Excel Misc
- IF statement
- What is the excel Wildcard in formulas?
- Why split a worksheet into sections
- Re: What is the excel Wildcard in formulas?
- Re: What is the excel Wildcard in formulas?
- Multiple Files
- Re: Multiple Files
- excel file does not load on launch
- Combining multiple cell text with punctuation
- display negative numbers with brackets
- reference book
- column / row merge sort
- Naming Cells
- Re: Naming Cells
- auto save - excel 2000
- worksheet tabs
- Re: How to extract original data from a pivot table?
- Links in a drop down menu
- Re: Menu's and Toolbars not visible
- Difficult Cells!
- Re: Naming Cells
- Re: Menu's and Toolbars not visible
- Querying cells across cells
- Left Join dilemma is this possible?
- Windows In Taskbar
- increment a cell value, and fix the value
- Where is relative reference button?
- Recently used file list
- Naming range
- Re: X-axis on Line Chart
- Re: convert data in import
- Comparing and Counting Data
- validation hic-up -- no drop-down list!
- Only grand total in Pivot Table
- Recording a macro
- .xls extension vs .xlr
- Tools menu...Option...startup folders
- Scroll bars disapear
- Adding two occurrences
- Re: Naming Cells
- horizontal Scroll
- Dave Peterson
- Can't establish a DDE connection?
- Let's try again
- Re: Using variable in cell reference
- Storing current dates and system username on a cell
- linking to a range changes
- Pivot Table data value minimum
- Help
- EXCEL help
- read only message
- Editing Intra-Network Hyperlinks in a Spreadsheet
- Re: Matching 2 data sets in the same spreadsheet
- Excel Error
- Same Header on Different Sheets
- Workbook duplication
- Creating a stacked column chart with 2 axes.
- Time
- Excel sorting
- Lines Not Showing Up in Print Preview
- Resizing Cells, but not Columns/Rows
- Re: Matching 2 data sets in the same spreadsheet
- Summary Page - advancing name of sheet - PART DEUX
- Using a VLookup "type" reference but the result is the CELL not th
- MULTY WorkBOOKS - No Macro's
- Selecting Dataset(s) From Data Picklist
- Excel
- Using VBA to change a range
- File Conversion
- Divide by Zero
- Protection in Excel 2002 deactivates
- custom color palette for every new workbook
- Hidden files in Ms-Query cause ODBC connect errors or Query is wac
- remove "false"
- A document with the name "abs.xls" is already open.
- formula help please
- Automating consecutive dates matching dates of the week in columns
- Excel 2003
- Excel 2003-Compatible
- Excel
- Select all Sheets
- downside standard deviation
- parsing HTML table into excel. How?
- Loop Macro
- Break links in Excel 2000
- Excel Viewer does not work
- Excel question, help plz
- Short cut key
- Naming "block" of formulas
- cannot open workbook outside of excel
- excell spread sheets
- Using the contents of a cell in a formula
- excel spreadsheet
- importing forms in Excel
- Don't change text to numbers
- Activesheet.Calculate
- Can WorkSheet Tabs be Colored?
- Re: X-axis on Line Chart
- Simple way to convert UTM ED50 coordinates to decimal coordinates?
- Insert worksheet
- Formular to calculate DATE
- Macro Command Buttons
- xls file extension to wks "Works" extension
- How to delete info without deleting entire form?
- User Defined Formular
- Re: User Defined Formular
- Array function comments
- Solver add-in and macros
- Compound Interest (growth rate) help needed
- Need help with strange Excel behavior
- Filtering a list
- having trouble adding more than one textbox to a form using vba
- how to protect different ranges of cells
- excel comparisons using limt data
- Locating random cells by their value
- current date and username automated on cells
- Allocate Time to a Shift
- limiting background graphics
- excel
- pasting a web page in an excel cell
- No macro recording dialog box
- Excel Workbook- Can't open file once any changes are made
- Excel projects
- Distance Calculator
- MSN Explorer email problem w/Excel 2000
- Regresssion analysis, data with gaps
- Unusually dark print background
- Mailing List Problem
- Sorting list of email addresses
- Dragging data without changing cell borders
- Find() parameters
- Dates in Excel
- Close Group
- Finding average of absolute values
- Calculate date
- Application.Volatile
- How do I subscribe, please?
- How to caculate subtotal of every other lines
- borders and gridlines not holding
- Protected worksheet
- Find & Extract
- unknown formats being applied
- Excel2000: Can't access an Excel table though ODBC anymore!
- Capital / Small letters
- Display web chart in excel
- Hyper link to another sheet
- Lookup and add values from 3 columns
- #N/A
- Links from Word no longer updating
- REPLACE across multiple excel files
- Excel / Word
- Need Help for Desirability Calculator (moving squares with numbers around)
- tool bar should come automatically.
- Re: Can I highlight links?
- Help with macro(saveas)
- Personal Macro Workbook closed
- Comparing y-t-d average between 2 years for each year without surpassing present year's week
- Search Capability in form created with Template Wizard
- Moving information from spreadsheet B to A
- Keep pivot references, really need help
- Embed more than 7 formulas in one (excel error code: 214124)
- ++++ SUPPORT FOR HEXADECIMAL DATA IN EXCEL +++++
- Spreadsheet Size
- Displaying locked cells
- Excel cannot access the file
- macro shortcut key won't work
- averaging cells to reduce data
- barcode
- Re: macro shortcut key won't work
- Re: averaging cells to reduce data
- "X" marks the spot
- Re: Excel VBA - Modifying formula with VBA
- total of colored rows
- Converting Word labels to Excel Database
- Pivot Table page field problem
- Macros in Excel Viewer?
- #DIV/0! error
- Office 2003 Toolbars
- Data-reduction in coloumns???
- macro problem
- Re: Round/Display (HR:MN:SEC) data in decimal HR format for Time Card
- Re: Formula Needed
- Indirect function
- Re: Formula Needed
- Re: Copy page set-up settings
- Auto fill keeps adding 1 digit or 1 cell
- Row width option in Paste special ?
- Excel Save/Update Webpage
- autoformat to scientific numbers
- File name problems - Microsoft Office 97 (only in Excel)
- Change default settings fro gridlines
- Re: Formula Needed
- Re: Formula Needed - PART 2
- Re: Formula Needed - PART 2
- Re: Formula Needed - PART 2
- More than 7 arguments in a formula II
- ZIP codes beginning with 0
- toggle calculation
- Automatic email generation
- Go to section of all worksheets
- Idiot-proof customization
- How to access Excel-Sheets from outside Excel ?
- Re: Formula Needed - PART 2
- Can I control the tab key from one text box to another?
- Forecasting Data Increases
- XL 2k - all digits in cell turn to 0 after 16th digit
- Copying a worksheet (not the whole book)
- e-mail worksheets
- Group and Ungroup rows & sheet protection
- Re: creating matching data in different columns
- summarizing selected data on a grid
- Need array formula to ignore zeroes
- Re: chart axes problems
- Re: Updating Cells...
- Off topic
- Worksheets automatic references
- Calculating shift patterns (Sorry can't be more specific)
- Turn Off Multiple Cell Selection
- Re: 3rd time is the charm! Linking CountIF formula
- High speed utility/API package...poll
- Excel dates to days
- Printing in Excel Fails
- Re: 3rd time is the charm! Linking CountIF formula
- Re: converting a word table to and excel spreadsheet
- Printing fails in Excel 2003
- Entering data as a number OR percentage
- 2nd Que: IF/AND from drop-down lists?
- Excel and Outlook
- vb question w/ if statment
- Sort problem
- This is A Test
- Merge Web Query
- How do I import data into an existing spreadsheet?
- Expandable / Collapsable Rows
- Count coloured cells
- pasting row to another workbook prompts because same defined name exists in new book
- Pivot Tables as Data Source
- Date Format
- Excel Add-ins
- Continuing the cell references in formulas
- want to do piovt table, where rows over 100,000
- Changing the Default location for Hyperlinks
- Change/assign keyboard shortcut for a macro
- Override Excel's date autoannoyance
- empty combo box
- How to club two "Page" values in a pivot table ?
- superscripting
- Refreshing a Pivot table
- Hilight differences in column???????
- Row height
- Excel freeze menu and toolbar
- Re: how do i arrange the columns in my pivot table
- printing specific columns
- Problem with OFFICE MULTICLIPBOARD EX 2003
- if isblank problem
- Missing file
- Omit request password when quit
- Re: VBA Code needed please
- Multiple Tables for Lookup
- Excel VBA - Iterative File Problem
- Re: Insert colums in Excel
- Re: Enabling Fill Color in Protected Worksheets
- Grid lines not printing
- Superscripting a portion of a string
- save when populated
- Optimum file formats for import of xcel data to PDA?
- How Enter Amount of Time hh:mm and Sum Time?
- Re: Two y-axes on a scatter plot
- Re: Rolling Year in Excel
- Dual Monitor
- Re: selecting cells using vba
- Count with two Conditions
- Probelms printing
- Re: How to overwright a file and answer prompts in a macro
- Re: Format numbers using prefixes
- Mround
- Format numbers using prefixes
- Keyboard Shortcut Only Runs Part of the Macro
- Bond Calculator
- drop down box linking worksheets
- Re: Formatting Cells to use Min:Seconds.Milliseconds
- Re: Replace all with transverse
- Compare 2 worksheets
- Re: Replace all with transverse
- finding a value in a string
- Formatting Cell
- Replace all with transverse
- Re: Combo Box values and defined arrays
- Using Formulas to Return a Range
- Complie Error
- excel functions for forecasting?
- Insert row after every blank
- CONVERT AN EXCEL 2002 Worksheet
- IF Function
- Function address from VB?
- Re: Function address from VB?
- convert to database
- zoom problem with textboxes
- Finding User Id
- Sort 661 rows left to right
- A simple macro question
- Macro Security
- excel vba 97 - "If" question and how to associate
- left, right,mid?
- Hyperlink Default
- Month Data in a Pivot Table?
- Subracting days from a date (in workdays)
- Month and Year Only
- Convert 00:00:00 to a plain number
- dynamically filtered pivot table
- Select Method of Range class failing???
- *insert cell* + 5
- Sorting does numbers in weird order
- Auto scroll to current date
- How to Organize Worksheets
- Excel Pivot table- Multiple Sheets
- Add the Cells
- Formula copying from one workbook to another...
- Directly asking about Indirect func.
- Re: Countif with a condition?
- Re: Countif with a condition?
- Re: converting a word table to and excel spreadsheet
- format numbers in hexadecimal
- Named cells to R1C1
- FOR statement taking a long time
- Re: Combo Box values and defined arrays
- Re: Tax Receipts for a non-profit organization
- Trying to put a pivot table report on an existing sheet causes err
- Adding columns beyond column #IV
- Golf
- Adding columns beyond column #IV
- =SMALL(A1:A10;6) returns #NUM error
- Counting entries in a column
- Printed pages are blank
- 16 digit credit card #
- Excel sheet with link to Word document
- enter a value where i want it to lookup
- how do i join the news group in outlook?
- Extract number from two delimiter
- IF and SEARCH COMMAND
- borders show on sheet but not in preview and they are not printing
- Refresh data in Protected worksheet
- Access-type projects in Excel
- Need Help with drop down list with conditions...
- Re-positionaing comment box
- Help ftp to sftp
- command buttons
- excluding cells from calculations by "marking" the cells?
- Excel almost freezes on F1 : very slow launch of Help
- Where can I find Excel to HTML tag reference ?
- Re: date format in text box
- Change of button colour
- Removing text from cells
- Data Validation-Custom formula
- Automatic CSV Formatting
- Counting entries in two columns
- Excel Hyperlink Problem
- Integers entered mysteriously divided by 100
- "Super Excel"
- Excel Conditional Sum
- Re: Searching in row
- Weighted average in a pivot table
- ITER: 1
- Print Preview
- Re: Searching in row
- Font Limit error message in Excel XP
- Macro executes on Sheet change
- Today's date as 07/14/2004
- File/New in Excel
- Need formula help - date/time, minus date/time
- comparing excel files
- Re: alt+enter in a formula
- Re: formulas appear as text in cells without calculating
- Re: Time stamping
- Re: formulas appear as text in cells without calculating
- How to I carriage return in "text" cell?
- forecasting
- password protect workbook
- Zoom
- Page Set-up
- excel
- Re: negative sums
- Re: Calculator Memory Function
- Re: negative sums
- how to import excel spreadsheet to Word
- timings query
- Re: Calculator Memory Function
- Re: Calculator Memory Function
- File name extension
- E-mailing data
- Re: conditional combo box
- Re: Lookup/Highscores
- donut on the outside series, hole filled in with second series
- Printing set up
- Decimal point - how to change?
- EXCEL Training
- Inserting rows
- Pivot Table formatting
- RE: Calculator Memory Function
- OFFSET function?
- coding a list
- Cell Drop-down Menu
- File does not open
- Re: Scanner input
- Search a Table, find, and copy all data from the row
- Re: concatenator & in macro
- Re: Something other than relative or absolute cell reference?
- Re: concatenator & in macro
- Re: Something other than relative or absolute cell reference?
- negative sums
- Time stamping
- To find the Cheapest Price
- Autofilter limit
- password protected
- smith@thomas - Split and Concatenate
- Excel locks up
- Reference a referenced cell
- sorting
- Version Compatibility Issue
- Can I prevent a worksheet from printing?
- odd behavior of mouse
- Ordered frequency
- Calling Pics
- Making a file name in a formula a variable
- Re: find/replace many links problem
- Re: Putting pictures into cells
- Using GIF image as macro button
- password for Excel 2000 workbook
- Copy & Paste chart into Word
- Last Cell
- Re: Running Macros faster
- Backup in Saving a file in Excel 2002
- Find function
- Excel validation using multiple conditions
- populating a cell using 3 other cells
- Range of Cells....
- how to generate a range of number
- Re: Running Macros faster
- RE: Excel 2003 - Using hyperlinks to jump from sheet to sheet
- excel 97 vba - need to associate values with drop down list choice
- emailing from browser spreadsheet
- Drop Down Filter, Unhide Rows
- Can't sort properly
- excel duplicate range name warning
- Re: warning message
- Re: Excel 2003 - Using hyperlinks to jump from sheet to sheet
- Negative Cell Format
- Trying to finish up a worksheet function (if/or??)
- combine data in 2 or more sheets
- Excel 2000 - Path Problem
- Conditional Format multiple cells
- CLSID Error on excel 2000 start up
- create and email a report
- Excel page formatting and column wrapping ?
- Computing formula for time
- CAE macro for green screen updates with Excel data
- U.W.- Identical Formatted cells in two xls-sheets in one book
- Re: Presenting Excel Data in a report.
- Requiring a cell password
- Excel Linked Workbooks
- Print current page?
- convert Quatro pro into Excel 2003
- Handling very large files (too many rows)
- Protecting a worksheet/workbook with a password
- Req: Formula Array.....
- Cell Padding & Concatenate
- Excel VBA - Memory use on Mac
- Following Hyperlinks
- Concatenate, preserve formatting
- always on top
- Creating Symbol
- Re: Analyzing multiple Pivot Tables
- Annoying ODBC error
- Importing Data from Access
- Add entry to right mouse click dropdown
- Converting from .CSV to .XLS without opening file
- COUNTIF problems
- Problems Setting Columns to Print
- Message when clicking on a link in Excel
- Re: rotate text 180° / upside down
- Capture part of a text string
- Creating shortcut or toolbar icon for "Insert/Name"
- Quikbooks
- Range of Cells
- Military Time
- Worksheet menu Bar Missing
- Re: Consecutive # list with \ before & after
- need help with VBA on opening a form if Vlookup is false.
- Wrapping a print range to a single page
- Keeping Cells on top when printing
- Macros and protected cells
- Message when opening a file
- Re: Message when opening a file
- text to columns
- not printing
- not printing
- Re: conditional combo box
- Re: merging from 2 Excel 2003 sheets into different new sheet
- New to excel-feel really stupid
- Custom Format
- Removing Buttons
- Re: Row & column heading format
- Pivot Table working with dates.
- Excel
- IsEmpty and bookmark help with excel 97 and word 97
- Macro
- Color Banding stopped working with Excel 2003
- Help with forecasting future values based on a current value?
- Bar Chart X Axis Labels
- Help with forecasting future values based on a current value?
- transferring macros from one PC to Another
- RE: Bar Chart X Axis Labels
- Drop List Valadation and Auto Fill
- using beforeprint
- adding data to 1 column in a 2 column chart
- Merging and formatting a cell in workbook_open
- Re: Running Macros faster - CODE
- Excel formula reference book recommendation
- Removing BLANK rows in Excel
- Experience under Manual calculation "kingdom" and some trivia
- Combo Box - extending the number of rows
- Protection sheet - options greyed out
- Counting Number of Identical Entries in a Spreadsheet Column
- Changing all sheets to LANDSCAPE in workbook
- Re: Want black vertical border to show up over gray horizontal border
- Opening Excel Workbooks
- Quick Data Entry
- Protected Sheets & Unlocked Cells
- Trouble with Autofill!!
- Re: Unlocking a protected sheet
- Unlocking a protected sheet
- Re: Unlocking a protected sheet
- Re: Unlocking a protected sheet
- lookup/total
- Save External Link Values
- godspeed macro
- Sorting numbers into ranges i.e 0-1000,1001-2000 and getting count
- Protected sheet and unlocked cells
- MVP Question Excel Changing
- Re: force sheet one to open when opening an excel file
- Re: Calculate once - "lookup" value once and never calculate again
- Pics VLOOKUP
- Excel Links
- SQLXML and Excel
- Trying to collect data with other data
- Run-timme error '1004'
- Tell the difference between upper and lower case
- How to automatically compare values across columns
- Re: Creating shortcut or toolbar icon for "Insert/Name"
- How to reformat data file.
- Changing "External Data" DSN Details to point to different server
- Comparing 2 columns for duplicates
- Help Please - Conditional Formatting
- Re: data all in column 1
- hlookup row_index_num
- Excel Filter error
- Can anyone help me figure this out?
- Re: Mail Merge w/excel
- Autocomplete entries problem
- Rounfing off to nearest 0.05
- Can anyone help me
- Exported XML Data Not Well-Formed
- Find string within a text in VBA
- Copying based on a condition
- pasting problem
- Color coded arguments
- Invoice. xlt help
- Vlookup
- Adding a link in a cell
- Hide picture handles
- WArning message
- Tools/Options/Security - Remove Personal Information setting
- Cursor jumping
- Print preview anomoly
- lookup multiple values
- RE: Mail Merge w/excel
- Cell reference increments with paste function
- Problem with IE menu's after installing macros
- Time and Date increment
- Excel 2000 vs 2002 Sheet protection & Validation cells
- "Duplicate" Personal.xls
- formulae results
- MS Access
- Problem emailing web-based spreadsheet
- Dr Watson if open a Shared Workbook
- function help!
- copy problem
- Excel VBA - Search and Compare for new entries Macro
- Comparing versions
- Re: Counting Multiple Data in a range.
- formatting text within multiple graphs
- Re: Counting Multiple Data in a range.
- Counting Multiple Data in a range.
- Finding previously used ID numbers
- Count Multiple Data in a column
- Conditional formatting a range
- Help with annual planning reports!
- RE: Conditional formatting a range
- Re: Conditional formatting a range
- Re: Conditional formatting a range
- Undo Save
- Converting Concatenated Strings to Formulas
- Sort hidden rows
- Re: Projecting dates from dates and times!
- Built-In Headers and Footers
- Re: Projecting dates from dates and times!
- links
- Copy Problems with VB
- Inserting worksheet
- Worksheet names
- nested if problem
- Spreadsheet Comparison, nested If statement
- Find & Replace
- Differences Tool
- Select part of column that contains data
- Avg. All #'s on sheet
- Re: CalculatinG Dates
- Re: CalculatinG Dates
- Re: Excel Navigation
- Re: Excel Navigation
- CLSID Excel
- Disable Recently Used Menu Options
- Time issues
- Re: CalculatinG Dates
- Re: Formulas Not Working
- Total Number of Hours
- WIzards
- Help!- Changing cell color
- Creating a timer or "stop watch" in excel.
- Trouble with offset formula
- Merge Cells
- $ sign alignment with negative numbers
- Basic Pivot Table Question
- Error message opening a file due to too many different cell formats
- triple sorting and twice sum
- problem launching excel
- Formatting concatenated text
- Format when "0" is the first letter
- Control Box Problems
- an interesting read
- Urgent ! How to create new row or column in a blank cell
- Pivot tables auto percent
- Data Validation Problems/Questions
- Urgent ! How to create new row or column in a blank cell
- Basic invoice template
- Navigation question
- Solver using macros?
- exporting excel database to outlook contact list
- shortcut key to go to formula bar
- RE: customized page numbering
- Pivot table and buble chart
- Re: customized page numbering
- Startup on grey screen
- need help with form textbox to equal worksheet.range
- Excel 2000... Missing row and column designators.
- Excel 2000... Missing row and column designators.
- Excel 2000... Missing row and column designators.
- Excel 2000... Missing row and column designators.
- Designing score cards
- Gereating an email list
- Protecting Excel formulas and VBA codes
- Question about If using Min
- Copying specific cells ?
- Copy and Paste problem
- Sorting - Ignoring a, an, the
- mailing list sorting
- cell formating- need to put two cells in one
- Copy all file names in a directory into excel
- Microsoft Office Features
- Date Entered,Only Number Symbols Appear
- Excel Won't open
- Average 12 week sales
- Excel File Paths Contain Spaces And Wont Open
- Cell Comments
- Finance problem - retrieving data based on two inputs
- comparing columns in two workbooks
- can't open exel file
- linking to word bookmarks
- How to go back from 350 worksheet to the first worksheet in 1 file
- SUMIF and SUMPRODUCT
- Combining Three Text Cells
- problem with vba application.worksheetfunction.sum
- Maximum value to use autofiler feature in excel
- links to excel file question
- EXCEL-ACCESS DEVELOPER AVAILABLE
- Excel's cells linking to Outlook for reminding
- find and replace with zero as the first digit in a cell
- vba for TODAY()
- Saving web pages as php...
- Rows to Columns
- Lookup External Data
- How to serch for Alt + Enter
- Black Background
- Checking of workbook open
- Slight change needed for VBA Code
- scrub file before submitting
- Bracket use
- Excel Hidden Secerats.
- Naming a cell
- check for double data
- return last four characters in a cell
- Excel Addins
- Advanced exercises
- ~ ambiguous name detected
- Where can I get a free Inventory control spreadsheet
- searching a column for duplicate, then replacing the row.
- [challenging?] Arrays etc
- Using the Find function in Excel
- help with summarizing
- File Saving Issues
- RE: Projecting dates from dates and times!
- Automatic entry of # in cell
- Lost save option in excel after creating Macro's
- Vlookup and #N/a
- stacked bar graphs
- shifting of nonblank cells
- Excel says file is reserved
- Re: split address
- Re: green triangle and null
- Info about external file on a cell on Excel
- formula/s
- formula/s
- formula/s
- formula
- Formats
- File will no open in 2000
- "No New Fonts"
- Checkbox & List Box
- not enough rows
- Excel 2000 Compare Worksheet
- Need to move decimal to the left two spaces
- Password protect Excel spreadsheet
- formula
- file changes on its own?
- Summarizing data from one worksheet to another
- Current Printer is Unavailable
- Re: Install Report Manager add-in
- Re: Install Report Manager add-in
- Filtering of prescription rows (records?) for Excel 2000
- Change to upper caseUpper case
- arrow keys changed function
- Alphabetizing/VLookup Problem
- Help with a checkbook register
- Formatting Columns of Percent Data
- consolidating data from 2 worksheets
- Mail Merge Wuestion
- Publique sus archivos Excel en la web en tiempo real
- Question about merging
- Combining data from 2 Columns into 1
- save as filename
205
vBulletin v3.0.5, Copyright ©2000-2008, Jelsoft Enterprises Ltd.