View Full Version : Excel Questions
- My sumif formula isn't working.. at all!
- VBA Excel - leading zeros in number
- Macro to run on specific
- Find next value.
- how to average the last five cells
- Calculate date and time with 2 set of Business hours
- Search specific text in a number of worksheets using VLOOKUP
- Code to copy formula down to the last row of data
- VBA Classes to add properties
- Excel Chart
- Calculate rows and columns based on a cell range reference
- INDEX / MATCH and empty cells
- Using LEN and TEXT for format
- Need excel expert
- IF statement to compare 2 columns and add to a date
- Saved *.xlsx lost macro but it still runs
- Button in VBA code
- Sumif/Sumproduct formula to add all values up until selected month
- Repeat the question and if again in funktion
- Macro - Deleting rows if cell value contains 0
- Address Line Separation! bane of my life!
- Excel VBA to find and replace in a text file, ignoring "".
- compare value
- sumif ?
- Hyper links from VLOOKUP
- Macro to format all worksheets
- Object File
- USing VBA to copy rows based on condition - amendment to macro needed
- Sumproduct returning "0"
- convert DTpicker time to minutes
- Saving PDF document
- How on earth do you set the fill color of a label or textbox on a worksheet? (not userform)
- vlookup on filtered list with sum
- vlookup
- Removing last 3 characters
- Excel VBA General QUESTION
- VBA help Do loop
- Compile error in hidden module: data
- Macro to create hyperlink
- help, i'm getting confused
- sum if question
- Pivot table - Items
- VBA Chart title from multiple cells
- Sumif/Sumproduct formula to add all expenditure related to a particular item up until the selected month
- Display a red X if Range contains the same
- Cannot transfer data from table to table by referencing column headers
- vlookup
- Nested IF Help pls
- Checkbox Question
- Get text string from another using wildcards...
- Resizing the image in PPT using VBA
- Cell Link Disapears
- Change Subscript to Markup Value
- sumproduct disregarding 0 values
- Using a checkbox to activate/deactivate
- How to record data every 30 minutes in Excel spreadsheet?
- Auto generate report on a worksheet from another worksheet
- Macro to copy data from one spreadsheet to another by looking up ID's
- Named Range
- vlookup
- Code to pull data from 100+ workbooks into 1 sheet. Is this impossible?
- Countif formula help required
- vlookup issue
- Conditional format with if
- macro - to read tick box
- List based on criteria
- Max Occurances
- Letting excel calculate with ^n
- In-cell pop-up calendar
- Linking textbox to cell
- VLOOKUP Question
- Excel Printing Issue
- count data in column and identify first
- Recording a macro to populate table from autofilter
- Conditional Format for Date
- Print "If" Function
- Address split
- Forecasing Question
- Sumproduct Array in VBA
- Data Refresh Issue
- Module Questions
- formula
- page breaks everywhere
- Correct my iRow value
- How do i SUM in this crazy way
- Compile data from multiple sheets macro
- Charts - Smoothed Line
- HELP - Bringing in values from a range
- Stuck
- Margins
- Sumproduct Help
- Change Cell colour based on ceertain criteria
- average of total percentages
- Need the Row Number
- Decimal precision in VBA macro
- Help with VB code
- Charting 0
- Creating a Template
- invisible open instances of excel
- Using Outlook's ItemSend in Excel
- xlVeryHidden
- ComboBox & TextBox Cascading
- Search table and return multiple entries
- index matching based on the 2nd and 3th instance of that value
- Formula help
- sum if w/ frequency, len, match, & left functions
- Take what is in B2 put in C@
- Incrementing Page Numbers?
- isna in vlookup
- Is this possible?
- Copy Formatting Question
- VBA for pasting Formula
- Macro help to select all & copy
- Static Time Stamp Output
- Filtering the display of Chart information
- Show bottom right corner of ActiveCell range
- Counting occurances in a cell
- VBA Expert Needed:Copy, Paste, Formatting Challenge : Excel 2007
- VBA Macro help - Year from Date
- Sorting Entire Columns
- Activate sheet with checkbox
- adding items to combox dynamically
- Macro with conditional formating
- Conditional Formatting Equation
- Saved xlsx to xls, but vlookup doesn't work
- Total all occurences of value in a range
- VBA to Find subtotals = to 0 and move associated rows to new WS
- Capturing Copy/Paste Changes in Change Worksheet
- Formula Help!
- Macro that copies and pastes according to range
- Tracking Complete/In Process/Late Assignments Using COUNTIFS or Pivot Table
- Towards a consistent Cell Click event
- Summing the functions of the previous function
- need help
- Creating a Date/Time Stamp
- If Isnumber Question
- VB code to convert multi tab .xls to separate .csv
- "Slicers" in 2007?
- Macro to copy and paste a specified number of times
- Save workbook to location with time stamp based on cell value
- VLOOKUP using a cells value to reference another sheet
- If Someone Feels up To The Task
- variable issue I need pointing in the right direction
- Do I need SUMIFS, VLOOKUP or both or neither? :/
- Sumif from another worksheet
- File burst from Excel in non-standard format
- Differentiate real text and number stored as text
- Change cells' color with VBA based off a pair of cells
- Adding a website hyperlink to a cell where data is brought back using a formula
- SUM n smallest
- latest value
- InsertRowsAndFillFormula stopped working
- Vlookup Conditional Formatting
- Scatter Graph Question
- Macro not calculating correctly
- Help a newbie!
- Bold Header - VBA
- Cell value determining visiblity of txtbox object
- Lose trendlines in Excel 2003
- vb code for date update
- SUMIF function on a lookup range
- sudoku type problem
- Problem with Worksheet_Change and UDF
- Easy Find then Move
- matching ID's in columns to get another columns data
- Conditional formatting ok manual, not ok vba
- Counting Non-Hidden Cells in a Row
- Excel 2010: How to format ALL data point labels SIMULTANEOUSLY
- Activate sheet on cell value
- Duplicates with multiple columns
- VBA to match columns of data and copy to another worksheet
- Over come 255 Character Limit with VBA - Question
- multi line text cell - remove blank lines
- Unique Counts in Pivot Tables
- Diffilculty with my "IF" statement
- Excel 95/5.0
- Macro help needed!
- Simple Coding question
- Import size and align photos
- Extracting numbers in alphanumeric cells (but in different places!)
- Avoiding Floating Point
- Pivot Table Formula Help
- creating a chart excel 2010 problem
- one number from 2 type of criteria
- Clearing Sort/Showing All Data
- VBA to show data from a dropdown box selection
- Need HELP !!!!
- Consolidating/stacking lists
- How to get color to fire an event code?
- Formula help needed asap!
- Countifs and Or combination: Need excel formula help please...
- Finding text in a string and evaluating a result
- VBA Next without For compile error
- Adding Time With Minutes Increment
- Can we supply username and passowrd in VBA
- Macro to configure screen when file opens and closes
- assign value to a date?
- Very Hard Task - Updated Data
- If someone could help, it would be amazing
- Best Way to load a listbox using a combobox
- Probability Generator
- Macro VBA SUB / Module Question
- combining row() with a vlookup
- about to create a complex excel file...
- My index match does not alyways give accurate result: please advice...
- Protect all sheets less Summary
- hex number recognition
- Simple sum and substruction...Need confirmation...
- count text cells
- Pivot Tables
- count text cells
- Accessing Wordart Styles Thru VBA
- Listing Top Performers
- concatenating multiple rows
- Excel Graph Question
- Protecting Cells ( by color ? ) or by Cell Reference ?
- Match Duplicate Records
- Countif question.
- Problem with ranges
- Merge duplicate rows into one row
- IF Statement: Easy way to "reuse" the Test Condition?
- Text Box Validation From A Range
- VLookup With Named Range . .
- Automated Image Replacement Suggestion
- Shifting Market Share using a percentage
- Help Figuring Out How To Get My Index Match To Display Correctly.
- Excel 2007 RefreshAll
- Copy Range of Cells Based on Find
- Sum a Row
- copy a file
- turning column into rows
- Looping through worksheets and delete
- Use Mod?
- Calculator control for a textbox...
- Separating names into rows using formulas
- Combo box source data
- Unknown Password
- Selecting multiple cells from activecell reference (not sequenced)
- How to easily create a chart from 1 column of data?
- Simple Question
- VB Code to compare names
- Get the column header based on criteria in a row
- Text formating
- Parsing data from worksheet name
- Window To Front Update Problem
- Modify delete to allow only single row deletions?
- vlookup based on 2 criteria (text and most recent date)
- Named Ranges as Data
- Export Tabs to Named word tables
- VBA code referring to UserForm textbox text?
vBulletin® v3.8.7, Copyright ©2000-2012, vBulletin Solutions, Inc.