- If statement to cover range
- excel formula formatting result
- Blank Cell
- .0 is creating #VALUE! Error
- Vlookup & Find
- Subtotals by grouping
- Limitations of RANK
- sorting scores
- Repeating headings
- Hyperlink function fails when using variable row number
- uk wage calculator
- excel status bar says "double-click to edit PBrush"
- Counting Values
- Remove text from cell
- How to get Excel to work faster
- msg box
- Counting by a Range of Values?
- excel
- Adding buttons to a new menu bar
- looking up data in another column
- How do recover from DATA Error [47 of 94 93 F4 K5] in Word/Excel
- Automatically multiply be a number.
- cut and paste or something more elaborate?
- Excel Formula - Add column of numbers but ignore negative numbers
- Same entry on multiple sheets
- Averages based on dates
- Preserve existing data whilw using external links
- Display Row label covering multiple lines in Excel Pivot Table
- Formula for duplicate entry
- Searching rows with multiple columns criteria
- dropdown lists
- Sorting Numerical Values...
- FTP Reference
- LEFT / RIGHT functions
- sumif with multiple conditions
- Should I use a macro to copy and paste value?
- Over my head on this one...
- Formulas
- Conditional Formatting based on other cells
- Required Field
- formula
- Shortcut Key for Text Changing Color in MS- Excel
- Using A Public Function /
- Error message #NAME from formula
- system won't allow a conditional format
- Does excel acept arguments
- how do i create hyperlinks
- After rounding/formatting to whole numbers...
- How do I calculate the cost of credit figured as a yearly rate?
- Writing Macros
- Match and Lookup problems
- how to print a page many times but add a unique reference on each
- entering formulas
- Why does this Formula work?
- Find sum across all worksheets
- Need an OR Function that will allow for Text vales.........
- Vlookup maybe???
- Pivot Tables - how do I add in calculated fields?
- Improving formula
- Nested Functions with OR
- challenging formula(for me), counting days between dates for multipleyears
- Vlookup help
- spreadsheet for tracking reports daily, monthly, yearly and graph
- How do you add the three lowest numbers in a column?
- Retrieve xml data from SharePoint
- Re: Help make a date = Day 1 of the next month ie. 20060501, 20060601
- VLOOKUP Question
- Counting Conditional Filtered (By Color) Cells
- Help make a date = Day 1 of the next month ie. 20060501, 20060601
- Single Function to Analyze Two Columns?
- Inconsistent Array Count results
- nested fnctions
- how do you enter more than 7 "if" functions in a formula?
- Random Matrixing Problem
- Fixing multiline cell
- MS Query takes along time to open
- Why does not Excel 2003 Replace comand romove spaces from cell contents?
- Quarter End Date
- MS Query error
- How do i set up a sheet to count the years to retirement?
- best in series macro
- Sorting or if statements reliant on formatting
- Formating cell
- Possible to combine VLOOKUP and IF(AND) functions?
- Summing values from array
- how to use trigonometric functions in Excel?
- Picking values out
- Auto copy of Numbers or date
- how to express > dan < using excel?
- Creating Drop Down lists
- printing columns
- Excel should let me link one cell to another.
- How do you calculate workdays if Saturday is a workday?
- Between? Is there a way?
- How do I count letters and numbers in a formula?
- how do I relace words in new ones in certain cells in Excel
- Tracking Errors
- Nil in Place Off #N/A
- How do I set cells to sum/average/etc time? e.g. 1 minute 30 secs
- combining ratios
- Formula Combination
- Problem with foumula
- Date function
- multiple regression
- I want to relocate a column, save the figures, and erase formula
- Can List or Combo Box have multiple selections?
- Sum range auto update
- How do I compare two simular excel documents
- Excel 2003 multilevel subtotals in wrong positions
- equal sign in front of date in formual bar
- follow hyperlink?
- Cell Formatting Conditional On Other Cells Fill Color?
- Conditional formatting, looking for changes in date
- Macro help
- Finding a "Between" function
- When i try to filter information, excel returns a blank page?
- Is it possible to insert a function within a sentence in Excel 200
- Format date in destination cell
- IF statements with lists
- "THIS" Row Reference
- Date - greater than and less than
- Countif Across the Midnight Hour
- imbedding picture
- Subtract Dates based on 24 hour system
- Figuring Grades
- Count entries in columns and rows
- Cell reference update when copied and pasted
- I NEED A HELP IN EXCEL
- Formula Assistance
- Problem with Excel worksheet in Word file
- can a conditional formulas be setup using text to get a numerical
- Deleted column
- Can I modify the YIELD formula to use a monthly frequency?
- Date calculation
- Advanced filter a dynamic date range
- priority naming
- Problems with IF statement
- Conditional Appending in Excel
- EXCEL
- Excel - allow cell margins similar to Word table cells
- Lease term dates
- Working with =IF(ISNA,(myformula),0,(myformula)
- how do I sum time difference
- use vlookup or other to find the nearest values (<>) or interpola
- Gauss elimination / linear algebra. Please help.
- I'm desperate I posted earlier about "If" statements that don't work but are correct. Now...
- Obtain Easter date?
- Pulling my hair out here
- Calculation of Gross Margin in a pivot table
- Summing cells in array
- Counting unique text entries in a filtered list...
- fractions and decimals!
- How do I hide a formula so it will not show on the spreadsheet?
- I need help with Excel
- Look UP Formula
- Indexing of Name
- How to Convert Figures into Text in Excel
- UK Excel User Conference - July 19-21, 2006
- Using Countif when column A=Num and Column B=Yes
- Help Please! - Creating Function Calculated Fields within Pivot Tables
- Excel Cell References are different to normal
- how do I add a drop-down calendar in excel?
- Adding up data in multiple cells for a single criteria.
- how to use list in excel 2002
- min value
- Bug Report for Excel
- I want to be able to create a dynamic reference in excel, for exam
- Vlook up and if statements (I think)
- Formula needed for 2 criteria
- I'm having a really strange problem with 3 if statements.
- Navigation
- Ranking on basis of 3 Parameters
- How to split worksheet to make smaller
- Ranking on basis of 3 Parameters
- making gains or losses appear red or black in formula
- look up formulas
- use Now() in two cells for start and finish times
- can this function do this?
- Conditional Formatting
- return value other than #N/A
- hyperlink in combo box/data validation
- Excel Conditional sum, lookups and functions help PLEASE!!
- Separating text and data in a column
- Macros
- Macros
- adding to different totals dependant upon selection from drop down
- cell painting
- Spreadsheet Function
- Excel Form and Data Retrieval
- Invoice Comparison
- How to Share & "Un-Share" Worksheets
- elapsed time problems
- Can I freeze column A and scroll down the other columns in Excel?
- how to retrieve information that was saved on a floppy disk?
- how to do a dynamic ranges?
- how do I update the scenario summary sheet?
- unable to grasp SUMPRODUCT
- edate function
- stuck with macros
- Conditional Expression in cell
- ReCalc'ing for almost everything I do
- How do I circle a number in excel
- Select Distinct Maximums
- number lookup
- Cell reference between worksheets
- formula to add dates.
- How do I get the MAX value of adjoining columns then SUM range?
- I need a payroll sheet that can auto update figures each week
- Formatting
- macro security too high in excel, I can not get into input data
- What has happened to "Save As" in Excel 2003
- Formula to a number can you tell
- Rank a changing row
- Cumulative Average
- how do i change an incorrect amount in a cloumn after download
- annual percentage return
- Can I lock worksheet reference?
- find a value in a table, go to the previous column and add that co
- Can't see sheet, and have tried unhide, etc?
- Comments in Excel
- Stumped: If a cell contains a formula, can you make text color automatically change?
- recognize formula
- DIV/0!
- sum column containing both text and numbers
- How can I use one formula to change case on an entire worksheet?
- Excel links
- Conversion of Numercials to Figure
- Rounding up/down problems ?
- How do I add a column of cells, but IF a row has (), subtract?
- Track Changes
- i maintain DB of URLs in Excel. how can i avoid duplicate entry?
- Is there a way to write an equation that ignores cells that have .
- Does Excel contain a decision tree analysis?
- Help with formula
- calendar help
- LOOK AT THE CONFERENCE- INTERESANT
- Using Check boxes in Excel
- Number Transform to Date
- Forgot my pass word for excel sheet
- Prefixing a selection of cells with zeros
- Retriving Values from a separate sheet of a different file
- Highest value in column b returning column a
- Mortage Calculations
- paste special values
- protected document loses all protection(hidden columns) when manually copy-pasted
- What is quickest way to insert 4000 hyperlink documents?
- show customer based on Weekday
- Excel 2003's autosum does not update data in real time
- Can a cell be set to accept input only once?
- =bahttext(A1) please tell me about language in english how can i
- =bahttext(A1) please tell me about language in english how can i
- =bahttext(A1) please tell me about language in english how can i
- =bahttext(A1) please tell me about language in english how can i
- 'Copy to' Advance Filter depend only on sheet ID not start sheet
- excel formular update
- trying to lookup a value and return if true or fals
- keeping cells aligned when data is updated
- Sorting Colums
- remove partial data from cell
- How to format 39.5 to 39.5%
- excel formular
- sum if conditions in two columns are met?
- Date Value
- Not sure which function - Maybe IF
- Array, circular reference problem
- Don't think it's possible, but I thought I would ask.
- Dynamic Ranges and Lists
- How to populate prices in sheet two based on cost in sheet one
- point to a cell in another workbook
- Index-Match from a range
- Using Lookup function
- Function for copying color formatting
- copy formulas without associated values
- Help with vlookup
- Can you write a formul that will put multipal answers in multipal.
- Can you write a formul that will put multipal answers in multipal.
- Change the width of a column by using a cell reference
- =If - how to tell it to calc certain %'s only
- Drop-down Lists
- copy only unique values
- Sorry for the 3 threads! My bad...
- Help with formating cells (decimal places)
- if statements
- Copy data from one worksheet to another using a function or a macr
- prevent data entry into cell?
- Some help needed?
- how do I get access to the datedif function?
- skip blanks
- Help with Excel formulas
- How to count after 2 conditions are met
- Help for sumif / sumproduct
- Changing Color Palette
- Offset
- Conditional Formating
- Vary column to sum in SumIf
- Comparison result changes font color
- convert number to time
- running balance in Excel
- Suggestion
- Sorting names in Name box
- Importing .txt file
- How to prevent warning messages on protected work sheet.
- RE: Sorting names in Name box
- incremental counter
- Match 3 Criteria and Return Lowest Numeric Value
- how do I put 'c' in () in excel & not get copyright symbol
- Subtracting From 2 Cells
- how do i have beginning balance take away an amount auto total
- Date formula that adds 7 days to a cell when sheet is copied
- Advance function of excel to get sorted data
- Exporting Excel spreadsheets with functions
- Formula help
- Newbie problem need formula help
- Create a Formula to display the sheet name.
- Date format problem
- Retrieving values from a specified sheet of a different file.
- Adding Tax in excel
- How do I select price from sheet.b where sheet.a part no = sheet.b
- Formulae containing more than 7 arguments?
- if statements
- How do I do a sumif function not including hidden rows?
- trivial problem
- Check my IF function
- Calculated Fields in Pivot Tables
- sumif based on partial match
- Function Help
- GETPIVOTDATA Bug
- NPV IRR MIRR
- how to convert julian date to general date
- Does anyone have a weekly schedule that computes total hours work
- Does anyone have a weekly schedule that computes total hours work
- Is there function to check and list data?
- How can I use dcount to total the number of columns with entries?
- summing problem!!!!!!
- Updates Problem
- No duplicate names in a range (A2:A200)
- LARGE and INDEX functions
- Updating LINKS when opening a workbook
- Input range and link a cell
- How many decimal places can a cell display?
- Array sum for negative match
- How do I set cell colors based on if query
- Fill cells with times
- Searching Columns and Rows
- change cell value greater than another cell value using formulas
- check marks in excel cells using your mouse
- Help Requested on Formula
- Calculate from time formatted cell
- Have column of nums, need qty of each?
- Return an Alpha based on number position in a word
- Status Changes
- Deducting a %
- how to substitute a value for calculation with a column of values
- number formats
- problem with blank cell
- Vlookup problem
- how do i add numbers in nonadjacent cells?
- Date entries
- How do I delete <br> or <b> that appears in text?
- condition formating
- How can I use the "TODAY ()" Function in an "IF/THEN" calculation
- Identify number of items with characterisitics from two columns
- Summarizing totals of all worksheets to one worksheet?
- Why would a pasted formula not calculate the new cell refs?
- rate of return
- If And Or
- Summing every nth row value based upon variable
- I am trying to "mirror" a row in excel, help??
- Working out wagees
- dates
- Referencing a range of columns and rows with the IF function
- VLOOKUP
- add 1
- Validation Q
- IF and MAX statements
- How to enter pre-decimal pounds shillings pence in Excel workshee
- Is it possible to convert a number into hours and minutes
- Sumif function
- Check if Equally Divisible
- formula to workout equal to or greater than
- retrieving values from a specified sheet
- How do I "Sum sales figure for a finacial month to currenct week"?
- Formula that will test text conditions in a single cell
- sorting data by a certain attribute
- Sponsor Tree
- How do change entire worksheet to uppercase letters and lock it
- Countif, Maxa or other function?
- HELP with dreaded formulas...
- Function Encyclopedia??
- freezing formulas
- freezing formulas
- Count dates falling in a certain range
- excel-How many macros can one spread sheet have
- Count Unique Values with Multiple Criteria
- present value function
- maturity schedule fixed inc securities by month, quarter and year
- New text added to cell AFTER current text in same cell
- Find & Replace woes
- Display a "0" when #N/A appears in formula
- Matching Text with With Certain Criteria
- Turning 0.000 values red
- Truning 0 vaules red
- Date (hours and still counting)
- How do I sum a date specific range of cells?
- IF statement including BETWEEN
- Is there a way to return records?
- not sure how to proceed
- Converting a GIF or JPG into Excel
- Formulas that refer to (several) other columns for arguments...
- Delete every other row.
- Grouping Similar items
- How do you make an graph containing an algerbrica formula?
- How to COUNTIF blank cells?
- Using Cell Variables to Specify Cell Range
- HOW TO I CALCULATE HOURS AND MINUTES? NEED FORMULA
- Where is the link???
- Can a formula ignore empty cells?
- CF ROWS
- delete unused columns and grey out the rest area
- VLOOKUP should compare numbers stored as text to plain numbers.
- Remove green mark upper left several cells Excel?
- If statement to find NA()
- Replacing Colored Items with Tags
- Copy/Paste Drop Down List
- RE: If statement to find NA()
- how do i create a drop down list of items from a different file
- Concantenate Help
- Combining functions
- Add decimal years to a date
- Matching Subtotals
- formula using up 2 10 cells of $ 2 seperate & = $ amt
- Deleting contents of cells in non contiguous ranges
- combining 2 dates into 1 cell
- OFFSET to include blank cells
- copy/Paste references other worksheet
- Changing file default
- Counting text in multiple cells.
- inventory comparison formula??
- Empty Cells
- Using IF function for inbetween cell values
- "workinghours"
- Please explain
- Text Time Conversion Calculation
- How to Calculate ANTILOG in EXCEL SHEET?
- How do i add to information to microsoft exel worksheet
- Format Numbers
- Crazy discount !!!
- Upper case to Lower case
- sumif from activeX control
- How do I extract data from every other cell in a colomn?
- =IF(ISERROR(SEARCH("insurance",A125,1)),"","*")
- <%><%><%><%>HOW TO BE FUNNY!<%><%><%><%>
- Keeping pictures with data
- EOMONTH error
- >@>@>@>@>GET MORE CHICKS............LEARN GUITAR.............
- Amnesty for illegal immigrants will not happen this time.....................
- Will illegal immigrants get deported?.........Of course not.....................
- Excel not calculating formulas
- Illegal Immigration, the Non-Issue of the Week??????????????
- How to have Excel Fill In Data in Column based on another columns
- Help writing an IF statement
- problem with checkbox control
- charts
- How do I sum values returned from functions?
- Transposing Data using Offset function
- Finding Text To Copy To Another Worksheet
- Help creating formula
- count only visible cells
- Lookup problem
- Cannot do calculations with numbers?
- Clearing associated dropdown fields
- Formulas for Time Sheets
- How to use lookup to retrieve next LARGEST value?
- Updating formulas
- combining multiple rows of data into one single row of data
- how do i do this - increment month by 1
- SUM of a variable range of fields
- Lookup based on range of dates
- searching multiple worksheets
- place text in one cell
- Sorting Parent Child
- Entering a hyphen into a cell
- data entry problems
- Score a list of numbers
- rather complex logic statement
- Drop-down list Populated by a Subset of a larger list
- #VALUE Help
- Convert excel spreadsheet into crystal report
- Need help with a dynamic lookup and logical formula
- get the last number from the row
- VBA Help
- How to reference a worksheet name
- Changing Cell References To a Different Worksheet in the Same Cell
- Extracting text from text string
- Vlookup? help.
- How do I print 1/3 cut Folder Labels from Excel
- Auto-delete Unbolded Cells
- WHAT ARE REASONS THAT A FORMULA WILL NOT RESPOND TO PRECEDENTS?
- Calculating Per Diem Rates
- Formulas that refer to other colums for arguments?
- use data in a cell in a formula
- If the cell contains..., do something (2)
- Automatic Saved Date
- Advanced Lookup (lookup for 2 values)
- Data overflow to second worksheet
- How do I assign a unique ID number to an invoice sheet I created?
- How do I calculate grades from excell
- Use array to return array of values
- How do I print my excel contact sheet into avery labels
- how to do a wookbook with sheets and subsheets?
- Conditional formatting of text in a shared workbook.
- Combining Text from 2 Columns into 1 then Deleting the 2 Columns
- merge text from 2 columns into 1 then delete the old 2 columns
- Sort a Spreasheet by Color Highlights?
- FLOWCHARTS
- Need to use if statement with drop down lists has this been done
- Password\Backup
- If statement with Vlookup
- Excel 2003 index function does not calculate
- Offset VLookup
- sum sub levels.
- Don't print a specific cell
- Function for an object
- How do I make all columns in a range in a worksheet the same width
- Import a word document
- need help accessing other cells within a function
- Identifying Duplicates in Columns
- Help with a formula
- In Cell Layout
- Combining IF AND & FIND Functions
- ADDRESS
- How do i cross reference two excel spreadsheets?
- Hlookup, how di I get it to return more than one cell
- How do i cross reference two excel spreadsheets?
- Comments/Warning fields
- how can I perform trig. functions usings grads 400deg per circle
- Hyperlink failed
- Transposing + Absolute Reference + Multiple Worksheets = my headache
- validation and further
- how do i slide months of data under my first column?
- do I need array formula or sumproduct for counting?
- How to get time to update automatically and continuos
- FOrgot Password
- hlookup function
- formula accross cells..when inserting a row..
- Conditional formatting - Find common material
- Converting cost price to retail in vast array
- Validation - clear blanks from drop down
- Keep text filter away numbers
- How do I hide and unhide the same columns without reselecting
- Excel 2003 Simply Stopped Working
- find largest value cell acrss worksheets
- Using IF function
- please help how to combine IF function with Countif function
- I Have No Idea How To Do Or Title This!
- Help with a blank cell warning
- 1900 not a leap year
- Variable Determines Number of Cell in Formula Range
- Sports Comp Ladder tabulating help needed
- NORMDIST function
- Conditional Formatting: Formula is
- Count Formula Problem
- How do I get an excel field to 'prompt' me to add a number to mul.
- How do I make items repeat on a pivot table?
- Counting Words
- Problem with paste
- average data from diff sheets
- List of data available for each cell within a coulmn
- Returning Cell Value if someone deletes the contents of a cell
- adding digits of a number
- Need help with concatenate formula
- reverse principle calculation
- How do I get rid of FALSE, #VALUE!, ###, in cells?
- change the case of all the text in a coloumn
- Need help with concatenate formula
- updating separate spreadsheets
- Leave existing data in a cell alone
- How do I sum text cells with number cells?
- Rehide Sheet in macro.
- remove conditional format
- formulas in worksheets/workbooks
- group counter in excell
- dollars/cents multiplied by hours/minutes or tenths
- Auto sort
- How to apply a formula to all cells in a column
- Custom Function not updating
- Re: Custom Function not updating
- N/A return
- Conditional Formatting for a range situation
- Standard deviation - confidence intervals
- Flagging constants
- importing multiple .dat files!
- Receive #VALUE! when I mix text with dates using SUMPRODUCT
- cell references
- Conditional Rounding
- How do I make an IF statement change cell shading
- a text array formula
- Easy question for you, but hard for me.
- Sum/average numbers in column A dependant on value in column B
- when using find I want the box in excel to be highlighted
- saveto or Submit Form functionality in Excel
- Different ranges in formula
- Why does my formula in Excell return a #N/A?
- Automate Copy / PasteSpecial
- Apply a formula as a pivot table calc or suggestion
- INSIDER - KNOWLEDGE NEUTRALIZING!!
- INSIDER - KNOWLEDGE NEUTRALIZING!!
- Convert Lats and longs to decimals
- #DIV/0! Errors
- formula help: calculate length of employment
- Emailing Macro
- How can I count conditional blank cells?
- How do you make information from one worksheet feed to another?
- Help with Countif
- NETWORKDAYS FUNCTION, Help please
- NETWORKDAYS FUNCTION, Help please
- To Protect Excel documents and allowing only few cells to edit
- if statements, and statements
- Formulae for Tolerence
- control limit
- Countif, Match or Sumif Formula
- Function for upper and lower control limits?
- Conditional Format as a MACRO
- Automatic colouring of cells
- Re: Loop time seems dependent on unrelated workbook - Why?
- UK Excel User Conference - July 19-21
- Please Help
- Working Hours (formula & graph) - any elegant solution?
- Copying Cells
- Unique numbers from data validation list
- How do I count differert items in a column only if the date in an.
- I need =SPELL()>True/False function in Excel
- Unprotect sheet button!??
- Lock a file so it can't be altered unless saved as another file
- How to repeat a code for selected sheets (or a contiguous range of sheets) in a Workbook?
- Use worksheet name
- Rounding
- How to find a row in a sheet and compare the complete row /w origi
- How to seperate data in a cell which is split by a comma
- Highlighting a whole column
- where is spell check on excel 2007
- How do I keep cell color formats separate from text during A-Z sor
- sort data by criteria other than ascending or decending
- UK Excel User Conference - July 19-21
- Using a calander for date select in cell
- macro or worksheet function?
- Finding Cells
- Create button on worksheet to restore woksheets orignal values
- Problem writing formula
- How to set cell 00/1-20/000 to move to another cell
- Can I create an If Statement that will replace text
- I can't sort my miscrosoft excel worksheet anymore, what happened?
- Graph
- calculate days
- Excel - Changing value of a date by a number of calendar months
- Control Display of Drop Down List in Validation
- Sum IF
- lookup
- How to replace a text with another
- change letter to number add number
- change letter to number add number
- Calculate Ebay Insertion Fees
- need help
- Dynamic fill of columns
- How do include Dates in a formula?
- cell sizes
- Calculating a Percentage
- lookup across multiple columns
- SUMIF with multiple criteria, by columns
- String parsing with variable lenght strings
- how do I round hours worked to the next half hour with a 24hr shif
- Can a workbook be locked against change to cells containing references to other files?
- how do i add text to Excel worksheet ?
- Need a formula
- lookup help!
- Restore an Excel spreadsheet
- Excel kept on asking to save file every time I jump from one sheet to another!
- How do I compare lists in Excel?
- How do you truncate a text string?
- calculate a formula instead of returning text
- How to insert text in one column and populate numbers in another
- Round current time
- convert lats and longs to decimals
- List Validation Improvement Suggestions
- Function displays as text, doesn't return result or error
- Ranking - Excel 2003
- Date Format
- Comparing and copying information from one cell to another
- Formula to look up a column and paste results in another column
- Excluding Zero's from Average (SumIF / CountIF)
- =if with multiple choices
- Date Function
- Hide an entire tab.
- Conditional Formating a cell .. to Show Nothing .. if True
- If Vlookup returns error enter 0
- How to exclude data that has already been imported?
- Conditional Formatting Formula
- Remove the "False" from Statement
- Nested "if" for price list
- How can I get an expired date to automatically be highlighted?
- reverse mapping for LOOKUP table?
- Return Blank
- Printing Multiple Data Validation Lists
- Checking data range in Pivot
- Extract Certain Characters and Numbers
- copy data between sheets, but not the formula
- Copy/Paste Help Please
- Suppress duplicate data
- Data Table Input Limits
- copy 40 tabs into 1 tab automatcially??
- Printing
- How to feed dynamic information to a drop down List (Validation Feature)?
- Average a part of a on going column
- Replacing missing values?
- how to extract input data?
- Creating a formula that will SUM with 2 Variables
- Need to look up value in another Sheet based on criteria in first sheet.
- DropDown Menu
- solving a formula
- rolling sheet references
- Lookup 2 directions
- Data tracking and auto sequential numbering
- How do I create a conditional formula that hides a complete row o.
- Average time for a race in minutes seconds & tenths
- Target directory & Path
- Large Function returning top values
- Date Calc in hours
- Macro to help oepn the file without prompting fopr passwords
- Macro to help oepn the file without prompting fopr passwords
- how do I set up if an answer is No then following row is hidden
- =networkdays formula was working, but not in upgrade to 2003
- Links error if referenced file not opened
- Re: Data Ranges
- Re: How do I do this, can it be done?
- Data Entry Using Pulldown
- Re: Excel - need an serial # to update everytime sheet is printed.
- RE: How can I get TreePlan for excell?
- How do I do multiple IF statemnets in one cell in Excel?
- Min Max Editing
- Counting the occurences
- ADD Macro - xlup plus xlto right
- formula for lenght of employment based on hire date
- rowwise total!
- Convert WeekNum to Sunday's date
- Formula for top n
- How do you link multiple cells in a worksheet?
- Color Code Rows
- Re: Is it possible to automatically change color of cell by keying off the date?
- Create folders in Window Explorer from tab or csv files export
- LIst Problem
- Matching Combinations
- Run Macro from a Cell
- How do I format spreadsheet w/o changing font size?
- Simple? Formula for "for the week starting Monday May Xxth"
- Conditional Format - 2 lists of names to find matching cells.
- Nested if in Array
- automatic address and phone cell entry
- how to get a total to add up a range
- How do I "lock" a graphic to a particular cell in Excel?
- Combine many exel files to one
- VLOOKUP in large Data sets of more than 16384 rows
- Text To Column
- conditional fomatting
- Update Links
- Calculating time between values (tricky Problem)
- How can I create an AutoFormat row color change for a value in a c
- How to creat summery file form many xl files?
- how do i make one part of my formula bold and the other normal?
- HELP: text keeps on displaying ##############
- Can i print non-contiguous areas on one page
- Matrix info
- Option Button
- sumif statements
- Delete empty rows from print in Excel
- SUM ERROR
- conditional formatting in excel
- crazy discount !!
- Hyperlinks within worksheets
- Who can I make a Cumulative calculation in Excel sheet?
- Averaging data
- xirr prorated?
- Formula Help
- add time greater than 9999:56
- How do I create a formula by percentage within a formula?
- Vlookup and SUM
- Making Cell Blank
- I want to count *'s that i have put in my sheet ?
- show fridays
- Vlookup in pivot tables
- worksheets xlSheetVeryHidden and show them once password-app
- conditional formatting with dates
- Prohibit entry of special characters
- Date and Time
- When I insert rows in Excel the pagination gives me unwanted page.
- replace blanks using formula
- formula in one cell or another
- how can i make dual label cells?
- copying part of a cell's contents (formatted as dd:hh:mm)
- validation rule - force text entries to appear as Proper
- 'IF' FORMULA TO CAPTURE CERTAIN CELL VALUES
- Lookup and conditional formating
- RE: is number between values
- RE: formula in one cell or another
- how to consolidate data in different excel sheets
- RE: how to consolidate data in different excel sheets
- create a list box in one cell of state abbreviations
- Font selection within formula
- is number between values
- Help with CountIf < and > time formula please
- HTH
- Verify spelling in a vlookup formula
- how do I get a spreedsheet to print an 8x11 size
- sumif or count between zero and 3
- VLOOKUP USING 2 LOOK UP VALUES
- RE: 'IF' FORMULA TO CAPTURE CERTAIN CELL VALUES
- RE: Font selection within formula
- Scroll bars: how can they be rotated?
- using the countif function
- holding a value after first calcuation
- How do I set up a formula to count only unique items in a column?
- Amortization template for uneven monthly payments
- RE: How do I set up a formula to count only unique items in a column?
- Excel formulas
- RE: formula in one cell or another
- How do I differentiate between duplicate ranks?
- an excel formula for specific conditions
- RE: VLOOKUP USING 2 LOOK UP VALUES
- how to create refrence using first and last words of any supplier
- How can you get a macro to work in transfer data from AS/400?
- RE: Excel formulas
- RE: how to create refrence using first and last words of any supplier
- Validation rule - custom 5 digits w/ leading zeroes
- maximum entries
- RE: HTH
- repeat an entry on spread sheet
- RE: Date and Time
- How do I set up a euchre rotation schedule
- Insert Row & Copy Formula
- Tabbing through Unlocked cells
- Auto Numbering
- countif
- sort data rows "greater than or equal" criteria in another cell
- CALCULATING A FORMULA TO USE A SPECIFIC CELL'S VALUES
- RE: an excel formula for specific conditions
- dechex
- Getting a case sensitive match?
- RE: an excel formula for specific conditions
- Sorting Formulas with "Empty" Results
- Problem using IF function for a gradebook
- Returning contents of a cell
- RE: Auto Numbering
- RE: using the countif function
- RE: Problem using IF function for a gradebook
- RE: Font selection within formula
- RE: VLOOKUP USING 2 LOOK UP VALUES
- AND array
- Summing a range with conditions
- lookingup a value in a table
- RE: 'IF' FORMULA TO CAPTURE CERTAIN CELL VALUES
- Conditional If statement
- Sum up a particlar cell in multiple Excel worksheets within same b
- RE: sumif or count between zero and 3
- how can i get a cell to flash or blink
- Conditional Formating
- RE: VLOOKUP USING 2 LOOK UP VALUES
- Combine 2 spreadsheets w/1 common column of data, text and number
- RE: countif
- RE: how to consolidate data in different excel sheets
- RE: repeat an entry on spread sheet
- RE: Help with CountIf < and > time formula please
- RE: how do I get a spreedsheet to print an 8x11 size
- Detecting patters in data
- RE: is number between values
- RE: Summing a range with conditions
- Conditional data
- Extracting using seperators
- multiply time and currency
- decimal to 16 bits binary conversion in Excel?
- nested if statment - needs if(isna
- Square root with a remainder
- Conditional sum
- getting the sum of variabel ranges
- error analysis
- Copy Problem (progression in formulas)
- Copying a calculations answer and not the calculation
- Split contents of a cell
- lookup and autonumber
- dcount vba
- dcount with vba
- Multiple hyperlinks
- N/A mine is returning with 1
- sum wrt substrings!
- Question re best practice
- Help With If And Or
- Auto-Numbering
- Protect Formulas
- Quick formatting for negative numbers
- Formula help
- gains/losses formulas
- Can Excel list order according to Total scores?
- iserror
- comparing two lists and returning value from different column
- Auto fill dates
- RE: Auto fill dates
- Two People Using Same File
- Display Rows From Sheet1 In Sheet2 (Import)
- multiple rows with some dups where I need result on one line
- Excel Math problem
- copying sheet references that refer to a cell in the preceding she
- special case of sumproduct
- Number to be like in colum A, if number in colum B and C are like
- How do I compare cells and if FALSE compare to next cell in EXCEL
- Clear Cell Without Removing Formula
- Counting Function
- Copy and Paste in certain format
- How do I take cell data and automatically put it in an email?
- Tracking changes
- Is there a way to create a toolbar icon for 'page setup'?
- auto fill sequence...
- russian excel vlookup
- Multiple Pastes Between workbooks
- How can "data validation" be enforced in calculated cells
- use cell reference,whose contents= a table array name for Vlookup
- Auto Change in Cell Color
- Formatting imported data
- TODAY function question...
- Hot key for time?
- Help with Date formula
- Gitter
- special case of sumif
- Matching Text
- copying with a Macro
- Macro to Unprotect sheet!?
- Removing protection from excel worksheets
- Exceptions to =Countblank function
- Copy worksheet ranges from One Workbook to another from
- Re: Copu worksheet ranges from One Workbook to another from
- help! printing locks up excel
- Automating text in a cell
- Can the sheet tabs be color coded?
- Selecting rows based on cell entries
- Select a range but only sum the cells in a certain colour?
- subtraction formula
- Help with TREND function
- Cell Reference Change
- Cell Formula
- Round amount to nearest $10 after other formula calc. in same cell
- how to identically size merged cells for filtering use
- Microsoft Visual Basic: Compile error: Sum or Function not defined
- Link Tab Name to Cell
- Serial number of Date
- Offset Type Lookup
- I need current value of one worksheet into another cell?
- How do I correct this formula?
- How do I scan a excel print into excel
- Text or Number
- 3-way lookup help
- Using information from one worksheet, to rename inserted worksheet
- referencing data from a table
- Avoiding Errors When Attempting To Retrieve Data From A Non-existant Worksheet
- cell reference to another file
- Codes
- hiding charts w/o data
- have a name change cells between sheets
- Filtering out weekday dead time
- Copying format when using "+'s" between worksheets
- How to make mtd and wtd totals on dates
- How do I correct this calculation?
- Function for 3 date columns
- post positive sum as a negative? help!
- How to list Alphabeticaly
- Date Comparison with VLookup
- How do I convert a number in Excel to text?
- Copy Worksheets from one Workbook to Another
- Seperating Numbers from Letters in Excel
- sort source workbook data, maintain formulas in destination workb.
- where do I find the the action icon in regards to a meeting?
- refer indirectly to Name
- Conditional Formatting Help.
- Another Basic formula I should know (but Don't)
- Count Unless??
- No value returned in if statement
- Can I make a graph using several tabs in an excel spreadsheet
- Converting list of IP Addresses to list of Hostname
- Running Same macro in 250 Worksheets in Same Workbook
- Why I am getting Error Message: "Cannot shift objects off sheet"??
- find the same entries and calculate sum
- Grouping rows together
- How do I add an angled tab to the top of each column?
- If Then formula
- how do i open up a spreadsheet in microsoft office
- Select only colored cells
- how do I expand a cell without expanding column
- Cell Reference with Range Name
- search for help? it sucks
- Lookup Values in Table
- Can OR be used within MATCH
- Conditional formatting for lowest number in a string
- timesheets
- Electrical Bill