microsoft.public.excel.worksheet.functions
- Referring to Sheet locations in a formula,
PCLIVE
- Re: Returning a column name or number,
Sandy Mann
- Re: change background color of a cell with an "IF" command?,
Sandy Mann
- Challenging Formula. Need help with writing a formula,
tom
- Excel Function,
fuller . susieq
- Re: How do I calculate a persn's age in years & months in Excel?,
Rick Rothstein \(MVP - VB\)
- RE: Does loop function cause this problem?,
JLatham
- Re: Monter IF statement??? sorry long question,
David Biddulph
- Code simplification,
Sandy
- Showing Top 30 with array-formula?,
Jen . Carllson
- Re: Showing Top 30 with array-formula?,
Bernd P
Re: IF,
joeu2004
Re: Is conditional formatting or formula possible by cell color?,
Rick Rothstein \(MVP - VB\)
Show Top 10 with array formula,
Jen
Re: Bizarre Excel 03 Problem - autosum not updating when cells are cha,
Peo Sjoblom
Re: combination of AutoFilter and array formula?,
Don Guillett
Re: convert columns to rows,
Piscator
Re: Is there a way to sort a list of multi-line items?,
Harlan Grove
Re: HELP--- adding duration of times,
Piscator
Re: Form drop down list,
Debra Dalgleish
Re: Advanced Sumif formula,
Rick Rothstein \(MVP - VB\)
Re: Excel Formula add if someone types PTO have it =0,
PCLIVE
Re: Rounding a sum to the quarter hour.,
T. Valko
Re: Sequential VLookups,
Naraine Ramkirath
Re: ISBLANK(),
PCLIVE
RE: any ideas appreciated,
driller
Re: How do I use an If= statement with an apostrophe (IF(s4="jack's",.,
Vasant Nanavati
RE: Dollar / Euro sign,
Yendorian
why do i get #value! using this formula,
Naraine Ramkirath
Please help me win my fantasy football league by answering this excel ?,
nicholas.deselle@xxxxxxxxx
Re: calculating sample sizes for independent groups,
Vasant Nanavati
Re: Another SUMPRODUCT Query,
T. Valko
Re: How to use Check Box input in a cell's fomula?,
Dave Peterson
how do i clean out all non-letter characters from an excel sheet,
jgarbis
Can IF do this?,
D.P. Roberts
Re: formula to count easily,
T. Valko
Re: Format,
Peo Sjoblom
Re: Time formatting,
Sandy Mann
RE: Allocation,
Dinesh
Re: Check if Conditional Format is True or False / Check cell Color,
Peo Sjoblom
List of Excel 2003 Functions,
JoJo
Re: counting values in rows,
T. Valko
Highlight if ...,
calibansfolly
Re: Eliminating invalid information,
Peo Sjoblom
Re: On Excel, the auto filter feature is not filtering all the data,
Peo Sjoblom
Re: Searching within an excel document,
Gord Dibben
Choice of Formula,
Naraine Ramkirath
Re: how do I set up a formula showing the day based on date?,
Peo Sjoblom
Re: Formula conundrum calculating a percentage average...help!,
Gary
Excel 2007,
Gary
RE: sumif or countif not sure,
Mike H
Re: Mulitple Formulas/Same Cell,
Rick Rothstein \(MVP - VB\)
Re: VLOOKUP JUST RETURNS THE TEXT OF THE COMMAND,
PCLIVE
To return the column number of a string,
prasanna.janardhana@xxxxxxxxx
Re: Bad result,
PCLIVE
Convert rows to columns,
lucrezia
Re: Conditional Formatting part 2,
Vasant Nanavati
Insert value from another cell AND text,
calibansfolly
Re: Formatting Dates,
David Biddulph
Re: How to ignore #DIV/0! in Sumproduct formula,
Peo Sjoblom
Re: How do I create a Form with check boxes in Excel,
Roger Govier
Re: I need you Mike H!,
Don Guillett
Excel Conditional Formatting -- more than 4 conditions by row,
heathermcpher822
Re: Hiding formula to calculate % visits met,
Bernard Liengme
Re: is anyone familiar with the pull formula in excel?,
Bernard Liengme
Forming a trend line,
Aaron
Linefeed Character,
Jen
Re: Cancel calculation,
Dave Peterson
Re: SUMPRODUCT problem,
Pete_UK
Excel Convert Multiple Rows into Multiple Columns,
james . y . so
Re: Generate list from column,
T. Valko
Re: Sorting into Groups equal size,
Gord Dibben
Re: Excel 2003 Time Calculation,
Pete_UK
Re: mirroring worksheets,
Max
Returning multiple indices for a lookup,
thomas . toth
Re: How can I open an Excel Doc from the AutoSave option?,
Gord Dibben
Round Function Philosophy,
herrdue
Re: Scroll bar (control) doesn't scroll!! ???,
Bob Umlas
Re: Help with COMPARE??? IF??? VLOOKUP??? Don't know which to use,
Pete_UK
Re: how to display mainframe negative numbers on excel,
Peo Sjoblom
Need Help Using Calculated Field or Item in Pivot Table,
sg
calculate various cells to acheive a specific value,
Jennifer_C
IF - AND Function,
Michael
Re: Inserting Additional Text in Spreadsheet,
naz
Batch Printing - filtered by Picklist,
naz
Re: How do you create roll-up rows in EXCEL?,
Bob Umlas
Re: Advanced filter I think,
Don Guillett
Re:Getting a cell reference when a value is less than 0 in Excel Works,
Bob
Re: Find where else in a spreadsheet a cell is referenced with formula,
Niek Otten
Indirect function,
andy
Name Embedded Chart,
Jen
RE: Compare 2 data set,
TouchTone
Calculating Conditional Standard Deviation?,
Harimau
Re: getting the next date based on another date,
Peo Sjoblom
How to find the first non-blank number in a row?,
RLind
Counting instances of text???,
tpmax
Microsoft Excel Sheet,
raju7763
Check Box & Counter,
RANI
Run Time Error 1004,
jeannie v
Two Separate Conditions for Cond. formatting,
singletary . phx
Dragging a formula containing external links,
Keith W.
Repeat Sort in Excel 2007,
Kevin K
If statement to replace #VALUE! code,
jeannie v
RE: would like to substitute and return value of 0 for vlookup #N/A er,
egols
RE: Excel Fromula showing as text but not value,
Paul
Re: Function to Identify the Modification of a Worksheet,
Vasant Nanavati
Re: Checking and IF ?,
Vasant Nanavati
Re: Can the worksheets in a work book be sorted ascending?,
Meebers
Re: Multiple a column of costs by a single factor,
Peo Sjoblom
Re: Average across cells with formulas,
Peo Sjoblom
Insert text in a formula,
petbi
Re: Getting a cell reference when a value is less than 0,
T. Valko
Automatic sorting,
shafer2717
Re: Two conditions in a SUMIF function,
Sandy Mann
COUNTIF cell reference won't work,
Kenny Newbry
show 0.00 if referenced cell is empty,
David D
Re: summation,
T. Valko
Re: vlookup for the second value of a list,
PCLIVE
Re: WorkSheet reference,
PCLIVE
Re: Custom Section Numbering,
Rick Rothstein \(MVP - VB\)
Re: formula help - maybe vlookup, not sure,
PCLIVE
Re: HOW TO USE BAHTTEXT FUNCTION?,
Peo Sjoblom
Re: Multiple passwords,
Dave Peterson
Re: What Excel formula caluclates number of months between two dates?,
Bernard Liengme
Re: alternating colors,
Bernard Liengme
Re: Index or Match or what?,
Bernard Liengme
Re: Find and Add a number in a text field,
Bob Umlas
Re: Auto Sum not working,
Bernard Liengme
Re: Find & Replace (DOH of the week),
Dave Peterson
How to count the occurences in my range with 2 characters only?,
Jen
How to combine a symbol and a formula,
Heine
Re: Formula - IF...then?,
Sandy Mann
Combo box displays positions not date,
Richhall
Re: Complex timesheets,
Niek Otten
Re: Looking for a function,
T. Valko
Re: how to change number to text with specific format in function,
Vasant Nanavati
Re: Automating a line item for several worksheets?,
Vasant Nanavati
Re: Find Duplicates and Move to New Worksheet,
Vasant Nanavati
RE: password protecting a column for data entry in a sheet, how?,
JLatham
Re: if then forumla,
joeu2004
Re: file.xls is locked for editing by "user",
Pete_UK
2 woorksheets 1 workbook, help with lookup,
David D
Re: if then formula,
Dave Peterson
Re: Error message - PivotTable will not fit on sheet. Show as much as,
Roger Govier
multiple ranges & criteria for SUM-IF challenge,
akumudzi
Re: How do I put "COPY" on a worksheet when printing,
Piscator
Re: Function to incorporate worksheets that have yet to be created?,
Gord Dibben
Re: if >200 and <300 formula,
Trevor Shuttleworth
RE: Conditional formatting of a text box ?,
Steve
Re: Excel formulas,
Peo Sjoblom
Re: sum if formula help requested,
PCLIVE
Re: I want to select a row and insert a copy later in the worksheet,
Peo Sjoblom
Re: Unknown Sheets,
Peo Sjoblom
Re: ifcount to compare two columns?,
T. Valko
Re: linked info,
Bob Umlas
Re: IF function not working in conditional formatting,
David Biddulph
Macro Request: Fill in empty cells with previous Filled cell in column,
Artis
Copy formulas not working,
Dave Stitz
difference between logical AND and multiplication?,
ergo
Re: Formula Help Please,
Ron Rosenfeld
Re: Links not updated when primary worksheet is sorted,
Arvi Laanemets
Re: Pasting across worksheets,
Sandy Mann
Re: "Paste" overwrites Verification Controls,
Harlan Grove
Re: Excel date format, NOT JUST DISPLAY !!,
Rick Rothstein \(MVP - VB\)
sumifs in excel 2003,
Lok Tak Cheong
How do I include part of a cell in text (string?) in another cell?,
Chris Mitchell
Re: macro sheet name conflicts,
Rick Rothstein \(MVP - VB\)
Re: top3 selection,
Ragdyer
Re: Top 3,
Trevor Shuttleworth
Re: Excel 2003 function for counting rows with two conditions.,
T. Valko
Re: Creating a formula that references the last value of a column,
T. Valko
RE: Splitting into Groups,
Socratis
Re: Changing worksheet direction,
Gord Dibben
Re: Returning the cell reference when you find a value in an array,
T. Valko
Re: MS Excel,
Harlan Grove
Re: Excel- option button,
T. Valko
zero out,
Pieter
Re: frequency,
Harlan Grove
Re: calculating # of days,
Ron Rosenfeld
Re: Trying to convert hh.mm.ss in General format to minutes,
Alan
Windows Explorer,
Launchnet
Re: Moving many named cells at once to the next column,
Gord Dibben
Re: Omitting zeroes when looking for minimum values,
T. Valko
Re: Need to fix macro to list data underneath each other,
Roger Govier
Re: Financial calculation,
Vasant Nanavati
Re: What does $ stand for in an excel formula,
Nick Hodge
Need a formula to sum no of times item no is used and sum up total quantity!,
Amean1
Re: Why do I get #NUM! for a GEOMEAN calc on a set of positive vals,
Ron Rosenfeld
<Possible follow-ups>
Re: Why do I get #NUM! for a GEOMEAN calc on a set of positive vals,
Harlan Grove
How do I delete the name for a named range i no longer require?,
Chris Mitchell
How do I use Named Ranges as Data Validation Lists?,
Chris Mitchell
Re: How to change amount in figure to amount in words?,
Rick Rothstein \(MVP - VB\)
Re: Cell displays formula instead of the formula's result,
Dave Peterson
Re: how to create macro to use cell references for data filter criteri,
Debra Dalgleish
Re: Pivot table dynamic Filter,
Debra Dalgleish
Excel 2007 backwards compatibility - nesting functions,
ilia
Re: How do I send multi-sheet documents from Excel via Outlook?,
Gord Dibben
Re: How do I find top 3 in an unsorted list?,
Peo Sjoblom
Re: Automatic Fill of a Formula,
krcowen
Re: copy from Excel 97 output put in Excel 2000, colors don't work,
krcowen
Re: Insert a column within a range of cells,
krcowen
Re: conditional indirect with data range,
krcowen
Re: IF / SUMPRODUCT HELP,
Rick Rothstein \(MVP - VB\)
RE: VBE Help, when linked value change, color will not,
Toppers
- <Possible follow-ups>
- Re: VBE Help, when linked value change, color will not,
Susan
- RE: VBE Help, when linked value change, color will not,
Toppers
- Re: VBE Help, when linked value change, color will not,
Rick Rothstein \(MVP - VB\)
- Re: VBE Help, when linked value change, color will not,
Gord Dibben
- Re: VBE Help, when linked value change, color will not,
JVANWORTH
- Re: VBE Help, when linked value change, color will not,
Toppers
- Re: VBE Help, when linked value change, color will not,
JVANWORTH
- Re: VBE Help, when linked value change, color will not,
Rick Rothstein \(MVP - VB\)
- Re: VBE Help, when linked value change, color will not,
JVANWORTH
- Re: VBE Help, when linked value change, color will not,
Rick Rothstein \(MVP - VB\)
- Re: VBE Help, when linked value change, color will not,
JVANWORTH
Re: Ending a Sheet,
Susan
Re: Calc order in pivot table with COUNT,
Debra Dalgleish
Re: Sum Amount if two conditions are met,
PCLIVE
RE: Need to know what formula to use,
MyVeryOwnSelf
Re: Changes cell function to answer,
PCLIVE
Converting to mailing labels,
Dave Stitz
Re: Problem with calculating hours in timesheet? (sysgulv),
vezerid
Run time error 91,
S S
Re: Converting Total Time hh.hh to HH:MM:SS,
Roger Govier
Re: Only weekdays (sysgulv),
vezerid
- Message not available
- Message not available
how to compare two columns on two sheets and copy associated data from one sheet to the other?,
meghantrus
Re: How do you display IF statement results in a different cell,
Pete_UK
RE: Link to text and return text into a formula?,
Mary
Re: changing print borders,
Bernard Liengme
Re: SUM by unique reference,
Bernard Liengme
sumif function,
nk
RE: Correct Macro so that if the person is not in the source document,
Socratis
Re: Jogging Log and Elapsed time formats,
Niek Otten
Re: Volumes of Text in a single cell,
Harlan Grove
Transfer CELL value and spread it among 24 ROWs on another sheet,
rhhince
RE: Nested IF/OR/AND Statement Help,
Toppers
Re: OK i need help with the if function.,
Harlan Grove
Re: Sum of a column excluding hidden rows,
Gord Dibben
Re: Zero Lines in Spreadsheets (removing),
Debra Dalgleish
Re: Pivot Table Calculations,
Roger Govier
Re: If logical value problems,
Peo Sjoblom
Re: GREEN MARK IN THE TOP LEFT CORNER OF THE CELL,
Gord Dibben
Re: Help with using functions....,
Piscator
password cracker for spreadsheet,
S S
Re: how do I mail merge data from excel to word as formated?,
Peo Sjoblom
Calculating Time from Speed and Distance?,
John
RE: VBE Expert Help, Code linked to Cells,
JVANWORTH
Re: How do I compare two cells and display the lesser of the two cell.,
PCLIVE
Combining multiple files in Excel,
sameep . sanghrajka
Re: Count only on visually populated cells,
T. Valko
conditional formatting problem,
T. Valko
Re: Combine SUMIF and SUMPRODUCT,
PCLIVE
RE: Repost of VBA Code/Lookup question,
Steve_n_KC
Launching PowerPoint Viewer from EXCEL 2007 with vb,
Mr BT
Re: Some gridlines are not visible in Excel,
Gord Dibben
Re: COUNTIF not working w/ cells result of SUM and VLOOKUP,
Peo Sjoblom
Re: Conditional formatting Max and Min,
vezerid
Solver Help,
brownti via OfficeKB.com
Need help launching PowerPointViewer from 2007,
Mr BT
Re: Choose from a list,
vezerid
Re: Pivit Tables,
vezerid
removing dashes from numbers,
Pat Jones
Re: In a set of dates, can you count the number of Jan '07 instances?,
Rick Rothstein \(MVP - VB\)
Re: Excel: How to insert carriage returns in a formula to manipulate t,
Gord Dibben
Re: Need help with my timesheet? regular, 50% and 100%,
Rick Rothstein \(MVP - VB\)
Re: Autopopulation of formulae after download of data into a master sh,
Gord Dibben
Missing count of age to a group of ages,
chedd via OfficeKB.com
Re: Converting GPS to Digital Geocode,
David Biddulph
sumproduct and visible cells,
Lee
Re: Compiling information from multiple workbooks and summarizing,
Ron de Bruin
Re: Formula to pull data from one sheet to another if X = Yellow,
Ron de Bruin
Re: Import Access Table into Excel,
Ron de Bruin
Re: Using COUNTIF and NOW() together,
Max
Re: add two numbers in same cell together,
Bob Phillips
Re: Comparing Data in Excel 2003,
krcowen
RE : upload data from excel to notepad,
reachsuja . sada
RE: Help: Creating Data List and value,
Duke Carey
Re: MINIF ????,
Pete_UK
Re: Counting date entries which are the same,
Bob Phillips
countif (I think),
Stephen Doyle
Re: Why does Excel not multiply a number generated by an IF formula?,
T. Valko
Re: Lookup help,
Dave Peterson
Re: Functions Expert...four (4) different colors if a specific con,
T. Valko
Re: Vlookup.... 2nd time,
T. Valko
- Message not available
- Re: Vlookup.... 2nd time,
T. Valko
- Re: Vlookup.... 2nd time,
Cinny
- Re: Vlookup.... 2nd time,
T. Valko
- Re: Vlookup.... 2nd time,
Cinny
- Re: Vlookup.... 2nd time,
T. Valko
- Re: Vlookup.... 2nd time,
Cinny
- Re: Vlookup.... 2nd time,
T. Valko
- Re: Vlookup.... 2nd time,
Cinny
- Re: Vlookup.... 2nd time,
T. Valko
- Re: Vlookup.... 2nd time,
Cinny
- Re: Vlookup.... 2nd time,
T. Valko
- Re: Vlookup.... 2nd time,
Cinny
Re: number of times consective data occurs in a range of cells,
T. Valko
Assigning payment formulas to dates,
alancunn
Re: printing parts of worksheet,
Gord Dibben
Formulas pulling from other tables,
dicko1
Re: Wildcards and if,
David Biddulph
calculate finishing time if night shift aren't working,
Martin B
Re: Formula to change date when other cells are modifed,
Gord Dibben
Re: rows 4-15 will not scroll,
David Biddulph
Re: Copying rows from one sheet to another....,
Gord Dibben
RE: MACRO IS NOT WORKING AS IT SHOULD,
Billy Liddel
Re: Comparing multiple column values,
T. Valko
Add-Ins Tab in 2007,
Mr BT
Re: "manual page breaks error",
Susan
password problem,
S S
Prompt for update,
S S
Re: How do I import data in Excel,
Gord Dibben
Re: Adding a Row to Multiple Worksheets at Once,
Vasant Nanavati
Re: Functions expert………numbering random condition in a column,
Rick Rothstein \(MVP - VB\)
Re: How do I insert a picture into a cell?,
Meebers
- Message not available
- Message not available
- Message not available
margin of error,
Lexi
Re: Functions Expert...four (4) different colors if a specific conditi,
Peo Sjoblom
Re: Functions expert...numbering random condition in a column,
Bob Phillips
Re: STUMPED,
Piscator
Re: Validation source field size and function.,
T. Valko
Need to remove cells with variable data,
cthomas
Re: Best Way to download XIRR,
David Biddulph
Automatically Hide rows with a value of zero,
tim
Re: Why does the following formula not work: =IF(2<A1<=2.25,2.25," "),
Dave Peterson
Font of drop down list is too small,
seng via OfficeKB.com
Re: Fixe Range,
Bob Phillips
Re: What does "cannot shift items off sheet" mean?,
Bob Phillips
Re: Referencing a named range based upon Range name entry in cell,
Peo Sjoblom
- Message not available
- Message not available
<Possible follow-ups>
Re: Referencing a named range based upon Range name entry in cell,
Bob Phillips
Re: Flag 1 in 5 entries,
Rick Rothstein \(MVP - VB\)
- Message not available
- Message not available
Looking for custom date format,
Pierre
- Re: Looking for custom date format,
Rick Rothstein \(MVP - VB\)
- Re: Looking for custom date format,
Pierre
- Re: Looking for custom date format,
Peo Sjoblom
- Re: Looking for custom date format,
Rick Rothstein \(MVP - VB\)
- Re: Looking for custom date format,
Pierre
- Re: Looking for custom date format,
Rick Rothstein \(MVP - VB\)
- Re: Looking for custom date format,
Rick Rothstein \(MVP - VB\)
- Re: Looking for custom date format,
Pierre
- Re: Looking for custom date format,
Rick Rothstein \(MVP - VB\)
- Re: Looking for custom date format,
Pierre
- Re: Looking for custom date format,
Rick Rothstein \(MVP - VB\)
- Re: Looking for custom date format,
Rick Rothstein \(MVP - VB\)
- Message not available
RE: How to fix the coding?,
Eric
Re: Random messages pop up,
Vasant Nanavati
Re: How to I get the tabs at the bottom of the page back?,
Vasant Nanavati
Movng Data Automatically the Fits a provision,
EGerety
Re: excel calculates after each cell entry,
Niek Otten
Re: can you tell excel to ignore #### cells when calculating,
David Biddulph
Re: Excel Formula,
David Biddulph
Referencing every 5th cell in another sheet,
Jan . Thorstensen
Help Nested If and And,
madeleine
Re: Excel VLookup,
Roger Govier
Re: IF COUNT,
Rick Rothstein \(MVP - VB\)
Re: How do I sort rows containing graphics?,
Gord Dibben
Re: return TRUE if a date falls between two dates,
Fred Smith
Sum A Range only if no text is present in the range,
AdmiralAJ
Re: Odd functionality,
T. Valko
Re: Limit to nested IF(ISNUMBER(SEARCH)) functions?,
T. Valko
Re: get a list of ticked add-in,
Chip Pearson
Re: How can I change the tab but keep the row and column constant,
MG
Re: pop up calendar using MS DateTime Picker,
Chip Pearson
Re: Functions/Formulas to count multiple variables,
Peo Sjoblom
Re: "Begins with",
T. Valko
- Message not available
- Message not available
RE: lock cell based on a condition,
Gary''s Student
- RE: lock cell based on a condition,
Amanda
- RE: lock cell based on a condition,
Amanda
- RE: lock cell based on a condition,
Gary''s Student
- RE: lock cell based on a condition,
Amanda
- RE: lock cell based on a condition,
Gary''s Student
- RE: lock cell based on a condition,
Amanda
- Re: lock cell based on a condition,
Gord Dibben
- Message not available
- Message not available
- Message not available
- Re: lock cell based on a condition,
Gary''s Student
- Re: lock cell based on a condition,
Amanda
- Re: lock cell based on a condition,
Gary''s Student
- Re: lock cell based on a condition,
Amanda
- Re: lock cell based on a condition,
Amanda
- Re: lock cell based on a condition,
Gary''s Student
- Re: lock cell based on a condition,
Amanda
- Re: lock cell based on a condition,
Gary''s Student
- Re: lock cell based on a condition,
Amanda
- Re: lock cell based on a condition,
Gary''s Student
Positive or negative sign in a calculated cell,
Michel Khennafi
Closest value lookup?,
ADK
Re: Closest value lookup?,
Chip Pearson
Re: Counting up with numbers and text,
Peo Sjoblom
Re: copy part of large WS to another sheet,
Gord Dibben
how do i sum of decimal digit in absolute terms,
dhir
Re: How can I change the tab but keep the row and column constant when,
Peo Sjoblom
COUNTIF with AND logic,
Mitchell_Collen via OfficeKB.com
RE: How to use the if statement for Macro coding?,
Eric
Re: Trouble with Index & Match,
Peo Sjoblom
Re: TAN INVERSE ?,
Dave Peterson
Re: Digit to Text,
Rick Rothstein \(MVP - VB\)
trouble locking specific cells,
alexisnguyen
Re: Merging 2 lists with a twist,
Roger Govier
Find and Delete,
Karen
Re: Cell Wrap,
Pete_UK
SUMPRODUCT #VALUE! error,
Chris Slowe
find and replace,
Karen
Re: Cell reference Issue,
Roger Govier
Re: DCF,
Pete_UK
Re: Auto Filter Range,
RichardSchollar
while loop,
Arun Kumar Saha
Re: =B1/A1,
Pete_UK
transfer date to number,
artisdepartis
Re: Can Someone tell me why this won't work?????????????,
Bob Phillips
- Message not available
- Re: Can Someone tell me why this won't work?????????????,
Ron Rosenfeld
- Message not available
- Re: Can Someone tell me why this won't work?????????????,
Ron Rosenfeld
- Message not available
- Re: Can Someone tell me why this won't work?????????????,
Bob Phillips
- Re: Can Someone tell me why this won't work?????????????,
skijsh1979
- Re: Can Someone tell me why this won't work?????????????,
Bob Phillips
- Re: Can Someone tell me why this won't work?????????????,
skijsh1979
- Re: Can Someone tell me why this won't work?????????????,
Bob Phillips
- Re: Can Someone tell me why this won't work?????????????,
skijsh1979
- Re: Can Someone tell me why this won't work?????????????,
Bob Phillips
- Re: Can Someone tell me why this won't work?????????????,
skijsh1979
- Re: Can Someone tell me why this won't work?????????????,
Bob Phillips
- Re: Can Someone tell me why this won't work?????????????,
skijsh1979
- Re: Can Someone tell me why this won't work?????????????,
skijsh1979
Re: Convert average daily yield to APY,
joeu2004
getting numbers divisible by 4 from random numbers in ascending order,
ramana
getting numbers that are divisible by 4,
ramana
Re: converting number to words,
Bernd P
Needing to return multiple values from single column,
graphite . art
Re: Calculating Time Worked in Timesheet,
T. Valko
Advanced Excel Functions Ebook,
robert
Re: Hard return,
Gord Dibben
Need Macro to Open Access,
Launchnet
RE: Formulas in Excel Worksheet,
jeannie v
Re: lookup formula,
Piscator
Re: Pull value from column heading,
Dave Peterson
Re: Need to add to a SUMPRODUCT formula,
Bob Phillips
Re: Changing row height in the same worksheet,
Gord Dibben
Re: locking and unlocking worksheets,
Gord Dibben
How to return multiple cells from a data sheet in a seperate workbook,
tennisash
- RE: How to return multiple cells from a data sheet in a seperate workb,
Gary''s Student
- RE: How to return multiple cells from a data sheet in a seperate workb,
Socratis
- Re: How to return multiple cells from a data sheet in a seperate workb,
tennisash
- Re: How to return multiple cells from a data sheet in a seperate w,
Socratis
- Re: How to return multiple cells from a data sheet in a seperate w,
tennisash
- Message not available
- Re: How to return multiple cells from a data sheet in a seperate w,
tennisash
- Re: How to return multiple cells from a data sheet in a seperate w,
tennisash
- Message not available
- Re: How to return multiple cells from a data sheet in a seperate w,
tennisash
- Re: How to return multiple cells from a data sheet in a seperate w,
tennisash
- Re: How to return multiple cells from a data sheet in a seperate w,
Socratis
- Re: How to return multiple cells from a data sheet in a seperate w,
tennisash
- Message not available
- Re: How to return multiple cells from a data sheet in a seperate w,
tennisash
- Message not available
- Re: How to return multiple cells from a data sheet in a seperate w,
tennisash
- Re: How to return multiple cells from a data sheet in a seperate w,
Socratis
- Re: How to return multiple cells from a data sheet in a seperate w,
tennisash
Re: Totaling Different Cell Values,
Rick Rothstein \(MVP - VB\)
Re: How to summarise information from 4 work sheets,
Gord Dibben
IF/COUNT Statements Help,
treen333
Re: Excell dragging formula to change sheet/tab not column/row,
T. Valko
Re: Sum numbers based on specified criteria,
Don Guillett
Re: Is there a 255 character limit in pivot table cells?,
Dave Peterson
Re: Snedkeys "{F9}", true does not work,
Chip Pearson
RE: Sumif,
Arlene
- <Possible follow-ups>
- Re: sumif,
Trevor Shuttleworth
Re: COUNTIF with dates,
JE McGimpsey
Re: How do I type so my words are vertical not horizontal?,
JE McGimpsey
Re: formula using several colums,
JE McGimpsey
zero value from using 3D formula, value is missing,
chedd via OfficeKB.com
How can you do COUNTIF between 3 spreadsheets,
chedd via OfficeKB.com
Re: On File open - how to stop conversion of postcodes to numbers,
David Biddulph
Formula - Help !!!,
ITCOM
excel Formula help !! - urgent,
ITCOM
Using a series of named ranges in SUMPRODUCT,
JzP
Re: If statement help needed,
Rick Rothstein \(MVP - VB\)
RE: If statement help needed,
ah
counting names,
brianjohnalford
Refering a cell,
Arun Kumar Saha
Re: what's the best way to calculate a person's years of age in excel,
T. Valko
Re: How do I add " to the right of a number when formatting?,
T. Valko
Re: umm..hard to explain..,
T. Valko
Re: option buttons help,
Gord Dibben
RE: Variable Data within a Macro,
jeannie v
RE: Macro with Variable Data,
jeannie v
Re: create a list dependant on info in a column,
Max
How to open a new instance of Word and its .doc file,
Launchnet
Re: Pivot Table Date Format Question,
Fred Smith
Re: Macros with variable data,
Trevor Shuttleworth
Displaying hours and minutes,
John
RE: show data dependant on certain columns (2 dif questions),
ShaneDevenshire
Re: Pivot Table Issue,
Debra Dalgleish
sum column a if column b, c, d, and e are equal,
jj
Re: Index and named ranges selecting difficulty,
Bob Phillips
Re: sumproduct 3 criteria inc. date,
Bob Phillips
Re: Counting,
Don Guillett
RE: formula to add values for all the same first words in cells in,
SAM
cell protection, how to?,
S S
Re: Columns,
Vasant Nanavati
Re: Conditional Formatting bug?,
Vasant Nanavati
- <Possible follow-ups>
- Re: Conditional Formatting bug?,
Vasant Nanavati
- Message not available
- Re: Conditional Formatting bug?,
Gord Dibben
- Re: Conditional Formatting bug?,
johnston
- Re: Conditional Formatting bug?,
Gord Dibben
- Re: Conditional Formatting bug?,
johnston
- Re: Conditional Formatting bug?,
Bob Phillips
- Re: Conditional Formatting bug?,
johnston
- Re: Conditional Formatting bug?,
Gord Dibben
- Re: Conditional Formatting bug?,
johnston
- Re: Conditional Formatting bug?,
johnston
- Re: Conditional Formatting bug?,
johnston
Multi-conditional count,
Jason@xxxxxxxxxxxxx
Multiply IF AND OR comparisons,
Hannu Laine
Working with pairs of cells,
vsoler
Re: Working with pairs of cells,
vsoler
Re: IF AND Function,
Bob Phillips
Re: Function to find 'n'th largest alphanumeric field (like "Large"),
T. Valko
Re: Worksheet does not open in the last place it was saved,
Vasant Nanavati
Re: replace space,
Vasant Nanavati
Re: XL how to change a cell reference in a formula to variable value?,
Dave Peterson
How to open a new instance of EXCEL and .xls file,
Launchnet
Re: How can 0 be used in the Choose function,
Bob Phillips
Re: telephone number format change in Excel,
Rick Rothstein \(MVP - VB\)
Re: SUMPRODUCT AND TEXT INM FORMULA,
Roger Govier
Re: Mouse click automatically enters character into cell.,
Vasant Nanavati
Re: I cannot select the compare and merge button,
Gord Dibben
@average function,
Chazbri
<Possible follow-ups>
@average function,
Chazbri
Countif to pur a persons age into selected caragories.,
chedd via OfficeKB.com
Re: Finding a row/column header in Pivottable,
David Biddulph
Re: Header/Footers,
Mike G
Re: don't know how to ask the Q,
T. Valko
Re: I am trying to lookup a persons name in a table.,
T. Valko
Re: What is this formula for?,
Rick Rothstein \(MVP - VB\)
Re: Sumproduct multiplying instead of adding,
Rick Rothstein \(MVP - VB\)
Vlookup using if condition or any other way to slove problem,
dhir
Re: Cell Formatting Question,
Peo Sjoblom
Re: copy an entire row IF a statement is true,
Ron de Bruin
Re: if then question,
Don Guillett
copy worksheet multiple times base on user's input,
azu_daioh@xxxxxxxxx
weighted average rent with growth,
prussom
Re: Add a row based on other criteria,
Roger Govier
Re: Add cells across multiple workbooks that increase...,
Roger Govier
- Message not available
- Message not available
Re: USE IF CONDITION FOR 2DATA,
PCLIVE
Creating Same Links On All Pages,
Launchnet
Re: Can I use excel to send personalized emails?,
Ron de Bruin
Re: Assigning a Value based on Results,
PCLIVE
Count,
brownti via OfficeKB.com
Re: Can't find project or library,
Bob Phillips
formula range,
ADK
vlookup formula problems,
Simon888
Re: How to use Ara and ARP fucntions on Ms Excel?,
David Biddulph
Message not available
Re: Sumproduct, multiple conditions.. but I also want to "minus" somet,
Rick Rothstein \(MVP - VB\)
Re: Looking up 3 cells based on defined value in a row/column location,
T. Valko
Re: First populated cell in row array/ Last populated cell in row,
Skyscan
Re: Help to edit a formula,
T. Valko
Re: How do I make the contents of a cell appear to flash?,
Bernard Liengme
Re: HLP! Nesting Problem??,
Roger Govier
Re: excel expert with data,
Bob Phillips
Re: Looking up a value,
PCLIVE
Re: Shift lists,
T. Valko
Re: if, and match,
PCLIVE
Array formula returning the cumulative sum,
vsoler
Re: More Secure Sheet Protection,
Susan
Lookup : Syntax Error,
Steve_n_KC
Re: Linking Between Sheets and #Value! Error,
Bob Phillips
if/hide formula,
Erica
Re: COUNTIF, criteria is cell-to-cell comparison,
T. Valko
Re: enumeration members,
Bob Phillips
If Between Dates Function - please help,
Mitchell_Collen via OfficeKB.com
Remove errors,
Steve
Re: Countif?,
Roger Govier
Re: how do I combine multiple worksheets into one? not summarize,
Ron de Bruin
Re: Countif Multiple Criteria,
David Biddulph
Conditional row format,
sephiroths816
Re: LOOKUP MATCH problems,
Lacty
Re: How to do the coding on UNTIL loop?,
Don Guillett
Re: Invalid date if weekend or bank holiday,
vezerid
MoveMiddleInitial,
gh
Re: Value errors in Match function,
Ron Rosenfeld
RE: Holding company: Automatically modifying data on different workshe,
Duke Carey
Re: Pivot Table Number Format,
Roger Govier
Re: PLS HLP! Countifs Syntax Problem?,
Roger Govier
Re: Ignore errors in range,
Bob Phillips
Re: Formula,
David Biddulph
Re: Annual Change from Decennial Data,
joeu2004
Re: HELP fixing GPA formula's,
toppers
Re: Auto fill of cell with information from seperate sheet,
Gord Dibben
Re: Excel 2003,
Don Guillett
Re: Array Brackets {},
Bob Phillips
Re: How do I...,
Gord Dibben
Re: how do i calculate what i make in a year into an hour?,
MH
Re: Text in Data Validation drop down box too small. Is there any thi,
Dave Peterson
Re: Multi-Cell Array Formula,
T. Valko
Re: lists urgent help needed,
JE McGimpsey
Re: Automate deletion process,
Gord Dibben
Re: create up and down arrows to increase and decrease value in a cell,
T. Valko
Auto Filter & Display,
lehigh46
Re: nested color index within sumproduct,
Bob Phillips
Re: How can I shrink a file size w/ a pivot table and many formulas?,
sephiroths816
Too many criterias...,
sephiroths816
Re: Pivot Table Quesiton,
krcowen
Conditional Formula,
bgetson
Re: Conditional Sum Brackets { },
T. Valko
Re: Array reference in =ROWS() function,
Dave Peterson
Re: Timezone converter,
Peo Sjoblom
Re: How do i merge date from multiple sheets,
Ron de Bruin
Re: tab color on worksheets,
Bob Phillips
Re: excel,
ashley . odonnell
- <Possible follow-ups>
- Re: EXCEL,
David Biddulph
Re: A change in one cell generates (todays) date in another,
ihatetheredskins
RE: Appending or Concatenating rows by Client,
Dina
Re: Extract text from a string,
Roger Govier
Re: Problems changing array field in formula,
Bob Phillips
Re: SUMIF Multiple Workbooks,
krcowen
SUM to infinity on a column,
Bobby
RE: How to confirm the open dialogue box by using macro coding?,
Eric
Re: Match with yes or no question,
Bob Phillips
Re: how do i count specific text strings excluding blank cells?,
Bob Phillips
Re: how to multiply a =sumproduct(--(A1:A10,"Jon"), by value in row,
Bob Phillips
Re: Number in words,
Rick Rothstein \(MVP - VB\)
Re: Extracting data inexcell 2003,
David Biddulph
- Message not available
- Message not available
RE: Sumproduct and Percentile,
ryguy7272
Re: Help with function/formula please!!!,
T. Valko
Re: Concatenate formula- text diff lines?,
Gord Dibben
Re: Excel: How do I auto expand Cells to show all the wrapped text?,
Gord Dibben
Re: Averageifs & Countifs,
Roger Govier
Re: arrange excel by street address instead of alphabetically by name,
Gord Dibben
- Message not available
- Message not available
blank vs. 0 when plotting a dated timescale graph,
nbayless
Re: RATE - what is the internal function?,
Harlan Grove
RE: Pivot Table Refresh,
Tom Hutchins
Re: How do I change direction of Enter Key in EXCEL 2007,
Peo Sjoblom
Re: =TODAY(),
Mike G
Conditional Formatting on calculated text,
gin
Calendar Control,
John
Re: Using Vlookup for intervals,
T. Valko
Re: Countif with Conditions,
Peo Sjoblom
Re: How do I compare a result to a range of values?,
David Biddulph
RE: Can I merge columns from one spreadsheet into another?,
Barb Reinhardt
RE: Invert a column,
Jakobshavn Isbrae
How to merge / combine several worksheets into one new worksheet without VBA / Macro? FOR EXPERTS,
jan . patrzalek
Re: Numbers in words,
Gord Dibben
How to index the closest data(cash flow)?,
vincentwady
Re: Displaying percentage sign in cell,
Peo Sjoblom
Re: Copy a worksheet from one workbook to another,
Ron de Bruin
Re: sumif for multi conditions. i.e sumif(A1:A10,"Jon" and B1:B10,"A",
PCLIVE
- <Possible follow-ups>
- Re: sumif for multi conditions. i.e sumif(A1:A10,"Jon" and B1:B10,"A",
Peo Sjoblom
- Re: sumif for multi conditions. i.e sumif(A1:A10,"Jon" and B1:B10,"A",
Bob Phillips
- Message not available
- Message not available
- Re: sumif for multi conditions. i.e sumif(A1:A10,"Jon" and B1:B10,,
Bob Phillips
- Re: sumif for multi conditions. i.e sumif(A1:A10,"Jon" and B1:B10,,
PCLIVE
- Re: sumif for multi conditions. i.e sumif(A1:A10,"Jon" and B1:B10,,
Harry Seymour
- Re: sumif for multi conditions. i.e sumif(A1:A10,"Jon" and B1:B10,,
Bob Phillips
duplicate occurance, assigning an ordinal value,
mcheng
- Re: duplicate occurance, assigning an ordinal value,
Bob Phillips
- Message not available
- Re: duplicate occurance, assigning an ordinal value,
mcheng
- Re: duplicate occurance, assigning an ordinal value,
Rick Rothstein \(MVP - VB\)
- Re: duplicate occurance, assigning an ordinal value,
Bob Phillips
- Re: duplicate occurance, assigning an ordinal value,
mcheng
- Re: duplicate occurance, assigning an ordinal value,
mcheng
- Re: duplicate occurance, assigning an ordinal value,
Rick Rothstein \(MVP - VB\)
- Re: duplicate occurance, assigning an ordinal value,
mcheng
- Re: duplicate occurance, assigning an ordinal value,
Rick Rothstein \(MVP - VB\)
- Re: duplicate occurance, assigning an ordinal value,
mcheng
- Re: duplicate occurance, assigning an ordinal value,
Rick Rothstein \(MVP - VB\)
- Re: duplicate occurance, assigning an ordinal value,
mcheng
- Re: duplicate occurance, assigning an ordinal value,
Rick Rothstein \(MVP - VB\)
using check boxes,
Hell-fire
Re: index and sum nonadjacent cells,
JE McGimpsey
Re: Macro will work on one computer but not on another,
PCLIVE
RE: Automatic deletion of specific cells from multiple sheets,
Jman
Re: Counting Time,
Rick Rothstein \(MVP - VB\)
Email Macro specific Cells?,
neilcarden
Having Excel Move Data that has a certain value,
EGerety
- Message not available
- Message not available
Re: matching & sorting data,
Bernard Liengme
Re: Convert SMITH to Smith and JONES to Jones?,
Rick Rothstein \(MVP - VB\)
Re: Two Formulas in one cell,
Vasant Nanavati
Re: How do I return Multiple values using VLookup?,
Domenic
Re: linking cell to Pivot Table data,
Roger Govier
Re: IF condition using GMT and BST times,
Bob Phillips
Scrolling in Page Break Preview,
Nick Wakeham
Re: Calculate monthly contributions,
joeu2004
Re: Calculation time,
Bob Phillips
Re: Excel 2003 I want text quoted and then the value of a cell followi,
JE McGimpsey
Re: how do I sort a column of random dates into Consecutive dates,
Gord Dibben
Re: how to get the 2nd max value?,
Ron Rosenfeld
Every 1st, 3rd, 5th Tuesday,
Rick
- Re: Every 1st, 3rd, 5th Tuesday,
Ron Rosenfeld
- Re: Every 1st, 3rd, 5th Tuesday,
Ron Rosenfeld
- Re: Every 1st, 3rd, 5th Tuesday,
Rick
- Re: Every 1st, 3rd, 5th Tuesday,
Rick
Help with Function: Compare text and and edit in cells,
CyranoDeBergarac
GETPIVOTDATA....Excel 2000....Desperation!,
Kev
Re: Vlookup Function?,
Bob Phillips
Re: formula for automatic up on numbers in cell in exel,
JE McGimpsey
Re: Sorting,
Peo Sjoblom
- <Possible follow-ups>
- Sorting,
Arun Kumar Saha
Generating blank or null cells that the Histogram Data Analysis tool will ignore,
EddyKilowatt
Insert copied row based on value,
eazyc10
RE: Pulling in data from another source,
MLK
Re: HIDE row if CELL value is #NA,
krcowen
Re: Combining multiple formulas in one cell,
Bernard Liengme
Re: How do I reference certain rows within array formulae?,
T. Valko
Re: formula to add Alpha?,
Trevor Shuttleworth
Custom date formatting,
Del Cotter
Re: How do I find the next blank cell in a range?,
Dave Peterson
Hiding certain decimal values,
neil40@xxxxxxxxxxxxxx
Re: Copy function with Excel 2003 not performing correctly,
Peo Sjoblom
Re: Strange calculation in PivotTable,
Roger Govier
- <Possible follow-ups>
- RE: Strange calculation in PivotTable,
Angus
- RE: Strange calculation in PivotTable,
Angus
- Re: Strange calculation in PivotTable,
Roger Govier
- Re: Strange calculation in PivotTable,
Angus
- Re: Strange calculation in PivotTable,
Roger Govier
- Re: Strange calculation in PivotTable,
Roger Govier
- Re: Strange calculation in PivotTable,
Angus
- Re: Strange calculation in PivotTable,
Roger Govier
- Re: Strange calculation in PivotTable,
Angus
- Re: Strange calculation in PivotTable,
Angus
- Re: Strange calculation in PivotTable,
Roger Govier
- Re: Strange calculation in PivotTable,
Angus
Re: IF(AND problem to work out commissions,
Don Guillett
Re: A validation rule on Alpha and Numeric characters,
Roger Govier
DCOUNT Help Needed,
Khaledity
Re: "Between" dates in Excel,
Don Guillett
Cell entry using Parenthesis,
Lucky
Re: can I do this in excel,
Bob Phillips
Find last space,
Francis Hookham
Re: Pick up digist from another column,
David Biddulph
Re: SUM and IF results,
Arvi Laanemets
Re: how to get the value in the upper 5 cell,
T. Valko
Re: How to close a excel file using Macro coding?,
Dave Peterson
Data connectivity across two seperate .xls files, interesting,
sash
Re: rounding of numeros,
Bernard Liengme
Re: dates for weekdays in non-contiguous cells,
Bob Phillips
Re: How do I get more smart tag recognizers?,
Gord Dibben
Re: Worksheet_Change,
Don Guillett
Re: Please help ... comparing text,
Don Guillett
Re: How to code on Macro on saving and closing a file?,
Bob Phillips
Re: Excel columns do they exceed IV?,
David Biddulph
Re: Hexidecimal lookup,
Harlan Grove
Re: Transpose?,
Ragdyer
Re: Bowling: Handicap between Teams,
T. Valko
Re: Excel 2002,
David Biddulph
WORKSHEETS IN ALPHA,
Pamela
Re: help to count easily,
Bob Phillips
help to consolidate data,
docdutton
Formula to indicate upcoming birthdays,
Victor Delta
Re: Match and Count duplicate names,
Bernd
RE: Copy a column leaving out any blanks,
Ron Coderre
Re: Deleting Text Boxes,
Peo Sjoblom
Re: How do I activate the Link feature?,
David Biddulph
Re: Invalid data circle disappers,
MartinW
Re: Merge contents of cells and insert line space,
Gord Dibben
Sumif question,
Harry Webster
Re: Macro Help,
Pete_UK
Re: Combine firstt & last name,
Mike G
How can I do this?,
Tmaxx02
Re: Multiple IF Statement,
PCLIVE
Re: How do I get a unique number on a form when I open it each time?,
Gord Dibben
Function to find the first cell that is not zero,
Mark
Message not available
Finction to find the first cell that is not zero,
Mark
Re: random row numbers,
David Biddulph
Re: Sumif only numbers formated as currency,
Dave Peterson
Re: auto filter on multiple rows,
Dave Peterson
Re: Excel Formula for Single Cell Adress,
David Biddulph
Re: problem with vlookup,
ruchie
Re: Logical Functions,
PCLIVE
Re: SUMPRODUCT - Ignore blank rows,
PCLIVE
Duplicate Item Numbers,
lehigh46
Re: Worksheet Function,
JE McGimpsey
Re: Help with Formula,
Pete_UK
More referencing,
splat
Re: Finding Annual Growth Rate,
Bernard Liengme
Fomat cells for IP address including leading Zeros,
Pete
Re: Need help please with VLOOKUP and INDIRECT question,
PCLIVE
Re: VLookup Range Help,
krcowen
Re: How to display numbers as text? Ex: 203 = "two hundred, three",
Ron Coderre
Re: Capital Calculation,
Jim Cone
Sum all integers of a given number,
pchr
Nested VLOOKUP,
ruchie
Re: Different validation list based on cellvalue on the left,
Ron Coderre
Formula problem,
Computer geek
- Message not available
- Message not available
Re: Choose highest value duplicate,
Don Guillett
Re: convert Excel sheet in 1904 format to 1900 without changing dates,
Scoops
RE: Identifying Current Cell,
Mike H
Function to Spread Costs,
andyhofer
SUMIF Criterion with NOT,
Fred Holmes
Re: CONCATENATE number and text from different cells,
T. Valko
Relative reference for named tabs?,
Dave in Fair Oaks
copying the Hyperlink function result without copying the actual formula,
mcheng
Re: HYPERLINK() referring value from a cell does not change when cell,
mcheng
SUMIF criterion to match the first 5 characters.,
Fred Holmes
Re: Large and if function!,
T. Valko
Vacation Accrual Formula Need Help Please!,
trucker
Function for all Characters after the :,
mcbe
Re: In series of 10 digit #s, how can I exclude 1st 3 digits in each?,
David Biddulph
Re: math,
Bob Phillips
- <Possible follow-ups>
- Re: math,
Otto Moehrbach
Re: Min Fuction,
Bob Phillips
Re: Count number of text values in a specific row,
T. Valko
Re: Date going forward,
David Biddulph
Re: can you make EOMONTH work without Analysis ToolPak,
T. Valko
Re: How do I get MROUND to only round up to the next multiple.,
Harlan Grove
Re: Relation betwn 2 sets of data, user to input one, sheet returns ot,
krcowen
Re: Creating a Data Validation List based on a Value in another cell,
Roger Govier
Re: Hiding Worksheets - Problem with Posts,
Dave Peterson
Re: lookup single value in a range and return specified value,
PCLIVE
Re: Automatically update a cell,
PCLIVE
Re: Copy & pasting formulas across workbook tabs,
Peo Sjoblom
Re: Breaking out individual files from a .xls worksheet,
Peo Sjoblom
Re: Conditional Formatting for cells with formulas,
Peo Sjoblom
Help Excel Formatting,
francesllee
Re: Cannot see any posts after 6/5/2007,
Gord Dibben
non-availability of Microsoft Community Newsgroups,
toppers
Re: Finding missing values in a column,
Ron Coderre
Re: formulas appear in cell as entered..,
Roger Govier
Re: Need Help Creating a Macro Multiple Workbooks to One,
Gord Dibben
Re: Conditional Formatting - Date Refresh,
David Biddulph
Re: how can i make a list of numbers automatically,
Gord Dibben
Re: Creating a name list from if quantity value is in adjacent cell on,
vezerid
Re: Help with Hlookup/Vlookup and Lookup. From multipul sheets,
vezerid
Re: Multiple Criteria,
vezerid
Re: Multi-Conditional Functions,
PCLIVE
Re: unable to see postings after 6/5/07,
David Biddulph
Re: Formatting Cells?,
PCLIVE
Re: Sum of Column with next column containing specific word,
Peo Sjoblom
Re: Dispay two values in one cell with the / border separating them.,
Harlan Grove
Weekends,
Bob
Help with function,
Computer geek
Re: HOW CAN I MAKE AND OR ADD NEW SYMBOLS TO THE LIST?,
Peo Sjoblom
Re: IF..THEN..ELSE,
JE McGimpsey
SUMIF Conditions,
hamblin . adam
Filtering diverse values,
sephiroths816
Re: Formula Help,
Dave Peterson
Re: Lookup returning incorrect result,
Niek Otten
transposing addresses,
Mike G
Re: Trouble Freezing Panes in Excel 2003,
sephiroths816
Re: About sorting and extracting data in one column,
vezerid
Round to thousands via custom format?,
znelson
Re: Summarizing data to another sheet,
vezerid
Re: Number of days in a running period,
Bob Phillips
Re: Sum duplicates unique values and delete dupliques,
Bob Phillips
Re: Can I calculate the number of days taken off in a running period,
Pete_UK
Ifsumproduct,
stevekanc
Re: DCOUNT function not working properly on string comparisons,
Roger Govier
Re: Sumif, having two condition,
Bob Phillips
Re: 2 Conditions + Sum of a colum matching those conditions,
Bob Phillips
Re: 2 Questions,
Bob Phillips
Re: Using Sumproduct in Autofilter,
Bob Phillips
Re: Help needed in updating excel worksheet values,
Arvi Laanemets
Dana: help with your Demo() macro to "expand" formulas,
joeu2004
Re: Average,
Mark
Re: Growth,
Fred Smith
Re: Converting Julian Dates to regular dates,
JE McGimpsey
Re: Averaging,
Ron Coderre
Re: How to auto data from one work to another worksheet.,
David Biddulph
Re: Calculating sales commission that changes based on a sales volume,
Pete_UK
Re: Leading Zero and the change command,
Pete_UK
Re: Copying cells from one spreadsheet to another?,
Gord Dibben
Re: Long List of Numbers sorting,
Pete_UK
Re: Excel list boxes,
Gord Dibben
Re: vlookup not finding matching data,
T. Valko
Re: Conditional Average,
T. Valko
Re: SUMPRODUCT with TEXT and dates,
T. Valko
Re: Parsing a text string into separate cells,
JE McGimpsey
quick double-criteria lookup?,
robotman
Re: Cell Shading,
Gord Dibben
Re: Condititional Formtting a Column,
vezerid
Re: How to merge columns from one worksheet to another worksheet,
Gord Dibben
Re: LOOKUP error,
vezerid
Re: TIME SHEET FORMULA CONDITIONS,
vezerid
Skipping cells in a formula,
Brian
Re: SUMPRODUCT and Dates,
Don Guillett
Extracting characters before or after a specific character,
Brian
Re: convert number to text w/ error checking sign,
Bernard Liengme
Re: Copying and pasting from a range,
vezerid
Re: Formula for cashflow on every 90th item,
vezerid
Re: formula for current stock count needed,
vezerid
Re: Consolidate multiple worksheets into new sheet,
Peo Sjoblom
Re: Hlookup?,
JE McGimpsey
Re: Formattting Text,
Peo Sjoblom
Re: a macro that Formats a textbox based on value in a cell,
vezerid
Re: Validation in a Conditional Statement,
Pete_UK
Re: current stock formula help?,
vezerid
Re: IF statement,
JE McGimpsey
Re: I want to make convert a number in words in excel,
Bernard Liengme
Re: If statements,
vezerid
Re: COUNTIF,
vezerid
Re: How to sort data according two matching cells?,
vezerid
Re: Cell reference OR INDIRECT function,
vezerid
Calculating percentages based on the number of checked boxes in a column,
gareth . wretham
Re: Using SUMIF to update prices on a worksheet,
Bob Phillips
Re: How to retrieve entire row (actually 26 columns) of data ?,
JE McGimpsey
Re: when i try to fill a cell with color, nothing happens,
Gord Dibben
Re: ecel will only open as read only,
Gord Dibben
Re: Automatic Decimal Places?,
Gord Dibben
Re: AVERAGE NUMBER IN COLUMN PROBLEM,
JE McGimpsey
copying formulas,
dimitry
Re: How to use =sumallsheets(b1)?,
Chip Pearson
Re: TIME SHEET FORMULA CONDITIONS" ARE THEY POSSIBLE",
JE McGimpsey
day vs time format ??,
K1KKKA
Re: Help with a formula,
Ken Johnson
Re: Return blank cell if value you vlookup is not on pivot,
T. Valko
Re: how can i round in excel to the nearest thousand,
JE McGimpsey
Re: Can I include a "validation drop down" in a conditional statement?,
JE McGimpsey
Re: Sum based on specific condition,
Peo Sjoblom
Re: Date format problem,
David Biddulph
Re: search and change without replacing-excel 2002,
Gord Dibben
Re: Averaging values from a list, based on user input,
NBVC
RE: Countif with 2 conditions,
DTTODGG
Lookup based on two fields without merging?,
robotman@xxxxxxxxx
Re: formula needed to bring values to another sheet,
Gord Dibben
Re: how do I change the colour of selected auto filter tabs,
Dave Peterson
Conditional format for the whole row,
sephiroths816
Re: Color of @IF Results Cell,
JE McGimpsey
Re: Functions to ignore hidden rows,
Peo Sjoblom
Re: VIN Number sorting,
Gord Dibben
Re: Creating an IF / AND statement,
PCLIVE
Re: Sumif not criteria,
RagDyeR
Re: Combo Box,
krcowen
Re: Writing IF Statement,
Bob Phillips
Re: My formula is =IF(B5="B",TODAY(),""),
Chip Pearson
Re: TimeSheet calculatons Overnights,
Roger Govier
RE: Text import/ Text to Column,
anto
Re: LOOKUP across Multiple Sheets,
Arvi Laanemets
Re: Count Text within Multiple Worksheets,
Laffin
Re: How do I sum cells by refering to discrete values?,
Bob Phillips
Re: Help on sumproduct function,
Roger Govier
Re: lookup with INDEX MATCH formule depending on 2 conditions,
Roger Govier
Looking up and reporting values across tabs,
gareth . wretham
It's a filter but not a filter,
matthew . clegg
Re: Custom format field,
David Biddulph
Re: A1= A2 (When selected).A3 (When selected),
Joerg
Re: HLOOKUP INDIRECT with alpha numeric worksheets,
T. Valko
Is there any way to delete a Digital Certificate,
Mac Lingo
Re: calculating a discount rate,
joeu2004
Re: Protected worksheet,
Harlan Grove
Re: Expanding Formulas,
joeu2004
- Message not available
- Message not available
Re: How do I change minutes (1.5) to 01:30?,
David Biddulph
Re: Need to 'COUNT'...,
JE McGimpsey
Conditional Selection,
matthew . clegg
Re: OFFSET: Returns error when used to a linked file,
Harlan Grove
Re: Multiple Lookup Application,
T. Valko
Offset / Match / MAtch,
Michel Khennafi
Re: Calculating earliest start and latest end dates by contract,
T. Valko
lookup value and date from a list with restrictions,
antonio
Re: How do I run a macro from inside an"=IF" formula in Excel 2003?,
moon
Re: Choosing last set of data in column,
Toppers
Re: adding time,
David Biddulph
Re: Date Generation,
Peo Sjoblom
Re: combining cells,
Bob Phillips
Re: Need to do an EXACT LOOKUP,
Niek Otten
Re: How to auto fill with fifth cell in a column?,
David Biddulph
Re: Command Button to run a Macro,
Bob Phillips
DCOUNT problem with numbers stored as text,
MJP
Re: Time Formula,
Bob Phillips
VLOOKUP,
Jerry
Re: ecel:create a file name from data in worksheet,
Susan
Re: give text a dollar numeric value,
Bob Phillips
Re: How to divide a number into various denominators,
Dave Peterson
Re: Autofill doesn't give the number of records filtered any more,
Roger Govier
Re: Basic formula - forgotton !!,
David Biddulph
Re: formula calculation,
Roger Govier
RE: Conditional Formatting,
singingsister
Re: Concatenate format,
Roger Govier
Auto Filter function only provide 2 criteria input,
Kent
Re: Master Worksheet Display,
Bob Phillips
Re: Ranking or sorting function,
T. Valko
RE: Auto scroll down event,
excelent
Look up 2 values, return result in a different workbook,
Positive
- Re: Look up 2 values, return result in a different workbook,
T. Valko
- Re: Look up 2 values, return result in a different workbook,
Positive
- Re: Look up 2 values, return result in a different workbook,
Positive
- Re: Look up 2 values, return result in a different workbook,
T. Valko
- Re: Look up 2 values, return result in a different workbook,
Positive
- Re: Look up 2 values, return result in a different workbook,
T. Valko
- Re: Look up 2 values, return result in a different workbook,
Positive
- Re: Look up 2 values, return result in a different workbook,
T. Valko
- Re: Look up 2 values, return result in a different workbook,
Positive
- Re: Look up 2 values, return result in a different workbook,
T. Valko
Re: Lookup,
T. Valko
Comparing two lists using Conditional Formatting,
roniaelm
RE: Array Formula Using LOOKUP function.,
Ron Coderre
Excel VBA help,
tmobccr2
Re: how do i create table of contents links/pg for multiple workbooks,
Gord Dibben
Re: copy cells,
Don Guillett
Re: Apply conditional formatting to individual cell Excel 2007,
Roger Govier
Re: function for repeated cells,
T. Valko
Re: How do I use excel for orders of 250 photos for 200 staff,
MartinW
Re: conversionof numeric data in word,
Bob Phillips
Re: Format Cells for Mins / Secs,
Roger Govier
Re: Highlighting with hyperlinks,
Gord Dibben
maybe by sumproduct or some other way with text.,
driller
PER function,
jpanknin
Array formula on INDEX function not working,
vsoler
Re: List cell values seperated by comma if criteria met,
T. Valko
Re: Extracting data,
Ron Rosenfeld
Re: Sum from two pages,
Gord Dibben
Re: type a 00 . It keeps changing back to 0,
Gord Dibben
Maximum filesize?,
Jen
Levy Jennings QC template,
jimbo
Re: LOOKUP, MATCH, INDEX?,
Rick Rothstein \(MVP - VB\)
- <Possible follow-ups>
- Re: LOOKUP, MATCH, INDEX?,
RagDyeR
- Re: LOOKUP, MATCH, INDEX?,
Ragdyer
- Re: LOOKUP, MATCH, INDEX?,
Roger Govier
- Re: LOOKUP, MATCH, INDEX?,
ShaneDevenshire
- Re: LOOKUP, MATCH, INDEX?,
RagDyeR
- Re: LOOKUP, MATCH, INDEX?,
ShaneDevenshire
- Re: LOOKUP, MATCH, INDEX?,
Ragdyer
- RE: LOOKUP, MATCH, INDEX?,
bob
RE: Adjusting Timeline with a link,
¤§Tarzan§¤
Re: SUMPRODUCT MISSING SOME ITEMS,
vsoler
Re: How do you remove some numbers in a series eg 1500024500 = 24500,
Roger Govier
Re: SUMPODUCT - Some one please help !!!,
Roger Govier
Quick Go To for Formula Components Other than First,
excel wonk
Vlookup question,
Tremag
Re: determine wheter string has a number in it?,
T. Valko
RE: summary of milestone,
JLatham
Re: nested vlookup does not work,
T. Valko
Re: How to change text color in a cell "comment" in Office 2007?,
Sebation.G
Sorting errs,
SG
lookup a value from a list excluding a previously found value,
antonio
Re: multiple if statment,
MyVeryOwnSelf
Re: custom autofilter,
Dave Peterson
Re: splitting cell,
David Biddulph
Re: How do I change the size of the drop-down arrow after validating?,
Dave Peterson
Re: Subtracting Text from Number,
PCLIVE
Re: on time indicator,
David Biddulph
Re: INDEX/MATCH/LARGE returning #VALUE! error,
Roger Govier
Re: Compare data in one sheet to another,
Peo Sjoblom
Re: copying one cell in multiple sheets into a column on one sheet,
vezerid
Re: Invoices,
JE McGimpsey
Re: SUMPRODUCT,
Roger Govier
- Message not available
- Message not available
Displaying calculated times - half-hours are not calculating...,
jacob
Re: Updating Master Log records,
Sinner
- Message not available
- Message not available
Merge of cells,
Heine
Re: sorting column data,
Don Guillett
Re: Counting non-blank cells in a column, excluding hidden rows,
Don Guillett
Re: Calculate Percentiles with dynamic ranges,
vezerid
Re: Distribution of amount using If Cond / any other function / by VBA,
vezerid
Re: Sorting numbers with two decimals,
vezerid
Re: I don't understand this formula {=TABLE(d19,d21)} - please help,
Roger Govier
What does this function do? {=table(D19,D21)},
Ridgeline . capital
Re: how to find common cells in several columns,
vezerid
Re: Date question,
vezerid
Converting annual rate of return to quarterly equivalent?,
Carl LaFong
Re: Return an absolutely empty cell ... but not "",
T. Valko
Conditional Ranking,
matthew . clegg
Frame an Invoice from the data available in a separate sheet of excel,
No News
Re: If function help,
Frank
Re: eliminate space at beginning of line,
Roger Govier
Re: How to Validate Excel for SOX (Sarbanes & Oxley),
Harlan Grove
Re: get a column of cells to add if current month,
Roger Govier
Re: cannot enable redo-undo function,
Oldtimer
Re: Data Validation,
Pete_UK
Re: Sort by Year and Week,
Pete_UK
Re: Sort by week and year,
Pete_UK
Re: Adding and Subtracting a Time with MilliSeconds,
Erny
Re: copy all and paste values for all sheets in a workbook,
cass calculator
Re: Formatting & Formula Problem,
Titanium
Fill Cells Based On Cells In Another Sheet,
blackice912
Re: Formula for Pulling partial data from one cell into another,
Rick Rothstein \(MVP - VB\)
