View Full Version : Excel Questions
- Vlookup table_array text reference question
- Dow 30 Combination Experiment
- If statement help
- formula to find and place a number
- Open .accdb Access file using Excel 2007 VBA
- YTM problem in excel?
- Formula required
- Bloomberg Excel formula
- Rank Formula With Tie Break
- Timesheets!
- Change cell background when using multiple values
- SMALL & LARGE function by code.
- Most efficient way of creating a Follow up List
- Activating Open Workbook from a Cell ref
- Formula Offset help
- VBA Save Sheet
- VBA Grouping Rows
- I can't figure out, but I bet it's easy...
- sum if date
- Tab color based on list
- connection file that is incompatible
- Conditional format base on varying data
- Clean way to sum two cells from another workbook
- Golf Skins Scorecard
- Find Last Date
- run a filter from a hyperlink
- VBA: How to read table´s order status (Ascending/Descending)
- Cumulative Total or Running totals
- Ordering based on a template
- Run-time error '-2147024809 (80070057)
- Find earliest data by date
- excel2003 move file from one directory to enother
- Macro To Record Data Into Next Available Row
- Multiple Vlookup at one time.
- SQL Alter Table - Remove NOT NULL
- sumif from multiple tabs
- Duplicates not removing correctly...
- Sort Automatically by column
- How do you crop a number in a cell?
- Get current keyboard layout with VBA
- VBA Copying Data From Open Workbook
- VBA, Defining the current workbook as a variable
- Setting Label Captions equal to cell values
- Accounting format display problem
- excel 2010 and entering formulas
- start in new range based on criteria?
- past special
- crawling buttons
- Change a column with multiple words to just one word?
- Seeking to insert formula via code, when cell <> "unused"
- changing text in a cell if data is entered in another sheet
- Change a column with multiple words to just one word?
- Vlookup Function
- VBA Excel 2003 vs VBA Excel 2007
- Hyperlink loses link if cell moves
- Defined Names formula use
- Combing multiple rows of data from one column into one cell
- looking for code
- VBA to Create button [Activex or Form] in sheet1.
- VBA Dynamic Array
- VBA - File Location from cell contents
- Secondary axis - CHARTS
- PowerPivot RELATED function with dynamic column reference
- Auto hide rows
- Grouping a pivot table
- Help with worksheet function
- Delete row Macro
- Copy data from one workbook to another
- close a shell of a windows explorer window
- Adding Custom field to Pivot table summary
- Help with a formula
- keep visible list
- Using worksheet_change to alter a different worksheet
- Match/Index Problem
- Catering excel file
- RSS import to Excel
- Question about this code
- Need excel formula to randomaly distribute.
- I need some macro help
- VBA to create multi-sheet workbooks from dataset
- Macro Button to Create Page from Template
- Formula for removing numbers from a cell
- Conditional Formatting
- Macro To Colour In Rows
- Pivot Table with Multiple Data Sets
- Macro Question
- Some Kind of VLOOKUP?
- Counting total number of specifc characters in a cell
- Vlookup, Index&Match,Sumproduct not working
- import txt to excel
- Clearing, or "unclicking", user created buttons.
- Lookup reference to return list of missing UPC's
- Copy from Sharepoint Calendar
- Formatting a formula
- Copying and Splitting Rows Horizontally
- Rsq in array formula case
- Chart the last 25 readings
- copy print areas from multiple sheets to one sheet
- COUNTIFS equivalent in 2003...?
- Modify command to support infinite values vs fixed amount
- =if(counta) problem
- Macro Print Buttons Disappear after single use
- Powerpivot date problem
- VBA help importing survey data into Master file
- Sumproduct with range restrictions
- Running Excel VBA from VBScript
- vb code change help
- VBA and Pivot Tables
- Best formula to use
- deleting values
- Paste a cell's contents if another cell's value changes
- runtime error 1004 paste method of worksheet class failed
- Hiding and Unhiding command buttons
- Workboot visibility and set active
- workbooks.opentext causes error number 1004
- Unable to add to dropdown list
- compile error on a listbox
- Look up a name on one sheet and show its value in another
- Return a value if..
- Sum with Multiple IF AND OR Conditions
- An error message
- basic sum but anserw wrong?
- VBA: Check if a workbook has macros without having the "Trust access to VBA project" option checked?
- Newbie needs more help...
- VBA: Searching and extracting
- Continuously Updating Sheet for Changing Oil
- Merge cells and add text
- replicate form publishing to another worksheet
- is it possible to change dates 1 to 30 march to 1 to 30 April at once using find and replace ?
- Open ASP files in Excel
- Move row to bottom +1
- picture of the best player
- SUMPRODUCT, selecting a range to count
- How to Validate Data in Cell using info from another cell?
- Calculation of Fraction values and auto date format issue
- How to find multiple identical cells & add values contained in their rows
- Copy Transposed if meets Criteria
- Need excel formula help to Round up/check the critiria and assign the code using if.....Thanks for helping.
- Sum Sort Of Count Formula
- Highlight the cell value/value
- Putting A Zero In Front Of Numbers
- Help Needed
- Change data source: From another pivot table?
- Macro or formula to transpose data
- Removing digits from a cell
- Complex Formula
- assigning Permission in excel help of macro
- Help with SUMIFS function
- Form Controls
- Date cross reference
- Here's a very easy one for ya's....
- filters + countif statements
- Macro to add 0 to a cell containing numbers in Text format
- Merging Various versions of a work book in one.
- Why isn't 0?
- Hiding more than 512 items from a Pivot Table Filter
- Macro from outlook to excel
- Convert number in (Deg) to direction (Text) N, NNE,...
- Indirect Help
- Transfer data from sheet1 to sheet 2 using VBA
- Macros and Option Buttons
- Sumproducts
- Transfer data from 1 file to another (Criteria Based)
- Find Duplicate / Count If?
- sorting issue - simple but annoying!
- Odd Result Using RANK and MIN
- Delete Columns with Condition
- new to userforms..question about populating a lable box
- extract number from a alphanumerical string?
- Excel: Formatting
- Word/Excel help required
- Formula Teaser
- Need Help! Macro
- Drawing data out of a graph
- Msg Box won't appear!!
- Copy_With_AutoFilter issues - macro
- Auto-open a user form
- Macro To Tell Me There Are Too Many Characters
- Cell appears locked but isn't?
- Variables in row...select statement
- Count of unique value based on certain criteria on a table range
- Cell with Format in text needs to show 10.0
- More Cubevalue/Cubeset questions
- Copy value from one of a number of cell depending on which contains value
- No way!
- Add 2 rows via VBA Help Needed
- Excel freezes every time I try to format cells
- Unlocking sheets with VB password
- Loop Error
- Summing an average with 0's
- Formula help to add one day more in date format mm/dd/yyyy
- Clear range of data
- More decimals??
- Convert Cut -> Copy, Paste -> Paste Values
- Compare date with todays date
- Having problems moving the selection on a protected sheet
- VBA and Parallel Port
- move data from form and paste into seperate worksheets
- Count the coloured cells
- User form and date
- link TO an cell from email
- Now() function. Problem when trying to compare
- date formula
- Macro to clear Data
- cell.address / variable with cell.find
- Macro to delete rows containing #N/A
- Timestamp Issue - no undo feature.
- VBHTMLMaker...what about Excel 2010?!
- VBA to check and see if addin is loaded
- Color Auto Fill
- No idea?!
- how to delete debit credit column with same reference number and same amount
- Filter the cells with specific colors & add the corresponding cells
- Conditional Formatting Arrows - Centre
- workingon protected sheet
- RE:how to delete rows if same refno and amount shown in Debit and Credit column
- Timesheet Formula Hair Pull!
- Excel 2007 and sheet protection
- Flexi Sheet- Show over 24:00
- years and months between two dates
- remove duplicates
- Excel and Publisher
- Password Protect Macro
- Transpose Excel row data to a form
- Question about assigning position within group
- Locate adhoc addin
- Format a TextBox on a Userform to 2 decimal places
- File size increase from .xls to .xlsm
- copy down formula
- Referencing cells
- Automatically create a PDF invoice
- Trouble uploading to Google Docs
- Known issue with printing?
- Subtract a range of cells
- An error with advanced filter
- Lookup based on 2 values
- Random number generator without the Rand function
- Left / right...?
- Lookup a value and copy
- if cell equals x then clear contents from another cell macro
- load a combo box with a list from name
- Is that possible in Excel?!
- Enter the fixed date when data is entered into a column for multiple columns
- help?
- Saving A Workbook With A Varaiable File Name
- Fuzzy matching in Excel
- Sorting without selecting in other worksheet?
- MTTA (mean time to arrival) & MTTR (mean time to resolution)
- Macro for Extracting content of Cells containing multiple lines
- Compare columns
vBulletin® v3.8.7, Copyright ©2000-2012, vBulletin Solutions, Inc.