microsoft.public.excel.worksheet.functions
- counting numbers in a range,
ystrumecki
- Re: Compare a value and if is true copy the line to other workshee,
Max
- Re: ########### error,
Bernard Liengme
- Delete in row C if it is repeated in row D,
calibansfolly
- RE: Extracting Numbers froma Text String,
Jules
- Re: Linear Regression in Excel,
Bernard Liengme
- Re: Formatting a cell to turn "white" when filled in...,
Bernard Liengme
- Re: RUNNING TOTALS...FORMULA NEEDED,
T. Valko
- Re: EXCEL - unable to get "TEXT" to wrap, even though cell is formatte,
T. Valko
- Re: How can I name Worksheet Tabs based on some king of reference?,
Gord Dibben
- Re: How do I sum column D and F based on multiple column criteria?,
PCLIVE
- Re: Question Involving COUNTIF and Possibly DCOUNTA,
T. Valko
- Re: Print Area Question,
Gord Dibben
- Re: calculating a formula for a service level,
David Biddulph
- Re: Data is not visible in merged and wrapped cells,
Gord Dibben
- Re: Greater of Two Cells,
PCLIVE
- Re: sumproduct,
squenson via OfficeKB.com
- Re: Compare side by side stuck,
Pete_UK
- Re: is there a way to format the date in an excel footer eg just year,
Dave Peterson
- Re: Compare arrays,
Bernard Liengme
- Not understanding MROUND,
nma2
- =sumproduct(round(,
mhoffmeier
- Formating Cells for Time,
Steven_Phillips77
- Re: month plus one - excel 2003,
Chip Pearson
- HELP ON AGE RANGES,
Malcolm Austin
- Re: Dynamic link to website,
Mark
- correlation when the cell references vary,
Mark
- Dynamic creation, or something different needed?,
Nehvun
- RE: Pivot Tables with text,
Ron Coderre
- RE: How can I find percentages of a number,
Stan Brown
- Re: Edit Paste Special Formulas,
Gord Dibben
- Re: Change Military time on Imported Cell,
Rick Rothstein \(MVP - VB\)
- Re: How do I add a simple calculator ( Like the one found in accessori,
Gord Dibben
- Re: summing all results in a vlookup,
Peo Sjoblom
- Re: Rounding issue,
Sandy Mann
enter user in cell,
pbs
Re: Formula for time cards,
Gord Dibben
Re: macro change formatting,
Gord Dibben
Re: Excel filters,
Gord Dibben
Re: a check mark next to something means what?,
Gord Dibben
Re: Copy Cells,
Gord Dibben
sheet duplicate,
sagar
Re: Copy cells to specific sheets,
Double R
Re: How do I return the 10th day of the following month?,
Sandy Mann
how to muliply,
S S
Re: Sum in Excel,
Ragdyer
nested if,
Gary Wessle
RE: CountIf embedded in an IF statement,
Toppers
That it's been checked!,
T. Valko
Re: Can the function window be expanded?,
T. Valko
Re: Hello,
David Biddulph
Re: Conditional comparison of values.,
T. Valko
Re: Countif within and if statement,
Rick Rothstein \(MVP - VB\)
Re: Need formula assistance ASAP,
Rick Rothstein \(MVP - VB\)
Re: how to use towords formula,
Rick Rothstein \(MVP - VB\)
Compare text string of a cell in Column A VS another cell in Colum,
Tan
Re: Bringing Data From Access To Excel,
Ron de Bruin
Re: Filtering a column and not all cells are available,
Ron de Bruin
Re: SUM,
Roger Govier
- <Possible follow-ups>
- Re: SUM,
David Biddulph
Re: The formula does not calculate properly... Help me if you could..,
Roger Govier
Re: Lookup for smallest number?,
Ron Rosenfeld
Re: Please help!!!,
Roger Govier
Three sheets total!,
rcoco
Changing portrate to landscape within publisher,
chedd via OfficeKB.com
Re: Finding a number based on a criteria,
Bob Phillips
RE: BwiSwy Help Please,
BriSwy
RE: dismiss blanks in lookup,
Manuel
Re: Highlite the cell if above 5:31,
Rick Rothstein \(MVP - VB\)
RE: Copy Data only if the cell has a value,
BriSwy
Re: Calculating cost of product,
T. Valko
Re: Merging Columns,
Roger Govier
Re: Merging Columns,
David Biddulph
Re: Summing a ranking of several categories,
Bernard Liengme
- Message not available
- Message not available
Re: Insert calender,
Ron de Bruin
Re: Applying pop up calendar to entire worksheet,
Ron de Bruin
Re: Extract specific text,
Harlan Grove
<Possible follow-ups>
Re: Extract specific text,
Bernard Liengme
Re: Change number of years,
Gord Dibben
Re: Frequency formula,
Harlan Grove
Re: NonLinear R-squared (R2),
Mike Middleton
Re: changing cell references,
Bernard Liengme
Re: blinking number,
KL
Re: Excel 2002: How to Select Greater Value of Numerous Cells?,
Rick Rothstein \(MVP - VB\)
Re: count and return pair numbers,
Rick Rothstein \(MVP - VB\)
Re: Multiple "lookup_value",
Jim Cone
- Re: Multiple "lookup_value",
Noel
- Re: Multiple "lookup_value",
Sandy Mann
- Re: Multiple "lookup_value",
Harlan Grove
- Re: Multiple "lookup_value",
Jim Cone
- Re: Multiple "lookup_value",
Harlan Grove
- Re: Multiple "lookup_value",
Harlan Grove
- Re: Multiple "lookup_value",
Sandy Mann
- Re: Multiple "lookup_value",
Harlan Grove
- Re: Multiple "lookup_value",
Sandy Mann
- Re: Multiple "lookup_value",
Sandy Mann
- Re: Multiple "lookup_value",
Harlan Grove
- Re: Multiple "lookup_value",
Harlan Grove
- Re: Multiple "lookup_value",
Sandy Mann
- Re: Multiple "lookup_value",
Jim Cone
Re: Top Ten List by Individual Volume,
squenson via OfficeKB.com
Finding the earliest date from a range of cells,
roniaelm
Re: Order/Rank,
Ken Johnson
Re: Formula to determine selling price with cost known @ X margin?,
Rick Rothstein \(MVP - VB\)
Re: DSUM Partial Match,
Peo Sjoblom
Re: increasing a cell value on each use,
L. Howard Kittle
Re: ComboBox - Link Cell that Accumulates,
krcowen
Re: Date issue,
Peo Sjoblom
Re: Combining worksheets with common column but different number of ro,
Harlan Grove
Re: Help with lookup (vlookup),
Harlan Grove
Re: If function with and,
Harlan Grove
Re: How do you calculate a negative percentage,
bob . golightly
Re: Excel Formula Help,
Toppers
Re: Color Banding,
Bob Phillips
Re: How do I print comments individually?,
Debra Dalgleish
RE: Calculate Selected cells only.,
CLR
Re: Display data retrieved from website and have it update periodicall,
Gord Dibben
Re: insert images in a protected worksheet,
Ron de Bruin
- Message not available
- Message not available
Re: Copy row below,
Peo Sjoblom
Re: multiple IF statements,
Don Guillett
Re: remove preceding zeros,
CoRrRan
Function refering sheet index.,
Joe_Germany
Unexpected #N/A error from INDEX-MATCH combo,
animeshhere
Re: Forecast and Trends,
Colin Foster
Re: paste greyed out,
NickHK
Re: Preserve format, right tab using concatenate,
NickHK
Re: my excel worksheet will not display gridlines,
tomek gomek
Dynamic cell reference using INDIRECT..,
Jason.Alden.Benoit@xxxxxxxxx
First day of month,
Dianne Groom
RE: PLEASE HELP!! FORMULA TO RETURN A SHEETS NAME/REFERENCE.,
JLatham
Keeping column name in view when scrolling,
Geoman
Re: separate an address street/city,state,zip within a cell?,
Meebers
Re: compound rate of return calculation,
joeu2004
Re: sumproduct - multiple conditions,
Bob Phillips
Re: How do I permanently delete a custom toolbar in Excel?,
Gord Dibben
Re: Count occurrences of text within a cell,
T. Valko
Re: Function explaination need,
Peo Sjoblom
Re: RENAMING WORKSHEETS,
Bob Phillips
Re: Dynamic average,
Bob Phillips
RE: Dollar/Euro/Pound Excel macro,
Yendorian
calender,
S S
Re: How do I remove the 'end' function in Excel 2003?,
Harlan Grove
Re: Splitting text in a cell,
Peo Sjoblom
Re: Month name to number of months YTD,
Harlan Grove
Date Formula,
Craig
Re: Trying to match up variables to a common list and confirm,
Matthew
Re: Excel 2003,
T. Valko
Re: Using the "Count" function with filters?,
BASFMark
Re: column alignment,
Gord Dibben
Re: Copying a formula which uses indirect(),
Harlan Grove
Re: seperating data from one cell to multiple cells?,
Bob Phillips
Re: Macro Problem,
Don Guillett
Re: How to remove duplicated data repeated in a column and keep just o,
Peo Sjoblom
Re: Subtract a future month from the current month to get remaining m.,
Peo Sjoblom
Re: Converting from Norwegian Krone to US Dollars format,
Peo Sjoblom
Re: Finding the value of x,
Pete_UK
Count of Value based on another value,
Richhall
Re: Vlookup returns #N/A correctly...but...,
Pete_UK
Re: How can Iextend a cell conditional formating to an entire line ?,
David Biddulph
Re: Function to return a month name from a number (1-12) that is not a,
Niek Otten
Lookup values in 2 columns, count and then multiply??? HELP!,
DebbieV
Excel count based on value in another column,
Richhall
RE: VLOOKUP using two criteria,
squenson
Re: Rounding problems,
Bob Phillips
Re: Need a formula, please!,
Arvi Laanemets
Re: How to format cell to display "NIL" if value of cell is zero in Ex,
tomek gomek
Re: Difference of two dates,
papou
Re: Need to creat dependent drop down list,
papou
finding all cells that match a certain value,
OTS
Re: Formula displays, not value,
Gord Dibben
Sheet Background does not print,
Corey
How to calculate the Date occurs,
Blue Fish
Re: Help! I need a formula to add numbers separated by commas within,
Gord Dibben
Re: Help! I need a formula to add numbers separated by commas within,
Harlan Grove
Re: I need to calculate a Geometric mean,
David Hilberg
Re: Work Sheet failed to open fully & stuck at one cell only,
Gord Dibben
Re: Copy from one sheet to another,
Gord Dibben
Re: How do I caluclate an Annual Percentage Rate in Excel?,
joeu2004
Re: vlookup returning a value in more than one cell,
Alan Beban
Message not availableRe: vlookup returning a value in more than one cell,
Pete_UK
Re: vlookup returning a value in more than one cell,
LTaylor
Re: vlookup returning a value in more than one cell,
Pete_UK
Re: vlookup returning a value in more than one cell,
LTaylor
Re: vlookup returning a value in more than one cell,
Pete_UK
Re: Backwards? lookup function,
Chip Pearson
Can excel list combinations,
BOJO
RE: Finding The MAX Value,
Jim Thomlinson
Re: When I enter a formula, Excel shows the formula not the results,
Pete_UK
- Message not available
- Message not available
Re: sum question,
Harlan Grove
Help with Index / Match function,
Livin
Re: When printing, I get 5 extra blank pages. How do I delete them?,
Pete_UK
Re: R squared,
Mike Middleton
- Message not available
- Message not available
HLOOKUP with 2 values and choose 1 value,
Positive
take the green pill or take the SUMPRODUCT?,
sexynumbers
Re: Another Quetion about lookups with errors,
George Nicholson
Re: negative and positive sums,
Pete_UK
Re: Cell reference to make a directory path,
Dave Peterson
Re: Calculate Average on specific items,
Sandy Mann
HLOOKUP and choose one value among 2 values,
Positive
Calculating how many Saturdays there are between two given dates,
tony . lipschitz
[OT] posting,
tomek gomek
Re: for Toppers and Barb,
Bob Phillips
Re: Calculating Mintues,
tomek gomek
Re: Freeze panes,
Pete_UK
Change to day format,
Blue Fish
Re: Array,
vezerid
Re: Conditional Formatting for alternate client refs,
vezerid
Importing Data Into Excel,
Martin
Re: what is the difference between a worksheet and a workbook?,
NickHK
Re: 'IF','LOOKUP' or 'HLOOKUP'?,
Arvi Laanemets
Re: Average nesting within Sumproduct?,
T. Valko
Re: Function in objects.,
NickHK
Unit Forcast,
Larry
Re: Trying to insert a row. Insert wont Activate,
Jim Cone
Re: Sorting dates,
Roger Govier
Decimal place + - button use in protected worksheet,
Aaron
a second call for the goddezzez and godz of SUMPRODUCT,
sexynumbers
Re: Counting unique dates based on selected criteria in a list,
Peo Sjoblom
Re: Final day of month,
Peo Sjoblom
Current Mortgage Balance,
JAH
Need a formula,
old coach
Re: find email address in a cell,
Ron Rosenfeld
Re: Extracting Rows to Make A Totals Sheet,
David Hilberg
how to pull out the last day data in an array?,
vincentwady
Re: Conditional Formatting on Null Value,
Peo Sjoblom
reference the latest date's data in an array,
vincentwady
Re: xml,
Gord Dibben
Re: negative log,
Tushar Mehta
Re: change a spreadsheet from single spaced to double spaced?,
Gord Dibben
Re: How do I write a macro that will allow users to set thier own pass,
Gord Dibben
Re: Cell References,
Gord Dibben
Sum multiple arrays of data according to criteria,
bmatheson
- Message not available
- Message not available
Re: finance functions not available,
Peo Sjoblom
- Message not available
- Message not available
Re: How to run a macro with the IF command,
Gord Dibben
Change cell background based on multiple cells,
oooprettyflowers
Re: ID and/or filter rows with 'Fill Color',
Bob Phillips
Re: help with match? I don't know what formula use,
Bob Phillips
Re: Formula help please,
Bob Phillips
RE: worksheet amalgamation,
JLatham
Payouts based on hours and rounding down if hour is not in list.,
The_Sleeper
Using a cell value in its own calculation,
silvz7105
Re: How to connect to database?,
Bob Phillips
Sum If,
Alex
Look up text value,
s . giliadov
Re: time in minutes and seconds and .00,
T. Valko
Re: How do I hide #N/A, ### in cells not yet worked on?,
Kimo
Re: LOOKUP Formula,
T. Valko
<Possible follow-ups>
Re: LOOKUP Formula,
T. Valko
Message not available
Re: How do I get a calculated amount to round to the nearest nickel?,
T. Valko
Re: what exactly prevents INDIRECT from accessing closed worksheets?,
T. Valko
Re: How can I lookup when match has more than one value?,
David Hilberg
Re: Sumproduct - formula to return data OTHER than given criteria,
T. Valko
Track New Values,
bgetson
RE: Create a "cell button" to hide selected cells.,
Steve1964
Re: Is SUMPRODUCT the right function to use?,
Roger Govier
Re: How can I do this Formula???,
Roger Govier
Re: Excel 2003 to 2007 Analysis ToolPack Errors ="#N/A",
Mike Middleton
Re: Fill Series,
Gord Dibben
- <Possible follow-ups>
- Re: Fill Series,
Gord Dibben
- Message not available
- Message not available
Re: Can't Stop Date Values from Changing to Formulas,
Ron Rosenfeld
Re: select and extract rows of data to new excel worksheet,
Gord Dibben
Re: COPY FROM COLUMN TO ROW,
Gord Dibben
Run Macro for all worksheets,
saman110 via OfficeKB.com
Re: cell height,
Gord Dibben
Re: Time to time range formula???,
Sandy Mann
Formula is being quirky,
Pierre
Re: Referencing cells in another worksheet,
T. Valko
RE: SUMIF & COUNTIF based on dates,
Toppers
Re: Looking up multiple results with VLOOKUP,
Peo Sjoblom
RE: IF STATEMENT HELP CHOOSE AND GET COST,
HERZHIS
Re: What do you call values used with a functions?,
Niek Otten
Re: Vlookup reference the row below,
Peo Sjoblom
Time Question,
Spike9458
Count function,
MarekZ
Re: regional settings,
papou
Re: Conditional function,
Pete_UK
Re: Assigning point values?,
Dave Peterson
Re: Insert newline in cell through formula (excel 2003),
Rick Rothstein \(MVP - VB\)
Re: Totally wierd,
T. Valko
Re: Canadian Postal Code format?,
Dave Thomas
Importing Data Into Excel From LONG Web Page With URL Ending With .cfm,
Martin
Re: product formula not totaling,
Dave Thomas
Re: too many levels of nesting,
T. Valko
vba,
harry buggy
- <Possible follow-ups>
- vba,
harry buggy
RE: renaming worksheets/objects in VBA,
JMB
Re: Excel 2007 table option,
Bob Phillips
Re: Inserting/deleting rows between worksheets,
Dave Thomas
Re: Excel - Fill empty cells,
Dave Thomas
Populating sequentialcombo's or fields,
Jeff
Re: I have no colours in Excel,
garfield-n-odie [MVP]
Re: Calculation Question,
T. Valko
WEIBULL formula to get probability rate,
Fin Fang Foom
Re: Another Conditional Formatting Formula needed?,
Dave Peterson
Re: How do I use sumif and mid function in same formula,
Dave Peterson
how to apply bold within string text,
dragonball20cal
- Message not available
- Message not available
Re: Is it possible to Macro a Pivot Table?,
Harlan Grove
Re: #DIV/0!,
Harlan Grove
Re: Delete certain records in Excel and then Change a # in another,
Gord Dibben
Re: under standing if statments,
Ron Rosenfeld
Re: How do I arrange columns alphabetically by column label?,
CLR
internet connection via excel macro at timed intervels & save data to excel file.,
Sam
RE: Need to work out a timesheet with times going into next day (>,
z_insyd
Re: Need to work out a timesheet with times going into next day (>24 h,
Ragdyer
Re: Formula for Matching Names and Conditional Formatting!,
Gord Dibben
Test if a number falls between 2 values,
dalymjl
Dates formula,
davey
Re: In over my head with calendar 8.0,
Dave Thomas
Re: Workbook_BeforeClose Question,
Dave Thomas
Checking cells for 2 conditions,
Mary Lancaster
Re: inverse error function,
Dave Thomas
Re: My Final #DIV/0! that I'd like to say Goodbye to!,
Dave Thomas
- Re: My Final #DIV/0! that I'd like to say Goodbye to!,
Peo Sjoblom
- Re: My Final #DIV/0! that I'd like to say Goodbye to!,
Dave Thomas
- Re: My Final #DIV/0! that I'd like to say Goodbye to!,
Sandy Mann
- Re: My Final #DIV/0! that I'd like to say Goodbye to!,
Dave Thomas
- Re: My Final #DIV/0! that I'd like to say Goodbye to!,
JLatham
- Re: My Final #DIV/0! that I'd like to say Goodbye to!,
Peo Sjoblom
- Re: My Final #DIV/0! that I'd like to say Goodbye to!,
Dave Thomas
- Re: My Final #DIV/0! that I'd like to say Goodbye to!,
Harlan Grove
- Re: My Final #DIV/0! that I'd like to say Goodbye to!,
Dave Thomas
- Re: My Final #DIV/0! that I'd like to say Goodbye to!,
Harlan Grove
- Re: My Final #DIV/0! that I'd like to say Goodbye to!,
Dave Thomas
- Re: My Final #DIV/0! that I'd like to say Goodbye to!,
Harlan Grove
- Re: My Final #DIV/0! that I'd like to say Goodbye to!,
Dave Thomas
- Re: My Final #DIV/0! that I'd like to say Goodbye to!,
Harlan Grove
- Re: My Final #DIV/0! that I'd like to say Goodbye to!,
Dave Thomas
- Re: My Final #DIV/0! that I'd like to say Goodbye to!,
Harlan Grove
- Re: My Final #DIV/0! that I'd like to say Goodbye to!,
Dave Thomas
- Message not available
Help understanding what a formula does and why it's 'faulting',
neil40@xxxxxxxxxxxxxx
Re: Copying formulas from one workbook to another,
Gord Dibben
Re: Can I make one or more spreadsheets unopenable?,
Gord Dibben
Re: Validation List AutoFill,
Peo Sjoblom
Re: Multiple Users in One Sheet,
Dave Thomas
Re: #DIV/0! Error-Another Twist, assistance please?,
PCLIVE
Re: How to use index match for multi lookups?,
Bernard Liengme
Re: Simple If, If part 2 (clarification),
Arvi Laanemets
Re: combining multiple sheets into one,
Ron de Bruin
Re: macro to delete the last value in each column,
Ron de Bruin
Less Than MATCH(),
bgetson
Re: lookup formulas,
T. Valko
Sumproduct again?,
Sandy
Re: how do I display the current worksheet name in a cell?,
Peo Sjoblom
Re: Text Import Wizard, Step 3 (converting .tsv file to Excel),
Peo Sjoblom
Processing Time,
bgetson
Re: INDIRECT Link of Variables for VLOOKUPs,
Peo Sjoblom
Regular Expressions & Middle Name,
pkaraffa
Re: INDEX - MATCH with three variables,
Peo Sjoblom
Re: Simple if, if ?,
Peo Sjoblom
Re: This is probably an Array Formula?,
Don Guillett
Do you want to save,
Alan
Re: Summing By Week,
Bob Phillips
Re: How can you round numbers to the nearest quarter (i.e. .63=>.75),
Peo Sjoblom
copying formulas to multiple sheets,
dimitry
Re: Counting unique items based on date,
Don Guillett
- <Possible follow-ups>
- RE: Counting unique items based on date,
Ron Coderre
- RE: Counting unique items based on date,
DKS
- RE: Counting unique items based on date,
Ron Coderre
- Re: Counting unique items based on date,
Don Guillett
- Re: Counting unique items based on date,
Ron Coderre
- Re: Counting unique items based on date,
Don Guillett
- Re: Counting unique items based on date,
T. Valko
- Re: Counting unique items based on date,
Don Guillett
- Re: Counting unique items based on date,
orchid11652
- Re: Counting unique items based on date,
Ron Coderre
- Re: Counting unique items based on date,
orchid11652
- Re: Counting unique items based on date,
orchid11652
- Re: Counting unique items based on date,
Ron Coderre
- RE: Counting unique items based on date,
DKS
- RE: Counting unique items based on date,
DKS
- RE: Counting unique items based on date,
Ron Coderre
- RE: Counting unique items based on date,
Ron Coderre
Multi-sheet sumif help,
Brian
Re: Formula Too Long error,
Arvi Laanemets
RE: Return the data from 3 columns,
CLR
RE: lookup formulas dependent upon lookup formulas,
Mike H
how to compare 2 cells in range,
tomek gomek
- Message not available
- Message not available
Re: Formulas not updating,
Niek Otten
Re: Match a currency with its corresponding value,
Bob Phillips
Re: Pls help me to solve this problem...,
Bob Phillips
- Message not available
- Message not available
- Message not available
Two CSV file data to new excel file,
Vishal
Top 5 in a List - Alterntive to Pivot Table,
Anthony
Re: PMT: Daily interest compounding; monthly payment,
NickHK
Array Formulas,
bgetson
Re: formula in excel that will highlight a cell that is left blank?,
Dave Thomas
Auto Open Macro,
Launchnet
Re: Linking Data for Proposal,
Debra Dalgleish
Re: Converting Letter to Numeric Value,
Gord Dibben
Re: Timesheet formulas for three in/outs, OT, Holiday, Vac, Sick,,
Peo Sjoblom
- Re: Timesheet formulas for three in/outs, OT, Holiday, Vac, Sick,,
Kathryn Pundt
- Re: Timesheet formulas for three in/outs, OT, Holiday, Vac, Sick,,
Peo Sjoblom
- Re: Timesheet formulas for three in/outs, OT, Holiday, Vac, Sick,,
Kathryn Pundt
- Re: Timesheet formulas for three in/outs, OT, Holiday, Vac, Sick,,
Peo Sjoblom
- Re: Timesheet formulas for three in/outs, OT, Holiday, Vac, Sick,,
Kathryn Pundt
- Re: Timesheet formulas for three in/outs, OT, Holiday, Vac, Sick,,
Peo Sjoblom
Re: Retrieve data for previous 3, 6, 12 month given current month,
T. Valko
separate a text cell to many number cells,
Khoshravan
Re: using offset function,
T. Valko
Re: Problem getting values,
T. Valko
Re: Can IF do this?,
D.P. Roberts
Re: Remove Characters Until a Specific Character is Reached,
T. Valko
ActiveCell or ActiveSheet,
Launchnet
Re: How do I flag up duplicate data entry in an excel spreadsheet?,
T. Valko
Re: relation between 'items' en 'prices',
T. Valko
Re: Need to Count Occurences in Multiple Ranges,
T. Valko
how can I compensate this...pleass contribute...,
driller
Re: SUMIF Function,
Don Guillett
RE: conditional formatting with vba,
Barb Reinhardt
Re: Randomly sort a set group of integers,
Peo Sjoblom
Re: change "true" and "false" to "availble" and "out of stock",
Peo Sjoblom
Re: validation,
Peo Sjoblom
Re: Error.Type or IsError to trap #VALUE! and #NUM!,
Jim Cone
Re: Finding max and min in column,
Peo Sjoblom
Re: How do I use VLOOKUP to find part of string?,
Peo Sjoblom
Re: dot count,
Peo Sjoblom
Error Trying to add Calculated Items to a pivot table,
runsrealfast
Re: Excel Problem,
Harlan Grove
Re: How do a set a parameter in cell - choose A or B options?,
Don Guillett
Re: AND, IF, and SUM IF Functions,
Peo Sjoblom
Re: Average Selected Cells From a Range,
Peo Sjoblom
Re: Matching 2 columns,
PCLIVE
return partial string,
alex
Re: How to break out data combined in a single cell,
Max
Re: interest only loan amortization schedule,
Bernard Liengme
Re: IF Clause,
Bernard Liengme
- <Possible follow-ups>
- Re: IF Clause,
Don Guillett
- Message not available
- Message not available
Re: How to set One value from Multiple Lookup Value,
Bob Phillips
Type Mismatch Error - Help Please,
Launchnet
Re: Type Mismatch Error - Help Please,
NickHK
IF, between two numbers,
ADK
Counting Staffs Reports,
Greenwich_Man
Pivot Table Problems,
itibot
Re: Import data from 1 cell on 1 worksheet to othr cell(s) in another,
Arvi Laanemets
Re: count pieces of records meet conditions in different columns,
Arvi Laanemets
Re: Can the conditional format box be locked to the cell,
NickHK
Financial functions in excel,
Abhi
Re: can no longer insert new columns & unhide hidden columns,
Dave Thomas
Re: how to make value whole (remove decimal point),
Sandy Mann
Re: How do I delete everything after a / in a column?,
Rick Rothstein \(MVP - VB\)
Re: Excel Conditional Summing,
T. Valko
RE: Challenging formatting formula,
robnet
Re: Comparing Text,
Rick Rothstein \(MVP - VB\)
Lookup help (I think),
SueN . Pools
Re: How to assign a formula to a letter?,
Sandy Mann
Re: Calculating to add years - including leap year,
Peo Sjoblom
Re: Shorten the Excel Sheet,
Dave Thomas
Re: how do I cross out something in a cell to keep it visible,
Peo Sjoblom
counting x instances of a string across columns...,
ucdcrush
Re: How to count(if) column B IF column A says "x",
PCLIVE
Re: Loan Amortization Schedule,
Dave Thomas
Re: How do I make cells subtract?,
Dave Thomas
Re: How do I add more than 30 arguments in a formula,
Peo Sjoblom
Re: Excel Function IF AND,
PCLIVE
<Possible follow-ups>
Re: Excel Function IF AND,
Bob Phillips
Re: Excel Function IF AND,
Dana DeLouis
Re: Excel Function IF AND,
Dave Thomas
Re: Excel must display error message if two blocks don't have same num,
Peo Sjoblom
Re: Delete a Column when in a Macro-Worksheet Event?,
Peo Sjoblom
Pivot Tables,
lehigh46
Re: How do I replace text within a formula with a diff cell value?,
Peo Sjoblom
Re: VLOOKUP and OFFSET,
Peo Sjoblom
Re: sumproduct a whole column,
Bob Phillips
Re: cell contents,
Vasant Nanavati
Re: Create search in excel,
Vasant Nanavati
Re: How do i create a tick box in excel? 2003 version,
Vasant Nanavati
Re: Flipping a Spreadsheet,
Vasant Nanavati
Subtotaling minus negative numbers and posative numbers,
lehigh46
Re: how can I add degrees? ie 300degrees + 100 degrees = 40 degrees,
Bob Phillips
Re: How can i make numbers have text format without insering ' at each,
Harlan Grove
Re: =OR(IF(AND(....),HYPERLINK....,
Max
Re: FORMULA TO FIGURE AGE,
Dave Thomas
Re: help on averaging function - Yet another example of much ado about nothing.,
Dave Thomas
Re: populating a master worksheet with variables in other worksheets,
Dave Thomas
Re: Formatting and Possible Transpose,
Gord Dibben
Re: again,
Dave Peterson
Re: Importing Data,
Dave Thomas
Re: Getting more than one lookup results in array,
T. Valko
Re: help on averaging function,
Dave Thomas
- <Possible follow-ups>
- Re: help on averaging function,
Dave Thomas
- Re: help on averaging function,
MartinW
- Re: help on averaging function,
Chip Pearson
- Re: help on averaging function,
Dave Thomas
- Re: help on averaging function,
Chip Pearson
- Re: help on averaging function,
Dave Thomas
- Re: help on averaging function,
Harlan Grove
- Re: help on averaging function,
MartinW
- Re: help on averaging function,
Dave Thomas
- Re: help on averaging function,
Harlan Grove
- Re: help on averaging function,
Dave Thomas
- Re: help on averaging function,
Harlan Grove
- Re: help on averaging function,
Dave Thomas
- Re: help on averaging function,
Dave Thomas
- Re: help on averaging function,
Dave Thomas
- Re: help on averaging function,
Dave Thomas
- Re: help on averaging function,
MartinW
- Re: help on averaging function,
Meebers
- Message not available
- Re: help on averaging function,
Meebers
- Re: help on averaging function,
Harlan Grove
- Re: help on averaging function,
driller
i need help creating a function that will extract words from a string of text,
bradyk819
RE: Sumif or sumproduct,
Klee
Re: Find a Cell Value In a Range,
Rick Rothstein \(MVP - VB\)
Re: Date issue to automate calendar - So much ado about nothing,
Dave Thomas
Re: vlookup lookup_value,
Bob Phillips
Re: linked formatting,
Dave Peterson
RE: Need help please-SUMPRODUCT and Dynamic Range,
Tasha
Re: formulas populating dates - 1st Tuesday,
Dave Thomas
Re: dates and 1st Tuesday of month,
Sandy Mann
Re: Transpose cell contents from multiple worksheets into rows,
Dave Thomas
Re: Displaying a time value, conditionally.,
Bob Phillips
Re: Displaying the current system time - 2nd Try,
Dave Thomas
Re: IF LEN formula,
PCLIVE
Re: Date issue to automate calendar,
Dave Thomas
- Re: Date issue to automate calendar - elegance,
Dave Thomas
- Re: Date issue to automate calendar - elegance,
Peo Sjoblom
- Re: Date issue to automate calendar - elegance,
Dave Thomas
- Re: Date issue to automate calendar - elegance,
Peo Sjoblom
- Re: Date issue to automate calendar - elegance,
Dave Thomas
- Re: Date issue to automate calendar - elegance,
Rick Rothstein \(MVP - VB\)
- Re: Date issue to automate calendar - elegance,
Dave Thomas
- Re: Date issue to automate calendar - elegance,
Rick Rothstein \(MVP - VB\)
- Re: Date issue to automate calendar - elegance,
Dave Thomas
- Re: Date issue to automate calendar - elegance,
Rick Rothstein \(MVP - VB\)
- Re: Date issue to automate calendar - elegance,
Chip Pearson
- Re: Date issue to automate calendar - elegance,
Chip Pearson
- Re: Date issue to automate calendar - elegance,
Dave Thomas
- Re: Date issue to automate calendar - elegance,
Peo Sjoblom
- Re: Date issue to automate calendar - elegance,
Rick Rothstein \(MVP - VB\)
- Re: Date issue to automate calendar - elegance,
Peo Sjoblom
- <Possible follow-ups>
- Re: Date issue to automate calendar,
Peo Sjoblom
Re: How do I make a cell in Excel "blink" if conditions are met?,
Peo Sjoblom
Re: Make #N/A blank if no value is returned,
Dave Peterson
Re: Advanced filter dates and nulls,
Debra Dalgleish
Re: Worksheet protection with grouped rows?,
E Halliday
Re: how to count without included duplicate records,
Max
Re: advance level of sorting data? by Ting,
NickHK
Re: How do I press TAB and get Excel to move through certain grid ref,
MartinW
Re: Change :47:57 to 0:47:57,
Bob Phillips
Re: "list unique" instructions fr xldynamic site doent work,
MartinW
Re: Finding the list of the question I have asked,
T. Valko
Re: look up / match / reference cell,
T. Valko
compare dates using a variable,
old coach
Copy range and past on another sheet,
gumby
Re: an exact number if a number is less than,
Dave Thomas
Re: dynamic range and data validation,
Piscator
RE: How to automate datasheet stuffing?,
Billy Liddel
Re: Weekly average in pivot,
Roger Govier
Re: I, too, am having problems with SUMPRODUCT,
krcowen
Re: How to display empty text boxes,
Meebers
Re: Problems with the Right & Find functions Second Look.,
Dave Thomas
Re: Problems with the Right & Find functions,
Dave Thomas
Re: sumif functions based on multiple data,
Peo Sjoblom
Re: Shortcut for Referencing Tab Data?,
Dave Thomas
Correction to previous post,
Dave Thomas
Re: IF FORMULAS NEEDED,
Bob Phillips
Re: Problem with SUMPRODUCT....help please!,
Bob Phillips
Re: A formula to look for a value in a blok (eg E1:J10) data,
Dave Thomas
RE: formula to track timeframe by automatically highlighting cells,
maijiuli
average in excle,
jeff . white
Creating a macro to line up data in 2 worksheets.,
tennisash
Formula to return position of the next Non-blank cell in a column,
PCLIVE
DATEDIF() The hidden function - You may find it useful.,
Dave Thomas
Finding Non-Duplicates,
calibansfolly
Re: SUMIF Value error,
Dave Peterson
What may cause macro modules to be created by accident?,
herrdue
changing text values to a different string,
sparks
Re: CHAR funtcion with double letter columns,
MartinW
Re: OFFSET,
Arvi Laanemets
Synchronized combo box in excel form,
sunilkes
Re: 'name of spreadsheet' function... please help,
Bob Phillips
Re: Int'l R1C1 or R1K1 or L1C1...,
Harlan Grove
<Possible follow-ups>
Re: Int'l R1C1 or R1K1 or L1C1...,
Niek Otten
very green at this formula stuff?,
stirred2generosity
My Problem - Help Please,
Launchnet via OfficeKB.com
Re: Month Calculation,
Dave Thomas
Re: Date,
Dave Thomas
- Message not available
- <Possible follow-ups>
- DATE,
Jamal A M
Re: Test for outline level of cell,
Vasant Nanavati
=SUM returns 5.54365E-11 instead of 0 (zero),
Chwan Keng Ng
Re: Make it Simple!,
Dave Thomas
Re: Find last cell in column then SUM in cell directly below,
Dave Thomas
Re: #div/0 errors and blank cells,
Dave Thomas
Re: # of days in month,
Dave Thomas
Re: Extracting Data back and forth between Sheets,
Pete_UK
Re: test expression for empty cell in =SUMIF(),
Rick Rothstein \(MVP - VB\)
Re: Currency format,
Ragdyer
Re: SUM(ADDRESS(ROW(C2),COLUMN(C2),1,TRUE):ADDRESS(C14+1,COLUMN(C2),1,,
Pete_UK
Re: Procedure to change Column heading from R1C1 to A1?,
Gord Dibben
Re: how to use MS Excel 5.0 Dialog,
Dave Peterson
RE: Matching a value, which does not exceed Min or Max.,
Assad
Re: Creating a Work place time sheet.,
Rick Rothstein \(MVP - VB\)
Re: copy cell based on date,
Rick Rothstein \(MVP - VB\)
Next number function,
excel
Condition depending on tab colour,
excel
Update Formula's based on drop down list value,
Steven Taylor
Re: sum cells based on criteria in first set of cells,
T. Valko
Re: Countif,
T. Valko
- <Possible follow-ups>
- Re: Countif,
Rick Rothstein \(MVP - VB\)
- Message not available
Re: Countif,
Stan Brown
Re: Excel database function,
Bernard Liengme
Re: Help - VBA Password Lost,
Gord Dibben
- Message not available
- Message not available
Re: auto save feature in excel,
Gord Dibben
Re: Can I have a formula with inputs from multiple pages?,
Gord Dibben
Re: how do I generate lists in worksheets based on a master list works,
Sandy Mann
Re: how to sort a column of Randomly selected numbers?,
Bernd P
Re: Macro that Fills Sequential numbers,
JE McGimpsey
Excel Newbie...How To Re-Order Data,
Martin
Re: EXCEL Worksheet,
Peo Sjoblom
How many Standard Deviations above and below the mean each number is.,
pkaraffa
Re: Auto-tab,
Peo Sjoblom
Easy Question,
Bob
Re: = or,
Pete_UK
Re: Filter Totals in a Pivot table?,
Debra Dalgleish
Re: Excel 2007 - table style default,
Debra Dalgleish
Re: How do you create a pushbutton lookup control,
Otto Moehrbach
Re: Hyperlinks and Email Addresses in Excel,
krcowen
Re: Display scenario name,
Debra Dalgleish
Re: Repeat title to top of each worksheet,
Gord Dibben
Re: Sound File,
Bernard Liengme
Re: Updating a range automatecally,
Bernard Liengme
Message not available
Re: I want to change the column width on a spread sheet?,
David Biddulph
RE: maybe it's simple with macro for this one?,
driller
Re: How can I determine what the compound interest rate is,
David Biddulph
Drop down or Combo Box Help with VBA code and formula,
mwheelock
Re: How do I link a value into a sentence in Excel?,
T. Valko
Formula with color fill?,
Positive
Re: sumproduct? sumif(sumproduct)?,
T. Valko
Re: Sum many unconnected cells,
Peo Sjoblom
Re: SUMIF using color,
Bob Phillips
Re: I Then logic help,
PCLIVE
Linking Workbooks using file names in a range,
Mark T
plus 1,
alex
Re: My column cell values are -ve how do I make all cell value +ve,,
Dave Peterson
MROUND formula problem, help please!,
Ivica TypeR
Re: Sumproduct - sort of,
Roger Govier
- Message not available
- Message not available
Re: How do I change the font to all caps for the entire worksheet?,
Ron de Bruin
Re: Excel Solver constraints,
Dana DeLouis
Right-to-Left direction,
Ninad
RE: DBSUM function but with function as criterion, not a range,
Ron Coderre
Re: offset and Sum function,
Lars-Åke Aspelin
Re: Excel 2003 - setting the Comment font size default,
NickHK
Re: Networkdays function,
Bob Phillips
Re: IF functions,
Roger Govier
Re: make one cell identical to another,
Roger Govier
Re: creating pivot from a horizontal table,
NickHK
Re: selecting a row,
Trevor Shuttleworth
- Message not available
- Message not available
Re: Typing problem,
NickHK
read the values from a excel row,
shantanu
Re: Stripping text from numbers in a cell,
Ron Rosenfeld
Re: Status Bar box problem,
Gord Dibben
Re: Cosmetics Capitals,
Gord Dibben
Re: Worksheet Protection / Security from Viewing,
Gord Dibben
Re: Formulas in subtotal worksheets?,
Pete_UK
Re: Text to Number,
MartinW
Re: again here's my another problem,
Pete_UK
RE: shared advice appreciated,
driller
Re: Linking a single number or text to a cell,
MartinW
Re: Return the value in the last cell of the list,
T. Valko
Re: Using a dynamic pathname in VLOOKUP,
T. Valko
Re: row lookup formula,
PCLIVE
Re: formula to find all possible combinations,
D Hilberg
Re: Offset every # of Rows,
Alan Beban
Re: Combining one row into two,
D Hilberg
Re: Getting a response other than true/false with an IF formula,
Mark Lincoln
formula for Canadian postal codes,
LB
Re: How do i display a negative time as a res of distracting 2 times?,
vezerid
Help with excel array - select, add and calculate result,
clk008
Help with Excel array functions - select, add & return result,
clk008
Turn around Time,
instereo911 via OfficeKB.com
Re: Dragging formulas,
Peo Sjoblom
Re: How i display True/Fale in one or two colum,
Pete_UK
Re: If - then help.,
Rick Rothstein \(MVP - VB\)
Re: Inserting Buttons as Hyperlinks,
Ron de Bruin
Re: Excel 2007 sheet and workbook protection,
Ron de Bruin
Message not available
Re: Converting embedded objects in excel versus word,
Gord Dibben
Re: simple, counting the last character in text,
Rick Rothstein \(MVP - VB\)
Re: Excel: How to insert current time (static) to the nearest seco,
Roger Govier
Re: named range with criteria.,
Roger Govier
Re: allowed/taken,
Sandy Mann
Re: RANDBETWEEN in a conditional format gives error,
MartinW
Nested IF Functions with OFFSET,
worzell
Re: Countif with Dynamic date ranges.,
Bob Phillips
display a number in another cell,
Motherlulu
Inventory Control,
arran . mckay
Re: pivot tables for likert-scale type survey items,
Roger Govier
pmt function,
Jason Smart
Indirect Use of XLM in Excel 2000 and Prior,
Harlan Grove
Re: How do I show web addresses in Excel, rather than their name,
NickHK
Re: JIS / ASC Functions in Excel 2007,
NickHK
Re: excel: count uppercase letters in a cell,
Harlan Grove
Re: Is there a way?,
Max
Re: Conditional Format Formula Issue,
Bob Phillips
Re: delete macros,
Dave Peterson
Re: Do not paste in hidden cells,
Dave Peterson
Macro that Finds the First Value in a range using a Combobox (drop down menu),
mwheelock
Re: Formula not working,
T. Valko
RE: finding exact matches,
Gunnar Lysaker
Re: PROPER FUNCTION,
Peo Sjoblom
Annualize/ Estimate year-to-date from monthly expense,
Positive
Re: Macro do works in excel...,
krcowen
RE: Extending Logic beyond the numbers and into a Name! Is it Poss,
Dan the Man
Re: NZ function equivalent in Excel,
Peo Sjoblom
Re: Spss verse excel,
omnicrondelicious
Re: Form drop down list,
Debra Dalgleish
Re: If, vlookup, data validation & dependent list,
Bob Phillips
Re: 17 random numbers between 1 to 65,
Pete_UK
Re: Extract Middle Initial from Name,
Pete_UK
sorting excel data,
leonliev
Conditional Formatting,
Mudit . Archna
Re: Average with multiple conditions,
T. Valko
Re: Worksheet,
D Hilberg
Re: Trial Has Expired and I can't open spreadsheet created in trial -,
Gord Dibben
RE: How do I insert cells in a macro?,
JMB
Re: Formula / Counting,
T. Valko
Re: How do I link text from mulitple cells to another spreadsheet,
Gord Dibben
Re: How do I enter the same data no multiple cells with current data?,
Gord Dibben
Re: How do prevent your column widths from changing in Excel?,
Gord Dibben
Re: Pivot Tables and VLOOKUP,
Debra Dalgleish
Re: calculation in pivot table with value of a column,
Debra Dalgleish
Re: How do I maintain cell formatting when I export to a mail merge?,
David Biddulph
Re: range, cell refrence, but with a new twist,
T. Valko
Re: Formula Suggestion Please?,
Pete_UK
Re: Formula that compares data in adjoining cells,
Pete_UK
Re: Count IF/Sum IF,
Bob Phillips
Re: Calculate value in a text filled cell,
Peo Sjoblom
VLOOKUP insert rows,
Positive
Re: 2 Part Formula,
David Biddulph
Re: how do i change a formula to its value,
Peo Sjoblom
Need help with =IF formula,
Harvey
RE: Need a formula to look up 2 values and return result from 3rd,
klafert
Re: When copying dates, they change by 4 yrs & 1 day, why?,
Peo Sjoblom
Re: Two Separate Conditions for Cond. formatting,
VegasSageV
Re: Conditional Formula w/Date=Where did I go wrong?,
Bob Phillips
- Message not available
- Message not available
- Message not available
Re: Formula finding last cell in row containing data,
T. Valko
Re: change fill color in 2 cells when data entered in one,
T. Valko
- Message not available
- Message not available
RE: any macro,
driller
RE: Cell Refences,
Instructor Cloud
Long formula,
Sandy
Re: sumproduct spanish version,
Peo Sjoblom
Re: #N/A value is returned,
Peo Sjoblom
randbetween(1.1,1.25),
Deniz
vlookup glitch,
Marlene
paste special / skip empty cells doesn't work!?,
Ivica TypeR
Re: I need a formula to calculate rates based on current age,
Peo Sjoblom
Re: Identify New Added Rows,
Don Guillett
Re: Import data from a website to excel,
Don Guillett
Re: Edit numerous cell entries,
PCLIVE
Re: VLOOKUP Question...,
Bob Phillips
RE: Moving values from one colum to another when there is spaces b,
Lii Hadin
Modified:-> Macro to Generate a new Column!!!,
Inder
Re: how get many days in March repeate in column have many dates,
Bob Phillips
RE: Rank,
Jock
Re: Dependant Data Validation - for Whole Column,
Bob Phillips
Macro to generate a new column denpending upon existing one!,
Inder
Re: Convert Function,
Vasant Nanavati
Re: Using a single cell refernce to change multiple formulas,
T. Valko
Worksheet disappear when saving on shared workbook,
jjuan
Re: Microsoft Excel Sheet,
vishwa
Re: combining sheets from different files into one file?,
Ron de Bruin
Re: How to set up variable data ranges in nested functions,
Max
Re: Return Value of last cell in column with a value in Excel?,
Peo Sjoblom
Problem with getting numbers in some range values!?,
Ivica TypeR
Re: Vlookup value of #NA,
Dave Peterson
Re: Leading "0",
David Biddulph
Re: Negative Numbers in a Pivot Table,
Dave Peterson
Re: any formula,
Dave Peterson
Re: Export Explorer Metadata to Excel,
Gord Dibben
Formula Disappears, converts to a value,
shumbert
Re: deleting the blank rows from the sheet,
Gord Dibben
Re: Subject: return a result from multiple conditions.,
Peo Sjoblom
Re: How do I reference an empty cell in a formula?,
Vasant Nanavati
Pivot table aging report sort order,
Pierre
Re: How do I print certain (specifics) columns in Excel spread sheet?,
krcowen
Re: Extract first second "word" from a Cell..,
Rick Rothstein \(MVP - VB\)
Re: Make each tab/worksheet into a separate document,
Peo Sjoblom
RE: Recalculating in a circular reference,
John
Formatting a number,
Michel Khennafi
Re: Sorting the spreadsheet!,
Dave Peterson
Re: automatically update macro,
Dave Peterson
Re: Clear Contents Of Cell If Value = 0 or Error,
Susan
Re: Dynamically Megre/Unmerge Cells,
Dave Peterson
Re: Please Help...,
Bob Phillips
DSUM criteria,
Edward
RE: finding and summing data in somewhat complex matrix.,
Willem
Re: Ignoring #N/A in an Autosum range,
Bob Phillips
Re: Can you convert this formula to 2003 from 2007?,
Bob Phillips
Prohibit manual entry via Drop Down,
Sean
Similar to paste special from another workbook,
animeshhere
Re: Excel file size too large,
Arvi Laanemets
Re: Rounding up for a decimal,
T. Valko
Re: Excel Formulas,
T. Valko
Re: Referencing a different tab according to a formula result,
T. Valko
Re: Protect Workbook,
Gord Dibben
Re: How can I handle negative time values?,
Ron Rosenfeld
Re: Formula,
T. Valko
Pivot Table - How to keep data hidden,
uteitler
Paying fee to someone who could extract data from web-page to excel!,
Ivica TypeR
Re: Federal tax withholding calculations - using IF statements..?,
joeu2004
Re: remove hyphens from a list of part numbers,
Jim Cone
IF 5 years old by Dec 1 they will start Kindergarten,
debbiep@xxxxxxxxxxxxxxxxxxx
Re: sumif between dates (quarters),
Sandy Mann
Slightly OT (Maybe) printing problem,
Meebers
Re: Get list of row #s with certain value,
Max
Re: Vlookup,
Rick Rothstein \(MVP - VB\)
Re: Update reference in multiple formulas,
Sebation.G
Re: Conditional Formatting for Duplicates,
Trevor Shuttleworth
Re: coefficients of trend line,
joeu2004
Re: range,cell refrence,
T. Valko
Re: Does excel have text effects?,
Dave Peterson
Re: invisible color,
Pete_UK
Re: IF function results not displayed in cell,
T. Valko
PivotTable question about grouping numbers in it,
Ivica TypeR
Re: Formula HELP,
Rick Rothstein \(MVP - VB\)
RE: Maximum Columns in Worksheet,
Toppers
Re: How to calculate bond value and current yield,
Don Guillett
Re: How to use goal seek,
Niek Otten
Re: Relative Cell References When Linking,
Stan Brown
conditional formating,
nk
Re: formulation setup() from 2003 good for 2007,
Roger Govier
Re: Array Formula and 2 Tabs!,
Dan the Man
Re: personal.xls,
Vasant Nanavati
Re: Formula to subtract a $ value based on specific date,
Pete_UK
Negative Column ????,
DB
Get highest value and adjacent cell value,
Ardy
Return Cell Address of MIN value - array formula,
todd . huttenstine
Re: conditional formula in Excel,
Pete_UK
Re: I'm still confused,
Pete_UK
Excel Formula,
bambi4thomas
Re: How can I combine data from two sheets where field contents match?,
Pete_UK
- Message not available
- Message not available
Re: Deleting a consistant portion of all cells in a given column,
Rick Rothstein \(MVP - VB\)
Re: How can i randomly select 780 rows from 4000 rows of data,
Bernd P
Re: referencing a different tab by referencing a list in the current s,
T. Valko
Re: Adding blank rows between groups of similar names,
Bob Phillips
Formula Cannot Be Converted - Function Not Available,
Thomas M.
RE: Need to find highs and lows formula and how-to,
JRod
Re: is there a formula to count something like this....,
T. Valko
Re: copy graph from a Worksheet based on a field in another Worksheet,
Pete_UK
Re: Assigning numerical value,
Pete_UK
Re: Adding percentages,
vezerid
Re: 'COUNTIF' and 'AND",
vezerid
Re: Dynamic Formulas,
vezerid
Reference Previous Worksheet Built-in Function,
ryanmhuc
Re: Excel work Book Order,
Dave Peterson
Re: Automatic value is malfunctioning,
Roger Govier
Re: Excel function,
Bob Phillips
Help to rename files,
Hilton
Re: please help with formula for same cells in different sheets,
Ali
Re: Add one more criteria,
Bob Phillips
Re: seperate field,
Trevor Shuttleworth
Re: spreadsheets,
Peo Sjoblom
Re: find matching text,
Harlan Grove
RE: Is there a formula to capture data between "Tabs" on a spreads,
Dan the Man
- Re: Is there a formula to capture data between "Tabs" on a spreads,
Roger Govier
- Re: Is there a formula to capture data between "Tabs" on a spreads,
Dan the Man
- Re: Is there a formula to capture data between "Tabs" on a spreads,
Roger Govier
- Re: Is there a formula to capture data between "Tabs" on a spreads,
Dan the Man
- Re: Is there a formula to capture data between "Tabs" on a spreads,
Roger Govier
- Re: Is there a formula to capture data between "Tabs" on a spreads,
Dan the Man
- Re: Is there a formula to capture data between "Tabs" on a spreads,
Roger Govier
- Re: Is there a formula to capture data between "Tabs" on a spreads,
Pete_UK
- Re: Is there a formula to capture data between "Tabs" on a spreads,
Pete_UK
- Re: Is there a formula to capture data between "Tabs" on a spreads,
Dan the Man
- Re: Is there a formula to capture data between "Tabs" on a spreads,
Roger Govier
- Re: Is there a formula to capture data between "Tabs" on a spreads,
Roger Govier
- Re: Is there a formula to capture data between "Tabs" on a spreads,
Dan the Man
- Re: Is there a formula to capture data between "Tabs" on a spreads,
Pete_UK
Re: cannot remove read-only from a file,
Vasant Nanavati
Re: count if on Visible - Filtered,
T. Valko
Re: Match and Lookup,
Pete_UK
vlookup formulas,
smprfii
MAX returns correct column, but row -1?,
Ryan
RE: Calculating productivity: widgets per hour,
JLatham
Re: Page Break Column Headers,
Stan Brown
Re: Quiero usar la funcion buscarh buscando un valor distinto de 0,
Harlan Grove
Re: averages without zero,
Stan Brown
Re: CONCATENATES,
Dave Peterson
Re: EXCEL CLOSES,
Dave Peterson
Re: File Size Function,
Rick Rothstein \(MVP - VB\)
Re: Help avoiding a circular reference,
Harlan Grove
Re: Change time format from :0 to 0:0,
Sandy Mann
Re: Sumproduct with OR,
Sandy Mann
Re: Create a credit (negative) column in Excel?,
Gord Dibben
Organizing data to sort in a spreadsheet.,
Dave Stitz
Re: Saving file using value in cell as the filename,
Gord Dibben
Re: Average with #div,
Chip Pearson
Re: Combining Worksheets,
Ron de Bruin
Re: How can excel 2000 users open a 2007 .xlsm workbook,
Ron de Bruin
Re: I need to sum the last column - is there a formula for this,
Dave Peterson
- Message not available
- Message not available
Re: Keep Same Cell Reference,
Gord Dibben
Re: Does a number exist in a range,
Rick Rothstein \(MVP - VB\)
Re: how to identify unique list of 200 random entries from a list of 3,
L. Howard Kittle
Re: create new paper size,
Gord Dibben
Largest value in Col B for each unique value in col A,
calibansfolly
Re: Clear Contents Of Cells Where Value = 0,
Gord Dibben
Re: Reformat spreadsheet,
Roger Govier
Re: Is there a way to require a cell to be completed in Excel?,
Malcolm Austin
Re: How can I calculate a due interest of annuities for a certain peri,
joeu2004
Re: Is it a formula or input data?,
Gord Dibben
Re: How to insert a space between display results,
Gord Dibben
Re: Reference a Worksheet Tab in Formula,
vezerid
Re: function add ins for english language,
Bob Phillips
Re: Need a way to determine the # of Saturdays in a month,
Don Guillett
Assign values to find Current Month in a Range,
sharann via OfficeKB.com
Re: Insert Row "Missing" from my list,
Sandy Mann
Re: How to convert a static formula to dynamic formula ?,
Bob Phillips
Re: Find lowest 3 values and sum,
Pete_UK
Re: A Formula for tracking Data on It's own tab in my spreadsheet?,
Pete_UK
Maybe a macro or whatever can do this easily...,
driller
Re: Vlookup Returning #n/a,
Pete_UK
Sumif banding on a condition,
stuart
Re: conditional formula,
Gord Dibben
Message not available
Re: Multiplying non consecutive rows, then adding it.,
Pete_UK
Re: Finding highest values,
Pete_UK
How to extract right-most word?,
nomail1983@xxxxxxxxxxx
Transferring cell contents from selected rows only.,
Colin Hayes
Re: Inserting a range of cells,
vezerid
Re: Too many nested IF functions!,
Matthew
Re: Scoring three groups, each with 6 levels,
Sandy Mann
Re: automatic copy of results to another page,
Don Guillett
Re: Linking a selection in a drop down list to a calc in another cell,
Roger Govier
Sorting,
Arun Kumar Saha
Re: Find/Replace External Data Web Query,
Don Guillett
time,
bob
Re: Converting hours over 24 into decimal format,
Pete_UK
SUMIF ?! .... not quite enough....,
WhytheQ
Re: User time input,
Bob Phillips
Message not available
Hide / UnHide - is there a Function to automate this ?,
Andrew Duncan
Re: Gray Out Expired Records,
Peo Sjoblom
Re: How to fill a blank cell down to a filled cell,
Peo Sjoblom
Re: min, dmin, etc,
T. Valko
Re: Finding tops and bottoms using stock data,
Peo Sjoblom
Re: If & Array,
Peo Sjoblom
Re: Vlookup derived wrong value,
T. Valko
Re: How do I create a first page index of worksheets in my workbook?,
Jim Cone
excel 2003: how to match records of 2 tables according to 2 columns?,
nk
Re: creating numbers to a fixed length string...,
Gord Dibben
Re: how to create macro to use cell references for data filter cri,
scshop
Re: Can excel export to an organizational chart?,
MyVeryOwnSelf
Re: Help with Formula,
Pete_UK
Re: Return Text or Blank,
T. Valko
RE: Autofill columns,
pdberger
Working with Time,
Diane
Re: how to encirle a word,
Vasant Nanavati
Re: Huge sum function formula,
T. Valko
Workbooks.Open Filename,
Konczér Tamás
Re: IF, OR, AND FUNCTION HELP,
joeu2004
Re: Bring Forward Balances and Formulas in a Spreadsheet,
Susan
Re: how do i change (or add) colour to the worksheet tabs (in excel),
Peo Sjoblom
Re: Sumproduct to find monthly bonuses,
Peo Sjoblom
Re: hiding huge formula's in an excel sheet,
Pete_UK
read data from a cell absolutely,
Andrew Duncan
Re: Formula to return blank,
Peo Sjoblom
Re: How to make the First alphabets in the cell to be blank.,
Peo Sjoblom
Re: Searching two columns for information,
Peo Sjoblom
Re: Using IF to find text + wildcard?,
Rick Rothstein \(MVP - VB\)
Re: MegaStat Add-In,
Gord Dibben
RE: How i can set two different rows as header and footer,
JLatham
Re: Excel to form email in outlook,
Ron de Bruin
countif multiple conditions,
gerryR
autopopulate multiple users personal info,
Kreg
EXCEL MAXIMUM VALUE AND VLOOKUP NESTED?,
Edu
Quick solver question,
Keith R
Re: sumproduct last 30 rows,
vezerid
Re: Summation question,
Bob Phillips
Re: Index to define a range,
JE McGimpsey
Re: Excel, how to copy conditional formats in sequential order 1,2,3,
JE McGimpsey
Re: How do I?,
Sandy Mann
Macro for a Pop-Up Box help....,
neilcarden
Re: Capturing a word sequence as part of a text in a spreadsheet cell,
Ron Rosenfeld
Re: reorganize string,
Bob Phillips
Using Index & Match functions to find data on separate worksheet.,
Andrew Duncan
Using Named Ranges with Charts: Part 2 (!),
artisdepartis
Re: Difficulty displaying text,
Max
Re: Date format in a text string,
T. Valko
Re: Use of the Contents of a cell as a worksheet name in a function,
T. Valko
Re: Help with editing a formula,
Roger Govier
Utilizing a Cell even with a Formula located inside it,
Ahh, Excel's Tough
Re: calculate various cells to acheive a specific value,
Jennifer_C via OfficeKB.com
Re: My formula is =Sum(E38). How can I add text to the formula?,
joeu2004
Consolidating with empty-string ("") cells removed,
Thomas Toth
Making a Formula Contingent on Check Boxes,
mwheelock
Re: Data validation dependencies,
Bob Phillips
Re: My formula is =Sum(E38). How can I add text to the formula?,
Niek Otten
RE: Goal Seek Algebra Formula,
driller
Re: Need formula,
Pete_UK
Re: Adding bytes, gigabytes, and megabytes in Excel,
Pete_UK
Re: Sum the first x cells in a range,
Peo Sjoblom
qn on counting in drop down menus and protecting/hiding specific worksheets,
qiong
SUMPRODUCT formula messed up,
Positive
Re: Look up 2 values, return result in a different workbook,
Positive
Re: Counting for unique values using 2 cells,
T. Valko
RE: sumproduct formula,
Todd
Re: Rename Sheet using Cell Reference,
Peo Sjoblom
Re: how to insert a special character (arrow) in IF statement,
Scoops
Re: concatenate link,
Scoops
Re: Solver Help,
brownti via OfficeKB.com
Re: Auto Fill days of the month (not including weekends),
Bob Phillips
URGENT: Using Named Ranges with Chart Wizard,
artisdepartis
RE: Split text to multiple cells,
Lauren H
Is there a better formula than this Q,
Sean
RE: Dollar / Euro sign,
Yendorian
Re: static date,
Stan Brown
Re: One more try!!,
Pete_UK
Showing Cummulative Top5 results with an array-formula...?,
Jen
- Re: Showing Cummulative Top5 results with an array-formula...?,
Bob Phillips
- Message not available
- Re: Showing Cummulative Top5 results with an array-formula...?,
Jen
- Re: Showing Cummulative Top5 results with an array-formula...?,
Bob Phillips
- Re: Showing Cummulative Top5 results with an array-formula...?,
Bob Phillips
- Re: Showing Cummulative Top5 results with an array-formula...?,
Jen
- Re: Showing Cummulative Top5 results with an array-formula...?,
Bob Phillips
- Re: Showing Cummulative Top5 results with an array-formula...?,
Max
- Re: Showing Cummulative Top5 results with an array-formula...?,
Bob Phillips
- Re: Showing Cummulative Top5 results with an array-formula...?,
Jen
- Re: Showing Cummulative Top5 results with an array-formula...?,
Bob Phillips
- Re: Showing Cummulative Top5 results with an array-formula...?,
Max
- Re: Showing Cummulative Top5 results with an array-formula...?,
Jen
- Re: Showing Cummulative Top5 results with an array-formula...?,
Toppers
How to,
George the drummer
Re: How do I get my rows and colums to show up when printing??,
Gord Dibben
Re: SPREADSHEET,
Harlan Grove
data validation with a formula,
LabrGuy Bob R
Re: can i add colours cells only in excell,
Gord Dibben
Re: Formula to identify character formatting (bold, italic, etc),
Peo Sjoblom
Re: Insert a progressive invoice number,
Pete_UK
Re: Index & multiple sheets in one workbook,
Pete_UK
need help please inserting multiple rows based on cell value then copying to data sheet,
tech
Re: Calculating the sum if two criteria are met?,
Bob Phillips
Re: Inserting a Row,
Chip Pearson
Re: Validation - clear blanks from drop down,
David
Re: Ignore Blank in Validation not working,
Bob Phillips
Re: Can I use an array formula with multiple criteria in the same,
Ron Rosenfeld
Re: I want result of a function in the cell and not the function itsel,
Gord Dibben
Re: Average of only cells containing numeral value,
Stan Brown
Re: Index function - problem copying to other cells,
Niek Otten
RE: Problem with IF statement,
Tanya
RE: calculating sample sizes for independent groups,
Billy Liddel
RE: Does loop function cause this problem?,
Eric
Re: Returning a column name or number,
T. Valko
RE: Challenging Formula. Need help with writing a formula,
Joel
Re: Array Formulas with multiple criteria in the same row?,
Ron Rosenfeld
Re: Can I use an array formula with multiple criteria in the same row?,
T. Valko
Re: Referring to Sheet locations in a formula,
T. Valko
Re: Showing Top 30 with array-formula?,
Ron Rosenfeld
Re: Multiple Lookups - SIngle Result,
T. Valko
