microsoft.public.excel.worksheet.functions
- Re: AutoComplete - Forms Combobox,
Norman Jones
- Re: Converting Excel worksheet to JPEG, PDF or TIFF pressing a cell/bu,
wjohnson
- Re: how to add a row between rows of data,
wjohnson
- Re: Counting Entries in two lists,
wjohnson
- Re: I Have two files that i need to compare?,
wjohnson
- Re: Finding total via entered text,
Biff
- Re: Can i add up all green filled cells in a workbook?,
Rowan Drummond
- How to group multiple items in to three groups.,
ramana
- can't edit a cell with a formula,
hell no
- need help guys,
psyherin
- Add amount if record contains a value,
Bexi
- Re: subtotals in a pivot table,
Debra Dalgleish
- Re: how to split data from 1 row into two rows continuously,
Roger Govier
- Re: return multiple corresponding values using INDEX,
Biff
- Re: unable to view color fill changes unless I print preview,
Rowan Drummond
- Re: Correct coding entry of VBA macros in Excel worksheet,
Bob Phillips
- Minif / Maxif ?,
Thrain
- Compound interest,
Robert Tracey
- Re: Tables tab under the Insert tab,
Gord Dibben
- Re: Calculation in left corner,
Gord Dibben
- Re: Linear interpolation between two points found using a lookup funct,
Bernard Liengme
- Function Help Needed,
Harvey Gersin
- Re: Countif? or Vlookup? Lost??,
John Michl
- Re: How do I extract hyperlink as text from an array of hyperlinks?,
Dave Peterson
- Countif and date check for second criteria,
Megazell
- Re: look up function and sum values,
L. Howard Kittle
- This should be easy...,
Jerry
- Re: How do I format Excel to add new rows automatically?,
Gord Dibben
- Re: IF function with value_if_true and value_if_false as equations,
Vito
- Re: how to use sumbycolor fuction?,
Gord Dibben
- Re: retrieve unique items with 2 criteria,
Vito
- Re: Forecasting using arrays,
Ron Rosenfeld
- importing csv files and dates,
jiwolf
- Re: Formula Instead Of A Pivot Table,
Vito
- Message not available
Re: If Funtion,
Biff
Where's it gone?,
Dave Moore
Array Formula Problem,
rmolitor
Re: Is it possible to create a workbook within a workbook?,
MrShorty
Re: on a calander how do i enter more than one event in one square,
Vito
Re: Count Number of Times Something appears,
John Michl
Re: COUNTIF function when 2 conditions exist?,
Peo Sjoblom
extract decimal place digit,
craig_100
Re: How to stop file open macro prompt after deleting all macros?,
Paul B
Re: How do I convert numbers to text like bahttext but in sterling,
Bob Phillips
Re: COUNT with Multiple Criteria Error,
Bob Phillips
Array Reference,
anar_baku
Re: Print all from list,
Arvi Laanemets
Re: How do I make the D.O.B. Column calculate in Age Colum in Excel?,
Peo Sjoblom
Re: Compare 2 columns - new worksheets,
vezerid
Re: #NUM! in Date field calculation,
vezerid
VLOOKUP?,
k . roberts
Re: HOW TO RETRIVE LAST NAME USING EXCEL, IT SHOULD BE GENERIC,
vezerid
Minimum but One??,
twogoodtwo
Re: countif functions,
JE McGimpsey
Re: number convert to text,
Bob Phillips
Re: selecting one from multiple occurrences,
Bob Phillips
Re: test if column isblank,
Bob Phillips
Re: Text Strings Swap,
Bob Phillips
Is This Possible?,
Eamon Byrne
Re: Force format change in excel,
Max
Re: Validations: provide the ability to format the fonts in the list,
Max
How to Breakup text in to two parts ina cell,
ramana
Re: in excel conditional formatting find the greatest value in 4rows,
Biff
Re: minimum from various columns without zeroes,
Peo Sjoblom
Re: turn off auto subtotal,
Debra Dalgleish
Locking Sheets / Hiding Sheets,
Lee Harris
Re: how do I find prime factors of a number,
DOR
Re: Delete text in cells but keep formula,
David McRitchie
Re: Weird problem,
Norman Jones
Re: True or False,
Bruno Campanini
Best way to tackle this problem...,
Lee Harris
Re: How do I perform multiple regression in Excel using two independe,
Mike Middleton
Re: Can anyone help me Create Excel list of files in windows folders,
Chip Pearson
Re: I get error messages in Excel cells once I save a file,
Gord Dibben
Re: I can't delete a whole sheet in Excel. Option is grayed out.,
Gord Dibben
Re: How do I change the date format when importing a txt file?,
Peo Sjoblom
Is there a "rank" like feature for alpha?,
jshrader
Re: COUNT or SUM with multiple criteria,
Biff
Calculating averages excluding outliers...a question,
stew1901
Calculating basic averages...a question,
stew1901
Summing if several conditions apply,
bexi_reyes@xxxxxxxxx
Re: How do you do a VLookup with two conditions?,
Dave Peterson
<Possible follow-ups>
Re: How do you do a VLookup with two conditions?,
Roger Govier
Hiding Columns,
lehigh46
Simple password generator,
ckroon
Filter problem,
glen . e . mettler
Re: Problem with lists,
Gord Dibben
Re: Protest sheet but allow sort,
Dave Peterson
Re: GESTEP,
Gord Dibben
Re: Modifying A Sumproduct Formula,
Bob Phillips
Re: Stop Loss Formulas for Stock Trading,
David McRitchie
Re: Data falls in a range +/-1,
vezerid
Vlookup max value only,
n_gineer
Count Intervals of 2 Consecutive Values in same Row and Return Count across Row,
Sam via OfficeKB.com
Re: using lookup to return more than one answer in date format,
Bob Phillips
Ignoring zero cells in IF statements,
~Andy~
Dispalcement, Vlookup problems.,
Paul987
Re: selecting every eg 5th cell in a worksheet,
Don Guillett
Re: How do I pull a random sample of people from a list in excel?,
JE McGimpsey
sum number of cells based on letter/title criteria,
chazmac
Formula - Count multi filter ???,
ecohen1
Event Macro adjustment needed - need to change font color also,
nick s
Re: How do I include only visible cells in a range?,
JE McGimpsey
Re: the answer to appear in more than one cell,
JE McGimpsey
Sort by Location,
ecohen1
Help with using range names in sum function,
soteman2005
Re: in formulas how can I use contents of a cell?,
Bob Phillips
COUNTIF or SUMIF or ??,
croakingtoad
Re: i forget my Microsoft Excel files password tell me the solution,
JE McGimpsey
MCONCAT,
lehigh46
Excel Function,
weller
Re: How do I change data spacing in a column,
JE McGimpsey
Need help again :D,
Smeeg
Re: SUMIF INDIRECT,
Bob Phillips
- <Possible follow-ups>
- Re: SUMIF INDIRECT,
Andy
- Message not available
- Message not available
Re: excel function help,
Bob Phillips
Found a SERIOUS bug in Excel !!!,
irresistible007
Getting info from Internet,
Bob Bedford
Re: Unwanted Repeats,
Max
Re: countdown dates by month,
Arvi Laanemets
Re: Custom Format alphanumberic value with spaces,
JE McGimpsey
Re: It seems to me that I need an event Macro,,
David McRitchie
Re: What formula captures specified rows of data?,
DOR
adding a ' ie 'xxxx instead of xxxx,
cclambie
Re: Class not registered dialog when trying to load Excel add-ins.,
Chip Pearson
How to copy data in one cell into different rows,
catchxan
Variable Criteria?,
chris2bc
Re: Adding Worksheet To Formula,
rsenn
Re: Labor Rate %,
Bob Phillips
Formula ABSOLUTE with INDIRECT - Is Fill Down Possible?,
Sam via OfficeKB.com
Re: "the formula in this cell differs from the formula in this area o.,
Niek Otten
Re: Formula encompassing conditional formating,
Bob Phillips
Re: I saved it by mistake!!!!,
Paul B
Re: how to remove gridlines from part of a worksheet only,
mevetts
Data validation issue,
mevetts
A difficult conditonal calculation,
0-0 Wai Wai ^-^
Re: Average of top 3 numbers.,
Don Guillett
Message not available
Password hyperlink or macro?,
Jonah
Increment column by column from data row by row,
Jonah
Re: CAN YOU PUT MULTIPLE % BRAKE DOWNS IN 1 CELL,
Gord Dibben
Re: I need a formmula to gives a % split for dif. $ amounts,
Bob Phillips
RE: Pulling a Letter from a cell and filling another cell with inf,
nick s
Re: formatting won't apply to my cell with a formula,
Niek Otten
Re: Pulling a Letter from a cell and filling another cell with info,
Domenic
<Possible follow-ups>
Re: Pulling a Letter from a cell and filling another cell with info,
blackburnjl@xxxxxxxxx
RE: Pulling a Letter from a cell and filling another cell with info,
Ron Coderre
Re: Pulling a Letter from a cell and filling another cell with info,
Ron Rosenfeld
Re: Formula Convert Digits to Words (1000 write One thousand),
Bob Phillips
need help on a formula for this problem,
whassup
Need Formula to find worksheet,
TJF
Re: How do I change default number settings?,
Paul B
Re: x and x+1,
Peo Sjoblom
Re: Sumif function with multiple criteria,
Bernard Liengme
- Message not available
- Message not available
results of "SUMIF" test criteria,
windsurferLA
Common Numbers Formula,
bradrob
Re: Using data from coloured cells in a chart,
Gord Dibben
meaning of this function,
afdmello
formatting,
afdmello
calculating commissions for a range of values,
abryan
commissions by range,
abryan
Re: Excel should have a formula for amortization.,
Barb Reinhardt
excel %,
joemoran7
Re: date that updates itself daily, plus another formula please??,
Don Guillett
One worksheet to calulate different items simultaneously,
John
Re: How many rows have I selected ?,
Norman Jones
- Message not available
- Message not available
Automatic calculation as sefault,
Pop
How can I update all workbooks in one go,
shrek
Re: how many rows did I selected,
Norman Jones
Re: from disc to cd why does it always become read only,
goober
Re: How to create a drop down menu for objects,
Max
Date Last Modified Function,
Leon
Re: limited lines in check register,
Biff
Re: Consolidate multiple workbooks,
Randall Senn via OfficeKB.com
Re: how do i combine IF and OR function,
Dave Peterson
See if this works,
Ron Coderre
="Printed " & today(),
ForSale
Problems with HYPERLINK in Excel 2002 and 2003,
Thomas Refsdal
Re: Excel 2002; copy formulas to one workbook to another diff data,
Gord Dibben
Re: Editing a simple macro,
Gord Dibben
Re: Finding a value associated with a range,
Niek Otten
Re: I need to "cross-foot" from worksheet to another,
Randall Senn via OfficeKB.com
excel.worksheetfunctions,
Max
Re: Spreadsheets are cut off when you paste and link?,
rsenn
charting your data automatically,
amrezzat
Re: Counting Data in a Column,
Bob Phillips
Please help me with a formula,
Smeeg
Re: Please help me with a formula,
Smeeg
help needed in VLOOKUP function,
DaredEvil590
Month to date sales - reset in new month???,
citybeing
Re: create a goto button in excel,
SteveG
Re: Formula needed,
Bernard Liengme
Criteria to use to dump it excel,
Krish
Need Help with complex formula,
TJF
Re: unprotect sheets,
Paul B
Re: Excel cell show sum upto 500 Exceede delet without if else conditi,
Andy
Re: Counting the number of values in a list between two specified valu,
Bob Phillips
Re: #DIV/0! in the array function,
Bob Phillips
Re: Colouring a row depending on data entered in a column,
Bob Phillips
Re: convert numercials into words,
Paul B
Re: How do I convert a text string into a date?,
Carlos Antenna
can I reference a cell as someting like: cell(1, 1) ?,
dukof
Re: Indirect Formula,
Bob Phillips
Offset delivers value error with Named range,
steve@xxxxxxxxxx
help needed in IF function,
DaredEvil590
calculate ranges,
Bob Bedford
Validation List,
Dilip Mistry
Problems with setting up a billing budjet,
JoeStL
Re: linked worksheet formulas,
Max
how to change absolute path to relative path,
hwijgerse
Re: Nested Formula,
Biff
Re: complex amortization,
Fred Smith
Re: Find last non-blank row with a worksheet function,
Biff
best formula to use,
raw
Re: Error in "IF" formula,
Bob Phillips
Why is my printer printing white fonts as black?,
Howie
Re: how to create the formula "cumsum" in excel,
Ken Wright
Re: How to summarize the first 4 numbers greater than 0 from a list.,
Peo Sjoblom
How easy is it to loop in VBA based on cell contents?,
Lee Harris
Count cell,
ecohen1
Move merged cells with conditional formatting?,
SpikeUK
Re: Time code cell format,
Bob Phillips
Re: Matrix Dimension,
Peo Sjoblom
Re: Calculating percentages in pivot tables on subtotals,
cs02000
Re: Excel - need a function to compare lists,
Niek Otten
Re: how can I fix a missing formula bar in Excel?,
JulianActon
Click button to automatically add row,
yirawan
Is this possible please someone help me ??,
spuds
VLOOKUP Problem,
uplink600
Re: Help!,
JulianActon
- <Possible follow-ups>
- RE: Help!,
BradleyLawrence
Find max date,
philcud
Re: I would like the worksheet auto name itself with a formula,
Barb Reinhardt
aLPHAnUMERIC validation,
pjaganathan
Re: Selecting a range of values for another function,
Bob Phillips
Re: CONDITIONAL FORMAT,
Bob Phillips
<Possible follow-ups>
Re: CONDITIONAL FORMAT,
Richard Buttrey
Re: CONDITIONAL FORMAT,
SteveG
Re: SumProduct Solution?,
Bob Phillips
Re: How do I do an amortization schedule knowing the princ, int rate,.,
Bruno Campanini
Help with SUMPRODUCT,
Robo
Part of text as criteria,
irresistible007
Re: How to tackle Division by zero for DAVERAGE function,
Biff
how to fetch a row and post the row into another sheelt,
ananthmca2004
Active cell counting in particular print page (one sheet having different print area),
ananthmca2004
returning a cell's value and a corresponding value,
Force Flow
Re: Rounding,
Biff
Re: formula looking up multiple information.,
Biff
Re: GETPIVOTDATA question regarding adding "rows",
Debra Dalgleish
Re: Two dimensional lookup,
Rowan Drummond
Re: How to find square roots on paper,
DOR
Re: Have 2 items in dropdown, want warning if one selected,
L. Howard Kittle
Re: Formula/Array question with dates,
DOR
match values in two different columns,
thomasNg
Variable Links to tabsheets,
Alberto Pinto
Re: Zero replaces blank field when paste special is used,
Jerry W. Lewis
Re: Printing Certain Columns,
Dave Peterson
Re: Vlookup multiple worksheets,
Dave Peterson
Re: if statements,
Bob Phillips
DROP DOWN LISTS,
eternal_cat via OfficeKB.com
Match Last Occurrence of Numeric Value and Count BACK to Previous,
Sam via OfficeKB.com
Re: Mileage Calculation,
Biff
Re: How do I point to another cell,
Biff
Re: In Excel: select the last 20 rows of data in a column,
Bob Phillips
Re: I need to Sum the value D2:G1000,
Bob Phillips
Auto fill multiple cells depending on single cell value,
henrat
Re: Can criteria in countif statement be a color?,
Bob Phillips
Re: Autofilter Locks???,
SkyDiver
Re: Time and Business Hours,
Biff
Re: What excel function to use?,
Bob Phillips
Re: Ignoring Time in a Date Time Calculation,
Nick Hodge
Re: count and lookup,
Bob Phillips
Re: How to add a column of accumulated data in pivottable?,
cs02000
Multiple Validations in for 1 cell,
dmcnutt_ghg
Nested --- Subtotal IF function,
Lisa Beach
Re: How do I set up a conditional cell from a drop down list in Excel,
SteveG
How to return the text data of the first col after getting the max value from the 2nd col,
Joyce
Re: Nested IF with OR Function,
Roger Govier
Calculate Hours and overtime by week,
gregt812
Re: Filter one column for all "Pending",
Dave Peterson
Re: Calculated fields-Pivot tables,
cs02000
Last Number to Average,
yirawan
PMT function,
joemoran7
Indexing/Matching True/False results,
drvortex
Re: Vlookup in large named range,
Niek Otten
Re: Return of blank cell if lookup fails,
Richard Buttrey
Re: Regular Time and Over Time,
Bob Phillips
Re: Overtime Hours,
Marhanen
Re: color fill cells based on IF function or formula,
Peo Sjoblom
RE: Empty Lines,
Ashish Mathur
Re: Dates - Months & Years,
Bob Phillips
Re: Hour and minute,
Peo Sjoblom
Re: Excel - how about allowing colored worksheet tabs for organizing,
JE McGimpsey
populating empty cell with value from above,
shepshedlad
Number Formatting Question,
Lee Harris
Re: SUM Days (to 30), Months (to 12) and Years,
Roger Govier
Re: Too few arguments,
Tushar Mehta
Excel formula,
k . roberts
Re: How do I count in a range of dates?,
Bob Phillips
Problem with TRUNC,
Steven_Archer
Re: importing data,
Richard Buttrey
Re: Referencing a different Workbook,
Max
Re: How to create a prefix containing text and zero?,
Roger Govier
<Possible follow-ups>
Re: How to create a prefix containing text and zero?,
rsenn
vb code - Automatic transfer of data from one sheet to another,
herr_bench
Re: Creating a Summary Worksheet,
Max
Re: how many if statements can i use in a single cell ?,
Biff
Re: -ve no with -1; positive with sign+ and 0 no sign? Tks.,
Rowan Drummond
Re: How to save the current worksheet as JPEG, TIFF or DICOM?,
hyiqiang
Re: Delete Cell Function,
Max
Is it possable?,
michaelp
indirect?,
cjjoo
Re: How to create a menue bar of numbers in a cell?,
Rowan Drummond
Re: Calculating slope, intercept, LOGEST with empty cells in data,
Jerry W. Lewis
Re: Column labels,
Biff
Re: Pivot Table Subtotals - Difference,
Lotus123
Re: Refering cells between worksheets,
Lotus123
Re: format cells,
Lotus123
Re: Finding the Max of a related Value Lookup,
Max
RE: Remove html markup,
Ron Coderre
<Possible follow-ups>
RE: Remove html markup,
Ron Coderre
Re: Remove html markup,
Dave Peterson
Re: Remove html markup,
KC
Re: Concatentate Join Identifier,
DOR
Re: Tab Key,
Gord Dibben
Do I Need to Use an IF Statement?,
jgp_2
Calculate duration in Excel 2000,
Babette
Re: deleting macros that are not really in my workbook?,
Gord Dibben
Re: How do I select form a drop down box by typing the first part?,
Gord Dibben
Re: How do I create numbers for a Chinese Auction?,
Richard Buttrey
Re: Formula questions,
Roger Govier
Re: Now(),
Nick Hodge
Re: What is the "--" used for - or how do I ask excel for help,
Ken Wright
Getting #N/A from Vlookup when matching value exist in the lookup data range.,
jdeshpa
VB Protection problem,
Rmagic
Re: Dealing with numbers that begin with a 0,
Niek Otten
Re: Average,
SteveG
Re: Interrupting A Worksheet Calculation,
MrShorty
counting the number of times something is bought during a month,
ldd
Re: Finding values based on color,
Niek Otten
Re: programming date functions,
JE McGimpsey
Displaying seconds in hh:mm:ss format,
PCLIVE
Re: entering date functions,
Roger Govier
Re: EXTRACT NUMBERS FROM TEXT STRING,
Roger Govier
Re: How do I compare the difference in two spreadsheets?,
Richard Buttrey
getting the last cell value in a column,
amrezzat
Re: Is there an "auto tab" option in excel?,
Richard Buttrey
Re: Using a Pivot Table Calculated Field to get a Unique Count,
cs02000
Re: VLOOKUP used only when IF condition is met,
Roger Govier
Display text depending on values of 3 different cells?,
henrat
Re: Possible? If total in a worksheet > 0, highlight worksheet tab?,
MrShorty
Re: Find a negative number in a range,
Roger Govier
Re: formulahelp,
Don Guillett
Re: remove all ",",
John Michl
Re: how can I calculate VAT for selective data in the same column of a,
Bruno Campanini
Re: Rolling 3 mth Average,
Roger Govier
Re: Formula Problem - interrupted by #VALUE! in other cells!?,
Roger Govier
- Message not available
- Re: Formula Problem - interrupted by #VALUE! in other cells!?,
Roger Govier
- Re: Formula Problem - interrupted by #VALUE! in other cells!?,
Ted
- Re: Formula Problem - interrupted by #VALUE! in other cells!?,
Roger Govier
- Re: Formula Problem - interrupted by #VALUE! in other cells!?,
Ted
- Re: Formula Problem - interrupted by #VALUE! in other cells!?,
Roger Govier
- Re: Formula Problem - interrupted by #VALUE! in other cells!?,
Ted
- Re: Formula Problem - interrupted by #VALUE! in other cells!?,
Roger Govier
- Re: Formula Problem - interrupted by #VALUE! in other cells!?,
Ted
- Re: Formula Problem - interrupted by #VALUE! in other cells!?,
Ted
- Re: Formula Problem - interrupted by #VALUE! in other cells!?,
Roger Govier
- Re: Formula Problem - interrupted by #VALUE! in other cells!?,
Ted
- Re: Formula Problem - interrupted by #VALUE! in other cells!?,
Ted
Re: Searching for multiple results in one cell,
Domenic
Difficult Excel Problem,
SpikeUK
Re: #N/A is not text, cannot use it in functions,
Bob Phillips
IF statement,
joemoran7
Copying a total from another Sheet,
bcemail
Re: How do I filter out duplicate values in Excel 2000?,
Peo Sjoblom
OT? Microsoft Works Database Import?,
Lee Harris
Re: Can somebody help me with this formula,
Bob Phillips
Re: get a total based on criteria in two columns,
SteveG
F5 function for zeroes?,
Lee Harris
Re: Formula for growth chart?,
Max
Re: formula ignores last infor - please help,
Max
Lookup type formula,
Lee Harris
drawing rect function graph in excel,
sulphox
Re: ROUND CENTS TO EITHER 49 OR 99 AMOUNTS,
Biff
Re: This should be easy,
Biff
shift right 5 columns,
raymond chiu
Re: Breaking up a string into separate columns,
Ron Rosenfeld
Re: how to use "IF" to do nothing if a cell is blank,
Rowan Drummond
Re: OPPOSITE FORMULA,
Max
Index Match function for multiple linked variables,
Bob
- Re: Index Match function for multiple linked variables,
Biff
- Re: Index Match function for multiple linked variables,
Bob
- Re: Index Match function for multiple linked variables,
Roger Govier
- Re: Index Match function for multiple linked variables,
Bob
- Re: Index Match function for multiple linked variables,
Roger Govier
- Re: Index Match function for multiple linked variables,
Bob
- Re: Index Match function for multiple linked variables,
DOR
- Re: Index Match function for multiple linked variables,
Bob
- Re: Index Match function for multiple linked variables,
DOR
- Re: Index Match function for multiple linked variables,
Bob
- Re: Index Match function for multiple linked variables,
Bob
- Re: Index Match function for multiple linked variables,
DOR
- Re: Index Match function for multiple linked variables,
Bob
- <Possible follow-ups>
- Index Match function for multiple linked variables,
Bob
Re: sumProduct (gimme a 1 if this is true, gimme the value) what is th,
Max
- Message not available
- Message not available
Excel formula help needed,
SteveFox
Re: Cross-referenced drop-down menu (nested drop-downs?),
Rowan Drummond
Re: Functions,
Tim C
Clearing #N/A's in one go?,
Lee Harris
Re: copying and pasting a formula,
Gord Dibben
Re: Vertical Lookup problem,
CLR
Lookup same word "value" across multiple cells,
chazmac
help me on rearrange cells based on its numerical values without repeating any number,
amrezzat
Re: vlookup using two lookup values?,
Bob Phillips
Re: Data Validation,
Dave R.
Re: HOW DO I CONVERT NORMAL TEXT INTO ALL CAPS?,
Dave R.
Make stair columns,
Chunrima
Re: Trim Function,
Lotus123
Re: how can I count blank cells as a zero, when using formula please??,
Roger Govier
Global Print Specs,
Steve Williams
Re: Calculations from date and time values,
Ron Rosenfeld
Re: Print titles: can noncontiguous columns at left be printed & how?,
Gord Dibben
Re: How can I get excel to ignore formula in dependant cells...,
SteveG
Re: Count If Array Formula,
Peo Sjoblom
is there a standard formula for this?,
keith
Help Please: SUMIF function,
baz
Re: Help with #VALUE! error please...,
Ron Rosenfeld
Re: Should I use STDEVP,
JE McGimpsey
Re: Working with dates,
Ron Rosenfeld
Re: Very weird error,
Ron Rosenfeld
Using a 'Select' (Data Validation) List?,
dezdan
Re: Dynamic Data Range,
Bob Phillips
Re: lookup to return larger value,
Harlan Grove
Re: Formula Problems,
Bruno Campanini
Re: Date & time short cut,
Bob Phillips
Re: Logarithmic curve formulas in charts and LOGEST fx values?,
Niek Otten
count and arrange cell numeric values,
amrezzat
Re: Combining Text on statement,
Bob Phillips
Re: help with vlookup function,
DOR
Nested IF problem - help please,
Dasin
Re: Date format default problem,
Ron Rosenfeld
Re: Change Excel default Workbook Template?,
Dave Peterson
Re: MATCHING DATA IN COLUMNS,
Max
XIRR with non contigous cells,
topola
Re: Can you recalculate an individual excel cell in isolation?,
Jerry W. Lewis
Function has worked for 5 years is now in error,
umloew43
Re: vlookup on a cell with a formula,
Bob Phillips
Cells with dates...,
Evgenia
Excel Boffins help please ! ! !,
ELBeanzio
Count cells with dates,
Evgenia
Re: circular reference (Excel 2000),
Ian
Re: Jumping colums in Excel 2000,
Ed Ferrero
- Message not available
- Message not available
Re: I don't Understand,
Desert Piranha
'problem starting the Office Assistant',
Eric
Re: worksheet formula problems,
Biff
Calculating Time elapsed,
bhomer
Re: help with formula,
Mike G
Message not available
<Possible follow-ups>
Re: Help with formula,
Ben
Re: Help With Formula,
JE McGimpsey
Re: Help With Formula,
Dave Peterson
Re: what means 'blank cell'??,
Ron Rosenfeld
Struggling for a solution,
Baz
Re: How to automatically update the date any time the Excel is openned,
Dave Peterson
Re: How to retrieve orignial file excel that is renamed,
Peo Sjoblom
Re: formula to calculate age using birth date and current date,
Peo Sjoblom
Re: how do i sum dollars & cents in different columns,
Bob Phillips
Re: How would I display the word "Paid" if the value of another cell=,
Bob Phillips
Re: Showing #VALUE!,
Bruno Campanini
Re: Fill color not showing up on cell tables,
Gord Dibben
Frustrated Cook,
Wazza McG
Entering numbers to get the time,
biegs
the sum of all bolded numbers,
Sam12345
Re: How to nest functions with SUMIF function in excel,
Peo Sjoblom
Combo boxs,
DenisN
change font color of cell based on critera,
amrezzat
Re: Top Five selections based on sum of items meeting criteria,
Ken Wright
Checking for dublication of text,
Hormes
Re: where is the accent key on the keyboard?,
R.VENKATARAMAN
Agreed.,
Anne Troy
Re: Ok, here is the Correct equation I am having trouble with. (from T,
Biff
Re: Problems adding formula together. Please Help!,
Adam Kroger
Re: How can I replace zeros with blank spaces during calculations plea,
Biff
Re: increase conditional formating options,
Biff
<Possible follow-ups>
Re: increase conditional formating options,
Alan
Re: find cells that contain specific characters,
Biff
Re: how do I get this,
Dave Peterson
Re: Dispalying negative times,
goober
Re: vlookup and calculation questions,
David McRitchie
Re: Delete rows by content,
RB-MC
Need assistance linking workbooks by date,
bsmith
Calculating frequency?,
Ken
Re: Excel OR function,
Bob Phillips
Re: Don't understand PMT(d412,e4,-c4) what is it asking me or means?,
Don Guillett
Re: How Do You Hide a #DIVO! Return in a cell,
Dave Peterson
Re: lock tab in sheet 2 until cell in sheet one is completed,
Gord Dibben
Re: how do i do an accounting spreadsheet,
bernard liengme
calculating fees from hours and minutes,
tinytots
Re: count a number that is less than a number and greater than a numbe,
bernard liengme
RE: Drop Down Menus - 2nd Problem,
Ron Coderre
Re: IF SUM,
bernard liengme
Re: Show top five records based on meeting multiple criteria,
Dnereb
Follow up to "Recalculate" problem,
Lee Harris
Re: Drop Down Lists - assign a value based on selection,
Paul B
Re: double records,
Niek Otten
Re: working,
Jerry W. Lewis
Finding values,
Chris Lane
Re: Regression - Standard Error X Variable 1,
Mike Middleton
Re: Linking Data,
goober
Re: How to add all positive and negative numbers?,
Peo Sjoblom
Re: Help with a f(x) formula,
Ron Rosenfeld
SUMIF with two conditions?,
Lee Harris
Re: delete series of letter in spreadsheet,
Gord Dibben
Linking Webpage to Excel Data,
Taier
Re: how do I lookup data based on two columns of data,
Bob Phillips
Re: Creating a dynamic list,
sirknightly
Re: Adding hrs,
Bob Phillips
Re: Summing Arrays,
Bob Phillips
Re: I get 0:00 when I format cells 4 time no matter what # I enter,
Niek Otten
- Message not available
- Message not available
Re: Why can't I write in a document that is not read only?,
dominicb
Re: I want to be able to count the number of checked boxes in a form?,
Bob Phillips
Re: Counting based on values in two columns?,
Barb Reinhardt
Re: Match and sort,
Lotus123
Re: total a range of cells in Excel into a different worksheet,
Barb Reinhardt
Re: How do I create a function to search a range for a number and...,
Chip Pearson
Re: It is some functions who insert rows?,
Chip Pearson
Re: How do I save my 'sort criteria' in an Excel file?,
Lotus123
Re: Effective interest paid - need formula/function,
Lotus123
Re: IRR Logic,
Lotus123
Re: Updating the Sum of a cell,
Lotus123
Re: vlookup,
Lotus123
Vlookup,
theukego
Re: barcode scan changes last 2 digits in excel 2003,
Peo Sjoblom
Re: How do I convert text to time,
Niek Otten
Insert-Subtotals makes Column Outlines disappear,
gpie
Re: How to show sheet tabs in Microsoft Excel,
Dave Peterson
Re: Auto-copy the last entry in a column to a new cell,
Biff
Re: formula to insert picture,
David McRitchie
Re: Macro to delete rows with same data,
Connie Martin
<Possible follow-ups>
Re: Macro to delete rows with same data,
Gord Dibben
Re: Multiple Vlookups,
Ken Wright
Help please,
Nospam
Re: Purge or transfer old data automatically?,
Anne Troy
Re: nested if functions in Excel 2002,
Anne Troy
Re: counting number of times value is greater than previous week,
vezerid
Re: Summarizing worksheets,
Yvonne
Re: Extract last and next-to-last entries in a range,
Domenic
Calculation within Text,
GeorgeF
$ definition,
nicolebelle
Re: networkdays,
Ron Rosenfeld
Re: count on condition / Formula,
Bob Phillips
another sumproduct question,
cjjoo
Re: Look Up Values Within a Range,
Max
Re: Need help with Excel formulas,
Anne Troy
Re: lottery drawing,
Biff
Re: Allow more than 7 nested IF THEN tests in EXCEL. Allow 30 or more,
Harlan Grove
Re: display words in a formula result in Excel,
Peo Sjoblom
Re: Drop Down List,
Debra Dalgleish
Identifying #N/A cells,
Lee Harris
Dropdown list with named cells,
WaterDog
Re: drop down list in Excel,
Peo Sjoblom
Re: How do you write an excel formula to sum data in every second cell,
Dana DeLouis
tagging / tracing / referencing duplicate values,
jonpdavies
Re: countif and concatenate,
Max
Re: Using worksheet functions in macros in Excel2000,
Bob Phillips
getting active cell value in another cell,
amrezzat
IF statements with more than 7 variables,
Liv4fun
Re: How to convert minutes to fractional hours,
Sandy
Re: ??SUMPRODUCT? other solution?,
Bob Phillips
Re: drop down option in a cell,
Gord Dibben
Re: LOGICAL FUNCTIONS WITH MULTIPLE VARIABLES,
Biff
Re: What is the formula to average alpha?,
Bernard Liengme
Re: drop down box in cell,
Sandy
Re: Cascade Validation,
Biff
Re: Is there a way to automatically change the location of a formula?,
Bernard Liengme
Re: In excel, how can i delete 1 digit and the decimal point?,
Biff
Re: Delete first two digits in column,
Ron Rosenfeld
Mode between two serial dates/times,
ChrisM
Re: Reference Cell Content,
Harlan Grove
Re: Count if a number is between X and Y,
Jezebel
colour due to conditional formatting & hyperlink/shortcut to a directory,
Peter STEVENS
Lookup values in one column to return another,
doug . neidermeyer
Re: Can I do this?,
Bob Phillips
Re: Automatic Date Update,
Gord Dibben
Re: Count According to Date,
Bob Phillips
Re: Count nonblank cells with multiple criteria,
Bob Phillips
Re: Are different column widths possible on the same worksheet?,
Bob Phillips
Re: Formula for inserting blank row,
Gord Dibben
Re: Combine 2 formulasinto 1.,
Biff
SUMIF 2 conditions are met???,
Granger
Re: multiple Lookup,
Bernard Liengme
Validation Help,
nicolebelle
Re: Converting numbers to text,
Gord Dibben
Re: separate name and address,
Bob Phillips
Re: function to insert a picture,
Peo Sjoblom
Re: IF formula,
goober
- Message not available
- <Possible follow-ups>
- Re: IF formula,
Bob Phillips
Re: How do I copy comments into cells,
Dave Peterson
Re: How can you add an "&" in a footer?,
Dave Peterson
Re: Count Function,
Anne Troy
Re: How do I convert hours and mins into just minutes in excel?,
Nise
Date from text to Date format,
Nise
search for text within text,
BigDave
Checking a number of sheets,
sphenisc
Re: Formula that sums the values if you have 2 criteria and 2 differe.,
Anne Troy
Re: help on lookup functions,
Ian
Problem with random inputs,
jtreme
Re: How do I highlight duplicate data on a spreadsheet?,
Don Guillett
Re: how can i ignore blank cells when multiple cells?,
Robert_Steel
Re: eliminate partial content from the cell,
Anne Troy
Re: How can I automate something to be added to a formula in excel?,
Anne Troy
Re: Dates in Excel,
Ron Rosenfeld
Re: Use Index to get range,
Bob Phillips
Re: hyperlink changes when doc emailed,
David McRitchie
Re: Vlookup and forecast,
David McRitchie
Re: text modification,
David McRitchie
Seperation of prime and sub inventory units,
Novice
Re: Help summarizing data needed,
David McRitchie
Re: how do you link rows of cells to other work pages?,
David McRitchie
Re: how do I make rows and columns appear when I print a spreadsheet,
Roger Govier
averging prices real problem,
amrezzat
Re: Problem with Slow ReCalculation of Dynamic Range Using OFFSET,
Niek Otten
challenging "share stock" average prices,
amrezzat
Re: calender drop down in an exel sheet,
Ron de Bruin
Re: LIST function,
Roger Govier
Re: calculations in excel,
Roger Govier
Re: formula,
Bob Phillips
liked workbook,
damorrison
trying index match,
damorrison
Re: "IF"- "THEN" type Formula based on Null value,
Max
Excel Cell Criteria Effect,
raymond chiu
Logical formula problem,
irresistible007
Database,
paulrm906
Re: How can I globally set "error message" parameters in Excel,
Jezebel
Re: how do i list the name off all my worksheets on a sheet,
Biff
Re: Does anyone know how to turn off the GetPivotData function?,
Debra Dalgleish
Date format issue,
LadyDoe
RE: data sorting,
Suresh
Re: Using Excel in different countries,
Skin
Re: How do I bring totals from one worksheet onto the second worksheet,
Biff
Re: TEN OLDEST DATES,
Biff
Re: TEN OLDEST DATES,
Max
Re: TEN OLDEST DATES,
Max
Re: IF NOT FOUND,
Max
problem with FIND,
cjsmith22
Re: Function determine if date is even or odd,
Dave Peterson
Re: program to open excel sheets without excel,
Gord Dibben
Re: How to correctly write a cross-sheet "IF" formula in Excel,
damorrison
Re: Is there a logical test for a cell's format instead of contents,
Rowan Drummond
Re: I would like to print the titles of files inside a folder.,
Gord Dibben
Re: how to diferentiate integers with decimals in the IF formulas,
joeu2004
How do I find....,
Smitch
Re: Search for record with specific name in a cell,
Domenic
lookup & match solutions,
ieatboogers
Re: DateDif problem,
Gord Dibben
Return entry in column above/below cell,
TheRobsterUK
Re: "FIX" is displayed on status bar,
Ron de Bruin
Re: Converting a number to a letter in Excel,
Bob Phillips
VLOOKUP issue,
Jonah
Re: If ? maybe.....,
Biff
Re: how do I count the number of times text in column A matches text i,
Bob Phillips
Re: INVOICE COUNTERS,
Bob Phillips
Re: Merg Worksheets,
Bob Umlas
Re: Return Array with Array,
Domenic
Re: Converting decimal calculation to h:mm format,
JE McGimpsey
Re: Sumif or Sumproduct,
Bernard Liengme
Re: Referancing differant sheets,
Bernard Liengme
Re: SUMIF Returns a #VALUE error when external source is closed,
Peo Sjoblom
Re: Bug in help for Excel SUMIF function,
Bernard Liengme
Re: How do I write the formula to calculate someones time worked,
mbarron
Re: Newbie needs help with incrementing a series of cells,
DOR
Re: Formula Needed...,
mbarron
Re: change values globally,
Bill Kuunders
Re: MAX function for a given Position Title,
Harlan Grove
Selecting specific row/column from a named range,
kakofoniks
Re: Formulas,
Peo Sjoblom
Re: countif,
Peo Sjoblom
Re: Sorting and Adding Space,
Ron Rosenfeld
Counting cells base on a predetermined range,
ddbruno
Re: Text is being converted to Date,
Dave Peterson
Re: If formula result is false, how do I auto-delete that rows?,
Peo Sjoblom
Re: =SUM(A1:A5)*24 for totalling hours and minutes is not working,
Peo Sjoblom
FLOATING CELLS,
zvone
Re: Running a macro if any data is entered in a range of cells,
Bob Phillips
Re: Nesting Index and Match Functions,
Dave Peterson
Constructing range address given row and col numbers of boundaries,
kakofoniks
Re: Excel filter dropdown shows all data,
Dave Peterson
Re: formula that will go up one space if no value in specified space,
Ron Rosenfeld
Re: Macros,
arno
Re: Significant digits,
tiah
Re: if command for yes or no,
Mladen_Dj
Re: How to project usage.,
Ron Rosenfeld
Re: Date(Y,M,D) 'feature' or problem?,
Niek Otten
Re: Date(Y,M,D) 'feature' or problem?,
Ron Rosenfeld
Re: How do I set up an "IF" formula?,
Ron Rosenfeld
Re: Holiday Dates,
Ron Rosenfeld
Re: Totals,
Bob Phillips
Inserting rows into worksheets that are protected,
Chris R
Display Part of the cell value,
ramana
Re: Show trial solution,
abhowan
Re: How to change number to text in new column from another worksheet?,
Max
Re: Entering Same Formula to A Full Staring from Say Row 5 Column.,
Max
Re: vergelijken tabblad naam met waarde uit cel,
Ron de Bruin
Re: How Can I call any form or macro..,
Bob Phillips
Re: How can I call a macro or form. in the moment that enable any shee,
Bob Phillips
Re: how to change a list of possitive numbers to negative,
Bob Phillips
Re: Multiple Criteria for COUNTIF and SUMIF,
Bob Phillips
Re: Icon for "Wrap" and for "Centre Across Selection",
Ron de Bruin
Discrete "Normal" Curve Function?,
Lee Harris
countif followup,
Lee Harris
countif problem - am I bonkers?,
Lee Harris
Re: conditional fraction - sumif?,
Biff
Re: How to get date averages,
Biff
Re: how do i name a excel worksheet and make it appear in cell a1,
Biff
Cell text based on 4 condition test,
Bob Wall
Re: How do I prepare a debt acceleration worksheet in Excel?,
Jezebel
Re: Identify missing record numbers,
Biff
Re: Transferring data between worksheets,
roy.okinawa
Re: removing pre-set characters from comments,
Gord Dibben
Re: Is there a macro to convert times between 2 places dep. on date?,
Ron Rosenfeld
Re: Averaging a Value Between Two Serial Dates,
Bob Phillips
Re: vlookup problem, possibly due to "noise",
vezerid
Value in cell refers to value in another cell,
morten
Re: How to repair 2005-2006 student attendance record?,
Roger Govier
Re: todayif??,
RagDyeR
Re: search funtion,
Peo Sjoblom
Re: Forms Toolbar in Excel 2003,
tiah
Re: Count rows if date is between two specified dates,
R.VENKATARAMAN
Another Date issue.,
TimM
Re: Calculating elapsed time,
Niek Otten
Re: Compare range with another range in other workbook,
Bob Phillips
Re: wrong year,
Max
Re: removing unnecessary spaces from multiple cells,
Max
Re: Column A = X, Column B =y count = count +1,
Biff
make custom formatting permanent,
simha
Re: multiple formulas in one cell,
Biff
Re: Comparing 2 columns if they are the same,
Max
Re: One line of list show up in different sheet,
Otto Moehrbach
need help righting script to sort rows alphabetically then seperate them to line up,
Kamachi923
Re: help me on tough sum on conditions issue,
amrezzat
Re: Excel Help,
Rowan Drummond
" / " Changing Decimal number format to Fraction on Protected Cell,
laudie
Re: Automate a date referenced in a formula pointing to another sh,
Mladen_Dj
Re: Number of work sheets,
Bob Phillips
Re: can an array do this.....,
Ken Wright
Re: formatting date-time values in macro,
scw-tzg
Re: Simple Formula (I thought),
csandi
Re: how do I autofill an excel worksheet with contacts from outlook?,
Ron de Bruin
Re: sort in excel using end of email address,
Chip Pearson
Re: Count excluding Duplicates,
RagDyeR
<Possible follow-ups>
Re: Count excluding Duplicates,
topola
Re: how do you make negative numbers show up as 0 in Excel?,
tiah
Multiple if or multiple vlookup,
Robo
Condense formula,
Derek Y via OfficeKB.com
Re: Select rows based on criteria,
Bob Phillips
Multiple countifs,
ozcank
extract numbers from cell containing text & numbers,
transferxxx
=250/1440 format as [h]:mm:ss,
Biff
Re: I have alot of text in a cell, I just want to see the top line,
Lotus123
Re: Linked Combo Boxes,
Lotus123
Re: creating hyperlinks,
Lotus123
Re: combo Box,
Lotus123
Re: Auto Inserting numbers,
Herbert Seidenberg
Re: if data in one cell, then date in adjacent cell,
Max
Text string and sum,
michaelp
Re: Headers getting lost in multiple sort,
mpjoyce
Macro to replace data within a worksheet,
Excell
Re: CF in a filter,
Rowan Drummond
Re: Suppress array formula #NA,
Peo Sjoblom
Re: can you use countif function for noncontiguous cells,
Bob Phillips
Re: How to make an input in one column determine dropdown list in,
Peo Sjoblom
Re: How to make an input in one column determine dropdown list in anot,
Debra Dalgleish
Re: World Clock,
Peo Sjoblom
Re: Summing large numbers...,
Peo Sjoblom
Re: Help!!! Vlookup!!,
theukego
Re: Countif with more than one criteria,
Bob Phillips
- Message not available
- Message not available
Re: An Inquirey on the Round function,
Nick Hodge
Re: part number with 'E',
Dana DeLouis
Re: What is a function in VBA EXCEL witch finds a string like "not" in cell and then deletes a row with this cell?,
Ron de Bruin
Re: help me please on if function,
Ron Rosenfeld
Re: Help formatting cells,
Max
Re: auto insert invoice number that increases by one each time opened,
Paul Sheppard
sequence of numbers,
andrewm
Re: Financial Functions,
Fred Smith
Re: How can I sort one column and have the entire row sort. (bindi,
Ragdyer
Re: Average to date,
Sean Bartleet
Renaming Sequential Rows to create serial numbers,
forceten32
Re: How do I subtract using formulas?,
mbarron
Re: Excel, turn off the hyperlink format when formula is @sum,
Tom Ogilvy
Re: If function for workday & weekend,
Tom Ogilvy
Re: Display text > 1024 characters in a cell,
Martin
Re: plot,
John
Re: Q - Excel 2000: How to refer to worksheet in the same book?,
joanna
Auto Sort using Macro,
Rubix
frequency formula with criteria,
seanc
Re: Performing Math with Time over 24 hours,
Peo Sjoblom
Re: Counting text across multiple sheets with a specific criterion,
Peo Sjoblom
help me getting value of column based on condition,
amrezzat
Re: Referencing cell in another sheet yields null?,
jamierphelps
Re: How can I use autosave from excel2000 in excel2003,
Dave Peterson
Re: IF Function to test formula in a cell,
Niek Otten
Re: linest r-squared bug when calculating forced through zero?,
Jerry W. Lewis
Re: Does Correl/Rank combo work eg CORREL(cols E & H) where E&H=RANK(.,
Jerry W. Lewis
sum of last 7 numbers,
tzvarza`
Re: looking for latest selling price..,
Don Guillett
is there a function for getting the content of a cell?,
tzvarza`
Re: Function newbie,
Bob Phillips
Re: drop down for excel?,
Nick Hodge
Re: Add excel horizontal & vertical ruler,
dominicb
How to connect two columns in Excel VBA??,
mar_male
VLOOKUP function,
joel51
Re: percentage,
joeu2004
Recalculation taking a massive 11 seconds,
David . Allen297
Re: Can I randomise the order of a number of rows?,
plh
VLOOKUP? Need to have value returned when select from drop-down list,
Budamon
Re: how to add 17.5% vat formula,
PCLIVE
Re: Multiple Range Pivot Table,
Debra Dalgleish
Re: How do I add a symbol between numbers in a column?,
Alan
Re: IF/THEN Average Problem,
Biff
Re: IRR Calculation issues,
Ron Rosenfeld
Re: How do you use the > < funjctions when calculating negative numbe,
Peo Sjoblom
Re: 2nd attempt ~ Faster/Shorter formula,
Luke
Re: Pivot Table Question,
Peo Sjoblom
Re: prevent empty rows from printing,
Harlan Grove
Re: Timesheet maximum hours problem,
Good Time
Re: Nesting SUMIF formulas,
Peo Sjoblom
Re: Input Range for a List Box,
Max
Re: extract year,
Bob Phillips
Re: Validate drop down box,
Bob Phillips
I need to link only certain cell...,
CNA48
Re: ##value error,
Roger Govier
best way to get reference to all used cells,
sugargenius
various values and listing them,
donjuan66
Re: Conditional SUMIF???,
Bob Phillips
Re: Colour full row in CF,
Bob Phillips
Re: Is there a function to give us the highest value in a list of tex,
Domenic
Re: SUMPRODUCT,
Domenic
Reformatting dates as text,
AmyTaylor
Excel Function returning negative 0,
ibertram
Re: workday date function,
Nick Hodge
Re: Show timesheet time in and out in regular time versus military tim,
Biff
Re: need help with determining a formula,
Bryan Hessey
Re: transposing links,
BorisS
Re: Match help,
Dave Peterson
Re: With formulas does anyone know the order of precedence BOMDAS,
Jezebel
<Possible follow-ups>
Re: With formulas does anyone know the order of precedence BOMDAS,
Ron Rosenfeld
Re: countif condition problem,
Peo Sjoblom
Re: questions being addressed,
Harlan Grove
Re: Spreadsheet will not sort,
vezerid
Re: sum>1 --> count = count +1,
vezerid
Re: How do I compare excel spreadsheets, tracking the differences?,
Harlan Grove
Re: Columns in excel 2003,
Harlan Grove
Re: SUMIF question with multiple criteria,
Roger Govier
Re: IF STATEMENT PROBLEM,
Manjit Gosal
Checking for duplicate items in list,
TheRobsterUK
Re: Reverse numerical values,
Bob Phillips
Hour Sum,
Vic1978
Re: Replacing Values in Cells Via Formula,
pclutts
IF statements and moving data to different columns,
Rhythm
Re: Change event fails to work,
Ron Rosenfeld
Calender Help,
Alexanderj
Re: combobox not working,
Bob Phillips
Re: trend for polynomial curve fitting by regressing,
Robert_Steel
Help I am going crazy with this formula.,
laz
Re: formula QUESTION,
Max
Re: how can I have Excel total a column of # that were derived by form,
Max
Re: COMPUTING TWO COLUMNS,
Biff
Re: Can I limit the amount of characters in a cell?,
Ron Rosenfeld
Re: Cell reference to current cell minus 1,
Ron Rosenfeld
RE: IF/AND/OR/DATEIF Issue...sorry...long post...,
EDSTAFF
Multiple SUMIF Criteria,
azazel
Re: max and lookup,
Biff
Re: templates,
anilos81
Delete rows listed less than 8 times???,
anilos81
Formula is entering a default time when it comes across an empty cell..,
Howie
- Message not available
- Message not available
RE: comparing many cols of data to one col,
DOR
Re: how do i add every fifth row in a spreadsheet?,
Biff
Re: How to I get a warning message box,
shrek
Re: How do I change hexadecimal number to binary in excel,
Hernandez, Roberto
Re: Seting up an Indirect Formula,
PCLIVE
Re: Footage to seconds (# to mm:ss).,
Robert_Steel
Search for instances of X in a sheet,
ThaPCdoc
Re: Macro?,
Duke Carey
Re: shortcut for merging selected cells would be nice.,
qwopzxnm
Re: ... I would like to apply more than 3 conditional formats ...,
Bob Phillips
Re: function problem,
bplumhoff@xxxxxxxxx
Showing the contents of a cell based on another cell,
Daminc
Re: How do I select & use contents of first non-blank cell in row?,
Roger Govier
Re: is it possible to make a spreadsheet display '0' when negative,
Bob Phillips
populate data valadation list by criteria,
John in Surrey
Re: using the same function to convert a column of numbers,
Bob Phillips
Creating Combinations,
michaelp
Re: LOOKUP,
Biff
Nested IF's with Rank Problem,
exutable
New Auto Selecting Cell Question,
Greegan
Re: Excel multiline formulas,
Rowan Drummond
Re: Using Two Worksheets To Capature Data,
Anne Troy
Re: How do I set up an IF function with text and numbers?,
DOR
Re: How do you count data that matches more than one condition?,
RagDyer
Help matching entries in two sheets???,
Curalice
sum,
ceemo
- Re: sum,
Anne Troy
- Message not available
Re: Copied nubers is not possible to add,
Don Guillett
Re: SSN Format not showing,
Anne Troy
Re: Using Autofilter with Protection on,
dominicb
Re: What function can I use,
Max
Worksheet tabs in a Macro,
jstoner50
STRING functions,
anar_baku
Re: How to AUTO SORT A-Z new data in a column (not menual sorting),
Thiem
Re: Function IN VBA,
mar_male
two cases for countif,
joi2
Re: how to automatically convert a number to words in Excel,
Paul B
Excel Crashes,
SS
Autofilter stops responding,
gazbea
Re: How can I add data analysis function in tool?,
Max
keep active sheet view and cursor position,
killa47
Can someone give me a hand with this formula please?,
Howie
Re: Complicated IF Formula,
Luke
can we round time in excel,
ramana
Re: How do you average if your data contains a 0?,
Max
Re: Vlookup doesn't work until i edit(but not change) the lookup cell,
Max
Re: Calendar - vlookup based on dates,
DOR
Re: Autofilter with Subtotal Sumif,
Debra Dalgleish
Re: Average with a 0 in the equation,
Peo Sjoblom
Re: Need help creating a formula to summarize data!,
DOR
Re: Formula Help,
Ron Rosenfeld
Re: dynamic summed range based on a variable,
RagDyer
Count and Sum cells with certain format (e.g. color),
hugo . vanegas
Re: Searching for a particlar value and matching to a name..,
spezialize
Re: lookup tables,
Rowan Drummond
Re: Time Sheet frustrations,
Meelikki
splitting names can't see whats going wrong (Save My Sanity ),
workaholic
Re: How can I display a "sliding" range?,
DOR
Re: Delete Formula,
Per Erik Midtrød
Re: IF statement containing OR,
Sandy Mann
Re: pricing problems,
paul
Re: Calc Diff Between Two Julian Date,
saltrm
Logon Screen,
mamun316
Drop-down boxs,
Eric C. Vogel
Re: Multiple IF,
Anne Troy
Re: Non-Blank Cells: Conditional Counting,
Chip Pearson
VLOOKUP Problem (limitation)?,
SnotRockit
Re: IRR Guess Problem,
Dkline
"Rows to repeat at top" option under page setup,
PaulandArt
Re: import external data too many rows for one worksheet,
Bruno Campanini
{=AVERAGE(IF((C3:C325<M4), C3:C325))},
Nebbez
Re: How do I lookup a corresponding value in another table,
Barb Reinhardt
Re: Time sheets,
sajay
Re: Columns with "zero" width,
Roger Govier
Re: overcoming nested IF limitations...with VBA?,
Harlan Grove
Re: Creating a league table based on results,
gpktm
Re: Vlookup returning Hyperlinks,
Lotus123
Re: Goodness of fit function,
Lotus123
Re: embeding a picture into a cell,
Lotus123
Re: toclearasell,
Lotus123
Re: unable to open file,
Lotus123
Re: need a function to calculate a mortgage payment,
Lotus123
Re: Excel Holiday Roster Calender,
ksp
Re: conditional subtotal counting,
Barb Reinhardt
Look up a list of prices,
Numpty
Re: IF Function,
bill k
Counting Age,
Simon Chang
Re: counting 0 in a row,
Ian
Re: conditioning,
Ian
Re: MATCH Limitation?,
Dave Peterson
Conditionally Fill a sheet row if cell value in another sheet >0,
nstx
Re: Bessel function/directivity function,
Jerry W. Lewis
Re: Average, IF,
Bob Phillips
Re: E-mail sent for a cell in a sheet that lists a birthday as today,
Roger Govier
Re: I WANT TO ADD A TWO RANDOM CHARACTER SEQUENCE TO A SET OF ROWS,
Max
Re: excel formula to enter "0" if cell blank,
Max
Re: Limiting the range of a lookup function,
Biff
Vlookup worksheet function,
Antonis1234
How to Append the Data to the Master Table,
Shiva
Re: event macros - xl 2003,
dominicb
Re: Finding Bad Web Queries,
R.VENKATARAMAN
Re: How to make data in one workbook appear automatically In another,
R.VENKATARAMAN
Re: Merging Text Help,
DOR
Re: How can I use the same validation for an entire column?,
Biff
Re: want sumif function's range to evaluate 2 columns,
Domenic
Re: mortgage calculator formula,
Anne Troy
Re: problem with #value!/zero,
Biff
Dynamic Average,
Big H
Percentages,
trev2283
Re: change the colour of text in cell for minus figure,
Don Guillett
Re: Lock row in Excel,
R. Choate
Re: Workingday Calculations,
Karthik
Re: Confused beginner,
sarahog
Re: Auto Selecting Cells,
Bob Phillips
New Menus - attaching but menus are reset,
Greegan
Re: How to add date format into if statement?,
Bob Phillips
Re: How to highlight a row containing specific phrase?,
Barb Reinhardt
Re: After adding Analysis Tool Pack, still no PRICE function, why?,
Niek Otten
How to return a value Referring to the other cell.,
ramana
Re: Some rows sort incorrectly in Excel. How do I correct the problem.,
damorrison
Re: linking columns,
Paul Sheppard
Re: don't allow users to assign the cntrl+s as a short cut for macro,
JE McGimpsey
Re: YEAR and MONTH confusion,
DOR
Re: Finding Min Cell values excluding zero in alternate columns,
Biff
Re: How do I hide #N/A, ### in cells not yet worked on?,
Sunny9210
Re: column and row headings,
Mladen_Dj
Converting functions into numbers,
vesuvius
Re: Hide text in shaded cell,
Bob Umlas
Re: Cell reference in diff worksheets,
Bernard Liengme
subtotal,
bbking
Hyperlink Formula to call up browser,
Bob Smith
adding rows of hours and minutes to get a total,
Tipps
Re: Using MAX to reference a row,
Niek Otten
sumproduct based on format,
mhoffmeier
Re: Sumif,
rjmat
Re: sumif,
Don Guillett
Re: sumif,
Ken Wright
Re: SUMIF,
Andy
Re: SumIf,
Vito
Re: SumIf,
Don Guillett
Re: SumIf,
Peo Sjoblom
Getting Excel to Calculate All Combinations of a Set of Data?,
marello
Re: Range used in a macro needs to be variable,
Bob Phillips
How to blank a cell with a formula,
nsv
Average given criteria, HELP!,
Nebbez
Re: Ordering fields formatted YYYY Mth in a Pivot,
Roger Govier
Re: Hide 0% figures in Pivot Table,
topola
How can I correct this Time formula,
John
Link A Cell In O ne Workbook To A Formula In Another Workbook,
Minitman
Count cells with strikethrough font?,
Mike Echo
Re: Is there a pull down Box to alert for minus balance such as ($5.00,
Barb Reinhardt
Re: Referring to Cells in a forumula using a function,
Barb Reinhardt
Re: could someone help!,
Barb Reinhardt
simple MAX + comparison formula,
j0e
Number of hours worked between 18:00 and 06:00,
clobns
=if(and(....,
Lift Off
Re: isolating different aspects of worksheets...as objects? through section breaks?,
Harlan Grove
Re: Links only update when external workbook is open,
Harlan Grove
Re: Income Tax Payable from table with escalating marginal percentage rates.,
Chris Lavender
How do you link 2 drop-down menus?,
jd1655
Re: Why doesn't my resized worksheet have a minimize or close box,
Debra Dalgleish
Locking linked cells,
satkinson
Counting the number of times a specific character appears in a cell,
PCLIVE
Re: "IF" function - 7 nested limit,
Niek Otten
Re: significant digits for decimals,
MrShorty
Re: Finding a value within two rows,
Domenic
Re: search all tabs for tab name specified & lookup reference?,
Bob Phillips
Eliminating blank cells in a list on a ROW,
grime
Re: Using CountIf with criteria on another sheet,
Lee Hunter
Re: Payroll analysis,
Ron Coderre
Navagating issue,
Beantown20
Re: Creating a Web Query,
Don Guillett
Countif using Wildcard * and number 1,
southdaytona
Calculate Total Sales from a Database,
John
listing and selecting data,
parthi_75
Re: Editing Repeated Text,
Bryan Hessey
Re: Random Date Generation,
bplumhoff@xxxxxxxxx
Re: Compare worksheets and generate list of missing data?,
Minuette
Moving a sheet from one work book to another?,
WTG
Re: formula cut and paste,
Ian
Re: Conditional Formatting,
Bob Phillips
Re: Conditional Formatting,
Rowan Drummond
Re: Conditional Formatting,
Rowan Drummond
RE: Conditional Formatting,
Gary''s Student
Re: Conditional Formatting,
Gord Dibben
Re: Conditional Formatting,
SteveG
Re: Points Ranking Formulas,
Max
Re: Charting,
Roger Govier
useform autosize to fullscreen problem,
Pierre via OfficeKB.com
Just a test message to be deleted,
Bosko
Convert mins:secs to seconds only,
ronedwards
Re: How do I write a formula in Excel,
Biff
Unusual data format,
Salty
Re: formula to calculate future date from date in cell plus days,
Paul B
Vlookup based on designated occurrence of value,
bill9340
Re: Translating an IF formula from Lotus 1-2-3 to Excel,
damorrison
Re: hide sheets use data,
damorrison
Conditional format combined with functions,
DAJ
Re: How can the count of filtered records always display?,
Bob Phillips
Text to Number,
Lift Off
Re: Extract Fractional Numbers as Numbers NOT Date,
Peo Sjoblom
Re: can't find custom function code,
Don Guillett
Re: Formula for a time card,
skateblade
Copy data to another column Macros,
dominoguru2
Re: Extrapolate numeric values from text string,
Harlan Grove
Re: Convert weeknr to a date,
Roger Govier
Re: vlookup function return all values,
Domenic
Re: Changing a Formula in Conditional Formatting,
Mladen_Dj
Currency button,
Alex H
Re: Text displays as ### in a cell.,
Dave Peterson
Re: How can I type Excel numbers to show as a barcode?,
Thomas Lutz
Re: I need a " IF THIS THEN _" formula,
bbuzz
Re: multiplying with excell,
Bob Phillips
Re: Yup - another question!,
John Michl
Using a cell value for row in R1C1,
Rob T
Re: Why does / key act like Alt+F and highlight file menu not type /,
Debra Dalgleish
Re: Need to Sum Mon-Sat each seven days; Average Sunday,
Bob Phillips
Message not available
Returning one text value in a long list?,
news.zen.co.uk
how to let the userform autosize depending on the screen resolution,
Pierre via OfficeKB.com
color the interior of a range,
Pierre via OfficeKB.com
Re: Range Lookup in VLookup ?'s,
Bob Phillips
Re: Hourly rates,
Bob Phillips
Re: Combining sheets on one,
em8195
numbers to time,
Jibba02
Re: how to I make an excel spreadsheet into a label format?,
Peo Sjoblom
Re: Convert Text to Number,
Max
Re: Has anyone had formulas change automatically with no explanation?,
Alan
format combobox in userform to accept dates,
Brad
Re: SUMPRODUCT as array formula?,
DOR
Re: How to lookup row # based on content of another column's cell,
Mr. Jan Park
Re: Simple find with right function,
Bob Phillips
Re: Vlookup using text,
Anne Troy
How do I write an 'if exist" statement,
John in Surrey
Re: Function or Formula,
Gord Dibben
Re: Need Help with Replace Function,
buymearing
Re: Find a "date" in a column of dates in Excel 2000,
Gord Dibben
Re: Lookup Value between 2 ranges,
Bob Phillips
Re: Historical Quotes,
Don Guillett
Re: index / match ?,
DOR
Re: # of Worksheets,
Anne Troy
RE: Max and MIN question,
scott45
Re: Countif with star operator in criteria,
mashfour077
anova post-hoc analysis: tukey test,
Ross
- Message not available
- Message not available
Re: Showing Mininum $ for items,
Bob Phillips
Re: adding color to cells based on a formula,
Biff
Re: Date Format,
Dreamstar_1961
Re: large / sumproduct combo,
Peo Sjoblom
Re: How to extract the data,
Shiva
Re: If True Concatenation,
duane
Re: update multiple worksheet in single book,
heatmiserkmp
Re: Can Excel calculate the effect of extra principal on loans?,
Peo Sjoblom
Re: Progressive Calculation,
Biff
Re: Data Validation List Length,
Biff
Re: Indirect in combination with ROW,
Harlan Grove
Re: Radio Buttons,
Harlan Grove
Re: IF text statements,
Bob Phillips
Re: DIAS.LAB function poblem,
Ron Rosenfeld
Re: Commission Calculation,
Richard Buttrey
Re: 12 digit code sorting,
Chip Pearson
