microsoft.public.excel.worksheet.functions
- Analysis Cubes add-in for Excel 2003 - Two Problems,
Dwight Specht
- Font size for Comments,
Manju
- List FullFilePath and File name,
FrodeOlsen
- Re: Weeks of Supply Function,
Jim Cone
- Re: Help with adding 10%,
David Biddulph
- Performance Measures and Conditional Formatting,
Giacomo
- Help with an Index Match Array,
petes_girl via OfficeKB.com
- Re: Lookup?,
Bob Phillips
- Macro help in veryifying data,
tweacle
- Re: lookup problem.,
Bernard Liengme
- Total multiple worksheets into totals worksheet,
David
- Display section of worksheet,
Grammie
- Extracting Info From Within A Text String,
nospaminlich
- Re: FIFI Method,
joeu2004
- Re: Counting Multiple Instances,
Bernard Liengme
- Re: Excel Page Formatting,
Gord Dibben
- Re: simplify a macro,
vezerid
- Re: Multiple If (Lookup?) Statement,
Roger Govier
- Re: Macro Error,
Dave Peterson
- Re: SUMIF/PRODUCT & DATES,
Bob Phillips
- RE: Formula based on text value..,
CLR
- Joining dates and text in formula,
RJS
- Eliminating 0 values when using the Small formula,
MIchel Khennafi
- Re: IF NOT THEN,
SteveW
- Index function?,
MIchel Khennafi
- Re: Track time to resolution (without including after hours on weekdays and weekends),
ljasonmiller@xxxxxxxxx
- Re: Sumproduct assistance - need multiple ANDs and ORs,
Bob Phillips
- Re: Last row that contains data in a column,
Domenic
- Re: Can I convert numbers to text in Excel?,
Bob Phillips
- IRR & XIRR - Different Results,
Alex Morgan
- Re: formulas from tab to tab,
shail
- Re: vlookup. HELP,
Bondi
- Days per month for calculating storage days,
Bart
- Re: Using 'OR' with validated data,
Bob Phillips
- Exception with EXCEL 2007 API,
Sharad Birajdar
- Re: excel worksheet,
David Biddulph
- Re: Inverse Tangent in excel formulae,
David Biddulph
- Re: how to copy only values and formats of worksheets to new workbook,
David Biddulph
- Re: left function,
Bob Phillips
- Re: Merging two Cells without losing info,
bony_tony
- Re: Automatically copy formulas/functions to inserted rows.,
T. Valko
- Re: keep the results as positive numbers,
Gord Dibben
- Re: Referencing last cell,
Alan
- Message not available
- Message not available
Re: Excel Formulas,
Bob Phillips
Re: Formulas cut and paste but do not compute,
Max
Re: refer to sequential sheets in a formula,
Max
Re: Does Excel keep track of leap years when making date calculations,
Dave Peterson
Re: How do I enter postccripts in an Exce, such as for powers of a nu,
T. Valko
Re: Named Ranges,
Trevor Shuttleworth
Re: copy a formula within a row from a column on another worksheet,
T. Valko
RE: Need help with some rather complex formulas......,
Dan B
Re: Lookup Value (and Total) Based on Two Criteria,
T. Valko
RE: How to select top six numbers from a of range of random number,
Jack M Taylor
Re: Find value in array,
Kevin Vaughn
Re: Accrual Formula,
Sandy Mann
Re: Assigning numerical value to text,
T. Valko
Re: fill the value in the cell when move the tab over,
David Biddulph
multiple entries per cell to save on table size?,
bactfarmer
RE: Military time not properly calulated,
0be1
Is the first character a number or letter,
bactfarmer
Stumped with VLOOKUP error,
bactfarmer
Finding Minimum Value in series, excluding zero values,
cpretzinger
Re: COUNTIF & AND Functions,
Don Guillett
Re: Reference a footer in a cell,
Juan Pablo González
Re: Multiple if statements I think,
David Biddulph
Re: SUMPRODUCT problem, using OR within statement,
Don Guillett
exam scheduling in Excel,
PaTodd
Re: how can i count text in a ranges of data,
Ron Rosenfeld
Re: Can't ungroup in Pivot Table Results - or how do I get what i want,
Debra Dalgleish
Re: Calculating Excess Days Formula,
Lori
Re: excell worksheets,
Don Guillett
Message not available
Re: IF statement to calculate based on cell values,
Jason Lepack
Re: Returning data,
Bob Phillips
Re: IF statement to calculate time usage in specific time bands,
Bob Phillips
Re: drop down lists,
Bob Phillips
IF OR Q,
Sean
Re: List,
Roger Govier
Re: How to make the current date appear when i click 'enter' in a cell,
Roger Govier
Re: SUMIF with four criteria,
RichardSchollar
Re: Find Applicable Formula, then Use It,
T. Valko
Re: custom cell formating,
Gord Dibben
order form,
Abe
Re: Indirect Formula Problem,
Pete_UK
RE: scheduling,
mittymun
Re: Cell displays formula and not result,
ragdyer
Re: How do I set up a conditional sumproduct formula (ie. sumifproduct,
Roger Govier
Re: Vlookup if 0 then POA,
Roger Govier
Re: Publishing a Pivot List in Excel 2007,
Roger Govier
Re: .XLS to .CSV Macro Conversion,
Dave Peterson
Need help with some rather complex formulas...,
Dan B
Re: Issue sorting by date,
David Biddulph
Re: Columns and Row headings switch to right side of screen,
Ron de Bruin
Re: Returning looking up all values in a list,
T. Valko
Filter Formula,
Josh O.
Non repeating random numbers,
Rowland
RE: offset,
Eva
Display Monday or Thursday,
Deb
Removing spaces in cell,
Tom
RE: Zero as a value,
StephanieH
Searching and finding,
Titanus
Re: 3 nested IFs causes error,
Niek Otten
Re: SUMIF, Text, and Leading, 000s,
Harlan Grove
Re: Sum numbers based on value in other cells,
Bob Phillips
Re: Time Calculation,
David Biddulph
Adding today's date if certain conditions apply,
Daniel Lapin
RE: Syntax for Info or Cell function for xl. file creation date,
driller
Re: how to match Id and Student ID,
Max
Re: Row to 2nd sheet,
Roger Govier
Last day of the month,
George W. Barrowcliff
Re: Checking if information in a cell is within a column,
Roger Govier
Re: Pivot table calculated field and subtotal,
Debra Dalgleish
Re: Vlookup information from blank cell,
Doug
Re: How to hide/unhide sheet Tabs in Excel 2007?,
Ron de Bruin
Re: Extremely complex IF statements,
Pete_UK
RE: I need a sort to descend and ascend simultaneously,
Irishimp23
Re: using if iserror on aonther sheet,
Dave Peterson
Re: Stumped with Excel,
Niek Otten
Re: command button,
Bob Phillips
RE: how to create function,
Dave F
RE: copying formula without scrolling 9000 rows,
Martin Fishlock
- Message not available
- Message not available
Excel spreadsheet sending email based on cell formula,
excelnut1954
Re: Sorting in pivottables,
Roger Govier
Re: Result required in 365-Days Bases,
RichardSchollar
Re: VLookup - multiple values,
RichardSchollar
Re: Using SUM with INDIRECT.EXT,
Harlan Grove
Dates for month in cell a1 downwards,
pano
Unique draws "Football",
Michael
Re: pmt() uses 360-Days Bases, I need 365-Days Bases,
JE McGimpsey
removing specific data from fields,
splat
vlookup last character of 102 char field,
splat
help with 12 week rolling average,
Dominick03
Print Macro both sheets at once with option to select days etc,
pano
RE: Need to find a function.,
MikeCampbell
Re: Cells with formulas won't update unless I click in browser Why?,
Alan
Re: How do I post a picture into a cell and have it stay there?,
Gord Dibben
Hiding columns without usimg a macro,
Mick
Re: vlookup help....PLEASE!,
T. Valko
How to create a function,
galsaba
Re: Sequential numbering with Subtotals,
T. Valko
Re: summating vlookup or index formulas,
T. Valko
Re: Formula to count numbers past a specified limit,
RiTSo
Working days left in a month.,
Doc203
Adding to current cells,
Tom
Re: IF Formula Help,
Dave Peterson
Help With DATEVALUE,
Dick Frederick
RE: How to sum a column from not the first cell,
Gary''s Student
Re: how to put 0 instead of #n/a,
SteveW
Re: degree or angle,
David Biddulph
Re: signing in,
David Biddulph
Re: exluding missing data values from equation,
T. Valko
Selection AutoFill, Excel 2000 & 2003,
James Cooper
Re: In spread sheet the numbers entered as whole numbers become decim,
MartinW
Re: Last non blank cell in selected cells,
T. Valko
Message not available
Sum within a date range meeting one other criteria,
Doc203
Re: SUMIF and AND function,
T. Valko
Re: Excel Formula Help,
Fred Smith
RE: Help with a formula. Lookup? referance?,
JLatham
RE: how to add a value based on a date change in Excel?,
daddylonglegs
COUNTIF Function with mulitple criteria?,
Corey
Using cell as worksheet name to return data on that sheet,
Rookie_User
Re: Nested IF function Revisted,
T. Valko
Re: Do not paste in hidden cells,
Dave Peterson
Re: Calculating averages (olympic style),
Bernd
Looking for a macro/function in an excel spreadsheet (Help),
Keith (Southend)
Help with Vlookup and if,
petes_girl via OfficeKB.com
Re: different text colours in the same cell in excel,
Don Guillett
cmdbarmenu focus problem,
pjbur2005 via OfficeKB.com
Conditional Formatting - 2 Worksheets one Named Range,
Sam via OfficeKB.com
Re: Excel 2007: Suggestion on for a full screen page reference menu,
MartinW
Re: Date Formulas,
Niek Otten
Re: Ratio - How To Create Your Own Function/Formula,
Harlan Grove
Re: sumproduct multiple selections,
T. Valko
Sumif w/ 2 conditions in in different rows,
St@cy
Re: What is an Excel function that will calculate rebates?,
Mike Middleton
IF AND OR functions,
Jiggy
RE: Adding to and subtracting from with no true value?,
Jackie
RE: Trying to move photo behind text. "Send back" doesn't work.,
Judy
Re: Conditional sums for adjacent cells,
Trevor Shuttleworth
- Message not available
- Message not available
RE: Excel 2007 Documents,
Jim
Re: Look up unique value over several columns of data,
Domenic
RE: Want to compare data in two numeric column,
homefunwork.com
Re: Array functions,
Domenic
Re: If Statement and a List,
T. Valko
Re: ranking by mutliple categories,
Domenic
Re: Sorting and Blank Cells,
Pete_UK
RE: Insert a BLANK value,
Jop Duyvendak
Returning value of active cell,
Sergio
linking workbooks,
Pennywis1
Re: English Currency Types,
Bernard Liengme
How to activate drop down box using keystrokes not mouse,
Lesliec4000
Advanced cell function. is it possible,
Tosco
- Message not available
- Message not available
RE: Advanced cell function. is it possible,
Jop Duyvendak
Re: How to extract email address in hyperlink,
Dave Peterson
Re: Excel All formula.....Req,
Gord Dibben
Re: auto transfering info between work sheets,
vezerid
Re: adding multiple vlookup results,
vezerid
Re: ROUNDUP MONEY VALUE IN SAME CELL AS % INCREASE,
Roger Govier
Re: countif bigger than zero fractions,
RichardSchollar
F- Keys,
Sulley
Re: Formuals not working in existing workbooks,
Roger Govier
Second Friday,
Deb
case sensetive data validation,
spam . obsen
Re: Data Validation when a list is already in place,
Bob Phillips
Re: how do I convert a value into timevalue on excel?,
Roger Govier
Re: Paste Special - Formulas - Add,
Roger Govier
Re: Lookup multiple lines,
Domenic
Re: How do i set up a drop down list and hide my list data.,
Roger Govier
Probability Win x Races, Win Exactly x Races, Etc.,
RiTSo _
Re: Probability Win x Races, Win Exactly x Races, Etc.,
Mike Middleton
Re: Probability Win x Races, Win Exactly x Races, Etc.,
RiTSo
Re: Probability Win x Races, Win Exactly x Races, Etc.,
Harlan Grove
Re: Cell shatracter length limiting.,
MartinW
Re: Exporting to excel from SAP,
Roger Govier
Re: Pivot table,
Roger Govier
VLOOKUP post UDF (#DigitsFirstID) creates error,
bactfarmer
Re: Find in string,
David Biddulph
Re: Total sum based on different costs for each new quantity group,
MartinW
Re: help with functions,
Harlan Grove
Re: I need to return the lowest time value in a range of cells.,
T. Valko
Re: Can I make excel 2003 use 1-2-3 commands (like in excel 2000)?,
Bernard Liengme
Re: Name ranges and Lookup,
Dave Peterson
Re: Hide Duplicate Rows,
Lori
division symbol in sas,
sasnew
Re: Calculating daily hours (as text) in the weekly total formula,
David Biddulph
Re: Offset Help,
T. Valko
Re: Items in Workbook won't calc,
Niek Otten
Re: XIRR,
Harlan Grove
- <Possible follow-ups>
- Re: XIRR,
Fred Smith
Re: Vlookup for multiple criteria, multiple worksheets,
T. Valko
Re: How am i able to view the formula bar as I am typing in a cell?,
Gord Dibben
Re: if/and formulas,
Pete_UK
Re: Do I want to create a Circular references,
Gord Dibben
Re: If, Then formula - Multiple levels,
Pete_UK
Re: How do I set the contents of cell to Null in Excel 2007?,
vezerid
Re: Why won't the SUMIF function in Excel add time?,
Don Guillett
Re: Variable worksheet name in offset,
Roger Govier
Re: Days in a month as of today,
Roger Govier
Automatic job id number once enter a row,
mlm823
Re: Spellcheck function in Protected Sheet,
Gord Dibben
Conditional format oddity in Excel 2007,
neil40@xxxxxxxxxxxxxx
Re: Can I set up a default footer that will appear in every spread,
Gord Dibben
Re: Discerning data by the date,
vezerid
Re: How do I round a number to the nearest 600 in Excel?,
Bernard Liengme
Re: Macros and protect sheet,
Bob Phillips
formula for Canadian Postal Codes,
LB
Re: Enter current date automatically in filename,
CoRrRan
Re: Conditional Fomarting,
SteveW
If Date Null Show Nothing,
Ardy
sumproduct for multiple sheets,
sarahbenoit
Re: Sumproduct assistance,
Bob Phillips
Re: Runtime error prevents Excel 2000 to save file,
Charles Williams
Printing variable length pages,
General Specific
Re: how do i create a formula in excel - demechani,
Tom
Re: insert records,
vezerid
Re: V LOOK UP AND IF STATEMENT,
vezerid
the "0" number is lost when combining multiple columns,
Hal
Re: Stuck on Nested IF Function,
David Biddulph
Re: indirect function,
CoRrRan
Re: Error calculating date,
Roger Govier
Re: Complicated Date formula,
Roger Govier
Re: conditional format by comparing to current date,
Roger Govier
Re: Sort list,
SteveW
Re: Postings without questions in the body of the message causes an er,
Gord Dibben
How to apply a 25% price increase to a column of rates.,
woolfie
Vlookup on Multiple Sheets,
Excel_Oz
Re: Can Excel automatically change the font color of an expired date?,
SteveW
Re: Why did text in entered formula change to red in Spreadsheet,
Gord Dibben
Re: lookup when there is multiple same numbers,
T. Valko
Re: IF or similar but true result to display in consecutive row,
T. Valko
Moving Cell Information from one workbook into another workbook,
genegulledge
Re: Count each entry of a day,
Don Guillett
Re: Formula for High Value,
CLR
macro to copy worksheet,
vitorjose
Re: Return cell name,
DavidS
calculating payback of an investment,
RobertH
Re: Excell spreadsheet formula,
Gord Dibben
RE: automate row insert to archive,
Tim
Re: simple macro question,
Gord Dibben
In Excel linked values turn to #REF! after clicking don't update,
guido
Re: Highting rows based on content of cells,
Ron de Bruin
Re: How do I make a column of data sort into rows?,
Bernard Liengme
Re: I'm trying to count sick and vacation days,
Bernard Liengme
Re: Assigning rank or appearance,
Bernard Liengme
Re: How to determine if a cell has a value, then copy it to a new loca,
Dave Peterson
Re: Changing 123456 to $1234.56,
Dave Peterson
Re: Bulk vlookup?,
Gord Dibben
for mayer: very fantastic news server - ag ruc - (1/1),
jermain
Re: Adding 6 Months to a Date,
Harlan Grove
Re: Count If,
Don Guillett
merge certain columns from worksheets,
rhwong via OfficeKB.com
Re: SumProduct and MatchingProblem,
Bob Phillips
Re: I need to select rows that have red text or are high lighted?,
Lori
Re: Multiple reference through multiple worksheets,
Charles
Re: Find the bottom cell that contains a specific val in a range?,
Lori
Re: Change Row Color,
Bob Phillips
Re: How do I generate a list of the tabs/worksheets from a workbook?,
Bob Phillips
Re: Select multiple names from drop down list,
Bob Phillips
Re: use of ISERROR,
Bob Phillips
selecting text area,
dave7
Re: How to setup a ratio,
Pete_UK
Re: VLOOKUP and LARGE,
Bernard Liengme
Re: Can I use OR function here,
Bernard Liengme
RE: How do I make a Coupon Book for payment from another party?,
JLatham
Re: My number shows as text,
macropod
Re: Keeping contents of cell A1 showing when scrolling.,
Bob Phillips
Re: Macro: Updates a formula or value when a data is entered.,
Bob Phillips
Re: Function that returns the month name,
Leo Heuser
Re: Changing whole numbers into decimals,
Joerg
Re: conditional format for if month(today) = xxx,
Dave Peterson
Re: probability,
Mike Middleton
Re: Comments on a Pivot Table,
Debra Dalgleish
Tabs in alphabetical order,
exrailman
SumIf Function,
Scott Halper
Re: Nested IF statement,
vezerid
Re: Save Column when importing from Access,
vezerid
Re: Count Saturdays in a List,
vezerid
Re: simplify VLOOKUP with conditions,
T. Valko
Re: VLookups - too long to re-calculate,
Charles Williams
Formula That Counts First Value Only In Array As A Condition,
mwheelock
Re: importing data into excel,
Pete_UK
http to text,
George W. Barrowcliff
VLOOKUP and IF Functions,
Peter W Soady \(UK\)
Re: Excel Pivot Tables-How to put two Data Varibles side by side,
Jason Lepack
Re: displaying output of a formula to be in double quotes,
Dave Peterson
Re: question about offset function,
OTS
Bizarre behavior in VLOOKUP function,
Michael Boydston-White
Re: create new variable,
Pete_UK
Re: Can excel tell me what numbers in a given column sum to X?,
Harlan Grove
Creating tables based on looking down a column and back across a row,
thecrow
equation / function question,
dhowell
Re: count unique values & filter,
Domenic
Re: IRR & #DIV0!,
joeu2004
Finding a text box,
Richard . Carr
Re: Countif Using Multiple Columns,
Dave Peterson
How to delete duplicates between workbooks?,
Jay
Re: Counting Characters,
Pete_UK
Re: There is a spline interpolation function?,
Jon Peltier
Re: formula for colour,
Pete_UK
Re: Run on open macro,
RichardSchollar
Pick which sheet to put a wordart stamp on,
pano
Re: Help required about vlook fomula,
Pete_UK
Re: help required about vlookup formula,
Pete_UK
Printing Macro how do I,
pano
Re: colour changingusing VBE,
Pete_UK
Re: Trying to use Lookup with Named Columns,
Bob Phillips
Re: Currency sum not correct Excel 2003,
Bob Phillips
Really strange issue with simple formula,
c mateland
RE: Data auto sorting,
Freshman
Re: Compare columns, count matches,
T. Valko
Can you do this with a list???,
pano
incrementing a date that the user has entered?,
pano
Re: How do I arrange a formula between cells that are not together?,
MyVeryOwnSelf
Re: Trying to List data that is being entered into an Invoice,
PY & Associates
Re: Excel Workday Function,
Ron Rosenfeld
Re: IF Statement in excel for a date,
Sandy Mann
Re: worksheet reference,
Bob Phillips
Re: page numbers in workbooks,
Richard O. Neville
Re: how can i round a dollar amount to the nearest thousand?,
joeu2004
Re: Cutting and Pasting cells from horizontal to multi vertical column,
Gord Dibben
Re: IF Statement with 3 parameters,
FxM
Re: Subtact 2 dates to get the number without counting weekends?,
vezerid
Re: Calculating Finance Charges,
joeu2004
Re: Multiple Number Ranges Results in Text ('A' if 1-5, 'B' if 6-8, et,
JE McGimpsey
- <Possible follow-ups>
- Re: Multiple Number Ranges Results in Text ('A' if 1-5, 'B' if 6-8, et,
Bob Phillips
- Re: Multiple Number Ranges Results in Text ('A' if 1-5, 'B' if 6-8, et,
David Biddulph
- Re: Multiple Number Ranges Results in Text ('A' if 1-5, 'B' if 6-8, et,
Leo Heuser
- Re: Multiple Number Ranges Results in Text ('A' if 1-5, 'B' if 6-8, et,
Leo Heuser
Formula or Macro to insert Data in Cell when having more than 7 Functions,
pwk
Re: Help with array lookup and max,
Roger Govier
Re: Insert a day on change of other cell,
Don Guillett
Re: How do I solve for x?,
Bernard Liengme
Re: vlook,
Don Guillett
Re: Clear list from weekends,
Pete_UK
Re: serial numbers with hidden rows,
Don Guillett
Running total question,
Mike Hyndman
Re: Get Date of Birth from a ID Number,
Bob Phillips
Finding last receipt number in a column ?,
pano
Re: How can I match a calculated date to closest date from a list?,
Bob Phillips
Automatic Numbering,
Fortune
Re: replacing text within a formula,
Roger Govier
Re: detecting duplicate input in a cell,
Roger Govier
Re: Formula won't adjust after sorting data,
Jason Lepack
Message not available
RE: formula returns a blank,
Martin Fishlock
Show Null As %0,
Ardy
Re: Highest 12-Month Period Average Over Range of Months,
Roger Govier
match and large fumction,
Rowland
Re: Buttons,
Corey
Check dates in spreadsheet against expiry years column and change colour,
OHSGoddess
Re: How do I add up time and minutes in a spreadsheet?,
Lynne
Re: description of countif criteria?,
Don Guillett
Re: How to return 1 with #VALUE!?,
JE McGimpsey
Re: Does anyone see this .xls]sheetname?,
Dave Peterson
Re: Cut and paste options,
ljasonmiller@xxxxxxxxx
Re: Cut & Paste visible cells on same row,
Don Guillett
Re: formula that works in a different workbook,
bridgesmj
Re: apply different prices to different quantities (variable pricing?),
Roger Govier
Re: Lookup Formula help,
Roger Govier
Adding random noise to data,
Augabog
Re: Cells Slide Under,
CLR
Re: COUNTIF cannot count decimal number occurences,
Dave Peterson
How do I highlight data differences in workbook,
tweacle
Re: Need formula to add a set amount to a balance on a specific date,
Don Guillett
Labor costs for estimates,
CIL
Count unique if text,
Mike Fogleman
- Re: Count unique if text,
T. Valko
- Re: Count unique if text,
Mike Fogleman
- Re: Count unique if text,
Mike Fogleman
- Re: Count unique if text,
Mike Fogleman
- Re: Count unique if text,
Mike Fogleman
- Re: Count unique if text,
T. Valko
- Re: Count unique if text,
Epinn
- Re: Count unique if text,
T. Valko
- Re: Count unique if text,
Epinn
- Re: Count unique if text,
Mike Fogleman
- Re: Count unique if text,
Mike Fogleman
- Re: Count unique if text,
Epinn
Return Unique Duplicate Numeric Values across Single Row,
Sam via OfficeKB.com
Re: use a worksheet as a form to collect data,
Paul Kinnear
Formula problems,
Lago2004
Re: Automatic Quote Number Creator,
JE McGimpsey
Re: Find max Row() number for a value in column,
Bob Phillips
Re: Rows not formatting all the way down,
Don Guillett
how do I paste range name list?,
Adesso
Vlookup on partially sorthed lists,
Sean
DSUM - non contiguous criteria range,
Nick''s brother
linking 12 monthly workbooks to one year to date workbook,
John
Pivot Table - Problems when using Calculated Item,
sg
Converting a formula to a date,
tom
Re: How do I hide a divide by zero error from an average formula?,
Dave Peterson
Re: saving filters,
Debra Dalgleish
Re: not showing pivot values of zero,
David
Find the top Scores per School,
Puzzled_User
What is the problem with this formula?,
rachitm
return the largest value associated with a duplicate occurrence,
Puzzled_User
Re: How to return to a cell after sorting a spreadsheet.,
Paul B
Re: How to repeat calculation for all cells in a column?,
Dave Peterson
Re: Array formula for unique values,
T. Valko
Re: conditional formula with multiple conditions and answers.,
T. Valko
- Message not available
- Message not available
RE: Most recent price per item,
JLatham
NA,
Darts via OfficeKB.com
Re: Calculate the number of months between dates include partial month,
JE McGimpsey
Re: How do i make excel auto-select the data from a different tab?,
JE McGimpsey
Lost in the lookup!,
Grandma B
Re: function to find the row number of the maximum value in a collumn,
Ron Rosenfeld
RE: Drop-down lists with colours or pictures,
Agneta in Stockholm
RE: Data Validation Problem,
Mark S
Conditional formatting date ranges,
arkmpr
LOOKUP and #N/A Error,
Poody
LOOKUP with 2 or more criteria,
Tomas
RE: remove links when pasteing formulas from one workbook to anoth,
Roger
why a excel file,one sheet only, take 23 Mb ?,
MCortes
= in cell does not upadate,
Karlos
RE: My SUM function is totalling to 0,
tom
Can I save custom headers and footers to use in other files?,
Gcwensel
RE: hiding zero values on all sheets & by default on new sheets,
vttanker
RE: columns like in word,
jenn
adding data to existing data cell,
Curious
Calling cell values from random sheets from a base sheet,
edwrobis
Display Months by looking at the dates,
hamad.fatima@xxxxxxxxx
another array question,
Robert Dieckmann
WORKDAY Function in an IF statement,
vkocheilas
Re: Creating number from groups of numbers,
frankjh19701
Function to detect type of cell contents,
Mark
Conditional IF statements,
sike11 via OfficeKB.com
Joining text in one cell,
ca.ankitgarg
Excel Function - Please help,
Neil Hindry
Re: How can I interpolate values off a table?,
Lori
Same dates in Sheet1 put as one date in Sheet2,
inta251 via OfficeKB.com
embarrassed,
Al
sales invoice,
Al
Re: excel, multiply problem,
Gord Dibben
Re: Conditional formatting a range of cells,
RagDyer
Re: Changing numbers/percentages to letter grades,
Alan
Re: Fit scores,
Pete_UK
Re: Why do columns zero out when I try to re-sort two spreadsheets,
RagDyer
Re: Vijay,
PY & Associates
Re: Vlookup problem is killin me.,
RagDyer
Re: CAR LEASE CALCULATION WITH RESIDUAL,
joeu2004
Re: If, Then Values,
JE McGimpsey
Re: why won't my cells format correctly?,
Alan
Re: Count the number of times a hyperlink is viewed,
Dave Peterson
Re: Simplifying VBA code,
Don Guillett
- Message not available
- Message not available
min & max values,
Robert Dieckmann
Re: Counting specific character in text string,
JE McGimpsey
Re: formula returns blank,
Sandy Mann
Re: SUMPRODUCT Formula Help,
JE McGimpsey
Re: how to creat a formula to advance date by one year,
Bernard Liengme
Re: Keyboard Arrows,
Bernard Liengme
RE: Creating drop down box with worksheet names,
Steve
Re: function to display contents of a cell,
JE McGimpsey
Re: Assistance with Alphabetizing a Library Worksheet,
Gord Dibben
Re: HOW DO I GET THE DAY (MONDAY) FROM A DATE (01/01/2007),
JE McGimpsey
Re: using sumif to sum a range of values,
JE McGimpsey
Re: how do I use a file list to recall data from listed files?,
Gord Dibben
Find Duplicate Values and Return Another Value,
stacy . mcmillan
Re: Dynamic Rolling Average,
bda75
Re: Order of Cell Advancement,
Bob Phillips
Array formula fill down problem,
n . berfeld
Re: WEEKDAY in Conditional Formatting?,
Bob Phillips
Re: Multiple If Then Statement based on ranges,
Bob Phillips
Re: SUMPRODUCT is OK for a while and later a similar formula returns 0,
Bob Phillips
how to set default column function,
hui
Re: split email id list into 1 extra list with everything after "@",
JE McGimpsey
MSDN article on Excel Limitations in Pivot Tables for Multiple consolidation ranges,
sairamr
Re: How to specific the cell format?,
JE McGimpsey
Re: Count no of cells containing data for more than one criteria,
JE McGimpsey
Re: How to look for value?,
JE McGimpsey
Re: Formula won't run,
JE McGimpsey
Re: Prevent worksheet from opening in a workbook,
Gord Dibben
Re: how to compare data in two different work sheets,
CLR
Re: Subtotals not working correctly when 2nd subtotal added,
Dave Peterson
Re: excell windows 03 cond format help,
Fred Smith
Re: hi, new value formula question,
Bernard Liengme
Re: clear range of cells if another becomes blank,
Max
Re: How to paste exact value into another cell?,
Gord Dibben
Re: SUM OFFSET COLUMNS,
Don Guillett
Making a Call to an external sheet using a variable...,
edwrobis
Re: MORE THAN ONE CONDITION IN A FORMULA,
Bill Kuunders
Re: {} in formel,
Gord Dibben
Vlookup problem,
Peter
Re: calculate,
Jason Lepack
Cell content is based on other cell value,
MIchel Khennafi
Re: Complex Look Up Problem,
T. Valko
Re: value expression,
Sandy Mann
Re: How do you alphabetize a whole spreadsheet ?,
Paul B
Re: naming sheet tab,
Don Guillett
RE: Conditional format based on entire row,
driller
Re: Creating Nested Functions,
T. Valko
Custom number format problem,
Pierre
first number after zeroes in sequence,
mdotgrant
Re: filter for even numbers in Excel,
Bernard Liengme
Change Multiple Page Fields in two independent Pivot Tables,
Oleg
Re: Looking for Bi-Weekly CDN Amortization Schedule,
Don Guillett
Re: formula/autocomplete to link data from other worksheets,
Andrew
Re: Autofilter multiple columns,
arno
Re: Expanding and Collapsing Groups within a Protected Workbook,
arno
Re: how to I make member list that indicates when subs due,
Pete_UK
Re: cells that "contain" values,
Rupert
Re: How do I treat row 1 in my worksheet as a header for each page?,
Don Guillett
Re: How to calculate the diference of times in excel?,
Lori
Re: Cell changes from General format to Scientific,
Lori
- Message not available
- Message not available
SUMPRODUCT returns 0, when I know it shouldn't,
Tim Bridle
Copy function across autofilter,
dd
- Re: Copy function across autofilter,
vezerid
- Re: Copy function across autofilter,
dd
- Re: Copy function across autofilter,
vezerid
- Re: Copy function across autofilter,
dd
- Re: Copy function across autofilter,
vezerid
- Re: Copy function across autofilter,
dd
- Re: Copy function across autofilter,
vezerid
- Re: Copy function across autofilter,
dd
- Re: Copy function across autofilter,
vezerid
- Re: Copy function across autofilter,
dd
- Re: Copy function across autofilter,
vezerid
- Re: Copy function across autofilter,
driller
- Re: Copy function across autofilter,
dd
Re: Sum of every 6th column and recurring,
Bob Phillips
Re: Formula to average the last 4 non-blank numerical cells of a r,
Harlan Grove
Cannot see formula descriptions in worksheet as I type a formula.,
RABL33
IF and lookup functions combined?,
RSS
Re: Formula to average the last 4 non-blank numerical cells of a row?,
T. Valko
Re: number/time format,
JE McGimpsey
Re: If, then statement troubles,
JE McGimpsey
Default date and time in the comment.,
Gary
Multiple formats in the same cell,
jimmcfarlin
Need help with a date check formula,
Dan B
Re: PRODUCT RESULTS/VALUE ARE NOT CALCULATING CORRECTLY,
T. Valko
Re: Workday Date Calculation,
Paul B
Re: Email on a condition,
Ron de Bruin
Re: help with the substitute and trim functions,
T. Valko
Re: Formula question - does anybody have the answers?,
Dave Peterson
Need help with recording a macro, attaching a button,
oxicottin
- Re: Need help with recording a macro, attaching a button,
Ken Johnson
- Re: Need help with recording a macro, attaching a button,
oxicottin
- Re: Need help with recording a macro, attaching a button,
Ken Johnson
- Re: Need help with recording a macro, attaching a button,
oxicottin
- Re: Need help with recording a macro, attaching a button,
Ken Johnson
- Re: Need help with recording a macro, attaching a button,
oxicottin
- Re: Need help with recording a macro, attaching a button,
oxicottin
- Re: Need help with recording a macro, attaching a button,
Ken Johnson
- Re: Need help with recording a macro, attaching a button,
oxicottin
Re: Count formel. Dont like the new year,
vezerid
Re: time and if statements,
David Biddulph
SUMPRODUCT - comma versus semicolon,
Epinn
Re: Incremental Numbering,
Bob Phillips
Re: Combination of formulas, if, and, or,
David Biddulph
Re: time,
vezerid
Re: convert a numeric number in text format in another cell?,
Manju
Re: How do I split my data into ranges,
vezerid
Count working days by week,
inta251
Prevoiusly posted message: Unable to remove objects pasted into Excel from HTML grid,
X-Ice
Re: how to read the data from -- >> Excel sheet,
JE McGimpsey
Re: Conditional Formating,
T. Valko
Re: vlookup with a sum of array,
T. Valko
Multiple conditional formula,
LeslieO via OfficeKB.com
Re: Lookup using multiple sheets and multiple criteria, sorry if 2,
Max
Re: background color,
Gord Dibben
Date/Time formula,
tmc
Another data across multiple worksheets question (ugh..),
Rasman007
SUMIF MULTIPLE ARRAY CRITERIA,
Santa-D
match two items to table for result,
Annette
Re: Can you link index keys between sheets for purchase/sales purpsose,
Rupert
Re: Excel,
Gord Dibben
Re: Grouping,
Roger Govier
Re: calculating cells hangs when filtering ranges in a sheet,
Pete_UK
Re: formula to convert raw data from several sources into relative tot,
Pete_UK
Re: countif,
T. Valko
Re: Named Range name problem in validation,
T. Valko
Re: MACRO AND MULTIPLE WORKSHEETS,
Gord Dibben
Re: Concantenate numeric fields,
CLR
- Message not available
- Message not available
Copy a column dependant on a the contents of a cell,
Peter
Re: if or statements to get three possible outcomes,
CLR
Interpreting "comma" where an optional argument is,
Epinn
Re: Excel-Match 1st text character in a string to a known character?,
vezerid
Re: how to auto fill information from a table to another sheet,
bda75
Re: Rows to Columns on reference,
excelmad
conditional Formatting based on cell formatting,
Totom
Multiple Selection of Non-Continuous Data,
bgetson
Adding something to a column,
August
Only calculate data table,
Rupert
Re: reference and replace data from one sheet to another,
vezerid
Re: work out compound intrest payments,
SK
Convert XLS to XML without XLS Properties,
M$User
Another "combine list" question,
SK
Re: All cells shud contain a unique ref how do i check 4 duplicates?,
RichardSchollar
Re: define nonblank in a formula,
RichardSchollar
Re: Adding only positive numbers,
T. Valko
Data Validation with IF and Max. Possible?,
Corey
Re: Can you find the cubed root on excel,
Sandy Mann
Re: how do I insert a variable amount of blank spaces in a formula?,
Dave Peterson
Re: Excell convert formula row to formula column,
Chip Pearson
Drop down list with different values.,
Honey
Re: mental block,
David Biddulph
Synconizing Worksheets,
itten
Re: dates,
David Biddulph
Find Max Value in WorkSheet,
Corey
Re: Find Max Value in WorkSheet,
Don Guillett
Re: ?formula,
T. Valko
Re: Last value in row,
Bob Phillips
Extract Rows for UNIQUE and MAX,
Justin
Re: Countif funtion,
Don Guillett
- Message not available
- Re: Countif funtion,
Don Guillett
- Re: Countif funtion,
Dot
- Re: Countif funtion,
Don Guillett
- Re: Countif funtion,
Dot
- Re: Countif funtion,
Don Guillett
- Re: Countif funtion,
Dot
- Re: Countif funtion,
JLatham
- Re: Countif funtion,
Dot
- Re: Countif funtion,
JLatham
- Re: Countif funtion,
Dot
- Re: Countif funtion,
JLatham
- Re: Countif funtion,
Dot
- Re: Countif funtion,
Don Guillett
- Re: Countif funtion,
JLatham
- Re: Countif funtion,
Dot
- Re: Countif funtion,
Don Guillett
- Re: Countif funtion,
Dot
- Message not available
- Message not available
- Re: Countif funtion,
Debra Dalgleish
Re: IF and or function,
Roger Govier
using IF function with AND/OR,
Ian R
Conditional Formatting: Excel 2003 vs. 2007,
JP
referencing active cell works in a sub but not in a custom function,
RITCHI
COUNT how many ROWS ago out of 10 days that the highest high in 10 days was made,
rhhince
If Function?,
KATYDID
Count how many Rows ago a particular number was hit,
rhhince
Prefacing a Copy/Paste Special formula with text,
Bob Smith
Counting how many rows since a new value was made,
rhhince
Re: FIND, CLEAN, REPLACE question,
Roger Govier
Using cell data as file name,
huntnpeck
Re: Why do column widths change in Excell?,
huntnpeck
Re: Formula to stop adding at a positive number,
RagDyeR
FORMULA THAT LIMITS WHAT IT CALCULATES VS WHATS ACTUAL,
Zigball
Re: Median calculation of grouped data.,
Philippe L. Balmanno
Re: Median calculation of grouped data.,
Epinn
Message not available
Re: how to combine formulas to.........,
Bob Phillips
Summing all cells containing the letter K,
Jan T.
Re: Automation,
Max
Counting numbers with a letter attached in excel,
pano
Message not available
Re: Count time to time,
David Biddulph
Re: How can I create list of degrees,minutes,seconds,
David Biddulph
Averaging across all worksheets except one,
theswener
Re: Drop down list linking,
Debra Dalgleish
Re: counting occurrences in another sheet based on several criteria,
RagDyer
- Re: counting occurrences in another sheet based on several criteri,
WiFiMike2006
- Re: counting occurrences in another sheet based on several criteri,
T. Valko
- Re: counting occurrences in another sheet based on several criteri,
WiFiMike2006
- Re: counting occurrences in another sheet based on several criteri,
T. Valko
- Re: counting occurrences in another sheet based on several criteri,
WiFiMike2006
- Re: counting occurrences in another sheet based on several criteri,
T. Valko
- Re: counting occurrences in another sheet based on several criteri,
T. Valko
- Re: counting occurrences in another sheet based on several criteri,
T. Valko
- Re: counting occurrences in another sheet based on several criteri,
WiFiMike2006
- Re: counting occurrences in another sheet based on several criteri,
T. Valko
- Re: counting occurrences in another sheet based on several criteri,
WiFiMike2006
- Re: counting occurrences in another sheet based on several criteri,
T. Valko
Re: message box when file is opened,
Ron de Bruin
Re: Setting up an If-Then Statement that will pull from a valdiated li,
T. Valko
Re: Rename sheet with NOW date,
JE McGimpsey
Re: Using TAB vs ENTER for data entry in a protected sheet,
Gord Dibben
Re: Future Value of Money,
Bernard Liengme
Question on Validation,
Manju
Re: Permanent formula?,
Dave Peterson
Re: Paste Specific Cell to Selected Cell,
Gord Dibben
Re: COUNT or COUNTIF using wildcard text?,
T. Valko
Re: Drop down menus,
Debra Dalgleish
Re: range in an IF statement,
Don Guillett
Searching in another workbook for a string and returning with the contents of the cell next to it.,
Hendy88
Re: ARrow Keys,
Pete_UK
Re: if statement,
Sandy Mann
Re: If Statement,
Bernard Liengme
Re: If Statement,
David Biddulph
Re: If Statement,
David Biddulph
Opening/converting other spreadsheet programs' files,
Conan Kelly
Re: Viewing an entire named range,
Max
Re: empty cells in a vlookup list,
Roger Govier
RE: how do I insert a picture using a formula?,
Ron Coderre
function,
n4navin9 via OfficeKB.com
Re: IF statements and conditions,
Max
Custom Calculated Items in a PivotTable,
JennyC
Re: Sum \ Count,
Bob Phillips
Re: conditional formating #N/A,
Bob Phillips
Lookup function Closed files Excel,
simon . stewart
Re: Sumproduct + wildcard,
Max
Re: SUMIF ?,
Max
Re: Checkbox values?,
vezerid
Re: How to automatically goto to today's date,
Bob Phillips
Re: A question about the Count/CountIf function,
Roger Govier
Re: Counting certian rows to sum them,
Peo Sjoblom
Re: Cell returns blank result...,
T. Valko
Re: Conditional formating using today() +/- 180 days,
T. Valko
Re: How do I arrange worksheets alphabetically in Excel?,
Dave Peterson
Re: How do I place Range text into a header?,
Gord Dibben
Re: Macro needed for inserting blank rows,
Chip Pearson
Re: List of functions contained in the add-ins, esp. Analysis Toolpak,
Bob Phillips
Formula Help,
LeslieO
Re: Need help extracting data....,
PY & Associates
Re: What formula to use?,
T. Valko
Re: I need to combine an "if" formula & an "and" formula, pls help ;),
joeu2004
Re: indirect formula,
Scott
Flipping Data in Excel,
August
Re: calculating double time on a workorder,
Jason Lepack
Re: I need help creating a formula,
Bernard Liengme
Message not available
Message not available
Modellingwith Excel,
Honey
Re: How do I re-set the tab stops in Excel to move 1 cell at at time?,
Bernard Liengme
Search table for string return next columns value,
mikpits
Re: How can you assign a bmp. file to a formula or macro?,
Gord Dibben
new chart task for 20$ paypal certificate,
turkyildiz
Re: COUNTIF for criteria in two separate columns (Excel 2003),
Bob Phillips
Automating Address Information based on selecting data via a validation list,
BrownsFan
Calculate needed gallons of water, based on weight of person,
Darryl
Re: Calculate needed gallons of water, based on weight of person,
Sandy Mann
Re: Calculate needed gallons of water, based on weight of person,
joeu2004
SUBSTITUTE patterns?,
nomail1983
Re: Spread Sheet Employee Hours Issue,
David Biddulph
Function that returns worksheet name?,
nomail1983
Re: Another formula question,
Bernard Liengme
Re: data sheet formulas,
John Bundy
Generate Random numbers from a pre-defined set,
frankjh19701
How can I output VBA function results (array's for example) to spreadsheet,
ww.childers@xxxxxxxxx
Re: Calculating a formula,
Bob Phillips
Re: Errors on Functions with many arguments,
Roger Govier
Re: Unable to select an Excel cell,
Don Guillett
RE: find last cell in a column but not a formula,
Ron Coderre
Find the row number with a date in it,
ianc2003
Auto suggest entries?,
Manju
Re: formulas,
Pete_UK
Re: "Additonal Numbers adjacent to it",
Roger Govier
Re: Using an Array to calculate the number of days between dates and..,
Roger Govier
Re: Using an Array to calculate the number of days between dates and..,
Roger Govier
RE: add up negative numbers,
bill gras
Re: Can you please hel me to find the correct formulas,
Bob Phillips
Re: Two TRUE to one FALSE statement,
Bob Phillips
Re: ??Calculate week number of a month,
Bob Phillips
Re: Can we add a blinking text / figure in spreadsheet.,
Bob Phillips
Re: look for row,
Roger Govier
Re: How do I add/count numbers in the same cell in excel worksheet?,
Scott
Re: how do I show the fractions shown on a ruler?,
Ron Rosenfeld
Re: Data validation & indirect,
Ragdyer
Re: Links between workbooks,
Ragdyer
Re: using countif,
T. Valko
Re: Totalling Values From The Same Cell In 12 Worksheets Onto New Shee,
Dave Peterson
Re: Operator,
John Bundy
ComboBox code,
Alexandre Ferreira
Re: how do i create a formula in excel,
joeu2004
Re: Help with Characters limiting,
Gord Dibben
Re: CountDays? need to count days in range by month,
Dave Peterson
Re: COUNTIF in between rows,
Bernard Liengme
Re: HOW MANY CELLS ARE IN EXCEL?,
Don Guillett
Re: inserting a row into a column that is read on another workshee,
Max
Re: Can IF function return an empty cell? (not ""),
T. Valko
performing conditional averages.,
vinnie123
NetWorkdays Calculation isn't working,
undrline via OfficeKB.com
Re: IF with SUMIF ? Or ??,
Bob Phillips
Re: Using text instead of number. e.g. If(E10=C,1,0),
Bernard Liengme
Re: Calculating Monthly Payroll Taxes,
joeu2004
Re: using formulae in excel,
Bob Phillips
Re: I have lost the office assistant,
Bob Phillips
Question,
ebruehling
Re: Vlookup using cell for tab name,
Roger Govier
Re: Index / Match in formula,
Roger Govier
Re: delete zero's from numbers,
P Sitaram
Re: Need statistics help!,
John Bundy
Re: If with Vlookup,
RagDyeR
Re: Going CRAZY with INDEX and Match Function,
vezerid
Re: Auditing,
RichardSchollar
Re: ROW(),
Don Guillett
Re: number formatting,
Roger Govier
Macros Not In Toolbars,
SV
How can i get formatted data from outlook to excel?,
syoung.chung@xxxxxxxxx
Re: Holidays,
Bob Phillips
Re: Conditional Formatting for ddd hh:mm,
Bob Phillips
Re: Want to create functions for Child maths,
Bob Phillips
How to control calculation of specific cells,
bda75
Re: How to count the odd or even in an excel area?,
RichardSchollar
Re: how to decompose the data in excel ?,
David Biddulph
Re: Excel>Excel 2002 display formula in another cell as text,
T. Valko
Re: Problems with LOOKUP,
T. Valko
RE: Drop TB into Financial Statements formula?,
Martin Fishlock
Re: How to get Blank into a cell as a result of a formula,
Dave Peterson
Text in Pivot Tables,
Gregc.
Re: Advance to predetermined cell,
Gord Dibben
Re: Unprotecting a Protect Worksheet,
Gord Dibben
Re: can you add rows to a single cell????,
Gord Dibben
macro to copy a value multiple times depending on value in adjacent column?,
jenlong
Re: how to make excel automaticly jump to next cell?,
Gord Dibben
Array formula for SUMPRODUCT,
Tim Lindsley
Re: How do I show only the whole number w/o eliminating four decim,
Gord Dibben
Re: How do I link a print header to variable data in multiple workshee,
Ron de Bruin
Re: How do I show only the whole number w/o eliminating four decimals?,
Bill Kuunders
Message not available
RE: IF_AND Formula Help,
Pcakes
Re: Defining Names in Excel,
Bob Phillips
Re: SUMIF,
Peo Sjoblom
Re: hide rows where cell condition is not met,
Trevor Shuttleworth
Re: compare date to various date ranges and sum value,
Roger Govier
Re: Conditional Formatting? Not sure,
Peo Sjoblom
Re: Conditional format a cell based on another range of cells,
Peo Sjoblom
Re: Using the If or lookup statement to find matches,
Peo Sjoblom
Re: sumproduct and colored cell as a condition to be met,
Bob Phillips
Re: Filters,
Dave Peterson
Re: Variable worksheet name (tab) linked to cell in same worksheet,
Don Guillett
Re: How do I tranfer the print settings to all worksheets?,
Paul B
Re: How to apply funcation,
aidan.heritage@xxxxxxxxxx
Re: copy/paste scenario,
Don Guillett
Re: Data Validation,
JE McGimpsey
Re: Excel / Word Merge Feature,
JE McGimpsey
Excel formula to extract a group of data from another list,
CTR
Re: Regional settings independent list separator in arrays,
Lori
Sumif problem,
Gerry Cornell
Re: Saving Totals Only,
Roger Govier
Re: that damned IF function,
Roger Govier
sumif / sumproduct for number of coincidences,
Mika
Re: Weekday + Time Calculation in Cell,
Pete_UK
Message not available
RE: Formula for a 4 day work week,
Martin Fishlock
- <Possible follow-ups>
- Re: Formula for a 4 day work week,
Arvi Laanemets
- Re: Formula for a 4 day work week,
Roger Govier
- Message not available
- Re: Formula for a 4 day work week,
Roger Govier
- Re: Formula for a 4 day work week,
T. Valko
- Re: Formula for a 4 day work week,
Roger Govier
- Re: Formula for a 4 day work week,
T. Valko
- Re: Formula for a 4 day work week,
Martin Fishlock
- Re: Formula for a 4 day work week,
T. Valko
- Re: Formula for a 4 day work week,
Martin Fishlock
- Re: Formula for a 4 day work week,
T. Valko
- Re: Formula for a 4 day work week,
JMB
- Re: Formula for a 4 day work week,
JMB
- Re: Formula for a 4 day work week,
T. Valko
Re: Formula for a 4 day work week,
Ron Rosenfeld
Re: sorting cells with formulas,
Epinn
RE: Vlookup for data comparison/validation?,
Martin Fishlock
Re: counting the # of unique values,
T. Valko
RE: Dropping Trial Balance into Financial Statements,
Martin Fishlock
Re: Multiple Nested IFs, ORs, Ands,
Scott
RE: I need a Lookup of some sort cont. - HELPM,
pappasd
Re: Rounding up to the nearest dollar,
Alan
Re: How do I...,
David Biddulph
Re: Sorting,
Dave Peterson
Set Windows Freeze Panes,
Sean
Re: HYPERLINK to a doc with a "#" in the name,
Dave Peterson
Re: formula,
Gord Dibben
- <Possible follow-ups>
- Re: formula,
Gord Dibben
- Message not available
- Message not available
- Re: Formula,
Pete_UK
- Message not available
- Message not available
Re: SUM not working,
Bernard Liengme
Re: Sick time accumulation,
Roger Govier
Minimum value after select case,
Gimp
Re: Functions in Excel 2003,
Roger Govier
Lookup, Match, something like this,
Sean
Re: How do I compute hours times hourly rate?,
Peo Sjoblom
Linking to Workbooks that Change Name Daily,
pwk
Re: Max using Index/Match Help,
T. Valko
Re: Mandatory Cells,
Nick Hodge
Date Function and Color Code,
JEN1752
SUMPRODUCT - (amended) Exclude LAST Row of Matched Criteria (Month & Year),
Sam via OfficeKB.com
Re: I want to round Int to quarter,
Niek Otten
Re: Averaging two if statements,
Roger Govier
Re: Calcing DOB,
Gord Dibben
Re: format adjacent cells,
Alan
RE: Finding row # of last cell containing contents,
Ron Coderre
Re: Create a formula based on date,
David Biddulph
Re: Using cell value in formula,
David Biddulph
Re: Option Buttons in Excel 2000,
Bob Phillips
display formulas as text,
Will Fleenor
signed over-punch,
Alex
Re: Sum of selected cells from different sheets in a new workbook,
Dave Peterson
Re: DCount help,
Roger Govier
Re: FORMULA SHOWING AS ####,
TR Young
changing a Sumproduct formula please,
Tester
Re: convert weekday date to the next sunday date,
Niek Otten
Re: Rolling 12 week calculations,
Bob Phillips
Re: How to calculate how many meet min and max criteria,
Bob Phillips
Re: ??conditional formatting??,
Bob Phillips
How do I count words in a column if they are inexact?,
Sam
horizontal sumif help,
Marcelo
Re: Excel Formula,
T. Valko
Re: How do I count values w/ criteria located in more than one column,
Peo Sjoblom
Re: How do I return a mileage value from a row and column value,
T. Valko
Re: array formula with if and hlookup,
sitaram . pothukuchi
Re: Can Excel headers automatically look to a cell for data? &[B2],
Gord Dibben
Re: downloading megastat software,
Peo Sjoblom
Re: Formula too long,
Don Guillett
Re: Problem with sorting 19th century dates,
Ron Rosenfeld
Re: How do i assign value to 3 cells =E41, =H41, = B41 by typing 41,
CLR
Re: only INTEGER INPUT IN CELL,
Alan
Re: Save Date & Time,
Nick Hodge
Conditional Formats for formulae and values,
GrahamB
- Message not available
- Message not available
Re: How do I deal with a "Too many different cell formats".,
Nick Hodge
Re: formula series (newbie),
Ragdyer
Multiple Condition Text Return,
Gymclass14 via OfficeKB.com
Re: Why does conditional formatting remain static?,
Bob Phillips
SUMPRODUCT - Exclude LAST Row of Matched Criteria (Month & Year),
Sam via OfficeKB.com
Re: Shorten Formula,
Bob Phillips
Values Returning Text,
Gymclass14 via OfficeKB.com
Index and Match Formula,
Barbara Schneier
Re: Is there anyway to simplify this formula?,
Debra Dalgleish
CUBE Functions in Excel 2007,
Hans Preuer
Days between,
Joseph N.
Re: Formula Replication,
RagDyeR
adding numbers shown in cells, not what is actually in cell - help!!!,
nelsonsdavis
Re: Filtering sheet data in another sheet,
CLR
Re: Filtering data in a database,
CLR
Re: Set the time and date for editing a cell,
Max
Place a Dynamic Date + a Certain Time in a Cell,
Sean
Timesheet Validation,
GrahamB
Re: print area across the freeze panes area,
Corey
Re: How to replace ... with a 0,
Corey
Re: If function returns #REF!, want it to return 0,
MartinW
Re: help with formula,
Pete_UK
Re: How do I create calculated items on pivot table reports?,
Debra Dalgleish
Re: Formula Didn't work how i needed,
Don Guillett
Re: Why isn't the drop down showing using data validation?,
Peo Sjoblom
Re: Adding sums only in certain colored cells,
vkauahi
Re: Opening to a default sheet every time,
Dave Peterson
Re: What is Excel keyboard shortcut for adding column?,
Gord Dibben
Re: PLEASE HELP,
T. Valko
How do I count the number of filtered rows,
2D Rick
Re: Iserror nested within a conditional vlookup,
Alan
Re: Repost (Comparing two ranges),
JE McGimpsey
RE: Count entries in one column based on values in another column,
Kurt
New Running Total for each worksheet,
Jeff
Re: formula viewing format,
Alan
Re: cutting characters from a cell,
Alan
Re: Need a Formula,
Niek Otten
Re: Excel A3 paper size ????,
SteveW
Re: How do I get data validation to disallow specific entries,
Harlan Grove
Message not available
Re: How do I count cells with different criteria in excel?,
Bernard Liengme
SUMPRODUCT question,
Conan Kelly
Re: V- Look UP,
Bob Phillips
Re: When I edit the cells referenced in my formula, the result does ch,
Peo Sjoblom
Re: display content of linked cell,
Bernard Liengme
sumif and countif nested?,
elaine216
Re: How do I delete a column that has been used for a function?,
John Bundy
Re: filtering entries in an excel costs schedule?,
John Bundy
Sum problems,
heine . mathiasen
Financial function requested, please,
Jack Sheet
Formula in comments?,
Manju
Re: Excel Error,
Alan
Re: Dynamic table array using Hyperlink,
Arvi Laanemets
Re: COUNTIF question,
Bob Phillips
Re: RGB values,
Bob Phillips
Re: How do I hide a sheet, that others will not be able to see it?,
Petya
Re: Autosum returns 0 value on data sheet,
Corey
Conditional Formatting across Sheets,
Corey
Re: Sum same cell/range of multiple worksheets within a workbook...,
Dave Peterson
Average function,
Rubix
Re: need formula to reference a cell in previous worksheet,
Bernard Liengme
expenses and monies recieved,
Harold Silber
Re: Can I use Sum Product across multiple tabs within a workbook?,
Bernard Liengme
Re: Count cells that meetin conditional formatting criteria,
Alan
Excel and Email/Outlook,
carl
Re: COPY A PAGE,
craiglittleperth
Formatting Text,
mastermind
RE: Count/average function with filters,
Gai
Re: <!Excel and Arrow Keys!>,
Nick Hodge
Return Matched Numeric Labels across Single Row,
Sam via OfficeKB.com
Re: Want a percentages of a single cell divided by a column of cells,
Max
Re: match week, count rows, sum rows?,
Bob Phillips
Re: Need a Function to Remove Text,
bony_tony
Re: How do I only display highlighted fields in excel,
Gord Dibben
Re: Formula Error Question,
Bernard Liengme
Re: Setting up slide scale for prices,
Niek Otten
RE: A rather difficult statistical search formula needed (Part 2),
Vasilis Tergen
Re: Help with VLOOKUP or other matching function,
T. Valko
Re: Vlookup or HLookup or Sumproduct Help,
Jason Lepack
Re: Macro to hide the row if both columns E & F are blank in that row.,
Dave Peterson
Re: "No RETURN() or HALT() function found on macro sheet.",
Gord Dibben
Re: Use of ^ symbol in a formula,
T. Valko
difference between the 2,
bda019
if command,
afromaniac
Re: Power and Sum,
Niek Otten
sumproduct return value by comparing two criteria.....,
batman07
Re: Continue typing in a cell after leaving the workbook.,
John Bundy
Formulas in a range of cells,
lmc
Re: EDate Unrecognized When Spreadsheet Opened Again,
T. Valko
VLOOKUP() Question,
mastermind
Re: Macro that set up each worksheet to print in legal size,
Dave Peterson
Pivot Change PivotItems - Visible/Hide with VBA,
rkuemin
Re: Filter data & sum or avg the results?,
Peo Sjoblom
Re: Is there a way to use a field link to rename a worksheet ?,
Don Guillett
Message not available
Re: COUNTIF Help,
Peo Sjoblom
Re: Change Exel headers text. ?,
Dave Peterson
averaging range across sheets after transforming text to value,
Keith
- Message not available
- Message not available
Re: vlookup with conditional formatting,
Peo Sjoblom
Re: Lowest number,
Pete_UK
Re: Automatically prefix cell entry,
RagDyeR
Re: tab question,
Don Guillett
Re: Logic Formula,
Pete_UK
- Message not available
- Message not available
- <Possible follow-ups>
- Re: Logic Formula,
RagDyeR
Re: Nested If help,
Bob Phillips
Re: using sum function,can I avoid calculating hidden rows,
Bob Phillips
Re: Conversion of numbers,
Bernard Liengme
Re: Search multiple sheets and return largest number found,
Lori
Re: How do I reference a cell as PART of a vlookup "Table_Array" locat,
Dave Peterson
Re: Merge content of cells,
Dave Peterson
RE: Importing signed over-punch text into Excel,
Alex
Re: Logic Formulas,
Don Guillett
Re: count in several colums,
Lori
Re: deleting worksheets from workbook when option not available,
RichardSchollar
RE: Can I 'auto update' my spreadsheet ?,
CLR
Re: indirect function referenceing changing file name,
Bob Phillips
Re: Excel Worksheets within a Workbook,
Bob Phillips
Re: COUNTIF across multiple workbooks,
David Biddulph
Re: COUNTIF across multiple workbooks,
Bob Phillips
Re: How do I replace a worksheet with lists,
Roger Govier
Re: Comparing two ranges and the positions of duplicates,
Roger Govier
Converting TEXT to DATE,
GFH
Re: More then 7 nested If functions.,
T. Valko
Re: Finding Annual Growth Rate,
Niek Otten
Sumproduct problem,
collis47
Re: If function with more than 7 conditions,
T. Valko
Re: Sum If function with 2 criteria,
T. Valko
RE: Amortization 30/365,
joeu2004@hotmail.com
Re: black and white display,
Gord Dibben
Re: please simplify mysearch formula.,
T. Valko
Format Cells to show different values,
bony_tony
Re: Auto change background of color based on formula,
Gord Dibben
date related question???,
_Bigred
Re: How can up type text upsidedown in a cell please not 90 degrees,
Gord Dibben
Re: formula reference between worksheets,
Gord Dibben
Re: Template Wizard with Data Tracking,
Gord Dibben
Re: Year Calculation,
Don Guillett
Re: Specific Data Ranges Produced From Drop Down Lists,
Debra Dalgleish
RE: A rather difficult & complex statistical search formula needed,
John Bundy
Re: Copy middle digits from one cell into another,
RagDyer
RE: Join 2 Lists - Lookup value in 1 list & use result in 2nd look,
JBush
RE: Lookup which returns multiple values which are additive,
Teethless mama
Comparing cells with text,
Mortir
Data sort over 200 worksheets - Help please,
Dave T
Copy certain cells from one sheet to another with a condition,
hamad.fatima@xxxxxxxxx
Re: Why does the font color not save on my excel spreadsheet?,
Gord Dibben
Re: How can I setup an If, Then, else requirement in excel?,
Don Guillett
Sumproduct not returning expected results,
Dos Equis
Re: Date Functions,
Peo Sjoblom
Re: How to change step in formula,
RagDyeR
Re: Data Validation; List,
Peo Sjoblom
copy and paste special question,
tweacle
Re: =randbetween still produces "#name?" after running the add-In,
Bernard Liengme
lookup returning incorrect cell values,
stuartjk
Re: annuity with daily compounding but annual deposit of money,
Niek Otten
Re: Look for and Retrive Data,
Dave Peterson
Re: Setup problem for hyperlink in Excel !,
Dave Peterson
Re: IF function between a range of numbers e.g 1000 to 2000,
Bob Phillips
Defining UserForm Caption from a Variable,
Hendy88
Re: If function,
Don Guillett
Re: Find missing values in a series,
bplumhoff@xxxxxxxxx
RE: Getting external data from multiple excel workbooks,
Santiago
Re: Can anyone recommend a reference book,
Paul B
Re: Can anyone recommend a reference book,
Debra Dalgleish
Re: Horizontal FILTER!!,
Bob Phillips
Re: Worksheets in an excel add-in,
On Ali
Re: functions largest to smallest,
Bob Phillips
Retaining Data after condition change,
phocused
Re: HOW DO I CHANGE AUTO FILL DATE VALUES,
Nick Hodge
RE: Can I hide my running totals when there is no change?,
SongBear
Excel Password Protection,
MWB
Re: Vlookup multiples and round up,
T. Valko
Re: Monthly bank stmts,
Peo Sjoblom
- Message not available
- Message not available
Lookup last value that does not equal certain value,
collis47
Re: thanks,
T. Valko
Re: Not sure if this is possible...,
Peo Sjoblom
Re: SUMIF help,
Shelly
embedding "ISERROR" function into an "IF" statement,
michael
Office 2007 Macros,
Mr BT
Re: Dragging,
Peo Sjoblom
Sorting by last digit,
pjamorton
Re: Sorting by last digit,
David Biddulph
Vlookup Help!!,
kasidickson
Finding a value based on contents of two cells,
xjetjockey
Re: Rounding Formulas,
Peo Sjoblom
Re: Find One Of Several Values Within A Cell,
Harlan Grove
Re: Displaying Tuesday's date throughout the week,
Sandy Mann
Re: Vlookup(?) with 2 Lookup Values,
MarketingGuy
Re: Return dates based on month and day of week,
T. Valko
Re: User Defined Function Syntax,
Scott
Re: Validation,
Bernard Liengme
Re: Clone worksheets?,
Gord Dibben
Re: Dynamic reporting rolling averages,
Bernard Liengme
Return Matched Numeric Values across Rows,
Sam via OfficeKB.com
CountIf --- for colours,
Cowtoon
Re: validation selection,
Bob Phillips
Conditional Formatting question,
Helen Holubowicz
Re: Displaying text during a range of dates,
Roger Govier
Re: Counting occurences and displaying in a different sheet,
Roger Govier
Retaining Data when a condition changes,
phocused
Re: If statement with validation list,
Roger Govier
Re: Summing Cells with #N/A,
Bob Phillips
Re: Counting Blanks in a list of dates by month,
phocused
Re: Adding and subtracting many columns numbers,
Roger Govier
Re: Counting Unique entry from Concatenated list,
Ron Rosenfeld
Digital signatures in Excel,
Santi
Re: auto filter,
Roger Govier
Re: Convert dates,
Max
re my new problem,
HANYANA via OfficeKB.com
Reference a cell from a another sheet that is always 24 rows away,
rhhince
Return Numeric Labels that have Values >=4 across Single Row,
Sam via OfficeKB.com
Re: Need Help!! Want to search through 3 columns for a list of keywords,
The Moose
Re: A HAPPY NEW YEAR TO ALL ! ! !,
bony_tony
Re: Average minutes per mile,
Niek Otten
Help with a function might be an if,
mcgrath383
Re: Cumulative sum with a ceiling,
Don Guillett
The =IF key function,
Ant
Re: Can autofill, as in months or dates, go to the end of the spreads,
Gord Dibben
Apostrophe Mayhew,
czarkalashnikov
Compare 2 pivot tables and report differences,
E
Re: Formula not populating from dropdown box.Works when entered manua,
Debra Dalgleish
Re: Winners & Losers,
Sandy Mann
Re: pivot table- need cell indentifier to repeat in each row,
Dave Peterson
Re: CREATE SERIES OF PERCENTAGE OPTIONS 4 A VALUE. IN A DROP DOWN BOX,
Don Guillett
Re: Finding the first and last entry in a column,
Bob Phillips
RE: File-search results in worksheet,
Gary''s Student
Re: how to Stop =TODAY() date function changing byitself,
David Biddulph
RE: Adding up multiple worksheets by name and totals,
Martin Fishlock
Re: If result of formula is "" (Blank) why is this considered > a num.,
Peo Sjoblom
Re: CREATE MULTIPLE WORK SHEETS IN A WORKBOOK,
Gord Dibben
Re: need help with a formula,
David Biddulph
Re: How to maintain merged cell format when cutting the content away,
Gord Dibben
Re: Formula for DAILY Interest?,
joeu2004
RE: help to build a list of holidays for 6 years,
dribler2
Re: teacher-how to convert a total number in a roe to a letter,
Gord Dibben
Re: using SUMPRODUCT() for commissions,
joeu2004
Getting around 'IF",
Dr Traffic
- Re: Getting around 'IF",
Don Guillett
- Re: Getting around 'IF",
Gord Dibben
- Re: Getting around 'IF",
Ragdyer
- Re: Getting around 'IF",
Ragdyer
- Re: Getting around 'IF",
ShaneDevenshire
- Re: Getting around 'IF",
Don Guillett
- Re: Getting around 'IF",
ShaneDevenshire
- Re: Getting around 'IF",
Don Guillett
- Re: Getting around 'IF",
ShaneDevenshire
- Re: Getting around 'IF",
Harlan Grove
- Re: Getting around 'IF",
Don Guillett
- Re: Getting around 'IF",
Ragdyer
- Re: Getting around 'IF",
ShaneDevenshire
- Re: Getting around 'IF",
T. Valko
- Re: Getting around 'IF",
Harlan Grove
consecutive,
gotta know
Re: how to count easily,
Bob Phillips
<Possible follow-ups>
Re: how to count easily,
dribler2
Re: Testing a person's age to be within a range,
Roger Govier
Re: vlookup false gives "#N/A" - can it say something else?,
Dave Peterson
Re: Sumproduct help,
Bob Phillips
Re: Auto updating worksheet,
Dave Peterson
Re: OR(EXACT(Cell; Range)) does not work properly,
Dave Peterson
Re: Free pdf creator which can render hyperlinks?,
Bob Smith
Re: Color Cells Summing,
Max
- Re: Color Cells Summing,
Dave Peterson
- Re: Color Cells Summing,
Max
- Message not available
- Re: Color Cells Summing,
Max
- Re: Color Cells Summing,
Gord Dibben
- Re: Color Cells Summing,
Max
- Re: Color Cells Summing,
Roger Govier
- Re: Color Cells Summing,
Gord Dibben
- Re: Color Cells Summing,
Max
- Re: Color Cells Summing,
Bob Phillips
- Re: Color Cells Summing,
Max
- Re: Color Cells Summing,
Max
- Re: Color Cells Summing,
Max
- Re: Color Cells Summing,
Bob Phillips
- Re: Color Cells Summing,
Max
- Re: Color Cells Summing,
Max
<Possible follow-ups>
Re: Color Cells Summing,
HANYANA via OfficeKB.com
RE: Color Cells Summing,
ShaneDevenshire
Re: Color Cells Summing,
HANYANA via OfficeKB.com
Re: Conditional Formatting,
Bob Smith
