microsoft.public.excel.worksheet.functions
- Re: =IF(D43>=45*D43<=87,"5.00","0.00"),
Biff
- Re: irr,
Fred Smith
- Re: Excel performance calculation,
JE McGimpsey
- Re: Index Match Function,
JE McGimpsey
- Re: Extract Date from Right Formula,
JE McGimpsey
- Re: Elapsed Time over 24 hours,
JE McGimpsey
- Re: Iteration problem (Excel 2002),
Sasa Stankovic
- Re: Count Formula,
VBA Noob
- Message not available
- Message not available
- <Possible follow-ups>
- Re: Count Formula,
Maistrye
- Extract data,
grannybier2
- Re: Converting hours:minutes:seconds to just minutes,
Dave Peterson
- Re: Comment Indicators,
Mallycat
- Re: How do I link password protected files to a master spreadsheet?,
Dave Peterson
- Re: Using Excel for mail merge,
Gord Dibben
- Countif with nested function not working?,
jshuatree
- Re: How do I get a cell to give a result based on the month we are in?,
VBA Noob
- Re: What's the easiest way,
VBA Noob
- Re: sum the values of a range based upon multiple ranges and criteria,
SteveG
- Re: Subtract time between certain days/work hours?,
S Davis
- Very large complex workbook is now giving me the wrong results :(,
S Davis
- Re: To leave a blank cell,
Otto Moehrbach
- Re: Length of Service,
VBA Noob
- Re: Convert time format to a decimal,
Dave Peterson
- Re: Data Verification Problem,
Dave Peterson
- Lookup mulitple tabs,
jillteresa
- Concatenation,
Harry
- There has to be a formula for this....,
LSB M
- Function - Counting Years in range,
VBA Noob
- Re: Time Calculations,
JE McGimpsey
- Re: How to write a count-if-not function?,
Jon Quixley
- Return array from worksheet function,
Steve Lloyd
- Re: how do I count the occurrences of multiple conditions,
Dav
Re: Converting positive numbers to negative numbers,
Ardus Petus
Gradesheet formula needed,
harrop1
Re: calender for spreadsheet,
Bob Phillips
List items in column,
Terry Bennett
Re: What is the function to calculate standard errors of the mean?,
Dav
Re: formula CENTILE,
JE McGimpsey
How to separate id and name from column,
kaustubhghag
Trimming Data,
Terry Bennett
Re: Convert from number to word in excel,
bplumhoff@xxxxxxxxx
RE: need help in the code,
Toppers
Re: what does IF(D3="," mean please,
starguy
Countif,
Harry
Re: Function to give value of a BLANK cell based on another,
Bob Phillips
Re: multiple function in formula,
Gary
Message not available
<Possible follow-ups>
Re: multiple function in formula,
Ron Rosenfeld
Re: multiple function in formula,
patele
Help needed,
Gary
Excel Functions,
digital21st
Regarding updating 1000 values using vlookup from another worksheet,
VirusKid
Array Formula with AND operator,
edwardpestian
How to hide Sheet tab Bar & status Bar for a excel file,
Vikky
subtotal(9,....,
Shane Moore
Re: Using Countif on multiple columns,
Biff
Re: Convert cell contents to range,
Biff
Comma,
Gary
Re: how to return multiple results in vlookup?,
Biff
access query to import to excel,
jazzydwit
Re: Using AVERAGE with conditions in different worksheets?,
daddylonglegs
Re: Can I run setup Office 2003 for office 2000 installed?,
Gord Dibben
Re: linking worksheets,
vezerid
Re: How do I get a cell to update itself based on the month we are in?,
Biff
Sort text list by character length - how?,
masterdiablo13
Re: A function to return the value of a blank cell,
CLR
Re: How do I add all values in a given row (not colum)?,
VBA Noob
Re: How do I total a series of checked boxes?,
Ron de Bruin
Re: Printing multiple worksheet areas in a single page,
Ron de Bruin
Question about Word export to excel?,
Mr BT
Re: How to make worksheet names dynamic?,
Don Guillett
Re: I can't find why my formula is inconsistant - please help,
MartinW
Re: formula - excell,
vezerid
Re: How do I add a duration time value and a clock time value?,
VBA Noob
listing unmatched items!,
via135
help is require with this,
craig
Formula not working for me now,
S S
Re: KEEP CELL VALUE UNLESS IT IS -0.15 THEN ENTER 0.00,
Ron Rosenfeld
I have to change a bunch of formula that need to reference a different workbook.,
Marc
Comparing specific date and hour with NOW(),
Memoman
Re: =COUNTIF(D4:D29,">0"),
RagDyeR
Date 13 Weeks from now,
Craig
Re: averaging 32 fields,
Niek Otten
Sumproduct & Indirect Functions,
VBA Noob
Re: how can i average more than 30 fields?,
Niek Otten
Re: countif both conditions in a row of 2 cells exists,
RagDyeR
<Possible follow-ups>
Re: countif both conditions in a row of 2 cells exists,
Dave Peterson
Returning Numeric Results across a Single Row in Consecutive Cells,
Sam via OfficeKB.com
Re: sumproduct formula,
Roger Govier
Joining Worksheets,
Naomi
Re: how do I move data in prexisting rows to columns?,
Bondi
Re: Unhide multiple work sheets at once,
Mallycat
Dynamically Generated Range using Macro,
JM . EE01
Re: How do I save a single spreadsheet in a workbook in excel,
VBA Noob
Using a listbox to show every unique record in a range,
jedale@xxxxxxxxx
Re: How do I put a company logo in the background of an Excel document,
davesexcel
Re: converting vertical data list to horizontal data list,
Ragdyer
Re: Staffer at work with problem...,
Ragdyer
Re: How Do I Write over Pictures?,
beachballbear
Re: Number of IF statements exceeded...,
gardenhead
Re: Conditional Excel formula,
Alan
- Message not available
- Message not available
holding the result constant,
tandon . sourabh
Re: Vlookup,
tony h
Re: How do I create a formula using cells from multiple worksheets?,
Otto Moehrbach
Re: Multiple IFs,
Chip Pearson
Re: formula,
Ingolf
Re: highlight largest number in a row,
Pierre
Re: How do I avoid referencing hidden values in formulas like OFFSET?,
Harlan Grove
Re: Date arithmetic: adding 1 month to prior end of month date,
SteveG
Re: I need help with a formula values,
Bearacade
List with auto filters,
lostinformulas
Re: PivotTable Question,
Debra Dalgleish
Format different worksheets automatically,
mariopayan
Inserting blank entries for missing values,
rbmcclen
Overtime Calculation???,
Cherilou
Atpvbaen.xls,
FilippoRotolo
Consolidate information / Summing,
Oggie Ben Doggie
Re: Extracting a number in a text string,
RagDyeR
insert page break when there is a change in the row value,
mandy_ball
Re: How can I edit the year in a date field in Excel?,
Ingolf
Re: CONCATENATE,
Die_Another_Day
Re: Extracting data from a cell,
MDubbelboer
Re: PING within Excel Cell,
Vikky
Find date query and Display issue,
VBA Noob
Re: data reentry for ferification,
Pierre
New Code,
Larry
Re: How do I get my Validation Lists to keep their formatting?,
Debra Dalgleish
Re: User defined function detects font colour,
Bob Phillips
Re: Confused on what to use ????? vlookup with different criteria,
Dav
=offset ???,
myeaddress2003
hiding blank cells when no results,
andyell
Copy content of cell to another depending on value of third cell (between worksheets),
Zeljko Milak
Re: sorting in excel,
Dav
Re: calculating age,
Dav
Re: functions,
Dav
How to Extend Range Automatically,
myeaddress2003
Re: Macro to lookup duplicates,
Ardus Petus
Re: creating functions,
Mallycat
Re: IF & OR functions,
Bondi
Linking to other sheets (depending of a cell),
petterss
Autocorrect Question?,
pork1977
Re: how do i get only the decimal value in excel,
MartinW
Re: Automatically add date into a cell,
Ashish
If Function. How to Add more criteria,
Corey
SumIf,
Dorian C. Chalom
Position Cursor to same address on another tab,
SassyLassie
fixing column width,
John P
use of wildcards,
italiavb
Need formula to count spinoffs,
jamescarvin
Re: extract number and use in formula from text & numbers in cell,
Biff
Change Shape Text,
rhani111
Search Multiple columns for criterion asterisk (*) and Return Numeric Label,
Sam via OfficeKB.com
Re: How to identify text from a autofiltered list using formulas,
Mallycat
summarizing data onto second sheet,
grannybier2
How to Evaluate Dynamic DDE Formulas,
MArcus Baffa
Re: Can I change my default settings to never show gridlines ?,
Gord Dibben
Re: Can I compile data in sequentially numbered worksheets easier?,
Mallycat
countif statement,
italiavb
Re: How do I use a pivot table to present data, not sum or count it.,
Mallycat
Re: need advice on 0, "" , " ",
Die_Another_Day
Navigating between worksheets using a drop down menu,
ncdogteam
Re: can I format a workbook so that every sheet has the same footer,
lostinformulas
Re: how do I show a value = a value in a range (A1 = any(b1:b35)?,
Biff
Re: I am trying to calulate total time,
VBA Noob
Automatically printing psted text over 250 characters to another cell,
Hobart007
Re: how to return mulitple corresponding values,
Debi H
- Re: how to return mulitple corresponding values,
Biff
- <Possible follow-ups>
- Re: how to return mulitple corresponding values,
Biff
- Message not available
- Re: how to return mulitple corresponding values,
Biff
- Re: how to return mulitple corresponding values,
Debi H
- Re: how to return mulitple corresponding values,
Biff
- Re: how to return mulitple corresponding values,
Debi H
- Re: how to return mulitple corresponding values,
Biff
- Re: how to return mulitple corresponding values,
Debi H
- Re: how to return mulitple corresponding values,
Biff
- Re: how to return mulitple corresponding values,
Debi H
- Re: how to return mulitple corresponding values,
Debi H
- Re: how to return mulitple corresponding values,
Biff
- Re: how to return mulitple corresponding values,
Debi H
Dependant Lists in Excel,
Browett
Concatenating and transposing a row of numbers,
Colin Hayes
- Re: Concatenating and transposing a row of numbers,
Richard Buttrey
- Message not available
- Re: Concatenating and transposing a row of numbers,
Gord Dibben
- Re: Concatenating and transposing a row of numbers,
Colin Hayes
- Re: Concatenating and transposing a row of numbers,
Gord Dibben
- Re: Concatenating and transposing a row of numbers,
Colin Hayes
- Re: Concatenating and transposing a row of numbers,
Gord Dibben
- Re: Concatenating and transposing a row of numbers,
Colin Hayes
- Re: Concatenating and transposing a row of numbers,
Colin Hayes
- Re: Concatenating and transposing a row of numbers,
Gord Dibben
- Re: Concatenating and transposing a row of numbers,
Colin Hayes
- Re: Concatenating and transposing a row of numbers,
Gord Dibben
- Re: Concatenating and transposing a row of numbers,
Toppers
- Message not available
Formula result not displaying in cell,
Brandon . Rutschmann
Create Dropdown menu without using the Validation on the Data Menu,
lostinformulas
Re: Date Last Modified,
All In
Re: Dependent Lists in Excel,
ThomsonJ
Re: from a cell which has numbers how to get it spelled,
Bondi
Re: Run Macro on Mouse Click,
Richard Buttrey
Help with Conditional Formating Time,
jonhunt
Re: Can you use INDIRECT in 3-D references?,
Harlan Grove
Using a PasteSpecial within a Destination:= line,
drdavidge
calculating a 2-log drop,
SMutchnick
Re: Sorting rows,
Die_Another_Day
Re: Can an Excel cell value be used in a Custom Footer?,
Gord Dibben
Re: worksheets,
Gord Dibben
Re: Cells only display formula,
Special-K
Hyperlink - Passing a cell reference,
buechler66
macro takes 30+ seconds to do an autofit on only 1 of 3 sheets it is autofitting,
drdavidge
Stumped....Matching Columns,
c0nfusEd : {
Re: how do I open a publisher file in front page,
Franz Verga
formulas/function require (2),
craig
Re: Macro to capture worksheet names,
Franz Verga
Re: index/match/replace,
Franz Verga
Calculating cells with text only,
Cissy
Here's a good one!,
Chris Berry
Re: =NETWORKDAYS not working as expected and as it once did,
Ardus Petus
Re: cells visable and following. Not freeze,
Die_Another_Day
help making formulation,
f_disk
Excel formula Q,
scoobz
Stumped with an IF function,
Grant Reid
Help With Formulas,
IanEmery
RE: Converting US Dates to UK Formats,
Matt
Re: Help..... with formula,
Bob Phillips
Re: formula to remind me of an appointment 3 months in the future,
Franz Verga
Re: DATEDIF,
Franz Verga
Re: Relative addressing,
Franz Verga
Re: Error when insering a "Right" function,
Franz Verga
Re: not sure which function to use for this summary,
Franz Verga
Re: How do I do a vlookup that links to file paths within a cell ref,
Franz Verga
Re: IF in combination with larger than,
Ardus Petus
Re: how to expand the autofilter range 1000 to 10000?,
Pete_UK
Need help with dividing and using ISERROR for Div/0!,
durerca
Re: Repeat last action,
Mallycat
Sumif with two conditions?,
thiensu
Re: Using the lookup Function for similar items to add together,
Biff
Need to find a formula,
Lanza52
Conditional Average Array with Dates, <blanks>, 0,
tangomj
- Re: Conditional Average Array with Dates, <blanks>, 0,
Biff
- Re: Conditional Average Array with Dates, <blanks>, 0,
tangomj
- Re: Conditional Average Array with Dates, <blanks>, 0,
Biff
- Re: Conditional Average Array with Dates, <blanks>, 0,
tangomj
- Re: Conditional Average Array with Dates, <blanks>, 0,
Biff
- Re: Conditional Average Array with Dates, <blanks>, 0,
tangomj
- Re: Conditional Average Array with Dates, <blanks>, 0,
Biff
Conditional Average across worksheets,
madduck
Using IF in an array,
L Martin
Re: How do you create a list & data validation in same cell?,
Debra Dalgleish
Re: how to start using vlookup, match & index formulas, examples,
Gord Dibben
Re: matching values that are not in order with conditional formatting,
Biff
PMT question,
SMAlvarez
Re: Complex Nesting,
Biff
Hyperlinking problems,
msteel
Re: Set solver constraints so variables are either 1 OR 0.,
Dana DeLouis
Re: Auto Numbering System,
Gord Dibben
Re: I can't change colors in certain Excel cells,
Richard Buttrey
Re: WORKDAYS FUNCTION CAUSES #NAME? ERROR WHEN OTHERS USE FILE,
Bob Phillips
Re: Why are formulas not updating when changing a value in the range?,
Nick Hodge
Re: How do I keep the font color with VLOOKUP?,
Nick Hodge
Re: Search column for value and return TRUE or FALSE,
Roger Govier
Re: How can I find comon values in seperate spreadsheets?,
kraljb
Re: How do I write a comlicated conditional statement?,
OlYeller21
Re: How do I make excel not prompt before deleting worksheets?,
Nick Hodge
Importing EXCEL Spreadsheets into ACCESS -- Macro or VBA?,
doctorjones_md
Please tell me this is possible,
Ryan
Delete Macro,
Saruman
Re: How can I find duplicates in one column of an exel spreadsheet?,
Nick Hodge
Re: Excel,
Gord Dibben
Re: how can I compare two excel spreadsheets?,
lostinformulas
Re: How can I covert dates to ccyymmdd?,
Niek Otten
Re: Average calcs - ignore sheets,
Bob Phillips
Average Time Difference,
jonhunt
Re: How do I get ONLY new info from 1 Worksheet to another automatical,
S Davis
Re: add leading zeros,
Arvi Laanemets
Re: auto updating list,
Roger Govier
Re: no password for protected sheet,
tony h
Re: How do I retrieve & view multiple matches from another workbook?,
Niek Otten
Formula/Macro to delete rows that do not meet criteria from a list?,
S Davis
date problem in excel,
arindamkol_1978
Count, Countif, Sumif??,
benjam_in
- Re: Count, Countif, Sumif??,
Arvi Laanemets
- Re: Count, Countif, Sumif??,
John Michl
- Re: Count, Countif, Sumif??,
benjam_in
- Re: Count, Countif, Sumif??,
benjam_in
Re: If statement,
RagDyeR
Re: How to format cells to show dates as the week-ending date of that,
Bob Phillips
Re: Time * Rate = Amount Billed Formula?,
Pete_UK
Extracting Data for a Formula from a List,
Zaraf
Import External Data -- Fill down formulas Issue,
Jonathan
Sorting Data From One Column into Multiple Columns,
Justin Hoffmann
Re: calculating a date using the day of the week as a starting point?,
John Michl
Tabs v.Pages,
DarklyCute1
RE: Converting data in one cell to 3 different cells,
CLR
how to hide a list of macros without password protection,
Padam
Re: Reverse worksheet data by columns,
Dav
Add worksheet Lookup based on date,
edwardpestian
Re: If statement to compare for wildcard value in another cell.,
Biff
average formula ingoring empty cells,
jenparker1234
set filename to <filename-date> on open,
bob engler
Re: get a count from multiple lookups,
bmstar
noamal curve and cumulative distribution graph,
hendra
Incremental Numbering,
fastcar
Simple Question but need urgent help pls...,
hendnov
Re: hidden columns,
Ken Johnson
Formula to search for given term, and if not found in column to add it to list,
financier
Please help me... with Case Structure,
LSB M
Formula problem with different sheets,
Carmen Gauvin-O'Donnell
Re: remove a drop-down list in excel,
Gord Dibben
I want to turn off Text Import Wizard,
NMacGyver@xxxxxxxxx
Re: COUNTIF - Multiple Criteria,
Bob Phillips
Re: How to "auto fit",
Gord Dibben
Re: Can I add a drop-down list to a Vlookup?,
Bob Phillips
Re: Referencing a column across worksheets,
Bob Phillips
Need to create a error message box,
lostinformulas
Re: change position of filter button,
Debra Dalgleish
combining fields on a pivot table,
asamoto . 2
Re: Is it possible to format a cell w/ 2 font sizes by formula?,
Dave Peterson
Retrieve Data from one sheet to another,
karstens
Re: Excel Sheets,
Otto Moehrbach
Re: How do I find best fit out of a set of options by ranking criteri,
Domenic
Re: Hidden worksheet,
Otto Moehrbach
SUMIF across multiple worksheets workaround help,
grant . henninger
Using linest for flow rate calculation,
Robert_Steel
Re: funtions for colors for fonts or cell backgrounds?,
lostinformulas
Re: how do you do an average for percent without putting in the perce.,
joeu2004
Return info based on Date Range,
kermitforney
Re: Custom Filter,
Ron de Bruin
Re: Question on some homework I have to do,
Die_Another_Day
Transpose row to read to column,
Tiesthatbind
Re: 2007 insert button/icon,
Ron de Bruin
Re: Can anyone figure a formula for this?? Please?,
Bob Phillips
Re: Look up date on another sheet and do count of active cells (column,
Bob Phillips
LARGE with text string,
edwardpestian
Re: How do I sort Library of Congress call numbers in Excel?,
Pete_UK
Compare times : IF time < time2 then,
david-witts
How do I resort names,
dsrtdrms
Re: Adding up multiple cells,
Gord Dibben
Re: how can I insert rows in part of worksheet,
Gord Dibben
Re: oldest incomplete job,
Bob Phillips
Re: sound or speech the value of the cell if value > 10,
Ran Pelly
Re: cond formatting ?,
Ran Pelly
Linking a Specific Word to a Specific Number,
julio . vazquez
Re: How do I shade the active cell in excel,
Bob Phillips
Setting Dates,
Maistrye
Copy cells to neighbor column after leaving the cell,
nemadrias
Re: Last Day Of Month Calculation...,
Bondi
Re: EXCEL SPREADSHEET FORMAULS,
aidan.heritage@xxxxxxxxxx
Nested IF,
Gos-C
Tracking Time,
CCS
Counting cells with text,
Cissy
Re: While using networkdays function, how can define weekly off days,
Bob Phillips
hyperlinks,
mastruccil
Leauge Table....Help!!!,
ronaldo444
- Re: Leauge Table....Help!!!,
Dav
- Re: Leauge Table....Help!!!,
ronaldo444
- Re: Leauge Table....Help!!!,
ronaldo444
- Re: Leauge Table....Help!!!,
Dav
- Re: Leauge Table....Help!!!,
tankimpong
- Re: Leauge Table....Help!!!,
Dav
- Re: Leauge Table....Help!!!,
tankimpong
- Re: Leauge Table....Help!!!,
Dav
- Re: Leauge Table....Help!!!,
ronaldo444
- Re: Leauge Table....Help!!!,
Dav
- Re: Leauge Table....Help!!!,
ronaldo444
- Re: Leauge Table....Help!!!,
ronaldo444
- Re: Leauge Table....Help!!!,
Dav
- Re: Leauge Table....Help!!!,
Dav
- Re: Leauge Table....Help!!!,
Dav
- Re: Leauge Table....Help!!!,
Dav
Re: Formula Query - Using Time & Text,
Pete_UK
Re: Logic Test ?,
David Biddulph
Excel question,
Lars Grøtteland
Re: referencing todays date.,
Bob Phillips
Re: Value within a range,
Bob Phillips
Re: compare 2 books in excel??,
Jon Quixley
VLOOKUP question,
duration
Plus or Minus,
edwardpestian
How to count the number of 'values' in a cell,
Sandih
Re: Distinct,
Biff
Re: Complex Formula,
Biff
Re: count number occurring within specific date range,
Biff
Re: select date range in column,
Biff
Different Number of Workbooks each week,
Wally Steadman
Re: Workday Function in Excel 2007,
Biff
More sort options - do they exist?,
shaunl
Re: lookup and add a value,
Die_Another_Day
simple formula,
marley
Re: How to calculate return from uneven cash inputs over time?,
joeu2004
row= cell's row,
wptech
Re: How do I set up a needs assessment result template in Excel?,
Gord Dibben
Re: Excel Formula Help!,
Richard Buttrey
Re: Advanced use of LARGE function,
Die_Another_Day
Re: Can you do inverse trigenometry on excel - i.e Tan-1,
Dav
Need help with linking a file to a picture.,
MrSales
Re: Formula in Excel to show greater than 50, but less than 250?,
Dav
Re: requiring a field,
Gord Dibben
Re: How do I reformat my database from all uppercase to proper?,
Nick Hodge
Re: How do I reinstall the autosum button? I cannot find it on Excel,
Gord Dibben
Re: multiple selections from drop down list,
Gord Dibben
Re: sending macros,
Don Guillett
Re: SUMPRODUCT with AND's and OR's?,
Bob Phillips
Re: Values in spreadsheets do not update,
Saruman
This is more complicated than it looks.,
dollarbill79
Re: Can I sort worksheets based on the tab name?,
Ryan Christiansen
Need Help w/ Index and Match Formula,
japorms
Re: Making multiple selections from Excel drop down lists,
Debra Dalgleish
Re: Excel is totaling wrong,
Niek Otten
Graphing a dynamic range that automatically picks up the most recent entry.,
gimiv
Re: SUMPRODUCTS,
Richard Buttrey
Re: How do I create a list inside a single cell?,
Paul B
How to: COUNTIF when ISTEXT is True?,
dpenny
Re: Summation Operator,
Don Guillett
What does -- do?,
Maistrye
Re: formula question,
David Biddulph
Re: COUNTBLANK function,
RagDyeR
VLookup Formula,
jazzydwit
Re: How do I Minus 10% discount On my Excel Invoices On the Sub Total,
Bearacade
Sum Column Entries that fall within Date Range Listed In Rows,
Ben
Re: Row() function returns wrong row and more..,
Niek Otten
Count number of textual values in a row,
c99sg1
Excel FUNCTIONS stop working,
suekh
Sorting SumIF,
slim
formula to extract text out of a paragraph,
The Moose
SUMPRODUCT and OR operator,
Madiya
Re: Excel limit that stops pivot table processing at column IV??,
JE McGimpsey
Re: adding conditional rows,
Don Guillett
Re: why does Excel add more rows than I have selected,
Richard Buttrey
Help with a SUM function...,
mitov
stuck on option buttons,
excel_stuck
Placing a Variable Properly,
Dennis
Re: How can I round in quarter points?,
Biff
Re: Sum based on two conditions,
Domenic
lookup formulas to obtain multiple results,
Scott Zane
Re: How do I calculate CAGR other than using XIRR function?,
Fred Smith
Re: percentages,
Sandy Mann
RE: conditional formatting,
Lofty
V-LOOKUP,
DFOSTER
Re: link a range of cells,
Ron de Bruin
Re: How do I use functions and calculations?,
Dave Peterson
RE: use a function to look up a result in a spreadsheet,
Toppers
flagging unmatched items!!!,
via135 via OfficeKB.com
How to make worksheet always open in same place?,
jiwolf
Re: How do I set NETWORKDAYS to regard friday and saturday as weekend,
Biff
Re: Occurance Counting,
Gord Dibben
Double Entry table,
Mnilo
Re: I would like to convert digits (eg. 16) to text SIXTEEN in Excel,
Niek Otten
Format of Cell an Issue,
John
Re: evaluate two cells and calculate based on criteria,
Don Guillett
Sum of individual digits (just for fun),
Hans Knudsen
RE: Vlookup HELP,
Toppers
Re: EXCEL CELL PROTECTION,
Nick Hodge
Re: Divide x/y should give Ratio x:y,How to express ratio in excel,
Niek Otten
Re: How can I script formula?,
Roger Govier
Re: Excel - how do I use drop down list to filter data,
Roger Govier
If Cell Contains Put in another Cell,
Dennis
Re: *HELP* time formulas,
Biff
simple formula not working,
Charles Shapiro
Repeated data into flat file format,
Paul Simon
Re: choosing off various lists,
KL
Re: How do I find the 12 highest numbers in a row of 52 numbers,
KL
CELL Function and Worksheet Name in a Cell,
David
Re: Three Variables,
Biff
Re: recording a data entry date,
Nick Hodge
Re: create report in excel sheet,
Gord Dibben
Re: RE Excel: Once a list is created, how do you delete it if needed?,
Nick Hodge
return payoff after "X" amount of payments,
jermsalerms
Lookup functions,
arnoberg
Re: search column of text cellto identify those cells with specific w,
Nick Hodge
Re: Adding numbers in rows results in zero. help!,
Nick Hodge
Re: How do I convert values in figures to words in EXCEL 2000?,
VBA Noob
Seting the minimum value in a cell,
crispydcrisp
VLOOKUP formulas,
Donna
Combin,
Andreas
Re: Combin,
Tushar Mehta
Re: Combin,
Dana DeLouis
Re: Combin,
MartinW
=SUMIF Problem,
doctorjones_md
Re: Lookup Function,
Biff
Re: how do I copy a worksheet with formulas to another workbook?,
Mallycat
Re: how do i put a formula in a macro to run a program,
Mallycat
Re: Can I flag numbers that are higher/lower than a range of #'s,
CLR
Using MATCH with dates,
robotman
Help with military problem...,
jgn2112
Getting column number from HLOOKUP?,
robotman
Re: Average function question,
Franz Verga
Using text for the range in AVERAGE function,
robotman
I need a formula can you help?,
sjgidman
Difference between 2 dates, incl weekends, with variable work days,
babryanton
Re: Please Help!,
Roger Govier
Re: Having a formula provide a running total from multiple worksheets,
macroll
Macro help.,
tweacle
Depreciation Formula,
doctorjones_md
Re: Calendar control on cell enter?,
Gord Dibben
Re: excel numbers in general format i cant add cant change format,
Gord Dibben
Re: Calculating dynamic moving averages,
dmax007
Diff two excel spreadsheets,
bhaskarmurthy
Re: How can I count the # of times the word "Yes" appears in a range,
Bearacade
Re: How do I display all conditional formatting in Excel?,
Gord Dibben
Re: doesn't work,
Gord Dibben
conditional calculations,
jenders
Search /Filter vertical Numeric pattern (down single column),
Sam via OfficeKB.com
Collecting data from worksheets.,
MrSeagull
Re: Calculate the difference between two cell entries using NOW() func,
Gonzo
Re: Can you create form in Excel & text wraps across several columns?,
Richard Buttrey
Unable to Evaluate Formula,
mht53
Re: If formula,
joeu2004
Re: excel 2003 wont sort when shared,
Casey
Re: Excel - Hyperlink, the link gets Corrupted,
Dave Peterson
Why does Excel say this formula contains an error?,
HuskerBronco
Re: Using Hide, Unhide, and auto filter - select all on a protected sh,
Casey
Joining/Linking nested formulas,
Aikisteve
Re: How can I use the & symbol as text in the header of spreadsheet?,
Casey
newbie question,
excyauseme@xxxxxxxxx
Can anyone see a problem with this?,
bikky
Re: Can anyone see a problem with this?,
Dav
If(If statement?,
Boulder257
Re: Vlookup from 2 columns,
Domenic
Re: Formulas in Excel,
MartinShort
Re: combine 2 cells but keep formating of each individual cell,
CLR
Re: How do I make excel pivot table count blank cells?,
Debra Dalgleish
Problems saving a worksheet with links to a New Location,
doctorjones_md
Excel in a Browser and Security,
Glenn Rathke \(Soft Design Consulting\)
Best way to populate worksheet from 2 combo boxes,
jswasson
adding value only if criteria is true,
gerryR
Re: How do I look up one worksheet and insert in another?,
Roger Govier
Add up worksheets,
Kate
Using a lookup to return multiple values in one cell??,
zim_zimmer
Multple criteria dilemma,
Grant Reid
Re: Number of years/months/days between 2 dates,
Bondi
Copy from worksheet to worksheet help,
bikky
Importing diagram from Excel to Word,
Omkar
copy active cell value,find the pasted value in different worksheet,
tomaz . vouk
Re: How do I insert new work sheets in numerical sequence?,
Nick Hodge
Avg Times in MOD fx using selected rows,
vldavis809
Convert arial text field to barcode,
bob engler
Re: find hidden data in worksheet,
Biff
Message not available
Sheets Tabs moved to Right Side of Page. How to get back to Left ?,
Corey
SubMenu .action argument,
jgwphansen
Re: Create a message upon opening of Spreadsheet,
Dave Peterson
Re: Excel: ADDRESS cannot be used in CELL. How stupid is this?,
Harlan Grove
Re: Print Preview icon behaves like Print,
Jim Cone
Re: keystroke to go to first worksheet cell from anywhere in notebook,
Steel Monkey
Re: Secant function,
Harlan Grove
Re: Page Setup protection,
Dave Peterson
if "x" days is more fall on weekend return following monday,
jermsalerms
Re: Macros in Office Excel 2007,
geko
Re: how do i copy down x number of times,
Ragdyer
Re: Complicated Lookup Function,
Biff
Re: Find & Replace a link to another worksheet in the same workbook,
barbetta3141
named range row offset,
barbetta3141
Re: IF THEN function help needed!!,
Sandy Mann
Please Help A Newbie - running balance,
JacobWallace
Re: How can i have a drop-down menue in a cell of an Excel preadsheet,
Maistrye
Pretty easy If loop - help!!,
nemadrias
Re: Conditional Sum,
Die_Another_Day
Re: Date to Days of the year,
Ron Rosenfeld
More math than excel, but a fun problem,
S Davis
Re: Chart with dual Y axis data,
nemadrias
function to change metric measurements,
devo
Advanced function to remove specific rows,
nemadrias
Re: Can't highlight a single cell. Creates a range when I move curso,
Gord Dibben
Display ranked data in order from a range,
S Davis
Re: Can't highlight a single cell. Creates a range when I move curso,
vavirgo777
Counting unique values,
JK57
Sumproduct,
jaybird2307
Calculating dates,
Toby0320
"Average" questions,
Bootroots
Re: Can I use more than two conditions in custom autofilter?,
Roger Govier
RE: interpolate,
tom ossieur
Solver Binary Contraints problem,
Rick Kaullen
Re: Moving data based on date ranges,
Roger Govier
Re: formula bar deception,
Roger Govier
Re: How can I use conditional formatting to hide or delete rows?,
David Biddulph
Re: 2 copies of my spreadhseet open!,
Bob Phillips
Re: IRR (or MIRR?),
joeu2004
Re: Give RELEVANT responses to questions. DO NOT give usless list,
Gord Dibben
Re: IRR and NPV,
joeu2004
RE: Using variables in a cell/formula,
Toppers
Complicated query,
Btbxgirl
Carriage returns in the formula bar?,
rubeus
Convert rows to columns,
Geno
Re: Separate First Name MI and Last Name into three Cells,
Gord Dibben
Re: fill down multiple cells in the same column,
Gord Dibben
How to extract email address and place into a new column,
Inquirer
Re: Sheet name/number,
Gord Dibben
Re: Digits spell it out in english using smart tag,
Gord Dibben
Re: Automate MTD summation,
RagDyeR
Re: Insert new date once.,
Don Guillett
Assigning Points in a Weighted Scale (HELP!),
greatday007
Re: Developing macro event to allow multiple choices on drop down menu,
Don Guillett
Re: Formulas,
Don Guillett
Re: IF-THEN Formula help needed,
Maistrye
RE: Difficult Average Calculation <HELP>,
JK
Re: Automatically updating cells in a different tab? Possible?,
DarklyCute1
Running Macros,
doctorjones_md
Re: Excel automatically inserts a formula in my sheet,
davesexcel
Re: Its always the simple ones....Basic Circular Reference Problem.,
Ardus Petus
Re: Need help in rounding answers to nearest multiple,
Vito
Re: Reference a cell containing a Reference,
Vito
if in conditional formatting,
DKY
Excel vba to call Access Macro,
ppyxl
Total on a different page,
DarklyCute1
Re: how do i run an autoexecute macro in excel,
davesexcel
Re: Adding # of days to a date,
Ardus Petus
FUNCTION GETPIVOTDATA MICROSOFT EXCEL 2003 VS EXCEL 2004 FOR MAC,
FRANCISCO PEREZ-LANDAETA
Using IF function for many many cells, and using more than one IF function,
Aikisteve
FUNCTION GETPIVOTDATA EXCEL 2003 v EXCEL 2004 FOR MAC,
FRANCISCO PEREZ-LANDAETA
Use cell value as reference to sheet in formula?,
bluegnu
How to find valuse in cells.,
kodzirko
Insert formula automatically with new entry,
Clare
Timesheet,
ChrisMattock
Re: create date,
MartinW
Combining COUNTIF and AND functions,
david
- Re: Combining COUNTIF and AND functions,
Bob Phillips
- Re: Combining COUNTIF and AND functions,
colin_b
- Re: Combining COUNTIF and AND functions,
Bob Phillips
- Re: Combining COUNTIF and AND functions,
colin_b
- Re: Combining COUNTIF and AND functions,
colin_b
- Re: Combining COUNTIF and AND functions,
RagDyeR
- Re: Combining COUNTIF and AND functions,
colin_b
- Re: Combining COUNTIF and AND functions,
RagDyeR
- Re: Combining COUNTIF and AND functions,
RagDyeR
- Re: Combining COUNTIF and AND functions,
david
- Re: Combining COUNTIF and AND functions,
colin_b
- Re: Combining COUNTIF and AND functions,
RagDyeR
- Re: Combining COUNTIF and AND functions,
Dav
- Re: Combining COUNTIF and AND functions,
RagDyeR
Re: I want to add 6 months to a certain date in a formula (Excel),
RagDyeR
Re: How do I keep a running 'Top five' in Excel?,
starguy
Re: IF function which returns the text from a cell,
Dav
Re: perform a calculation when a certain phrase appears in a cell,
Dav
Re: FInding Duplacates & correcting addresses automatically,
Dann Pedersen
Compare two worksheets for missing information,
Naba via OfficeKB.com
Re: leave the decimal fraction,
Ardus Petus
Re: How do I find all items with the same value without using filters,
davesexcel
Help! Reports,
Muffin
Compare Old & New Product List (i.e. VLOOKUP),
Hal
Re: Can a user select more than one entry in a drop down list?,
Debra Dalgleish
1,4,1,3,3,1,2=>1,4,3,2,
bridgerbell
- Re: 1,4,1,3,3,1,2=>1,4,3,2,
MartinW
- Message not available
- Re: 1,4,1,3,3,1,2=>1,4,3,2,
bridgerbell
- Message not available
- Re: 1,4,1,3,3,1,2=>1,4,3,2,
bridgerbell
Re: 1,4,1,3,3,1,2=>1,4,3,2,
Harlan Grove
- Re: 1,4,1,3,3,1,2=>1,4,3,2,
bridgerbell
Matching and Aligning Cells Formula/Function? Macro?,
junsung82
Re: Display an array of references,
Biff
RE: Formula to return under-budget store locations,
Josh Craig
Re: change minutes to hours and minutes,
Biff
Multiple Conditional @IF Statement Method,
crwiseman
Re: Lookup in Multiple Columns, Return Multiple Values,
Domenic
Simplifying my previous Request for Assistance,
doctorjones_md
Calculate a 30-day moving average based on the last x number of entries and date,
gimiv
Re: Time Totals in a Workbook,
Trevor Shuttleworth
Re: Calculation of a number in a range,
Bob Phillips
Return Row Number of LAST Numeric Consecutive Duplicate in Column,
Sam via OfficeKB.com
Database function criteria,
Maistrye
Protect IF statement AND allow data entry,
stilton
Re: Show the last # in a column,
Vito
Re: NEED HELP in Writing a FORMULA in colum D,
Bob Phillips
RE: Dissecting the contents of a cell,
El Bee
Re: macro,
Bob Phillips
RE: In need of a formula,
Ron Coderre
SumProduct for multiple WORKBOOKS,
chanbrig
Get the formula,
daiv
Re: Payroll labor costs,
Bearacade
Advanced Question (that I really can't describe!),
S Davis
Re: Trendline Equation,
Bernard Liengme
Updating data with an ODBC link to ACCESS,
doctorjones_md
Re: Macro question,
Chris
Re: Pivot Table - Options,
Die_Another_Day
Re: How to round negative and positive numbers,
Bearacade
Re: Excel Functions,
joeu2004
Re: Insert and sum in empty cell,
salsal
Re: how to convert number in word in a xls,
No News
Re: Delete rows with certain text,
David Biddulph
Ranking multiple columns by 1000th inch,
chappo555
Re: How do I round numbers to the nearest multiple of 10 or 5?,
Bob Phillips
Re: calculate date between,
Bob Phillips
Re: how to count if one column has email and another column has yes,
Bondi
Problems with Permissions...,
Corey
array formula(s)- not working, need some help please (problem with an 'AND'),
KR
Re: Formula uncertainty,
Dav
Biff I need your help!!,
Lorne Oliver
Re: Display Improvement for Writing Formulas,
Don Guillett
vlookout and if,
tomaz . vouk
Efficiently Generate 88 Chartsheets,
mtonkovich
Simplify Cell Formulas AGAIN,
mtonkovich
Re: opposite of weighted average,
David Biddulph
copying formulae,
ajs
Re: calculate date between....,
Bondi
Re: IF functions,
Lorne Oliver
Re: ajaynagpur,
David Biddulph
Re: Fill a cell based on a condition being met,
Biff
Difficult HLOOKUP/VLOOKUP,
edwardpestian
How to increase a variable after checking of cell is filled up or not?,
wuming79
- Message not available
- Message not available
Re: calculation,
starguy
Re: Finding Min Cell values excluding zero in alternate columns,
Biff
Is IF() Conditional the way to do this?,
Lorne Oliver
RE: Status Bar Configuration area,
Ron Coderre
Re: Delete rows if specific criteria not met.,
Barb Reinhardt
Re: NESTED IF FUNCTIONS,
Biff
- Message not available
- Message not available
What is "Adjusted R^2" in Multiple Regression,
poster1234us
Re: Formatting numbers,
Don Guillett
Re: How do I find total number workdays from a range of date,
Biff
Re: Convert Decimal hours and Minutes to minutes please.,
Chip Pearson
- Message not available
- Re: Convert Decimal hours and Minutes to minutes please.,
Biff
- Re: Convert Decimal hours and Minutes to minutes please.,
Steved
- Re: Convert Decimal hours and Minutes to minutes please.,
Steved
- Re: Convert Decimal hours and Minutes to minutes please.,
Biff
- Re: Convert Decimal hours and Minutes to minutes please.,
Steved
- Re: Convert Decimal hours and Minutes to minutes please.,
Steved
- Re: Convert Decimal hours and Minutes to minutes please.,
Biff
- Re: Convert Decimal hours and Minutes to minutes please.,
Steved
- Re: Convert Decimal hours and Minutes to minutes please.,
Biff
- Re: Convert Decimal hours and Minutes to minutes please.,
Steved
- Re: Convert Decimal hours and Minutes to minutes please.,
Biff
Re: need help with a formula,
Gord Dibben
Re: time problems,
Bob Phillips
Re: Automatically updating worksheets from a master worksheet,
Arvi Laanemets
Re: Help with formula,
Biff
<Possible follow-ups>
Help with Formula,
martins
Re: Formula help,
Scoops
Re: Change number formating,
Gord Dibben
Re: Skipping cells problem,
Gord Dibben
Re: Need to identify duplicate entries in a Table,
Richard Buttrey
Re: Excel - Formula Help!,
Arvi Laanemets
Re: How do/can I calculate the date for every Tuesday???,
Don Guillett
Filter question,
Bg
Re: Error in vlookup formula,
Franz Verga
Re: PMT,
Shaz
Text to value,
pantelis
Re: Change text to a single characters,
Dave Peterson
Re: How does Data Validation change with a formula change?,
Debra Dalgleish
Re: Worksheet Name from Cell Value,
Bob Phillips
Re: how do i remove default holiday format in XL i.e sat and sun?,
Dav
Re: How to turn rows horizontally to form columns?,
starguy
Counting between dates,
okanem
Excel filter over multiple sheets,
botto
Re: Converting a decimal time into hours and minutes,
Arvi Laanemets
Re: Extract multiple records from Excel table,
Ardus Petus
Re: Can a dropdown list be used to autofill data in more than one colu,
Bob Phillips
Re: Locate/goto a specific worksheet quickly,
starguy
Cell question,
Steve
Re: Sorting 2 names in one column,
Scoops
Re: Issues with my excel formula as it needs Circular reference - hlp,
Scoops
Re: Using IF function and validation list,
Dav
Re: How do I generate a list from a range of values,
starguy
Please Help Me with Custom menus,
Mr BT
Trouble with SUMPRODUCT,
edwardpestian
Re: A download of Analysis ToolPak (Analys32.xll) for Excel 2000,
Mike Middleton
Re: Cell reference of result,
Biff
Easy formula to return a true or false,
motol
Re: calculations in MS excel,
Ken Johnson
Re: MS excel incorrect autocalc?,
Carlos Antenna
Indirect function ?,
Carlos Antenna
Re: Why do my Autofilter icons no longer appear?,
Gord Dibben
Re: How do I fill in pivot table blanks?,
Dave Peterson
Re: Conditional formatting in a worksheet,
Bob Phillips
Re: excel formulas,
Bob Phillips
Re: VLookup function to right!,
hile trotman
Help filtering date related data,
mgalloway
Need Excel Function to FIND Text - Help!,
Cole
Re: Values to Letters?? Possible?,
DarklyCute1
RE: Comparing 2 Tables,
Gary Brown
Re: Excel, error:" too many cells format",
Dave Peterson
Re: Round formulas,
Bernard Liengme
Not Calculating Formulas.,
msmouse
Calculating time difference in minutes,
jonhunt
Re: how to compare two columns and get a output from it,
Scoops
to search and display the top 50s (from the previous 14 sheets) in a new sheet,
joyjoy329
Protection : More than 1 range protected ??,
Corey
Re: How to lookup the minimum, 2nd minimum and 3rd minimum.........,
Mark McDonough
# in Function,
CIL
Re: Auto copy down depending on criteria,
Debra Dalgleish
Re: Lookup of identical values?,
TobbeGardner
Easy one... but not for me :S,
ChrisMattock
Re: I need to return one of three answers in a cell,
Dav
Re: tertiles,
Dav
extracting data from other worksheets,
peiwen
Auto filter through the Comman Button,
irsath
RE: Converting a letter grade to a numerical value,
Greg Wilson
Re: adjust sales tax on my Excel Invoices,
CaptainQuattro
Re: blinking cell,
Gord Dibben
Re: TROUBLE COPYING AND PASTING FORMULAS,
R..VENKATARAMAN
Comparing Calculated Times,
Mike
Re: What does "<>" mean in an excel equation?,
Ragdyer
Re: Where is my question,
Ragdyer
Re: Range for Ranking IF Cell is Y,
Biff
Re: make a cell red after 14 days,
CLR
Simple match and link,
motol
Re: Count IF excluding blanks or zeroes,
davesexcel
Re: Create new excel table with filtered records from another table,
Nick Hodge
Re: $C$1972,2,FALSE, $C$1972,3,FALSE is ok, But $C$1972,4,FALSE Give #,
Nick Hodge
- Re: $C$1972,2,FALSE, $C$1972,3,FALSE is ok, But $C$1972,4,FALSE Give #,
Nick Hodge
- <Possible follow-ups>
- Re: $C$1972,2,FALSE, $C$1972,3,FALSE is ok, But $C$1972,4,FALSE Give #,
davesexcel
Re: 14 Nested IF statements creating different validation lists,
davesexcel
Re: How can I Make 3 copies of one worksheet Page?,
Ron de Bruin
Re: changing names in Cells of the Sales Pipeline management template?,
Gord Dibben
Is it possible to make a word in a formula bold?,
SpielbergRules
Checking if as split deposit is more than the total?,
SpielbergRules
Toggling Visibility of items with VBA,
SpielbergRules
Re: Worksheet Reference,
davesexcel
Re: remove the ( ) & dashes from column of phone #,
Don Guillett
calculating wanted cash from overlimit dealing in stock market.,
Wafa
Re: Excel can't conditionally format a cell if it contains a formula,
Ron Rosenfeld
Re: Advanced filtering,
MartinW
<Possible follow-ups>
Re: Advanced filtering,
Don Guillett
Re: Auto Copying Data,
steven1001
Mandatory Cells,
Mel1221
Lookup of Cells and transferring them to make a list,
Dan
Create Headings from Column Data,
alphag_25
Sort by color?,
Bud
Re: IF Function,
CLR
- <Possible follow-ups>
- if function,
bronking
- Re: if function,
mattjenkins
- Re: if function,
David Biddulph
- Re: if function,
bronking
- Re: if function,
mattjenkins
- Re: if function,
bronking
- Re: if function,
bronking
- Re: if function,
daddylonglegs
- Re: if function,
daddylonglegs
- Re: if function,
bronking
- Re: if function,
daddylonglegs
- Re: if function,
bronking
- Re: if function,
daddylonglegs
- Re: if function,
bronking
- Re: if function,
bronking
- Re: if function,
daddylonglegs
- Re: if function,
daddylonglegs
- if function,
structuresc
Re: If Function,
vezerid
Re: If Function,
Ragdyer
Re: uploaded sample of worksheet,
RagDyeR
Re: In Excel, how can I stop the drag function to copy and not add?,
Gord Dibben
freezing frames,
Bob Griendling
Re: Is there any way around the maximum of seven nested functions?,
RagDyeR
Re: wrapping text,
Gord Dibben
Re: Excel finance function,
joeu2004
How to create a fill down that increments based on the workbook name,
mdms515
value convert,
xman123
Re: "clean up" after running a program in Excel,
Jim Cone
Re: Can I print mail out labels or envelopes using data in excell,
Trevor Shuttleworth
Re: how do i enter a value to cells containing text?,
Franz Verga
Re: CONDITIONAL / NESTED COUNTIF,
Franz Verga
Re: Conditional Statement with Multiple Arguments,
swflorida77
Re: Equalls fuctions,
Franz Verga
Lookup Question,
jam
Re: Sheet layout,
Franz Verga
Conitional copying of a serie of rows from one spreadsheet to another,
david
Using a cell reference within a cell reference in a formula,
david
Re: Copy and SUM functions with different ranges,
Franz Verga
result of selecting from the dropdown list should be a dropdown list,
No News
Changing Opening folder,
Blair
Re: selecting a single sheet from a volume of sheets in a workbook,
No News
RE: 3 questions: drop downs and comments,
paul
Save Botton,
tr2usa
Copied Cells do not run Series consecutively...,
Gucci
Re: What if I want the answer to be in Dollars or Percentage.,
Fred Smith
Re: Preventing a function being called if argument is unchanged,
Ken Johnson
Choose data from a selected range and put result in new column,
Betsy
Re: DCOUNT for non-contiguous columns,
Domenic
Re: concatenate cells by a given range,
Herbert Seidenberg
Re: insert date,
CLR
Re: Extract area,
Debra Dalgleish
Re: Return single value on multipl criteria lookup,
Bernard Liengme
Re: Need a function that calculates time between 2 dates,
Bob Phillips
Re: calculating speeds in mph,
Bob Phillips
RE: IF statement help,
TammyS
How to add time to a cell formatted as yyyymmddhhmmss,
JD
Re: Dates,
Roger Govier
Re: Finding max value within a subgroup,
Roger Govier
Re: Select a range of non-adjacent cells in Excel?,
hodgsonk
RE: Is this possible,
Toppers
Re: create if formulas,
Bob Phillips
RE: Extract text from String,
Toppers
RE: index match offset?,
LanceB
