View Full Version : Excel Questions
- Total sum of counts formula
- add more columns???
- Pasting to thenext available row using VBA
- Excel Kill Switch...
- Macroing a Pivot Table help
- Writing VBA data to Excel spreadsheet
- Button Control...Do I need Macro?
- Clear Contents if LEN=0
- Got stuck with formula! Help
- Conditonal deleting large data set - please help
- Can someone correct this formula
- Unique ID, Multiple Rows, Truncate Data
- Conditional Formula needed? Maybe?
- Indirect Function Summary Tab Template - Need Help!
- How to get Value of the Left Cell?
- hover and display data
- Automation error
- Macro Help
- Formula to calculate a result within a percentage range
- Cannot create or use data cuz too complex
- If formula VBA Help
- Count for Formatted Cells
- help?
- average visible cells only - VBA
- Allow only one answer in row
- extracting and sorting
- Macro to unlock a variable cell
- small, if, countif
- assigning value to a cell from a cell on another sheet
- excel get email from last 24 hours
- What was the previous selected cell.
- Days between dates formula
- Convert 215 to 2:15
- Max 125%
- Strange Worksheet 'Formula Calculation' Behaviour
- Clear contents in Cell
- IF(OR question
- access query with excel vba
- Need to Bold Part of Formula
- How to set autofilter field values by controling other cells?
- Complex text extraction formula
- Using For Next with Do Until inside of it
- Conditional If Statement
- VLOOKUP function not working properly for numbers formatted as text
- Labeling Scatter Points
- Pull Value from a Cell Using Formula
- Pivot - Grouping the only option?
- Amatuers Need Not Even Try To Solve This
- excel macro called through outlook
- Help with Formula- Returning VALUE# Error
- Excel 2007 inserting percentages into PivotTables
- Autofilter Selection Criteria Referencing The Content Of A Cell Range
- Identifying Numbers 5,10,15,20,25, etc.
- Filtering a range of dates
- Link Text to another Sheet
- Trying to speed up a macro that creates a vlookup for huge datasheets
- Excel 2007 - dual axis
- Data Sort
- Help with formula....
- Search Forms
- Auto filter and Lists
- Count items in workbook with script
- Scroll Bar Macro - Runtime error?!
- Delete Blank Rows
- waterfall chart challenge
- Macro to add row, and input 1 piece of data
- copy / rename / move
- Pop Up Chart
- Pivot Table auto Sorting
- Month over moth percentage change formula
- Financial Report - Pivot table doesn't do it.
- Delivering a 1-2 punch with =IF(VLOOKUP...
- Sum, Offset and Match formula - need help
- Copying and Pasting Macro code
- Second, Third, Fourth, and Fifth Modes
- How do I make this formula return a blank
- How to summarise specific elements of a large dataset
- Can this be done?
- Runtime Error 1004
- Simple sort macro that allows sheet names to be changed
- How to..insert Input Box into Formula
- Insert & Move Picture
- Deductions
- THREED function
- VBA will not run when another spreadsheet is open in internet exploer
- Copy code no longer working...
- Macro - selecting bolded text
- VBE Properties Window Disappeared
- Summing wage hours
- Resetting the shape counter?
- rounding with forumla
- Making sense of large data tape
- Complex Look Up
- Question about reading data from Pivot Table.
- Hide Columns Based on Cell Contents
- Ranking Formula Help
- IRR function.
- current region: works in immediate window but not in module
- ARIMA question
- Formula for auto text based on a date
- Macros to filter a OLAP pivot table
- How to change Font color...?
- vlookup the date
- Search for Keywords in other spreadsheets
- Charting problem with an outlier
- Running Totals
- If stmt and date range for leap year
- COUNTIF or DCOUNT or DCOUNTA
- Rental income expense workbook?
- Is there a generic way to check if some VBA code is currently running ?
- How can I make a label visible before saving the workbook?
- Multiple Conditions True
- Populate cells using a List Box (Form Control) with multiselection
- copy and paste
- multi color function
- Send Keys for ORACLE R12
- Data Validation
- Random numbers
- Highlight Matches
- Text Separation
- Change /translate cells and save in new doc with scheduled macro
- Pivot Table Collumn Format
- Pivot Table problem
- If 'A1' =... and 'B1' =... then 'B2' =...
- Date format issue with CSV data
- Object doesn't support this action
- Formula checking help
- advanced cascading selection boxes
- Remove conditional formating but retain colour
- time calculation
- Zero Values
- Speed up Looping Macro
- Help deleting macro!
- Macro Issue
- Attach file between 2 paragraphs in Lotus Notes
- Filter Cells in Locked Spreadsheets
- making conditional formatting fill colours permenant
- Reading data from the text boxes in a group
- attaching a PDF to be viewd with such a click
- Making pivot table field a variable
- Multiple "If" formula
- SUM and Wildcard search
- Arrange Rows and Column
- Search from list
- Finding last populated cell, using this as to copy and paste and number of other cells
- Multiple Rows in a single cell
- Pivot Table "Page" question
- automatic date
- Holding/ saving data in a textbox
- Macro to seperate Tel No
- Searching a column
- how to attach a file without Hyperlink
- QAT not running macros anymore
- Can anyone help me with this please?
- Delete rows based on criteria in cell
- Date formatting
- userforms - combobox cell update
- Formula to Find First Blank in a Range
- Extracting cell data via a formula
- Sumif+a range of figures
- Using VBA Find to Copy Range
- Conditionally format a cell with VBA
- Pivot tanble ranging
- Text Boxes Excel to Powerplay
- Next available row
- Arbitrage bet calculator problem
- Data Validation sheet1 to sheet 2
- Trouble averaging a column with "0"s
- Formatting data linked to other cells
- treating (.) as figures (Excel 2007)
- Lists Data Validation
- Need solution for filtering and appending
- Combining the Data
- Hidden Links - Breakage required
- Please some body can help me on this
- Simple formula question for excel?
- Linking large fields of data to set Template
- Exclude 0 From Average
- Quarterly/Annual report with VBA
- Connecting cells???
- VBA Excel 2007 multilevel sort
- Counting number of duplicate rows.
- Percentage Diffrence
- insert formula into cell as part of a macro
- problem changing regional settings, vba
- How to use poisson distribution in a simulation
- Go back to the previous worksheet I came from
- How to monitor how long you spend in files using VBA
- Using a Cell value in a formula
- Moving files with macros
- How to select the last day of the month?
- File Size Issue
- Wildcard * in pathname issues
- automatic calc/manual calc.
- Help with formula: frequency, duplicates (more?)
- Sum coloured cells
- vlookup using two sources
- Date handling in VBA
- Parsing Macro
- Copy from one cell to another using VBA
- Formula to list unique names in range
- Macro to cut row based on certain criteria
- Column Move Macro
- Dealing with an undeclared variable
- Switching between userforms - egg timer!!
- Easy Quick Lookup Forumula Help
- How to get those plus/minus sub-dividers on left hand side of excel
- Value not available error
- Very hard Look Up Formula or Macro!
- 3 dynamic comboboxes, 2nd dependent on 1st and 3rd dependant on 2nd in VBA
- Few Rows and Columns, But BIG File
- Creating a folder
- VBA Output to a specific column.
- Why isn't there a User Defined Function to calculate FIFO?
- Please somebody help... Sort Occurrences of Duplicate Values
- Formula not working in nested loop
- Vlookup won't work after importing data from a website...
- Links in OFFSET formula
- Very Detailed IFs and VLOOKUPs Help Needed
- Using VBA to change a pivot's 'Drop Page Field' that contains a date
- Clearing cells after a block of text
- XY Scatter Lines Disappear When Plotting with Gaps
- Getting Lotus Address book Info from VBA
- If(iserror...
- TEXT Function
- should be simple...but
- running slowly
- Switch to a Better Method
- Autopolulate worksheets and filter the results?
- VB Excel to a text file
- Groupwise
- Column selection base a Value in range...
- Create new folder from scratch
- How to open to a specific sheet
- create vba hyperlink on integer value
- My EDIT menu is missing
- Count fields in red
- Counting numerical entries
- Combine hundreds of Excel 07 workbooks into 1 worksheet
- Simple array code
- Process Each File in A folder Macro
- Selecting specific characters in cells
- Cont Number of Cell Changes
- Need help with Macro
- Protecting hidden rows
- Counting Text Problem-Probably easy questions
- Complie Error - Range
- pivot table
- merge and huperlink cell
- Random Numbers (with no repeats)
vBulletin® v3.8.7, Copyright ©2000-2012, vBulletin Solutions, Inc.