microsoft.public.excel.worksheet.functions
- Re: time clock wrap around midnight,
Peo Sjoblom
- Re: ='Tabl.1&3 Cohorts'!C70,
Dave Peterson
- Re: Can you create a dual formula?,
Peo Sjoblom
- Re: How to convert text into range reference?,
Peo Sjoblom
- Re: if function with rounding,
Bob Phillips
- Re: SUM formula in Excel2007,
Bob Phillips
- Re: Index, Vlookup, Offset,
T. Valko
- Re: Reference other worksheet,
dq
- Re: Filtering a dynamic range,
Bob Phillips
- Help please with formula,
joec
- a Excel question,
yuzengw
- Re: excel 2003 "cell" function....,
Stephen at ZennHAUS
- RE: Comparing text within cells in two columns,
andy62
- Re: change row reference when pasting formula,
vezerid
- Re: Insert data with length between 11 OR 15 digits,
T. Valko
- Re: identify duplicates and sum corresponding values,
Bernard Liengme
- Conditional Format - Outline Border,
Sam via OfficeKB.com
- Re: Morefunc v3.241 and the latest Morefunc,
Harlan Grove
- Re: Column headings changed from alphabetical to numerical,
Bernard Liengme
- Re: Change EXCEL Clock to Standard Clock or Military Time,
Alan Beban
- Re: Delete Duplicate records,
Bernard Liengme
- Re: How do I default separator for thousands when working in XLS in t.,
Bernard Liengme
- How do I calculate an average of the last 5 nonblank cells in a row?,
tmsciulli
- Adding values in columns with a specific indicator,
basjakob
- Re: Sheet Protection Difficulty,
Gord Dibben
- Re: Where is "Insert Name" on the menu bar?,
Otto Moehrbach
- RE: Cell reference from 2 Lookups,
Toppers
- Re: how do I combine multiple IF statements to come up with 1 value?,
Trevor Shuttleworth
- parse text string,
Dave F
- Re: Creating a list using w/ a function,
T. Valko
- Re: Understanding the logic and criteria of Array formulas,
MartinW
- Extract given and surname a string,
Bob Maloney
- Re: In a formula, copy the value and formatting of another cell,
JE McGimpsey
- Need value for spread sheet,
rreuille
- Re: EXCEL IF FUNCTION,
MH
- Re: look up in work spreadsheet,
Gord Dibben
- Re: left trim,
Gord Dibben
- Re: How can I restore a deleted worksheet in Excel?,
Dave Peterson
- Filling only cells for rows with content,
Colin Hayes
- Need formula to lookup data in row,
Davey Boy
- Finding Named Field in Formulas,
Jeff Jones
- Excel Worksheet as Wall Paper,
Rafaqat
- Re: Sum a range of workbooks?,
Ron de Bruin
- R1C1 referencing,
Sandy
- Message not available
- Message not available
- Re: Count distinct based on criteria,
Bob Phillips
- Re: format text color within formula,
Peo Sjoblom
- Re: index match & NA,
T. Valko
- Re: How can I rid Page 1 watermark in Pagebreak Preview?,
Peo Sjoblom
- Re: How do I recover a lost file after my computer froze?,
Dave Peterson
- Re: Automatic seek and copy data from one sheet to another,
Gord Dibben
- Re: build a formula that references other worksheets,
T. Valko
- Re: Harlan Grove PULL Code Help Please,
pat henriquez
- Re: transfer total from one sheet to another,
Ragdyer
- Re: Vlookup and #N/A result,
JE McGimpsey
- Re: Excel Formula,
George Nicholson
- Re: SUMPRODUCT not working,
Don Guillett
<Possible follow-ups>
Re: SUMPRODUCT not working,
dq
Freezing headers and first column?,
flint
Referencing last populated cell in a column,
flint
Re: Wrap Text problem,
Susan
Displaying winner/first four placings.,
Toobi-Won Kenobi
Re: counting in exel chart,
Don Guillett
Re: dget or dsum criteria,
Don Guillett
Re: Showing full pull-down list,
Peo Sjoblom
Re: Using IF Statement,
Pete_UK
Re: Filtering Duplicate Course Names Using an Existing Formula,
Pete_UK
Setting Listbox Size VBA,
Sandy
Help with formulae,
joec
Re: Text box in Excel,
Bob Phillips
Re: This'll be one for the wizards,
Bob Phillips
Re: Formula?,
Peo Sjoblom
Re: keyboard shortcut for $(row)$(column),
Dave Peterson
Re: SUM function won't allow more than 30 non-adjacent cells,
Pete_UK
Re: Is there a way to make a link to a specific tab in excel?,
Dave Peterson
Re: Date and Dollar Formula,
Dave Peterson
Re: Counting occurences of characters in a cell,
Pete_UK
Re: How do I find a code in Excel,
Pete_UK
Re: Extracting data from large worksheet,
Bob Phillips
Re: Limit In Conditional Format,
Bob Phillips
Formula to display the winner,
Toobi-Won Kenobi
Re: convert standard number to time format,
T. Valko
Remove the #DIV/0!,
Corey
Re: Pivot Table: new column with a calculation,
Debra Dalgleish
Re: drop down lists,
Ragdyer
Re: Which fuction!,
Pete_UK
Re: Pivot Table Question,
Debra Dalgleish
Re: compare dates,
Pete_UK
Re: Finding text in one field, and then totally another,
Pete_UK
Re: Is a date in summer or winter?,
Bob Phillips
Re: Multiple variables-SOS,
George Nicholson
Re: Labview timestamp conversion,
David Biddulph
Re: Non-consecutive criteria database functions,
Peo Sjoblom
RE: Count of Data Based on Multiple Columns,
Chris Hofer
Min of range where other col has a value,
Pete Derkowski
Lookup,
joec
Return Frequently occuring Rows, based on COUNT,
Brooks
RE: Paste Special links do not copy right,
Duke Carey
Formula to lookup data and enter it in another WB,
joec
Re: Find number of unique entries within a date range,
T. Valko
Auto extend formula down a column,
Sandy
Re: I changed my spreadsheet fix upper rows in sight how back?,
Peo Sjoblom
Re: IF statement comparing month and year separately,
Ron Rosenfeld
Re: Total instances of the same numbers from one column?,
PCLIVE
Re: Columns are numbers (instead of letters). How to revert? XLS,
Dave Peterson
Selective cell changes,
Colin Hayes
Sumproduct Q,
Sean
Re: Sorting Protected Worksheet,
Dave Peterson
Re: I want to get negative hours if subtraction of hours is negative,
Ron Rosenfeld
sort rows,
basjakob
Macro Data Entry Validation,
Sandy
Re: Average 6000 data points in sets of 10,
MartinW
Re: hello! and heelp,
Bob Phillips
Calculating rates using sumproduct,
masterkeys
VLOOKUP problem,
Mortir
how to show if a table contains the same data,
Heine
sorting rows,
basjakob
Re: RANDBETWEEN,
T. Valko
Re: Multiple Sheets and Columns,
T. Valko
RE: Hour Calcuation,
Karan
Re: How do I calculate dates and times, w/answer of days & hours,
Fred Smith
Same result on two worksheets,
Patrick Murray
automatic and manual calculation not working,
BobS9895
Re: Need a simple recommendation,
Don Guillett
Re: How can I make a drop down box visible within a worksheet?,
Peo Sjoblom
Re: Index/Match problem,
T. Valko
Auto response of one column to another,
Colin Hayes
Re: if/then formula help,
T. Valko
Dynamic Hyperlink to a specific workshet on a web published workbook.,
Tony
Re: Countif,
T. Valko
count,
Darrell_Sarrasin
Re: How to exclude a cell(s) from a range w/o mult. ranges on any fcn,
David Biddulph
Re: excel 2007 number formatting,
Bernard Liengme
Re: information functions,
T. Valko
Re: Adding .45 months to a date,
Ron Rosenfeld
Find First Non blank cell than find column header and return that value,
Silver Rose
Re: Countif or Sumproduct,
Don Guillett
is it possible to combine data sets, eliminating duplicates?,
wam525
How to create a spread sheet for time,
JTScherer
Re: Formulas,
JE McGimpsey
Re: correlation,
JE McGimpsey
Re: how can i select all sheets in excell?,
Bob Umlas
AutoFilling Function not updating,
PJohnson
Re: convert time from one zone to other zone in excel,
David Biddulph
Re: disable get pivot table function,
Roger Govier
Re: reference another cell in getpivotdata function,
Roger Govier
Re: Countif month & year,
Roger Govier
Re: working out days between date.,
Dave Peterson
Excel 2007 SUMIFS,
C3PU10
Re: When DO Excel formulae execute?,
Charles Williams
QUERY FOR TODAY RECORDS,
shaqil
Re: Excel 2007 header,
Mike Middleton
Re: Count data in one column if certain criteria exists in another,
T. Valko
Re: Counting help,
Bob Davison
Re: How do you get the formula bar to display in Excel 2007,
Harlan Grove
Re: how to auto fill zero in a area,
Ragdyer
Re: how to vary cell name in formula,
Ragdyer
Re: Can I use symbols in an If statement as outcomes?,
MH
Stair-step commissions question,
Serg
Re: mainframe file to excel spreadsheet,
Dave Peterson
Re: Why does a menu pop up when I hit control-C?,
krcowen
Re: Dates,
T. Valko
Re: how do I alphabetize listings in a column?,
Bob Phillips
Re: Help with Excel 2003 cell #,
Ragdyer
Re: Summing,
Ragdyer
Re: Indirect with COLUMN,
Ragdyer
Re: Date Formula Problem - Leave date blank if Null,
T. Valko
Concatenate 2 cells, and have one cell value display as bold?,
Pierre
Range name of "\0"? - How can I slide this past Excel?,
Mr Big
Re: Calculating Date Ranges,
T. Valko
Re: Tabulation the number of different names in one column,
Bob Phillips
Macros,
Sandy
Why doesnt it change sheet in the macro,
lwik
Re: Autofill - Excel,
Peo Sjoblom
Re: How do you export data and keep the same fomating?,
Peo Sjoblom
Re: pull down menus,
Dave Peterson
SUMIF Criteria,
Emile
Re: tedious If & or statement,
Bernard Liengme
Re: add duration to start time,
Bob Phillips
Retrieving Cell Data From Variable Files,
DJ Pomeroy
Re: return the first value in a column,
Bob Phillips
Re: Formatting Times In Excel,
Bob Phillips
Re: sumif + average over12mths, then removing the avearge on 12mth,
Bob Phillips
stock quote help, VLOOKUP or what??,
Carl LaFong
- Re: stock quote help, VLOOKUP or what??,
MyVeryOwnSelf
- Re: stock quote help, VLOOKUP or what??,
krcowen
- Re: stock quote help, VLOOKUP or what??,
Carl LaFong
- Re: stock quote help, VLOOKUP or what??,
MyVeryOwnSelf
- Re: stock quote help, VLOOKUP or what??,
Carl LaFong
- Re: stock quote help, VLOOKUP or what??,
MyVeryOwnSelf
- Re: stock quote help, VLOOKUP or what??,
Carl LaFong
- Re: stock quote help, VLOOKUP or what??,
MyVeryOwnSelf
- Re: stock quote help, VLOOKUP or what??,
Carl LaFong
Re: how to edit formula without changing formula of each cell,
Rodrigo Ferreira
Re: XLsfunctions,
David Biddulph
Re: Counting (Countifs) in excel2003,
Arvi Laanemets
Re: auto set time(now) if criteria=true with no later change,
JE McGimpsey
Sum IF,
deen
Re: Round up entire worksheet,
T. Valko
Re: How can I use a filter and still use "protect worksheet"?,
Dave Peterson
Re: when the column text is different, how to insert one row below eac,
Gord Dibben
RE: variable annual wage increases based on start date,
spence
Re: compare -neg and +pos number that cancel each other in a colum,
Max
max in on column, description in another,
sylv1501@xxxxxxxxx
Re: whole number conditional formatting,
David Biddulph
Re: Conditional Sum of cells,
T. Valko
Re: Excel ignoring previously entered formulas,
T. Valko
Re: unable to "sum" cells in a column,
Dave Peterson
Where next, I'm not sure and need help,
deaconj999
Re: Problem importing Excel to Access,
MH
BEDMAS,
renaissanceme
Re: Sort by Last Name when name is combined,
Pete_UK
Re: Nested IFs Not Calculating,
PCLIVE
<Possible follow-ups>
Re: Nested IFs Not Calculating,
Pete_UK
Re: Find Similar,
Bernard Liengme
Re: How to add conditions to an if statement,
David Biddulph
Re: Dropping Zeros,
David Biddulph
Re: INDIRECT for range of sheets,
RagDyeR
RE: Greater than 5 days formula,
bj
Re: macro with dynamic input,
Susan
Re: how to round down the result of a formula,
JE McGimpsey
Re: Drag & Drop Corupts protected cells,
Susan
Re: Averages formula for multiple ranges,
JE McGimpsey
If then Else in macro,
Sandy
Re: SUMIF - my formula misreads after data has been sorted,
Bernard Liengme
Count unique items in pivot table results,
BW.Wooster
Re: Count unique items in pivot table results,
Dave Peterson
Re: Why =if(A2:A4="",1,0) will output #VALUE ?,
JE McGimpsey
How can i use If and or function,
dhir
Seperating Data From Lists,
JF
Re: Extgending a conditional format.,
Pete_UK
Re: Count data in one column indicated by data in another column,
T. Valko
Re: return a character at a certain position in a string of text,
Ron Rosenfeld
Re: My accounting program is a penny off, Why?,
Ragdyer
Re: IF TODAY equals date in cell A10, or if TODAY is beyond that date,
Ragdyer
Re: nested what if statement,
JE McGimpsey
Re: Serial nos for unique records,
Lynne
Unprotect groups,
Ed Davis
Name for a group,
Ed Davis
Printer Setup For Multiple sheets,
Ed Davis
Re: Over time hours,
Roger Govier
Macros and buttons,
Sandy
Using UDF in SUMPRODUCT,
JzP
Re: changing date value to date,
T. Valko
Removing Blanks from Multiple Cells _Using Excel 2007,
Jim
Re: how to pass on different parameters to VBA Code?,
Stan Brown
Re: Unable to copy the merged cell to the rest of the column,
JE McGimpsey
Re: How to to put together this function below,
JE McGimpsey
Re: combination or "if" and "or" formulas,
JE McGimpsey
Re: Max Cell Value,
JE McGimpsey
Re: I need to extract the first 3 digits from a cell (ex: AAG12345)?,
Ron Coderre
Would like to Group by Hour,
Brian Drab
Calling a Userform from a Predefined Variable,
Hendy88
Re: YTD calculation using same cell,
Don Guillett
Code needs simplifying,
Sandy
Re: excel worksheet functions,
JE McGimpsey
Re: regular and overtime hours,
T. Valko
Re: numbers within a range of numbers,
T. Valko
Re: entering a formula,
Stan Brown
Help with a database..,
got2stamp
Re: Drawing toolbar Icon,
Mike Middleton
Re: Office 2007 Bizarre =@sum() formula BUG - generates mailto: hyperl,
Dave Peterson
- Message not available
- Message not available
Re: Workbook event code won't work on laptop,
Don Guillett
How to auto-return to next cell that accepts data.,
charlesweaver33
Re: INDIRECT and multiple sheets,
T. Valko
Re: Nested If statements returning a sum calculation,
JE McGimpsey
INDEX / MATCH performance for lookups,
VancitysFinest
Re: If and Or Functions in Same Cell,
JE McGimpsey
Pivot Table Show Pages On Same WorkSheet,
dprotaso
Re: cells,
JE McGimpsey
Re: excell number formatting,
Ron Rosenfeld
RE: Zero-Fill,
Duke Carey
Re: workbook in formula,
Niek Otten
Re: sorting and filtering results,
Art Farrell
Re: Securing Pivot Table detail?,
Debra Dalgleish
Re: Calculating for a specific date range,
JE McGimpsey
Re: Poor Dumb Teacher Needs a Little Help,
Jim Cone
Re: If function with two results required,
JE McGimpsey
Re: Copying Formulas,
Pete_UK
Re: Ho to pull inmormation from a list?,
Pete_UK
Re: How to Calculate No. of Days between two dates,
Niek Otten
Re: Some cells have been colored and should be replaced by text,
Jim Cone
Re: remove and replace digits from a number,
Dave Peterson
Re: personal.xls will not load,
Dave Peterson
Re: Function bar,
Dave Peterson
Re: Turning green,
Susan
- Message not available
- Re: Turning green,
William Horton
- Re: Turning green,
bollard
- Re: Turning green,
William Horton
- Re: Turning green,
bollard
- Re: Turning green,
William Horton
- Re: Turning green,
bollard
- Re: Turning green,
David Biddulph
- Re: Turning green,
bollard
- Re: Turning green,
William Horton
- Re: Turning green,
Susan
- Re: Turning green,
Sandy Mann
- Re: Turning green,
David Biddulph
Re: Why do I get correct answers to formula then #NAME for some no's,
Pete_UK
Re: If statement query,
Pete_UK
Re: Counting number of observations within a date range?,
Nic
Re: how can convert the figures in to the word in excel,
Bernd
<Possible follow-ups>
Re: how can convert the figures in to the word in excel,
Bob Phillips
Re: formula in excell 2007,
Bob Phillips
Re: Display dates as months,
Ron Rosenfeld
Re: List of fields will not display for Pivot Tables,
R1C1
- Message not available
- Message not available
Re: can a function be disabled?,
T. Valko
Re: =sumif(a1:a3,">median(a1:a3)") always gives 0. What to do?,
Max
Formula with If and others,
Eli
Re: How do I creat a macro to delete the first 20 cell characters,
JE McGimpsey
Re: Search function needed (sumproduct?),
JE McGimpsey
- Message not available
- Message not available
Re: Insert new colum, without changing information,
Héctor Miguel
Ctrl F,
ltstrong
- <Possible follow-ups>
- Ctrl F,
ltstrong
Re: Pivot to Create New TAB / Worksheet,
Debra Dalgleish
Re: dynamic number format,
JE McGimpsey
Re: swapping formulas with the value they generate,
Trevor Shuttleworth
HYPERLINK() function,
Conan Kelly
Goal Seek with two constraints,
Boom1
Re: How do I link a Folder from Word to an Excel Worksheet cell,
Gord Dibben
Re: Counting occurrences on a particular date,
T. Valko
Re: How do I freeze a row other than the top one?,
PCLIVE
Re: IF STATEMENT - NESTED,
JE McGimpsey
Re: I cannot edit work sheets on excel but i can view them.,
Gord Dibben
Pivot Table possibility,
Brandon G.
Re: I cannot edit work sheets on excel but i can view them.,
Nick Klein
Re: If a date entered,
PCLIVE
Finding Percentage,
Eric C. Vogel [Win Live! MVP]
Re: simple vlookup,
Pete_UK
Excel Worksheet Names,
jrp7286
Re: adding page numbers,
JE McGimpsey
Re: Closing dates,
Bob Phillips
Re: Conditional Formatting (Excel 2002 SP3),
Bob Phillips
- Message not available
- Message not available
If, then: to run macro,
Sandy
Re: automatic fill formulas down,
Susan
Inserting Rows in Excel,
Need_to_Know
Re: How can I colour format all cells based on their values,
vertigo
Pivot table problem,
jps1x2
Re: Convert Percentage to total number of NPT Days,
JE McGimpsey
Re: IF function,
JE McGimpsey
Date concatenate?,
Hilton
Re: how to enter data "OnTime", OR when workbook opened,
Bob Phillips
Re: IF,
Arvi Laanemets
importing txt file!,
via135
Re: Concatenate a Column of e-mail addresses,
JE McGimpsey
Re: financial functions - HELP!!!,
JE McGimpsey
Re: Leave cell blank,
Ragdyer
Re: DATA FROM ANOTHER WORKSHEET,
Dave Peterson
RE: Filter and SumProduct,
JMB
Create hyperlink without filename?,
robotman@xxxxxxxxx
Re: Getting around [Edit][Calc] keystrokes to derive a value from a fo,
Gord Dibben
Re: Certain info from one workbook to another,
Gord Dibben
RE: Cross referencing with VLookup ?,
Toppers
Re: IF statements across Worksheets,
Gord Dibben
Re: Monthly Mortgage payments for a Semi annual compounding rate,
Niek Otten
Re: template,
Ragdyer
Re: How do I set up a running balance worksheet ?,
Sandy Mann
Comparing values in columns,
Sandy
Re: clipboard wont paste,
Susan
Re: How do I Import worksheet into a word doc.?,
Peo Sjoblom
Re: Pick From Drop-Down List...,
Gord Dibben
Re: Protecting portions of worksheet,
Paul B
Re: Removing concatenated colums after using them?,
Peo Sjoblom
Re: Counting cells from one workbook to another,
RagDyeR
Solver Problem ( related to earlier post of using if an Vlookup),
Honey
Finding Particular Day of Month,
DF
Conditional Formatting?,
JethroUK
Re: HELP! What function to use!!,
Niek Otten
Re: Finding a date range from given date,
Bob Phillips
Re: IF THEN,
Bob Phillips
Duplicates,
Karen
Inserting Number,
Karen
If and Vlookup,
Honey
editing music tags in excel,
william . hooper
Using If and Vlookup together.,
Honey
Re: SUM range from another sheet,
Bob Phillips
Timeline chart of projects,
stremetzky
Re: Which function wd I use to set up a ref to a list of possible name,
T. Valko
Re: how do i set a sceen in the background of a worksheet,
Gord Dibben
VLOOKUP Newbie Question,
Mike C
Re: tick box with formula,
T. Valko
Separating a List onto multiple worksheets in the same workbook based off 1 criteria,
DMRbaxter
Re: Open Excel with Just Menu Bar in Full Screen,
Bob Phillips
Copy Results from Autofiltered List,
Kaye
Find the top five in list,
Brandon G.
Re: Why does using @SUM in EXL 2002 trigger an O/L "new" email ?,
Dave Peterson
Re: How to make a formula cell dynamically display,
David Biddulph
create a master list from other sheets,
ADK
Re: Analyze Range of Cells,
Bob Umlas
Re: Formating a timestamp as a date and time.,
Bob Phillips
Return value based on checkboxes selected -- IF() LOOKUP(),
Nikki
Re: DSUM,
carlos
- <Possible follow-ups>
- RE: DSUM,
William Horton
Autofilter Issue,
PWS
Re: Using SUMIF/IF statements for multiple conditions,
carlos
Re: CheckBoxes Stack up when Rows are hidden and unhidden,
Dave Peterson
Formatting as date,
gwplotts via OfficeKB.com
RE: Help please,
Duke Carey
conditional sum for budget spreadsheet,
gareth . wretham
Selective concatenation using VBA,
Colin Hayes
Re: IF Statement Help,
JE McGimpsey
Re: how i can protect few rows or few coloumn?,
RFJ
Re: if statment,
RFJ
Re: How do I count coloured cell in a particular range ?,
Bob Phillips
Re: how to use countif function,
Bob Phillips
Excel graph..,
Joe_Germany
Re: VLOOKUP or IF with many criteria,
T. Valko
Re: count if cell if fill with text,
Trevor Shuttleworth
Converting Lotus 1-2-3 files to Excel 2007 format,
Clas
Gaussian Curve using Normdist?,
velocityinc
Re: Random Numbers,
Stan Brown
Microsoft Excel http://www.teenwag.com/poll?n=1510,
foto
Re: rolling year attendance,
T. Valko
Re: How to hide or replace (blank) in a Pivot Table Column,
omnicrondelicious
Re: multiple search,
Max
Re: Disable "Insert Function" Utiliy,
Gord Dibben
Re: Formatting in a Protected Spreadsheet,
Harlan Grove
Re: Excel if/and,
PCLIVE
Re: IRR Formula,
JE McGimpsey
Re: IRR Calculation,
JE McGimpsey
Re: SUMIFS with dates,
T. Valko
Re: Can I find a specific value in a random column of numbers,
PCLIVE
Re: Dups from 2 worksheets,
PCLIVE
Re: Worksheets,
Harlan Grove
RE: Excel form for expense reporting,
wardawg
Re: delete cells from one workbook to another,
JE McGimpsey
Adding business days to a date,
Keith R
Re: Count Text within Multiple Worksheets,
Peo Sjoblom
Re: If Statements,
David Biddulph
Executing a bat file from Excel,
Mr BT
Message not available
Re: Why don't all my data rows show up in auto-filter?,
Pete_UK
Trying to keep track of updated link data in an excel spreadsheet,
Tony
Conditional count across 2 columns,
RFJ
How to tell the number of current open workbooks...,
Hendy88
Getting and error while calculate business hours between 2 dates with holidays.,
sharadmittal80
Archive for ng?,
Mr BT
finding multiple parent-child relationships?,
Keith R
Re: Large for disjunct cells,
Niek Otten
Re: Temporary Storage in IF function,
Pete_UK
Re: Using text as a criteria in Excel,
Pete_UK
Re: How to count specific colour from cell range with varied colors?,
Bob Phillips
excel graphic planner,
stremetzky
RENEWED-- Arrays: Counting multiple values within array,
Trilux_nogo
Losing formulae that evaluation to #N/A,
Jack Sheet
formula to define relationship between two sets,
Greg Lovern
Re: can I have excel count occurrences for 10 people in 7 days,
T. Valko
Re: Min <> 0,
Harlan Grove
Array: Counting multiple values within array,
Trilux_nogo
Re: Trying to get hours for 11pm-7am shift,
David Biddulph
2 questions: copying between sheets and display >0 data...,
Grim
Help - Does value exist in range of CLOSED workbook?,
c mateland
Re: I want to return the #VALUE! as a blank cell.,
David Biddulph
Re: What formula do I use for copying cell information between workboo,
Bernard Liengme
Re: How do I set caps lock as default?,
David McRitchie
Re: ARRAY NOT COUNTING A CERTAIN ROW,
Don Guillett
Re: validation zero,
Anne Troy
Re: Do nothing in excel formula,
vandenberg p
Re: Enable the Options button from the Tools Menu,
Gord Dibben
Re: Removing a formula from a cell once the result is in the cell,
T. Valko
Re: Importing Excel Sheet to Outlook Contacts,
Nick Hodge
Re: Conditional cell color,
Don Guillett
Re: help about date & month function in Excel,
Ron Rosenfeld
Re: Need help,
Roger Govier
Re: Formula,
Tyla
Re: Dependent Dropdown List - Not Easy!,
Bob Phillips
Re: Condtional Format Question,
JE McGimpsey
Re: Lookup function using 2 variables,
JE McGimpsey
Formula depends on which cell contains max.,
Len B
RE: Formatting one cell based on the contents of another cell,
A.C.G.
Re: Cell incremental increase,
Dana DeLouis
Re: Reference a Sheet in Formula,
Bob Phillips
Re: Sumif,
Bob Phillips
Re: Excel List submenu missing in XP, after reloading builtin menus,
Gord Dibben
Trouble with copy & paste from Visa web site,
Tri-Pacer
Re: Combining Cell Contents,
Gord Dibben
Re: Link cells when initials are entered, it time stamps the next???,
Gord Dibben
Re: how do i transfer dada from one spread sheet to another,
MyVeryOwnSelf
Re: Use a code to populate a cell with a specific value,
Bob Umlas
Re: Linking 2 documents,
GQC
Re: Can I duplicate headers and footers on multiple sheets?,
Peo Sjoblom
Re: Converting Month Number to Month Text Abbreviation,
PCLIVE
RE: List disctinct values,
Ron Coderre
Re: Sumif vs Text?,
PCLIVE
SIMPLE SUM FORMULA,
techjohnny@xxxxxxxxx
Re: How do I find elapsed time between 2 dates and times?,
Peo Sjoblom
Re: RANK with 0 values,
Peo Sjoblom
RE: Advanced Filter ...??,
RWilliams
Re: +++Switch Rows & Columns,
David Biddulph
Re: sorting excel worksheet,
Pete_UK
Re: get Pivot table to generate separate worksheets for each row?,
Roger Govier
Re: How can I use "&" in footer coz Its not appear when print preview,
David Biddulph
Re: Tricky Conditional Count,
David Biddulph
Re: Can't make conditional lookups work with SUMIF.,
T. Valko
Finding the oldest & newest dates,
Bob Smith
Re: is there a function to change negative values to zero?,
David McRitchie
Re: Is there a way to automatically hide empty rows?,
PCLIVE
Re: I want to use sumif to sum up a column based on a range of dates,
Bernard Liengme
Converting a Grid (or range) of Data to a List,
a
if between two dates,
ADK
Conditional Rank (or rather, Conditional Range),
downwitch
Re: DAYS360,
Niek Otten
Re: A "IF" result that will not result in a selected field when using,
PCLIVE
Add 4 hours (only if between 9am-5pm),
Angela1979
Re: Plot times of day on chart,
David Biddulph
SUMPRODUCT with Autofilter,
Gustavo Strabeli
Re: New Errors in Sumproduct Usage,
Bob Phillips
Formula to give date and time,
Angela1979
Re: IF functions based on conditional values,
PCLIVE
analyze list,
alex
Re: Adding months to a date,
Roger Govier
Re: Conditional Formatting with Percents,
David Biddulph
Question for T. Mama - Copying filtered data to another worksheet,
DavidS
Re: Help with Formatting cells,
David Biddulph
Re: Auto Filter Function getting 'stuck',
David Biddulph
Re: Making Cell protection visable (like Lotus does with different col,
Héctor Miguel
Re: sum,
Anne Troy
linking cells,
stremetzky
conditional formay date maturity,
Frank
DP adjustment using quick menu buttons when sheet protected,
Aaron
Re: how to remove number from alphanumeric cell,
Ron Rosenfeld
moving cells,
PeterJames85
Re: Check Box,
Dave Peterson
Re: Help finding the date of the last Saturday of a given month,
T. Valko
count if,
cletabujol
Formula for extracting data from a string,
LFM
Re: IF formula,
David Biddulph
Re: SUMIF, with specific search criteria,
T. Valko
Re: show a column of numbers also as percentages,
stevevrabel
Re: VLOOKUP ERROR,
PCLIVE
Re: Array formula that works columnwise?,
T. Valko
Re: SUMPRODUCT,
David Biddulph
Re: How do I link the header to something in the worksheet?,
Gord Dibben
Re: how to use the ceiling function,
T. Valko
end date,
ADK
Re: Return a list dependent upon the selection of a preceeding list,
Peo Sjoblom
Re: Excel question,
Peo Sjoblom
Re: Excel decimal moving?,
Gord Dibben
Re: updating email addresses in cells,
David Biddulph
Import into Access from Excel, passing a variable for the field...,
Hendy88
Re: Converting more than one currency,
Bob Phillips
How to forecast non-numerics?,
seahorses09
Re: Exporting data to Excel,
David Biddulph
Re: How do I change date based on year,
Bob Phillips
workday include saturday,
stremetzky
Re: static formulas - HELP,
Max
Re: Adding formulas,
T. Valko
Use of Match, Index, and Vlookup to Interpolate,
velocityinc
Re: Breaking it down a little bit further,
T. Valko
Re: what function do I use for excel to choose the 2nd highest number,
Roger Govier
Re: Excel 2003 customize toolbar command lost,
Gord Dibben
Re: I need to copy & paste multiple lines to another workbook?,
Gord Dibben
Re: can I add values of cells that are certain colours?,
Gord Dibben
Find the date of the coming up Saturday given the current date.,
Michael Ermino
Re: Sorting latitudes and longitudes,
MyVeryOwnSelf
- Message not available
- Message not available
Re: Require Minimum Amount When Entering Data,
Peo Sjoblom
Re: Multiple conditions in formula,
Per Erik Midtrød
Re: Multiple conditions in formula,
T. Valko
Re: Multiple non-consecutive rows,
Peo Sjoblom
Re: sum certain cells in a column based on criteria from another colum,
T. Valko
Re: Can an Excel cell value be used in a Custom Footer?,
smhish
lookup and return multiple values,
Treena
Re: Please help with a "find duplicates" macro - 4/10/07,
Rodrigo Ferreira
Re: Opening a worksheet automatically at start up of computer,
Susan
Re: Using the LEFT formula for multiple cells,
Conan Kelly
Re: I need to convert a number to text but I need it to be 5 position,
Peo Sjoblom
Re: Count characters within a string,
Peo Sjoblom
Re: Comma Seperated File,
Dave Peterson
Re: How do I show zero in Accounting format ?,
Dave Peterson
Re: how do i get a list of only the begining of weeks in excel?,
Pete_UK
Countif question how do I do this ?,
pano
Look up and return text values,
plb2862
Re: IF(FIND Formula gives #VALUE! error,
Dave Peterson
Re: how o i use commas for lakhs,
Bob Phillips
Re: Restricting date entry relative to current date,
JE McGimpsey
RE: Trying to figure out a formula for range of numbers?,
Joel
Return to sheet,
Ed Davis
Re: how to display an error message,
Bob Phillips
Re: Multiple criteria options determine which name to show as result.,
Bob Phillips
Re: Cond Formula for adding only cells of particular colour,
Bob Phillips
Re: HELP HELP with excel formulas,
David Biddulph
RE: Insert photo into a protected worksheet,
Wei Lu [MSFT]
Re: how to use a function to average all the numbers except 8 in a col,
T. Valko
Inserting a line,
S.C
SUMIF and INDIRECT,
Lok Tak Cheong
Re: criteria in multiple columns,
T. Valko
- Message not available
- Message not available
Formatting lost in a Pivot Table after a data refresh,
LordCommando
Re: how do I figure multiple commission percentages,
JE McGimpsey
Re: vlookup with zip codes - not working - frustrated,
R1C1
Re: Nesting IF/calculate percentage,
joeu2004
Re: formulas display but don't calculate.,
Gord Dibben
Re: Worksheet colors don't show on screen,
Gord Dibben
Re: Worksheets and Control Option Buttons,
Dave Peterson
Re: run macro if cell value changes,
David McRitchie
Re: widening a drop down box,
Peo Sjoblom
Re: need mail merge system for excel spread sheet,
Peo Sjoblom
Re: Worksheets Tabs,
Gord Dibben
Re: Help With a Date,
Mike G
Re: Yes/No Function,
Peo Sjoblom
Totaling cells consisting of values determined through concatenate,
brianc
Reformatting text in cells,
RFJ
RE: Saving Values in Excel when using RTD,
SongBear
Re: is it possible to get a formula for words or figures to "flash",
Peo Sjoblom
How to Copy and Paste only new rows,
johnmanc
RE: creating outcome series from formula,
Maurice
Disabling security popups,
Colin Hayes
Re: Please let me know more options about Pivot Table,
David McRitchie
Re: summed product of multiple arrays,
Bob Phillips
Re: date format,
Roger Govier
Please help for FV and XIRR function.,
RushatiINDIA
Shannon diversity index formula,
peter
Re: Copying cell value to master report file which is closed?,
Gord Dibben
Re: IF and AND functions help required,
Ragdyer
How to look up a value in a list and return multiple corresponding values,
alex . noe
Re: deleting takes too long,
Don Guillett
COUNTIF with additional qualifiers?,
Larry
Re: Understanding the objective '--' used in SUM PRODUCT function,
Ragdyer
- Message not available
- Message not available
- Message not available
RE: assign button for color,
bk
Grouping Data in Pivot Tables,
rttaksali
Re: IF Function - Specific currency format,
Bernard Liengme
Re: How to delete the "Insert Function Dialog Box" (dialog box only)?,
Niek Otten
Re: Price List and Quote Form,
T. Valko
Re: cell location containing specific text,
Gord Dibben
Time Countif help or convert to text,
SFD
Re: Updating Data in Validation Lists,
Max
Re: Checking a cell against a named range,
Bob Phillips
Re: IF and VLOOKUP - how efficient?,
Aladin Akyurek
Re: formula in Excel 2000 to work %'s,
David Biddulph
Re: Present value and future value,
JE McGimpsey
Re: How can I create a Drop-down cell?,
Debra Dalgleish
RE: Merging text cells from two worksheets with one shared column,
JLatham
Re: Need to Calculate only part of a formula in Excel 2003,
Fred Smith
Re: Colorful Dropdown Lists,
Dave Peterson
Re: counting cells by text color,
Peo Sjoblom
Re: EXCEL 2007 DATEVALE FUNCTION,
David Biddulph
{ } functions,
Ray
Re: date series in PivotTables,
Roger Govier
Re: single lookup value with multiple results,
Peo Sjoblom
pulling data automatically from one spreadsheet to another,
skiguy02920
Re: Summing values from an undetermined number of sheet,
Peo Sjoblom
Re: How to number lines (rows) on both sides of spreadsheet,
daregreatly
Re: Delete a sheet and access charts,
Gord Dibben
Feed Data from Multiple worksheets to a Summary Worksheet,
BT1113
Copying filtered data to another worksheet,
DavidS
Match, Index, Indirect ?,
PCLIVE
Re: Find and replace,
Richard O. Neville
Re: Help with Excel formula in a Workbook,
David Biddulph
Re: Refrencing cell formulas in a new worksheet,
Dave Peterson
Re: sum multiple cells from a 2d array,
Domenic
working with employee tenure and grouping,
Casey Tremper
Re: Wildcard lookup,
Max
Re: Unequal Product Sum,
Roger Govier
total using months,
outhouses
Re: UDF question,
T. Valko
Re: Problem with a UDF im trying to write,
T. Valko
Re: Data Validation In-Cell Dropdown has Suddenly Stopped being Displa,
Héctor Miguel
Saving an excel file using a date,
Ed Davis
Re: Vlookup,
Pete_UK
Re: how do you convert a number into a date,
Dave Peterson
RE: more sorting,
I. Miller
Re: filter using "ends with" and 3 choices? Ex: ends with 1,2 or3,
Dave Peterson
Re: VLOOKUP?,
Toni
sum based on PARTIAL content of another cell,
mmartinucla
sum if based on PARTIAL content of another cell,
mmartinucla
Re: how many characters are there in a cell/,
Dave Peterson
Re: Find date duplicates Col 2 or Col 3 then combine Col 1 text,
Vibeke
RE: how can excell extract data from Access (hot line?),
SongBear
Re: Questions About Iteration,
Niek Otten
Dynamic Sum,
Steve
Re: How to enable macros and automatic calculation on Excel Viewer?,
Gord Dibben
Cross-Referencing Across Worksheets,
Chris Hall
Re: Too Many Variables,
Bob Phillips
Vlookup multiple value,
deen
- Message not available
- Message not available
- Re: Vlookup multiple value,
deen
- Re: Vlookup multiple value,
Ron Coderre
- Re: Vlookup multiple value,
deen
- Re: Vlookup multiple value,
deen
- Re: Vlookup multiple value,
Ron Coderre
- Re: Vlookup multiple value,
deen
- Re: Vlookup multiple value,
Ron Coderre
- Re: Vlookup multiple value,
deen
- Re: Vlookup multiple value,
deen
- Re: Vlookup multiple value,
Ron Coderre
- Re: Vlookup multiple value,
deen
- Re: Vlookup multiple value,
Domenic
- <Possible follow-ups>
- Vlookup multiple value,
deen
- Message not available
- Message not available
Re: Criteria length limit in SUMIF(),
Dave Peterson
Matching formula results to datasets,
Ben Burns
Re: How do I round a formula generated number,
Bernard Liengme
Excel Calculation Result Display Failure,
guy.yeon
Validation drop-down arrow not showing for SOME users - fine with others?,
pennie . thomas
Re: Total last 30 days,
Peo Sjoblom
Re: What does the "-{1,7}" do in conjunction with SUM,
T. Valko
Re: MS-Excel Formula,
Fred Smith
Re: fit multiple values into specific value (combinations?),
Dana DeLouis
Re: What is the priority of Mode function?,
T. Valko
Reordering part of a list with VBA,
omnicrondelicious
Deleting Rows with data duplicated in 2 columns,
meganryan
VLOOKUP gives duplicate results for "empty" searches,
Doc Farmer
RE: Lookup tables?,
Dave
Identify last row of populated data,
Jumbo Shrimps, Jr.
RE: Conditional Queries?,
JMB
Re: summing daily data by month,
T. Valko
Re: sorting without changing formats,
Bill Kuunders
Re: edit links,
Peo Sjoblom
Re: user defined function,
Dave Peterson
Re: How do I sort two columns without changing the formatting?,
Peo Sjoblom
Re: Function termnology,
Peo Sjoblom
Nested loop,
giel.vanboxtel@xxxxxxxxxxxx
RE: Multiple Lookup as condition in sumproduct formula,
ExcelMonkey
reference to other sheet,
Bakerman
Re: Text formula,
T. Valko
Re: Help with nested function,
Colin
Re: Sumproduct copying blanks or how to insert zero into blanks,
Peo Sjoblom
This ones got me stuck,
DB
Re: VLOOKUP Formulas,
George Nicholson
VLOOKUP/Index&Match data format issue,
oscar . olipane
Re: Using multiple IF criteria,
Hans Knudsen
Re: Finding the last entry in a column based on criteria,
Hans Knudsen
Re: Help - I need to combine both a SUMIF and COUNTIF into one for,
JE McGimpsey
Re: Create filename based on cell contents,
Peo Sjoblom
Re: How to leave the lines on my exel work sheet,
Peo Sjoblom
Re: How can I make my entire document CAPS?,
Paul B
RE: Data table function,
Bruge
rearranging data,
brianjohnalford
Match data in 2 columns and return data from 3rd column,
gwtreece
Re: Help - I need to combine both a SUMIF and COUNTIF into one formula,
Bernard Liengme
Re: How to I calculate 180 days from any date?,
Bernard Liengme
Re: earlest date not complete,
Bernard Liengme
Re: Looking for formula that selects last value entered in a column?,
Bernard Liengme
Re: How Excel help to reproduce a form like this,
Bob Phillips
Re: basic question - how to calculate a cumulative percentage?,
Bob Phillips
Calculate Range,
SRV....Frenzy
QUERY data range to populate separate worksheet?,
Greg Purnell
Question using DGET function,
Jasonm
Re: Creating Buttons using the Forms Tool bar.,
Jim Cone
lookup stock symbol on worksheet and return summary data,
Greg Purnell
Re: Count how many persons in a month using a date,
Bernard Liengme
Excel Chart - Require a Formula,
slsjmc
Re: =and formulas with =if formulas,
Ragdyer
Generating a list,
Dave
Re: sumif formula,
T. Valko
RE: Using booleans in sumproduct formulas to extract boolean range,
Elkar
Re: Adding numerical values based on multiple values in another column,
Peo Sjoblom
Re: Load caption box on userform open,
Bob Phillips
Re: Printing selected parts of a list....,
Gord Dibben
Excel Loan amortization Excel X for Mac 10.1.6,
Larry Rowe
Re: Increasing font?,
Gord Dibben
Re: how do i use code39 bar codes that update as a cells value chages,
Thomas Lutz
Re: Dragging Data into a new worksheet and arranging it by type,
Peo Sjoblom
Re: Formatting Time As hhmmss Gives Me Dates Instead?,
Peo Sjoblom
Re: 2nd lowest Value in Array,
Peo Sjoblom
Re: Merging Databases,
MH
Re: Fiscal Quarter Conversion,
Peo Sjoblom
Re: Copy Excel tab (worksheet) to another Excel file,
Peo Sjoblom
Conditional Average,
robotman@xxxxxxxxx
Pivot Table: Change dates to fiscal year,
denhamlee
My Buttons shrink with every click,
kylancal@xxxxxxxxx
Re: Hide macro's,
Paul B
Re: Compare and group like numbers and info,
John L
Re: change the century,
Peo Sjoblom
Re: need to do a calculation.,
David Biddulph
Re: Counting two numbers,
Domenic
Re: SUMPRODUCT Formula Help Please,
Domenic
How can I convert a character string that contains letters & numbers "£2,456.99 (including flights)" into a numeric?,
ship
Filter,
princy_varghese@xxxxxxxxxxx
formula or vba solution,
rumkus
Re: Difference between two dates rounded up.,
macropod
Re: adding function,
Domenic
Change Cell Format,
SRV....Frenzy
RE: Sheet creation and colouring the tabs,
SYBS
Re: Format Cells by code,
Bob Phillips
Re: simple inventory totals,
JE McGimpsey
Re: Enter data, move automatically to next unprotected cell,
Gord Dibben
Re: How do I calculate the interest payment manually (without usin,
Fred Smith
Re: lookup the next matching record.,
Gord Dibben
Re: product between two dates and with criteria,
T. Valko
Re: If a cell = TRUE how do I get the cell to do a sum function,
MH
Multiple CheckBoxes can be selected require additional info if sel,
Goldenfoot
Re: Can i get advanced filter to automatically refresh,
Debra Dalgleish
Re: How do I set up slider bars to input data in Excel?,
Gord Dibben
Re: auto fill text,
Gord Dibben
Re: Help w/ INDEX and ROW reference using OR statements,
T. Valko
Re: Summary sheet with Vlookup,
BNT1 via OfficeKB.com
Re: Change Cell Value from another Cell,
Niek Otten
Re: Need help in forcing number that wants to stay in Sci. Notation fo,
David Biddulph
Re: Convert Time to a Text,
George Nicholson
Re: How do I merge/combine different workbooks with different sheets,
Ron de Bruin
Why can't I copy this worksheet?,
DaveMoore
Re: Need Help with Macro,
Bob Phillips
Re: Multiple cells reference,
David Biddulph
Re: sum values in cell based on another cell,
Niek Otten
Re: how do I show 1st, 2nd, and 3rd most repeated non-numeric values?,
Bob Davison
Re: How can I apply a formula to all cells even those with < signs,
David Biddulph
Re: Excel spreadsheet formula,
Niek Otten
Rank excluding Errors,
Werner Rohrmoser
Guess my number game for kids.,
Honey
Re: How do I use a formula to give me a cell reference in excel?,
David Biddulph
Re: Deleting rows with 11+ characters.,
Sinner
Re: Wildcard and Sumproduct,
Bob Phillips
RE: vlookup and dates!,
Stefi
Re: Sumproduct Count, Allow Or Two Fields,
Peo Sjoblom
How accurate is SOLVER?,
Augabog
Re: sorting data,
Max
Re: How do I edit a cell in Excel without clicking on the cell first?,
L. Howard Kittle
Format date as text,
Invalid
Re: WHAT IS A DELIMITED LIST,
Debra Dalgleish
Re: Worksheets with OFFSET command always ask if I want to SAVE,
Gord Dibben
Re: Counting different workinghour types,
Bernard Liengme
Re: Like items will not combine in a pivot table.,
Debra Dalgleish
Re: Can I rename the column letters a,b,c etc. in excel 2003,
Gord Dibben
Student Marks Calculation,
Dr Traffic
Re: future value calculation in excel,
Fred Smith
Re: Changing a pivot table's data range in Excel 2007,
Nick Hodge
Re: Sum by company?,
JE McGimpsey
Re: counting cells?,
Bernard Liengme
Nice site!Check it:,
Prohor!
Changing Entries to Proper and Upper Case Q,
Sean
Re: find replace,
spaceage
Re: Calculate next number using dates?,
T. Valko
Re: Array formula with index + match,
Sena
Re: How to set condition for frequency?,
Domenic
Re: drop down button,
Debra Dalgleish
Re: Sumproduct??,
Bill Kuunders
