View Full Version : Excel Questions
- Select Date in Range
- Using Cell location
- How can I count this group?
- HOW TO stop #NA appearring in index and match function?
- VBa form question
- complex vlookup help
- How to find the first non blank cell in a range
- Can this code be simplified.
- data from pdf file
- Assign a constant from a cell value
- VBA Compare two Sheets by Row
- Seperating 2 different numbers in one cell to other cells
- Tricky Transpose Duplicate Formula
- Excel email alerts
- show userform when cell selected
- MS Query Help
- Creating a button for a UDF
- Change cell colour
- Quick Question Vlookup
- Excel Get External Data from Access with .mdw
- How can I select groups of worksheets?
- IF Function and Color format
- Unhiding Sheets
- ListView Question
- code to add "00"
- Sheet Protected Indicator
- Reading zero as a value
- Find first instance of a value in a column
- Capitalise characters after full stop
- CountIfs
- Array formula in one cell
- Delete duplicate cells from a column
- Return rate based on name
- defining rows to be repeated at top of page
- date recognition in referenced cell
- Insert x number of rows based on x value in Column E
- Pivotcharts/tables
- Insert hyperlink from browser
- Stripping out defined names
- MATCH formula
- Change excel's background color
- Runtime Error 1004 - Selection too large ???
- Vlookup & match?
- Ifs , Vlookups ... limited... match / index
- Returning two figures using Dim as Integer
- Subtotals - Grand Total figure doesn't match
- Excel 2007 glitch, or is it me???
- IF a value is within a range of another value.....
- Macro to rename tabs and open and copy text files into Excel
- Zipping a Folder ?
- Chart formatting ?
- IF statement in code
- http.send blocked by firewall...
- Spell check warning message
- Drop-down list arrow on left-hand side?
- Custom Cursor
- Refresh excel in run time....
- Multiple Countifs
- Array
- need to total mm:ss
- converting from Rupees to Rupees in lacs
- Userform TextBox converts Numbers to Text
- Workbook AFTER save event?
- Countif question
- Macro Question.
- Save File Special, Values Only?
- sum product failing... range whole column, can you ?
- Piviot Table Puzzler
- Checking references via VBA code
- global variables initialized when...?
- VBA excel runtime error 91 - code working and not at the same time!
- Can numbers be separate in groups by delay result?
- COUNTIF with blanks producing error
- Change MSForms.control value when referring to the userform and control by name
- Consolidation of Multiple Sheets
- Multiple sheet Calculate
- VBA Transfer a number with a leading 0
- Issue with excel graphs
- Hyperlinks within Charts
- UDF in E2007: inactive after re-loading file
- Changing Default Paper size to legal for a workbook
- Macro Autofit row height to display wrapped text
- Use of Count Function to comply with two requirements.
- Scheduled update of links
- How to insert audio file alert to a conditional result
- String manipulation
- Count Date only once
- Rounding up currency to specific values
- Date Stamp Question
- Old Question - Needs new answer! Hide/Unhide rows with checkbox
- Extract Bold Letter
- Separate first & last names
- Converting Multiple Variables to a Common "Scale"
- Random Errors Using Random Generator
- Test row for hidden property?
- Sumif, Multiple Criteria, With Wild Cards...Possible?
- Populate a spreadsheet using macro
- Using time, minutes and GBs!
- File Name not at top of page
- Conditional Formatting to create a calendar
- Column/Row Formatting....Is this a bug?
- copying user-specified column
- Formula Help
- Pivot Table Question
- Excel VBA - Replace function acting very weird
- Running a macro in another workbook
- can't for the life of me figure this one out...
- Hiding Rows Based on 2 criteria
- Formula Help...Please
- Graph Help
- VBA to change the value of a named cell?
- powerpoint vba shortcut
- Copying entire sheet to a new workbook (and ignoring macros used for that sheet)
- roundup
- Object variable or with block variable not set, run time error 91
- Finding Average Help
- Creating Multiple Worksheets based upon cell value
- Run macro after dropdown selection is made
- COUNTIF with 2 conditions
- Easy one for VBA lookup
- Identical values from dropdown list problem.
- macro to insert formulas in blank rows
- SQL in MS Excel
- One Cell, Multiple Vales: Filtering?
- Excel Import from SQL Security
- count text values
- Gaming wheel
- Can you use sumproduct and offset in one formula?
- Need to change multiple formulas in 'DATA' sheets based on value in 'CALC' sheet
- Excel VBA Error 2042
- Text Boxes instead of a ListBox
- transferring a line of data to be used as data on another worksheet
- Time Macro - working, but not sure how to expand on it...
- Pivot Tables Macro
- Need one range to equal a dataset on another page
- Seeking method to prevent a page from being sorted
- Excell 2003 please help
- 2 files linked to same source file.
- Status bar
- Vlookup multiple records
- userform multiple txtbox.value check
- add footer to all worksheets in a workbook
- Vlookup left
- Extracting payroll data
- Average Time
- Why is the following code wrong?
- Date formula help
- Goal Seek - Excel Mobile Version 6.1
- X-Y graph issue
- Date ranges?
- Macro to Automatically Fill in Excel Sheets
- vertical tabs
- Best match, given several criteria
- Font Size
- Follow up: what is wrong with the following code>
- External Application Checker
- Formula assigment in different panes
- Newbie question re:userforms
- Complex Formula help.
- Using a formula in If Function
- VBA code to tranpose table data...
- Complex Date Formula Help
- Inserting data values from Excel into a Word doc using bookmarks
- combobox doesn't work at runtime
- 3D Chart
- using SUMIF and TODAY in same formula
- clear all unlocked cells
- List Box print range
- Betting System
- macro between two workbooks
- Limit number of decimals in Formula Bar
- Proper Syntax to delete non-contiguous rows?
- decimal seconds
- how to replace similar course names by one new name
- Filter data
- Run time error 1004 - Object defined error
- Shortcut for Makeing a Cell CONSTANT
- search for text
- Eliminating #VALUE!
- Formula Help
- Vba to print to different printers
- Calculate What the Daily Compounded Interest Would Have Been?
- Adding additional data to a stacked chart
- Bold Part Of A Text String
- Last Day of Month
- Conditional Format Problem
- Adding text with number
- Macro Help PLEASE......
- Importing csv file into Excel "Junk" characters
- Associate word and color..in a cell!
- SumIf with multiple criteria?
- Can Excel Solver include a VLOOKUP????
- Need Help with multiple option formula
- VBA Question
- Trying to Create a Tab in a workbook based on a column of part number
- Chart not plotting using VBA
- Introduction to SQL tutorial for Excel users
- Divide a number by contents of another cell
- Multiple rows and columns into single column
- how to pass an array with a variable number of rows from vba to excel
- Not sure how to title but has to do with columns and userforms
- UDF or Vb to hide rows depending on contents
- overtime calculation
- Ranking a list of alpha, alphanumeric and numeric values
- Conditional format or UDF?
- Help with RANDBETWEEN
- EQUATIONS reading row the wrong row
- Excel 2003: Array Formula: x and, y or z
- Time Formatting
- need help with macro
- Retrieve data from excel database
- Dates
- Summing Using Blank Row as Qualifier
- Close open Book*
- Help w Extracting numberic values from an array of text string
- insert with character between letter
- ignoring hidden/filtered values
- Drop down list macro
- count blank in first contiguous blank cell
- 2003 help
- Excel Date Formula to exclude weekends
- Move excel Files to different folders
- Extracting cell data from closed excel workbook
- list non blank data
- Adding a baseline to a graph
- data import from MFD
- Adjust Pivot Table Field to show Cell Value
- Excel 2000 - Analysis ToolPack Add In
- Automatically deduct lunch breaks
- New to 2007
- Name Ranges = Worksheet tab name
- how to use choose function with band 1 and band 1a?
- Font changes & Space Saving for Pull-Down Menus?
- formula for returing a specific work
- Wildcard in Replace Macro
- Pivot Table Calculated Field - Null Values Treated as Zero
- How to setfocus textbox framecontrol
- Excel row data saved as HTML file
- Unprintable section?
- Custom Tab Order
- Ranking using excel
- Vlookup nested in offset
- Negative Number value for time formula
- Sum all Sheets based on lookup value
- Formula Auditing Across Tabs
- Powepoint linked from Excel Model freezing
- Excel 2007 bug - Paste as Formula then multiply
- Creating Log Function to trace error
- Excel 2003 Now Opening All Files Instead of Excel 2007
- excel match then cut and paste
vBulletin® v3.8.7, Copyright ©2000-2012, vBulletin Solutions, Inc.