View Full Version : Excel Questions
- average if help
- Data tables in a chart
- Dates in IF Functions
- Compound 'if' functions in Excel 2000
- TroubleShoot Delete Row Macro...
- array formula resize cell
- vlook up code
- Mark duplikate or similar cells
- I am so stuck with this coding... Any ideas??
- Selecting buttons using VBA
- Import data/Graph Concern
- Help with SUMIF
- Formula to count and return top 5 + count of top 5
- Userform Help Specific cell
- macro to remove numbers from cells
- Double value vlookup in Excel 2003
- Evaluate in VBA using Array Formula
- Inputting =
- Sumtimes code works other times it doesnt
- Trying to Autofill until reaching specific cells over and over...
- Graphing - Series order (Sorting)
- VBA for data validation list
- Attn: Pivot table gurus
- nested IF(ISERROR help needed
- Speed up the process
- Finding the value "Range("J" & Rows.Count).End(xlUp))" in cell not VBA?
- Scientific Format in Message Box
- average if help
- Vlookup Help Simple answer
- Garbabled database cleanup.... seperating city, state, zip...
- VLOOKUP Help
- Need Advice on Excel Solution to Produce a Booklet Type Listing
- Return column header
- Add Worksheet Events to Calendar XL2003
- Vlookup - Trying to get multiple cells as out put from one number.
- Early Binding a native function like 'Substitute'?
- pointer in drop down box
- =if(and( Errors
- Creating a Matrix of Variable Size in VBA
- Data Validation...Can't get INDIRECT to work
- Programmatically create multiple PivotTables on New Sheet
- IF Statement - Combining AND & OR
- Help with formula
- Naming Worksheets from a List
- question UDF array returning function
- Search for Text String in a text document part 2
- Combining Fields
- formula to count alternative Column
- Password box for protect and unprotect worksheet
- Msgbox Help
- Making A Spreadsheet Name Anonymous
- lookup across multiple workbooks
- If Statement Referencing Parital Text
- compare two columns, if missing insert missing data
- Scheduled Macro, Can I set a time for a Macro to start?
- Return a variable's name...
- Help with MAX/If formula
- I need help!
- Converting inches to feet.inches
- Header row sort problem
- Search a column & return many results
- Common mistakes not leading to errors
- Keep Getting Error With Public Variable.
- Code for Date filter need to alter!!!
- Formatting cells from two sets of data.
- Nesting Formula
- Disappearing Addin List
- FORMATTING color
- 0's and blanks IF problem
- Unique Items
- look up multiple ranges
- Too Complicated
- Incremental Variable Names
- Copy and paste all data (cells and charts) to a new Excel application
- Macro to Hide Columns/Rows
- Can't Open Workbook
- More than 7 nested if statements
- Save As Dialog - specific location
- Locating Dates from another Workbook
- How to get TEXT attributes to propagate to linked values
- Excel 2007
- Frustration with date validation in Excel vba
- form checkbox doesn't move with the cell
- Forcing userform text boxes to be filled
- Formula Problem
- Formula Help
- Time Stamp Macros
- Regression slope doesn't match the slope / linest formula! Help!!
- VBA Wait
- Multiple Cell Sort Problem
- nested if solution
- retarded "A pivot table report cannot overlap another pivot table report"
- Trigger for email notification
- How to say macro select sheet name from cell. To paste copied data.
- Vba CodeAuto save every 5 mins?
- Formatting
- Sizing of Graphs
- Need to filter worksheet by Cells that Contain specific characters
- time management
- lost vba password properties
- Using Excel UDF's in a pivot table
- VBA: looping through an array of tabs
- Closing Workbook
- Long text displays as ### when format=Text, ok when format=General, but XMLMap resets format to Text
- Count Max Number of Columns?
- Data Validation listing
- Is there a way to copy 4 times and append _01, _02, etc..
- Copy cells to other sheet based on date
- Fix Macro Location?
- Macro for getting % change between data in two different PivotTables
- Command Button and list box working together
- how to create difference matrices (lag data transpose)
- How Can A Command Button Function For Two Worksheets?
- Self deleting/destructing excel file
- Getting Last Numeric Value in a Range
- Macro Advance filter
- How can this be done??
- I need a way to sum every 2nd cell in a row
- HELP! Formula Nesting
- Time/Number Anomaly
- Copying Formula
- seperate names/rows with colors --> new row?
- Rank Data Based On 2 Columns
- Read Only workbooks
- Solver VBA: Complicated SolverAdd question for static constraints
- Delete cell-value (not cells!) based on corresponding cell format
- vlookup
- Auto signature as mentioned in the .TXT need Help
- Multi-level grouping of rows macro
- Round Down to Nearest 5
- not case sensitive
- Advance Search
- Excluding data from a chart
- Drop down List based on criteria
- COUNTIF help
- VB Code to save workbook
- Check to ensure data is filled in :s
- Protect question
- Excel File Size
- Urgent Countif question
- VB Mail Workbook
- Help with codes
- seperating data
- SUMIF function
- SUM function with an IF statement???
- Consolidating by 2 keys
- AUTOMATIC formula FILL!!!!
- Userform --> Text contctnt copy
- Replacing Sheets statement with variable
- Formula Explanation (=IF(W8=1,IF(X8=T8, 1,0),"")
- Center Userform
- Add Value
- Count IF and IF then Subtract two times in 24 hr Format to recieve time on task
- This is silly - 'virtual' blank cells!
- howto make a VB6 subform modal with excel
- Macro to clear contents of Cells
- VBA Counting Number of AutoFilter Columns
- Quick qtn - pls
- Macro for copy paste to run with a formula
- Vlookup with IF statement?
- Macro Query
- Excel 2002/XP SP2->SP3 effects?
- Old Lotus Habit
- loop values of a combobox + verify in real time
- Transfer data based on 3 criterias
- Computing Calculated Fields in Pivots
- execute cell contents
- Complex Sort
- Date in Header
- ADD two cell's and add comma!!!!
- Data sorting on multiple worksheets.
- match formula
- Data manipulation between 2 workbooks
- Sum if question
- CountIf question
- Debugging Qtn - pls
- Help with loop?
- Error message.
- Macro to copy a hidden sheet and rename with an inputbox
- Vba Print Command Problems
- IF someone give me the answer AND it works THEN I'll be happy ;)
- Deleting unwanted rows
- Need to calculate difference between date/time fields
- Julian day with time conversion
- Cell Reference / Replacement...??? HELP
- Gathering data from different sheets into a third one by using macros
- Market data feed?
- How do I Copy a Range of Hyperlinks
- Find First Blank Cell & Copy above formula
- Pivot Page Field: Multi-criteria select?
- Setting NumberFormat of value returned from UDF
- Removing quotes from a text file
- Subtracting Percentages Issue
- Macro makes decision based on cell color
- Excel & Powerpoint
- Pivot Tables
- Importing data from several txt files in a given folder
- Working out a time differance
- Macro to add data to a table
- Deleting entire rows of duplicate names
- Unprotect timing issue? Step-thru works, Run doesn't
- Formula for certain sized cell groups
- Button Command
- Find and replace a specific letter/number combination
- Comparing two lists and summarize differences
- pasting values without trumping my validation
- Screen Flash
- How could one “auto-increment” only part of a formula?
- UserForm Maintain Data . . .
- How can i look for a character or an operator in a FORMULA
- code to make whole row unvisible
- restoring window from vba
- Code or formula for State lookup
- Worksheet Name Function Error
- Separating cell values based on numbers, letters, and symbols
- Counting multiple cells with a condition in the middle.
- Recording real time interval after event trigger
- Time Translations
- HTML file named as CSV
- Left CTRL C = cents symbol
- Sum across sheets with variable cell reference
- Last 3 results in a range
- Protection using Windows user name
- URGENT: Help with hidden rows needed
- Concerns about connections to SQL Server
- Help with VB
- Price List VLookup
- Pivotreport Data Manipulation
- Making a long list of option buttons
- Copy folder file names into a sheet
- Copy folder file names into a sheet
- VBA Help with copying Filtered Data in to new Sheet
- Choosing Range Names in VBA
- Compare folder and filename
- Help with Simple IF Function
- object defined error
- Rounding with Excel - many formulas
- Excel vba checking cell for spaces only
- Not sure whats up with this
- Can I make my VBA code automatically update the cell location?
- Using FormulaR1C1
- Muliple Cell Filter, move values to matching column
- Merging Multiple Worksheets
- VLOOKUP Refernce
- Query Excel data?
- VB code to place formula in cell please
- Help in Pivots
- Code is not capturing an address for me
- Excel Services question
- 2007 file with macro slow in opening
vBulletin® v3.8.7, Copyright ©2000-2012, vBulletin Solutions, Inc.