microsoft.public.excel.worksheet.functions
- Re: This function returns incorrect value sporadically,
T. Valko
- Re: V_Lookup question!,
T. Valko
- Re: How can I merge and link workbooks into one summary workbook?,
Ron de Bruin
- Re: Another Cool Macro,
Jarek Kujawa
- Re: Excel worksheet,
Spiky
- Re: FORMULA, DAYS WORKED TO VACATION DAYS,
Ron Rosenfeld
- Re: Percentage ranges within data range - help needed,
Spiky
- RE: if formula,
Mike H
- Activate second macro only after the first macro is run,
Ruchir
- Re: Mann-Whitney U test,
Pete_UK
- Re: Using Autofilter to exclude dates,
Reitanos
- Re: Difference between 2 cells (growing column),
MyVeryOwnSelf
- Re: Additional Columns past IV?,
Peo Sjoblom
- Re: Lookup formula?,
Glenn
- RE: Min Values minus 18 months,
Mike H
- RE: Find Function,
Jeff Gross
- Re: Using LARGE function with criteria,
RagDyeR
- skipp blank cell,
Sanjiv
- For Mr. RagDyer please,
ytayta555
- Re: Conditional format when text contains using cell reference,
Glenn
- Pivot Table Calculations,
Neanderthal
- RE: Excel PERCENTRANK help,
Erica.DC
- Networkdays to open previous day's file,
Dave
- Re: Can I use solver for this?,
Dana DeLouis
- I Need get work this formula,
ytayta555
- RE: VLOOKUP - MULTIPLE RETURNS,
Stingz
- VBA code to hide blank rows,
ub
- Re: Sum multiple worksheet sales data by month,
Bob Phillips
- Re: Summing Problem In A Pivot Table,
Fred Smith
- Re: Sumproduct calculation for January 09,
Pete_UK
- Re: Filter on more than one cells (text),
Pete_UK
- need help mutiple worksheets to create monthly report sheet,
tedt
- Re: Quick way to change file name,
Pete_UK
- Re: Formula using worksheet names,
Pete_UK
- macro help to change row colour automatically,
angel
- Re: Counting time,
vsoler
- Complex cost allocation formula,
vsoler
- Re: Identify missing numbers in list,
T. Valko
- Re: Data Base Functions,
Infinitogool
- Re: Filtered Data-Linking,
Pete_UK
- RE: Need help with an IF formula,
Michael M
- Cell offset issue,
MGarrison
- Re: Using a function/formula for copying text,
Max
- Re: VLOOKUP formula results strange after copying down,
CaptSpify
- Re: Count a range of cells using an IF,
Max
- Re: Formula with multiple variables,
Pete_UK
- Re: Sum Time.,
robzrob
- Message not available
- <Possible follow-ups>
- Re: Sum Time.,
Peo Sjoblom
- Message not available
- Message not available
Re: Rounding Time.,
David Biddulph
- Message not available
- Message not available
Re: List of when functions where added,
Ubentook
Re: Decimal to Time Format.,
David Biddulph
How to check previous entries in column for same contents,
Emily
Re: Need help with this formula,
Don Guillett
Re: How do I count sets of cells in two columns?,
robzrob
RE: Need Function for Year-to-Date spent total,
Barb Reinhardt
Picking up data from workbooks which may not exist yet,
robzrob
Re: VLOOKUP question,
Niek Otten
Re: count if with multiple criteria,
RagDyer
Re: Product - Conditions - Edited Results,
Bob Phillips
Re: left and right functions,
Glenn
Re: Conditionnal Formatting,
Glenn
Re: Determining work hours between dates / hours,
David Biddulph
Can be here some changes for a faster speed ?,
ytayta555
NETWORKDAYS formula,
Susan
Re: Averages,
Bob Phillips
- Message not available
- Message not available
- <Possible follow-ups>
- Re: Averages,
joeu2004
match values in two column and return value in,
PW
RE: Pulling Data from External Worksheets,
Jim Thomlinson
Re: Vlookp-matching names between sheets,
Pierre
Need function that will work in Excel 2003 like "Countifs" in 2007,
RD
RE: Enter a User Name When Changes are Made,
Gary''s Student
putting help text in the animated bubble,
Pete Derkowski
Re: iferror,
Infinitogool
Re: Lastrow,
ryguy7272
formula for unique values,
bridgeb3
Re: Better performance Vlookup or Index/Match?,
Infinitogool
Re: Add days to a date, but exclude holidays,
Bob Phillips
- Re: Add days to a date, but exclude holidays,
Chickadee
- Re: Add days to a date, but exclude holidays,
John C
- Re: Add days to a date, but exclude holidays,
Ron Rosenfeld
- Message not available
- Re: Add days to a date, but exclude holidays,
Ron Rosenfeld
- Re: Add days to a date, but exclude holidays,
Bob Phillips
- Re: Add days to a date, but exclude holidays,
Ron Rosenfeld
<Possible follow-ups>
RE: Add days to a date, but exclude holidays,
John C
Re: Add days to a date, but exclude holidays,
Pete_UK
Re: Determining the text mode from a variety of data types,
Pete_UK
Re: Functions for inventory,
J-LL
Re: Round to the nearest minute if more than 6 seconds,
Infinitogool
RE: Work Sheet Association,
Gary''s Student
Excel showing files as read only , when they aren't.....,
Colin Hayes
RE: Pop Up Message,
Mike H
Re: count number of instances a number occurs,
Pete_UK
Re: Min Function,
Don Guillett
How to use the IF Function for 3 conditions,
tech1NJ
Find duplicate, but only if an adjacent cell is identical,
stevewy
Re: can assign a picture to a cell ?,
Ken Johnson
RE: Fill color with if function,
Mike H
RE: Names and addresses,
Steve
1st sheet,
Tia
RE: HELP linking access table to excel,
greg
find and Summarize data in a table from a different sheet?,
Richard Z SF
RE: sorting problem.,
John C
RE: Excel conditional sum,
John C
Previous visible cell,
Fred
Re: SumProduct?,
RagDyer
Function indicating a row have empty value on several columns,
Aline
Re: two variables to get result,
T. Valko
Macros in Excel,
Cheryl
cheapestsell@hotmail.com sell cheap NHL NFL MITCHELL NFL PRO BOWL&SUPER NBA NBA children MLB NBA jerseys t-shirt shorts,
cheapestsell
display.. help,
angel
Re: lookup and display,
smartin
RE: when I enter a number, only ###### shows?,
Joe Mac
Simple problem with Dates and Times is driving me nuts,
BingBong
Re: Make cell contents blank upon opening worksheet,
Max
cell reference formula,
BBB
Re: help with pivot tables,
Infinitogool
Calculating the value of a cell from another cell,
GPark1018
Re: index(match) Wind Uplift Calculations (match four conditions),
JMeier
RE: Display row of the maximum in a list,
Marcelo
Rolling Monthly Average,
Colin Hayes
RE: How to Change Column Header from numbers back to letters,
FSt1
average formula,
hserphillips
How to Combine Cells using Other Cell,
pll
RE: Filter by Date of Birth,
M Kan
Re: IF function,
Reitanos
RE: Formula being replaced by =#N/A,
VoxBox-Richard
How can I calculate total spend on items that have different values,
gorbash . uk
Re: Exporting list from Excel to PP, I want a new slide for each cell,
Reitanos
Re: HOW CAN DUPLICATES BE DELETED,NOT FILTERED?,
Anna
Re: MATCH working but not....,
Max
Counting Records Between Two Dates,
Stevo
Re: Summing between two dates,
Max
RE: how to make a cell mandatory in the excel sheet,
Gary Brown
Re: Excel not correctly calculating formula,
Pete_UK
Re: How to check if a date falls within a range(2 cells: Start/End Dat,
Pete_UK
Re: If with multiple or,
Pete_UK
Re: Lookup Function Not in Ascending Order,
Pete_UK
Re: Multiple Data Validation,
Bob Phillips
Re: convert US dates to UK dates,
Pete_UK
Is it possible to filter using row height in Excel,
xBRITO
Apply a percentage factor to a base number,
Southern Kiwi
Re: sumproduct help.,
Max
IF function? to turn around answers in questionaire,
Windav
Re: Adding sums from different worksheets,
Pete_UK
Re: Regarding Formula for Date and time,
Bob Phillips
RE: Copy & paste block of text number of times equal to value in cell,
ryguy7272
Re: displaying the correct value.,
T. Valko
Re: INDEX / MATCH with SUMIF/COUNTIF/SUMPRODUCT Statements?,
RagDyer
Re: Lowest two values,
Pete_UK
Lookup Formula Question,
JWNJ
MS Excel 2007,
sherrysboyfriend
Need to report a count that meets multiple criteria.,
tkm
Re: How do I use a variable as a reference to an array in INDEX,
T. Valko
Still need help with IF and Count Function,
Vicki
Re: Count if problems,
T. Valko
Re: Excel worksheets,
Peo Sjoblom
Re: How do I format cells as custom and keep text formatting?,
Peo Sjoblom
Re: excel 2007 formulas,
T. Valko
Creating a data entry form in excel,
Seaside Nutty
How to use the IF function to resolved more than one creteria,
tech1NJ
Re: How to combine two columns into a new column,
Spiky
Re: Cell Paste using cell link option Half works,
Spiky
Re: If Statement On Two Conditions,
T. Valko
Re: Write a formula using two arrays, across two worksheets,
Lars-Åke Aspelin
- Re: Write a formula using two arrays, across two worksheets,
Vicki
- Re: Write a formula using two arrays, across two worksheets,
Lars-Åke Aspelin
- Re: Write a formula using two arrays, across two worksheets,
Susan
- Re: Write a formula using two arrays, across two worksheets,
Lars-Åke Aspelin
- Re: Write a formula using two arrays, across two worksheets,
Susan
- Re: Write a formula using two arrays, across two worksheets,
David Biddulph
- Re: Write a formula using two arrays, across two worksheets,
Susan
tracing precedents,
Ricardo Monroy
RE: Deleting/Sorting,
StumpedAgain
SUMIF,
Brad Bross
Re: Lookup automatically specified arrays,
Spiky
Problem with IF Statement,
M Peddle
Re: Help required,
Spiky
Conditional Formatting in Excel 2007,
neillstoddart
Ignore blank cells when calculating date for If, Then function,
AndreaS13
Re: Exporting data,
Otto Moehrbach
Re: VLOOKUP(),
Don Guillett
Not allow data to be entered beyond a specified row.,
Cassie
RE: Search for data and return cell reference,
Gary''s Student
lookup or vlookup,
jamalhakem
Using auto filter after my worksheet is protected,
LY
Calculate the time difference excluding weekends and out of business hours ( i.e. 8AM - 5 PM),
joshi . sadanand
Re: How we convert number in to word,
macropod
Re: Different password for different worksheet,
macropod
Re: all dates in a column have gone back four years,
macropod
Password,
Gitano
hlookup,
mtitanium
Vlookup with multiple corresponding values,
Dudeone
Re: Summing by weeks,
Scopar
RE: Find & Replace - Limit search to a specific column,
falena23
RE: Report Function,
Wigi
Re: protecting worksheets,
Otto Moehrbach
Re: Multiple If Statements in the same cell,
Don Guillett
Adding Rows,
leimst
file names,
Esradekan
Re: Freezing Panes,
Rick Rothstein \(MVP - VB\)
Re: Break a forgotten worksheet password,
Peo Sjoblom
Re: AVERAGEIF,
T. Valko
Re: How do I link cells from one excel worksheet to another?,
Gord Dibben
Freeze a title only,
Judy Kay
capturing all of the data,
jimbo
RE: WORKDAY() results appear to be inconsistent...,
Mike H
finding out denominations.!,
via135
Need help creating formula for given data,
Need Assistance! Please Help!
Re: How do I copy a VLOOKUP into a column and keep a constant array?,
Lars-Åke Aspelin
Formula Not Working,
JBoyer
Re: difference between exel 2003 and 2007,
David Biddulph
RE: Alphanumeric,
hardeep via OfficeKB.com
Re: Formula for multiple cells,
Rick Rothstein \(MVP - VB\)
Formula for Adding cells up,
Raich
Re: TABBING BETWEEN PARTICULAR CELLS,
Ragdyer
Re: ANOVA with two factors,
NoodNutt
Need Help on formal - output a sum,
Deiow
Re: Auto Sum entries in a cell,
Gord Dibben
Re: Replacing ISERROR Formula,
RagDyer
Re: Variable named range in worksheet function,
Peo Sjoblom
Re: INDEX using range,
T. Valko
Msnstockquote,
tfjr
Re: Formula greater than,
T. Valko
Excel Script to Auto pick next,
Jay Bowers
Trying to get work days out of two dates,
erick-flores
Re: Caps formular please help,
Pete_UK
Need help with formulas,
Rita
RE: Excel Spreadsheet,
JLatham
Re: Lookup MIN Date,
Pete_UK
Seperate Cell contenets in to different columns on basis of leading spaces,
vgondia
Re: Associating a STATE or TIME with a phone number,
JE McGimpsey
Total rows allowed on spreadsheet 2007 version,
Babyjsmom
remove #n/a from the columnI've used a function,
Sue
Linked sheets, blank cells and adding new rows,
CharlieJane
Re: VLOOKUP for multiple colums,
Pete_UK
Re: Using Countif with multiple worksheets,
Peo Sjoblom
Multiple Lookups in one Cell,
lehigh46
Need something other than IF function,
PrinceAli
RE: Logical if more than 7,
vmohan1978
Re: Counting the ones, twos and threes - Please Help,
Peo Sjoblom
vlookup() function,
harsh_njoy
Shared Document & Hyperlinks,
chickalina
Re: large amount of data moving to excel,
Pete_UK
Re: new to excel need help with function,
Pete_UK
Re: HOW CAN I MERGE MULTIBLE SHEETS TO 1 SHEET,
NoodNutt
Re: Enter a value in wks1-Find that value on wks2-Auto fill cells in w,
Pete_UK
Simplification of IF Statement,
NoodNutt
Re: just wondering, do they have smthing called XMIRR,
David Biddulph
RE: alphabetize ignoring hyphen,
Mike H
create a summary sheet,
Tia
Calculating present age if date of birth is given.,
harsh_njoy
Excel 2007 lookup problem continuing ...,
Trish
getting list of files,
Esradekan
Re: Average if and networkdays,
T. Valko
Re: Use Len and Left to make name 3 letters,
T. Valko
How to ID numbers in Excel sheet that add up to specific sum?,
Kassira
Re: How to use LEN & LEFT on last name to show only 3 letters,
Pete_UK
Re: using error type and if statement to return a value.,
Bob Phillips
Re: Using IF and date ranges,
Bob Phillips
MODE - Second most frequent value,
Sam via OfficeKB.com
Re: COUNTIF,
Rick Rothstein \(MVP - VB\)
- Message not available
- Message not available
- Message not available
Re: VLOOKUP,
Gord Dibben
RE: DATA VALIDATION,
Wigi
Re: how to make an IF function that has the same result as COUNTIF?,
Peo Sjoblom
RE: need help with sumif function,
Gary''s Student
Re: can i create formula to make cell PLURAL if other cell is >1?,
David Biddulph
?Advanced? Hyperlinking,
PurchaseGuy
Re: setting multiple conditions in one cell,
Don Guillett
Re: excel won't save the border lines,
Spiky
Re: formulae corruption in excel,
Spiky
Conditional Formatting qn,
Trisna Lim
Re: Scroll Bar Disappears,
Gord Dibben
Re: excel text formula does not calculate after editing,
T. Valko
RE: How to dealing with functions with 30+ variables?,
Mike H
How do I create a table on a new worksheet from other worksheet da,
Etg-Para
Re: column reference in an Excel spreadsheet,
Don Guillett
Re: Color coding cells,
Don Guillett
Re: have date show in cell when only entering numbers,
Peo Sjoblom
Re: Summary help!,
Sandy Mann
Re: Look up Function,
Pete_UK
Macro to copy an image (or picture) from one workbook to a new sheet in another workbook,
Ruchir
Re: Excel 2000,
Pete_UK
Re: drag across multiple data sets,
Spiky
- Message not available
- Message not available
Re: Sales mark up formula,
PCLIVE
Inserting data into next blank cell down in next sheet,
Nick Wakeham
Query: Automatically transfer complete rows?,
Smurrf
Counting Empty Dates within a Range?,
Gina
How to conditional format columns in a range based on,
BlyChris
SORTING CELLS,
LAURA
RE: How to change cell value if cell contain specified word,
Stefi
RE: Countif numbers fall between two values,
Teethless mama
Re: INDIRECT reference to another worksheet in same workbook,
Max
Graph and updating,
Nick Wakeham
Re: how to extract caracters up to comma in excel cell,
Ken Johnson
Re: Cell references in SUMIF formulas,
Pete_UK
Re: Cannot insert worksheet in exel - not available in insert menu,
Dave Peterson
Need help ( Hope i made it clear this time),
Tia
VBE Error (Project unviewable),
Tia
Re: Nested Forecast Formula Help,
Bob Phillips
Re: sumproduct _zafar,
Bob Phillips
Re: Hiii - Please help,
Bob Phillips
calculating Leave,
Tia
Excel 2007 Autofilter vs Excel 2003,
James8309
return values in the table with multiple conditions,
cprao
Re: Copy Paste filtered column ok in 2003 not in 2007,
NoodNutt
Re: Cell Underline problem underlines across width of cell,
Pete_UK
Re: Date Calculations,
Pete_UK
Re: How do I delete the refernce a formula when copying and pasting?,
Gord Dibben
Convert int ccyymmdd to date(time),
patf@xxxxxxxx
RE: assigning grades,
John C
Re: How do I intergrate lines added so they follow in descending order,
Spiky
Re: NON SEQUENTIAL DATE RANGES,
Spiky
Re: Using SUMIF with RIGHT(),
T. Valko
RE: Get rid of $ signs in formulas,
Gary Brown
Re: Excel Function - Date evaluation,
Pete_UK
Calculating dates of holidays,
mikelee101
Create macro with button in excel spreadsheet,
Lori
Re: if statement syntax help,
T. Valko
Generate list,
dvya
Re: Separating Strings,
T. Valko
Pivot Table data,
ahern79
Conditional Sum of cells,
ub
change formula in a shared worksheet without losing change history,
DCE
Printing with "",
Alan12345
Expansion of COUNT if Question,
Adam
Adding duplicates...,
accountant
Insert Graphics File into Worksheet via Formula,
rockfalls3
Re: correct formula,
Rick Rothstein \(MVP - VB\)
Re: The hyperlink reference doesn't changes when I insert Rows and co.,
d . louchbaum
calculate percentage of numbers <= zero in a given range,
spowel4
Re: Vlookup on Dates,
Pete_UK
how to change formula in shared sheet without loss of change histo,
DCE
Extracting data from Outlook to Excel using VBA,
HBruno
Annual Leave automatic calculation,
Tia
IF,
Karen6175
How to Create Macro to Increase Cell Value to one and Print Worksheet,
mdms515
how do I set up or adjust my column chart?,
Jerome
RE: Entering changing months with a cell,
Mike H
Pivot Table Question,
Liz J
MCONCAT,
lehigh46
Use tab name in Vlook Up,
AMH
Re: I have year based data want to convert into weekly basis,
Pete_UK
why do I lose cell format in a pivot table?,
Megglesface
RE: Replace mutiply sign *,
Mike H
Adding a sort to a working query asks for a parameter value,
BRob
sumproduct_zafar,
vlook fomula
print range is gray and i cannot change,
peter
Re: Removing Digit Separator,
David Biddulph
Re: Date Calculation in Conditional Formatting,
David Biddulph
Re: unhiding formulas,
Jan Bolluyt
Re: Index, Large and Match??,
Max
RE: Excel filtering of split panes,
M Kan
Concatenate a formula,
Steven
Re: certain time,
T. Valko
Re: format a right justified zero filled field to a prn file,
Dave Peterson
Re: Multiples conditions in an array,
Infinitogool
Re: COLUMN & ROW EQUAL,
RagDyer
Re: month text in calculation,
T. Valko
Combine 6 Worksheets to 1 Worksheet with total amounts,
Ms. D
Changing worksheet reference in a VLOOKUP,
Mark
Re: I think I know how to ask this sumproduct question now:,
PCLIVE
RE: Comment insert,
THILL
Re: Formulae stop working,
Lars-Åke Aspelin
Re: define name with 2 lists,
Spiky
Re: IF function, nested with 2 source cells?,
Pete_UK
Re: Remove Rows That Are NOT Duplicates,
Pete_UK
Re: invalid reference for vlookup,
Pete_UK
Re: counta,
Gord Dibben
Re: Case Sensitivity in Lookup Functions,
Jan Bolluyt
Re: Really large files, not sure why,
Jan Bolluyt
Re: VLOOKUP Question - Can I Keep the Same Aray with Drag?,
T. Valko
How to count for 3 columns,
Mysa
Re: How to use a range name in a macro,
Bob Phillips
Re: Data Validation Question,
T. Valko
Copies From The Internet,
lehigh46
Re: Nested if using range names,
Bernard Liengme
Re: use source formatting with protected worksheet,
Gord Dibben
Re: Dates - Custom - Pos Pay Format,
Rick Rothstein \(MVP - VB\)
Re: Pos Pay,
T. Valko
RE: How do I copy specific information from a master sheet?,
Gary''s Student
Re: Linking formulas between several woorkbooks,
Spiky
Re: match, lookup two column data,
RagDyeR
RE: How best to use sumproduct instead of conditional sum:,
Teethless mama
Re: How do I copy cells containing drop downs?,
Otto Moehrbach
Conditional Hyperlinking,
PurchaseGuy
Re: append column data,
Rick Rothstein \(MVP - VB\)
Re: Retain font/cell color on lookup/copy,
Pete_UK
Re: conditional formatting #,
Spiky
Conditional Format - Hide/Unhide,
robzrob
Conditional Formatting Question,
mommatee
=If(A1:D1="Pass","Y","N"),
Gaurav
RE: VLOOKUP? SUMPRODUCT? not sure how to do this,
Gambit-6
Re: why do I get an error message when i try to merge cells?,
Susan
If, Lookup, Match or a combination of all,
Beverly Darvill
Re: I want help to fill data of sheet 2 in sheet 1,
Lars-Åke Aspelin
Combining data from 2 sheets - advanced help please,
Mark
Re: EXCEL Formula Microsoft Product ID,
JE McGimpsey
Re: MATCH not working in IF statement,
T. Valko
Re: Autofill reference formula but repeating n times before incrementi,
T. Valko
Re: Cell on Cell interaction help,
T. Valko
Re: Make a cell not equal less than a certain number,
T. Valko
RE: Excel 2007 Lookup,
M Kan
Re: TRUE/FALSE function in IF statement,
Bob Phillips
Multiple if statements based on two columns of information,
Elizabeth
Re: Incorporating Cell color fill in an "if" logical function?,
T. Valko
Re: Row reference formula not working with a VLookup,
RagDyer
Re: Mid Statements,
RagDyer
Conditional Formatting,
PRS1114
RE: NOTES FOR A CELL,
Wigi
Search/Match/Find ANY part of string to ANY part of Cell Value,
TWhizTom
grouping cells,
johnrb7865
[XL07] Conditionally format fill color for entire row,
Trevor Stone
How do I export report and have info appear on 1 line?,
Jackson
compare cells in column to criteria, then average next column cell,
Bradwin
If and/or Look Up function,
Maureen
Re: Prevent alpha character from being entered into a numeric field,
Reitanos
VBA Help,
Marino M
Re: rounding problems,
Bernard Liengme
Re: Max function,
T. Valko
Help with Functions (IF),
Melissa
Re: Filling speadsheet with INDIRECT functions?,
Max
Purchase Order Form,
Ice Man
Re: Sorting out negative numbers,
Spiky
Vlookup based on 2 criteria,
Alex
Re: Long If Statement,
Bernard Liengme
Re: Lotus 123 has a function called "rvbalance", does excel have?,
Bernard Liengme
Re: help text for user defined formula,
Niek Otten
Re: Multiply with conditions,
Bob Phillips
copy and paste not functioning, think clipboard problem,
Jane, UK
Re: Count items in range,
Jarek Kujawa
RE: Count items in range,
TWhizTom
RE: Count items in range,
Stefi
Re: need help formating a cell,
Jarek Kujawa
Convert Indirect row reference,
Harry Stevens
Lookup Function,
Aequo79
Drop down lists and macros,
lost and confused in excel-land
Re: Formula Returning Records # of Days from Today in Excel,
Ragdyer
Conditional Average,
Eki75
Re: Sort excel columns as a function,
Gord Dibben
Re: Excel Function,
joeu2004
RE: Returning a value based on a query,
Gail
Sorting columns into a table,
Christian
Re: how do I copy automatically from one worksheet to another,
Bernard Liengme
RE: I Need An Argument,
newdeas
Re: Need a Formula to Calculate the Area -Simpson Rule,
Lars-Åke Aspelin
Sorting,
Eamon
Re: sumproduct with wildcard for text?,
Per Jessen
Letter Replace Help!!,
James8309
Re: Locking cells with formulas,
Gord Dibben
Re: FINDING THE FIRST ENTERED NUMBER IN A ROW OF DATA AFTER A BLANK CE,
Lars-Åke Aspelin
Stuck in a Sub Loop,
robzrob
Re: Any ideas why a reference that works will in 2003 has problems in,
T. Valko
change order of 5 letter word based on another cell containing 5 numbers,
Forum Freak
Re: Sum Of Last Three Entries In Rotating Columns,
Peo Sjoblom
Excel mobile help please,
Terry
Re: 40 sheets/Formula to advance to next worksheet,
Don Guillett
Re: separating numbers from text,
Ron Rosenfeld
can you link an excel workbook to a live word doc,
Dave Gerecke
Re: Using IF and MAX functions together,
Lars-Åke Aspelin
Re: Auto updates with checkbox that affects total,
NoodNutt
Want to add help file for custom function but excel 2007 is flaked,
Sabotuer99
Excel Formulae,
FootballvBlues
Excel Formulae 'Help',
FootballvBlues
Re: Scoring Formula helop,
MyVeryOwnSelf
Re: Referencing Checkbox Names,
Dave Peterson
Re: Countifs with same reference?,
Per Jessen
Re: VLOOKUP Keeps Returning #N/A,
Niek Otten
Re: Keyboard shortcut for Paste Special-Values,
Mark
Re: Count instances of text in date entries,
Peo Sjoblom
RE: How do I SUM multiple results from a VLOOKUP?,
M Kan
Re: Add top numbers,
RagDyer
Re: Excel not converting file,
Otto Moehrbach
Re: Counting rows that meet conditions in multiple columns,
Peo Sjoblom
RE: Need help with a multiple criteria formula,
butterfly
past cell by date,
Tony
Re: fixed asset life table,
Spiky
Re: Excel 2003 - Copy Down Function to Reference Next Worksheet,
T. Valko
Date Function needed,
smonczka
Re: Alpha conditional statements,
Peo Sjoblom
Re: Count functions with multiple conditions/ranges,
Peo Sjoblom
Analysis Toolpak,
Spiky
Re: Excel - Compare spreadsheets and indicate matched data,
Peo Sjoblom
Re: help with function/formula,
Max
Re: Mutually exclusive cells - Excel 2003,
Spiky
Re: Sum and If Function Problem with Excel 2007,
Bob Phillips
Re: Sum from a Drop down menu using value in the cell below,
Jarek Kujawa
Re: Help in formula,
Bob Phillips
Re: how to format a complex number,
Jan Bolluyt
Focus on a cell based on date,
dave . castle
RE: No more rows...??,
RET615GA
how to combine Logical if and Vlook up,
vmohan1978
Re: Excel Documents,
Ivan
Re: worksheet functions,
Jarek Kujawa
RE: Columns into 2 way tables,
Billy Liddel
RE: Exact Precedents,
Abdul Shakeel
=If( statement for 80-90% condition then write "ME",
Master T
Re: Blank date column return datel 00-Jan-00,
T. Valko
Re: how to sort addresses in microsoft excel,
recrit
Re: Negative time numbers,
Fred Smith
Re: Do nothing if False!,
Dave Peterson
Re: VLookup is not working correctly,
Ron Rosenfeld
Re: whats the formula,
Gord Dibben
Re: emailing active sheet with macro,
Ron de Bruin
Re: How do I insert a work sheet populated with data into another?,
Gord Dibben
Re: Formula for Next Sheet and Every Other Cell,
misteremanca
Re: VLOOKUP and HLOOKUP,
Dave Peterson
RE: My formula returns a result but the cell displays a zero?,
Wayne
RE: update a sheet automatically with changing values from another she,
J Sedoff
Cant use indirect() and dynamic ranges together?,
nashism
RE: How to add a prefix to a column of numbers in an excel document?,
J Sedoff
Pivot Table, Calculated Field, Running Total,
Valeri
RE: Connecting multiple IF THEN formulas in one cell,
Peter P
Re: Conditional Formatting on empty cells,
T. Valko
Re: Can I Use a Count Function for Text?,
T. Valko
Re: SUMIF sum range,
RagDyeR
Advanced sorting,
Gerben Dirksen
Re: count occurences meeting criteria,
Rick Rothstein \(MVP - VB\)
- Message not available
- Message not available
Re: SEPARAT NUMBERS FROM TEXT,
Rick Rothstein \(MVP - VB\)
Re: Problem with "Currency Convert to Text",
Rick Rothstein \(MVP - VB\)
RE: Aouto filter by macro,
Stefi
Need to remove text with strikethrough - Excel 2007,
HD
Re: RANGE addresses. Getting from other cells.,
Jarek Kujawa
automatic inserting the values,
stremetzky
Re: Formula help,
Jan
Sliding commission rates in excel,
dene . coleman
Calculating percentage complete,
Daisy
Re: Why QUOTIENT function is not being recognized?,
Ron Rosenfeld
Re: What is the math divide funtion in Excell?,
Ron Rosenfeld
Re: Tabs,
Max
RE: Vlookup or getpivot? two entries,
ryguy7272
RE: Using Table Column Data in MATCH,
ryguy7272
Count cells based on whether another cell is blank or not,
luvnrocs
Re: semi-interquartile range function?,
Niek Otten
color change after date,
flasherr
past date cell colour change,
flasherr
Need a formula,
Darrell_Sarrasin via OfficeKB.com
Re: Conditional Formatting: Adding more then 3,
Gord Dibben
Re: need formula to apply to entire column not just one line,
Gord Dibben
Re: Counting a range of cells,
T. Valko
Re: blank date shows up as s 1/0/00,
T. Valko
Re: Complex Conditional,
T. Valko
Re: HOW TO CREATE AN ARCHITECTURAL NUMBER FORMAT,
Bernard Liengme
Re: Question on the countif function and times,
Bob Phillips
RE: Min +1,
John C
Re: SORTING WORKSHEETS?,
Peo Sjoblom
Vlookup problem,
Belinda7237
Macro for Edit/Copy/Paste Special,
icanlearn
RE: Date of worksheet comes out numbers on other linked worksheet,
Mike H
Re: PivotTable Grand Total Error using Calculated Field,
Debra Dalgleish
Re: DATABASE REACHED MAXIMUM SIZE,
Spiky
Sumproduct,
googley
Re: How do I create macro to add 8 rows at a time?,
Glenn
RE: Sumproduct with If,
StumpedAgain
Re: Spreadsheet,
Niek Otten
applying formulas for all sheets selected,
emilr17
Re: Can't view all text in a cell,
Dave Peterson
Re: Selecting the latest date reference,
RagDyeR
Re: Sum the amount of times a number appears in a column in Excel?,
Glenn
Re: Chronological Numbering,
Bernard Liengme
Re: how do I Count number of records beteen two dates- Excell 2007,
Bob Phillips
Re: multi-if then formula i think,
Bob Phillips
Non-table look ups,
Rich Mogy
Re: Define fiscal year,
Fred Smith
RE: Paste Special,
Gary''s Student
Data Validation - select AcctName and AcctCodes shows,
SJAdams4444
RE: Data Validation - select AcctName and AcctCodes shows,
John C
Re: Locking Cell through Validation,
Max
Macro To Make Workbook Demonstrate Itself,
robzrob
How to set the enter key to move every 2 rows instead of one row,
PhyllisTheCat
how to get the answers from 3 conditions,
Chiran
Re: This formula can not work in Excel 2007,
Jarek Kujawa
Excel still not recognising equal values,
pecan
Time query,
Ber
Message not available
Re: Count Function,
Bob Phillips
Re: How can I recover the previous data after save change,
edp . laveranda
Re: I have a text cell and I want to inport a value into the cell,
David Biddulph
Re: Check if a person exists in a distribution list,
Jarek Kujawa
Multiple Critiera Sum Array - One critiera to be between two numbers,
Forgone
Hyperlink Function,
Hershey
Message not available
Custom functions,
Palpha32
text in mm:ss to time,
P Boric
RE: Function for grouping range of data,
John C
Sum up all up changes and down changes,
Tetsuya Oguma
Combination...SumProduct, Index, Match?,
Monte
Re: can you link a text box to a cell in excel?,
Max
Replacing characters with numbers in cells,
Juan Valdez
Re: Finding cells with a value ending in '.0',
David Biddulph
RE: Histogram bins driving me crazy-please HELP,
Joel
Re: help with a formula,
gromit
Conditional formatting to a different cell and it contains a formula,
Rick
Re: MIN and Year Functions,
T. Valko
Re: Automatically adjusting chart reference,
Gord Dibben
Re: Conditional formula,
Mindy
Display a Date when a cell is Modified,
Sean
Re: IF Formula and multiple formulas,
Per Jessen
Paste, Paste Special,
robzrob
Re: Sorting Worksheet Tabs,
janabanana
Re: Workdays/Networkdays #Name? Error,
Fred Smith
Re: subtracting date/time,
Fred Smith
Referencing Table Data,
Steve Haack
Re: Using the Subtotal function,
Bob Phillips
Re: Anchoring Excel Cells,
Bob Phillips
Re: WORKDAYS FUNCTION CAUSES #NAME? ERROR WHEN OTHERS USE FILE,
Bob Phillips
Re: SUM ONLY CELLS INA RANGE THAT ARE NUMBERS,
Jarek Kujawa
Re: counting two ranges for one criteria,
Bob Phillips
Re: How do I calculate the mode for a column of text?,
T. Valko
Check box in Filters,
AceRoadRunner
Re: Upper to Lowercase in Excel,
JuanMarin
Re: Pivot Table,
Debra Dalgleish
Re: Match forst four letters,
Peo Sjoblom
Re: Combining date and time data,
Rick Rothstein \(MVP - VB\)
Re: Cell Background Color,
Rick Rothstein \(MVP - VB\)
date flexibility,
Karina
add cells together from different sheets within a workbook,
s6292
how do i copy a worksheet to another work book,
multi work book sheet copies
RE: Formula Error,
cdjudge
Re: If formula error,
Bob Phillips
Mid Function,
Mattlynn via OfficeKB.com
Looking to replace "dots",
Rick
Converting from 12-hour to 24-hour format,
Nathan
Random Sampling - Please Help!,
Lee Mathew
Using COUNTA for a variable array,
Schannah
SUMPRODUCT - Using Month,
Phendrena
<Possible follow-ups>
Re: SUMPRODUCT - Using Month,
Jarek Kujawa
Total of a specific name,
Tia
Re: formula alternate column call value,
Jarek Kujawa
Countif with two conditions,
Jean-Bernard STROOBANT
Re: Formula at alternate Cell Values,
Bob Phillips
Re: cell color,
Jarek Kujawa
Multiple Criteria Lookup Results,
Forgone
Re: total a column in which there are sum formula,
Jarek Kujawa
DP jog macro.,
Aaron
Function to Produce a Number Pattern?,
mommy2kh
Buttons,
Henrique
Re: Auto Fill Color Cell,
Gord Dibben
Re: Formulas,
Gord Dibben
RE: I need help with an if statement that has more than 7 nested condi,
StumpedAgain
Re: Dynamic Link to Quickbooks,
Alan Beban
How do I display the result of a function on seperate worksheet e.,
Beth
Re: SUMPRODUCT: dividing the formula of one cell by another.,
Bernard Liengme
Re: Formula question,
Rick Rothstein \(MVP - VB\)
Re: Filtering failed moving on...HELP,
Otto Moehrbach
Re: Compare lists when one column contains multiple entries,
Dave Peterson
Re: Extracting Specific Data from one sheet to another.,
Pete_UK
Re: Creating a formula which would affect multiple cells,
T. Valko
Re: different phrasing,
Pete_UK
Re: Vertical lookup of pictures,
Peo Sjoblom
Message not available
Can I copy a field from another spreadsheet based on search?,
Faye
RE: Document Specific Autocorrection,
TheBroon
Re: using OR function with Index/Match?,
Bob Phillips
Re: If statements looking for nonblank cells,
T. Valko
Re: Find matching values in two different columns,
T. Valko
count if unique entries,
Tonybagodonuts
Re: Count IF,
Bernard Liengme
Re: PERCENTILE exceeding 8191 points,
Bernard Liengme
Re: edit data in multiple cells,
Jarek Kujawa
RE: Sum of continous cell,
John C
Counting data in a range,
Glenn L.
controlling pivot table,
mrc1986 via OfficeKB.com
Gradient and intercept on data with errors,
Dave Curtis
Re: Pivot Chart Formating,
Debra Dalgleish
Re: How can I choose more than one item from list in a form in Excel?,
Rick Rothstein \(MVP - VB\)
- Message not available
- Message not available
Re: How to print entire workbook 9 pages to a sheet?,
Glenn
Re: Average time,
Jarek Kujawa
Re: an IF function that can take no action?,
Jarek Kujawa
Re: counting values ignoring duplicates,
Jarek Kujawa
Re: HYPERLINK - Jump to another sheet in the same workbook,
Pete_UK
vlookup not returning a match even when there is one,
karen
Re: Subtotalling taking long time to complete,
Pete_UK
Re:How do you alphabetize street addresses within a column?,
Dave Curtis
Re: countif and sum if if two condition are satisfied,
Jarek Kujawa
Re: Need Simple List...Multiple Columns and Multiple Worksheets,
Otto Moehrbach
Re: vlookup returns wrong answer (off by one row),
Peo Sjoblom
Re: Weekly Totals Based on Dates,
Ed Ferrero
Re: Return to a default state???,
NoodNutt
clear cell based on text in opposing column,
bubba
Re: how to have auto calc cells be blank unless entry made,
Per Jessen
RE: Flying Hours,
FSt1
Re: how to change font in form contollers,
Gord Dibben
Re: <>= Formula ?,
Henrique
Lock or Unlock Range of Cells on Worksheet_Change Event,
Grahame Coyle
Re: sum between a range of dates,
Bernard Liengme
Auto populate a cell by comparing lists,
Ken
Extact minutes from text field?,
Lenchik
RE: Populate cell range,
lost and confused in excel-land
Re: insert column header in cell below result of max FUNCTION,
T. Valko
Re: how do i calculate cumulative percentages in Pivot table reports,
Herbert Seidenberg
Re: INDIRECT,
Tim Zych
- Message not available
- Message not available
RE: Replacing Part of a Cell's Content,
Mike
Re: Excell Formula,
Max
Excel Loan Repayment Schedule template.,
stevegg
Re: sumif < date,
Dave Peterson
Re: keep old cell value and new cell value,
Gord Dibben
Re: how to convert number to words,
Bob Phillips
keep track of phone numbers,
Eamon
Re: >> vlookup refering to a cell to get wookbook name,
Bob Phillips
Re: Can I Use A Count If Function With A Forward Slash?,
T. Valko
Re: Need formula to return next Monday's date,
Tim Zych
Re: If statements in Data Validation,
Tim Zych
VLookup in a form,
theresaluff
Inserting Function blanks adjoioning cell,
Dave
Re: Finding quantity that falls within a range or Tier,
Ron Rosenfeld
Re: Calculating values based on selection from a drop-down list in Exc,
Gord Dibben
Re: Copy Info from 1 sheet to another within same workbook,
Gord Dibben
Re: how to count if cell "contains" a word,
RagDyer
RE: circular reference where sumif and vlookup overlap,
John C
Re: Printing,
Gord Dibben
Re: Filtering,
Gord Dibben
Multiple calculations within cell? Writing in Excel 2000, using in Excel 2003,
robzrob
Re: Average of Day and Time,
Bob Phillips
RE: multiple IF formulas,
Gary Brown
Re: Compare and get the best value,
Pete_UK
Re: Quday001-Conditional Formatting,
Pete_UK
Re: Already exists on the destination workbook,
Pete_UK
Re: conditional formatting or VB,
Don Guillett
Re: Count Non-Blank Values in a Table but only for a range,
Pete_UK
Re: Formula, automation turn red if value exceed a number,
Pete_UK
Duplicate ramdom sampling,
Lee Mathew
Re: want to automatically skip certain cells when you hit enter,
IanC
Re: Push updates from one workbook to others?,
Pete_UK
Re: match or vlookup function formula help,
Pete_UK
Re: IF function question,
Pete_UK
Re: Minutes/seconds not right ( 24 ??? %$@#$%$),
Pete_UK
Peak call times/hours,
Ber
Re: IF and dates,
PCLIVE
Re: ?????????????????????,
bony_tony
CONCATENATE within SUMPRODUCT,
Icarus
- Re: CONCATENATE within SUMPRODUCT,
Bob Phillips
- Re: CONCATENATE within SUMPRODUCT,
Icarus
- Re: CONCATENATE within SUMPRODUCT,
RagDyeR
- Re: CONCATENATE within SUMPRODUCT,
RagDyeR
- Re: CONCATENATE within SUMPRODUCT,
Peo Sjoblom
- Re: CONCATENATE within SUMPRODUCT,
Bob Phillips
- Re: CONCATENATE within SUMPRODUCT,
PCLIVE
- Re: CONCATENATE within SUMPRODUCT,
Harlan Grove
- Re: CONCATENATE within SUMPRODUCT,
PCLIVE
- Re: CONCATENATE within SUMPRODUCT,
RagDyer
- Re: CONCATENATE within SUMPRODUCT,
PCLIVE
- Re: CONCATENATE within SUMPRODUCT,
Bob Phillips
- Re: CONCATENATE within SUMPRODUCT,
RagDyer
- Re: CONCATENATE within SUMPRODUCT,
Harlan Grove
Refer to a sheet using a cell value,
bony_tony
Re: Look Up two cells,
RagDyeR
RE: copying formulas,
ambam
Spreadsheet to keep track of phone numbers,
Eamon
Re: "in" function???,
Bernard Liengme
Quday-Conditional Formatting,
Udayan
date problem or is it me?,
zekni
Re: HOW CAN I FLAG A CELL IN EXCEL WHEN IT HITS A REORDER LEVEL?,
Meebers
sumif or if or something else????,
durrienz
Re: Date Correction,
Bob Phillips
ideas needed, pls help..,
angel
Re: how to use my Excel 2003 DTF commands,
David Biddulph
Password in Visual basic editor,
Tia
Re: Can I made a cell reference variable? i.e. =sum(D4:D(4+A2)),
Max
Re: Two way lookup on a table from user input,
T. Valko
Re: Payroll lookup,
T. Valko
Re: Excel time calculation,
Mark K
Re: Test for normality of data,
Mike Middleton
Re: Comparing Addresses from 2 different Worksheets,
Max
Re: using vlookup,
Pete_UK
Re: Data Validation and combination,
Gord Dibben
Re: How do I remove names from a drop down box?,
Gord Dibben
Re: Auto filter sort ascending not working while sheet protected,
Pete_UK
RE: I need help with a IF(ISNA with vlookup,
StumpedAgain
RE: Replacing a Range of Numbers,
StumpedAgain
Re: password protected workbook,
Niek Otten
Re: adding a round function to an existing formula,
Fred Smith
Re: IF STATEMENT,
Fred Smith
Re: Conditinal Formation,
Bernard Liengme
Re: Searching Multiple rows using VLOOKUP with wildcard(*,?) lookup va,
Dave Peterson
Re: Data lookup function,
Zumble
Align data in 2 column in the same row if the user id's match,
simon
Re: Date Formula,
Pete_UK
Re: move or copy,
Pete_UK
RE: leave cells blank until formula applied,
tim m
Re: Counting dates including the beginning date.,
T. Valko
RE: Easy to do but cannot remember how!,
Chivalrous1
Re: How to Compare between cells and choose smallest value,
T. Valko
How do I force entry in multiple cell ranges in one worksheet,
CindyB
Re: Critical - Converting Single Column Address Data into Multiple Col,
Zumble
ACCRINTM() function,
Zumble
Re: Conditional formatting - source data from another sheet,
Gord Dibben
Re: What does the ! notation mean in excel financial formulas?,
Peo Sjoblom
Re: Format changed when the details in cell changed,
Gord Dibben
Re: the font colour icon in excell 2007 kicks me out of the programme,
Ron de Bruin
Re: FONT COLOUR CHANGE,
Peo Sjoblom
Re: lookup by multiple parameters,
Peo Sjoblom
Re: Average If - averaging cells based on value of another cell,
Pete_UK
RE: List or colour Cells of results,
Jamie
Fill down with references to worksheets,
chris
Counting on 2 criteria,
Richie
Re: how do i get zeros to show after decimal point?,
Cimjet
Re: multipying a cell by a percentage,
David Biddulph
Re: Another LINEST bug,
Bernard Liengme
RE: Date and time stamping with a (macro) button,
ArcticWolf
=SLOPE(OFFSET(INDEX .... Help please,
Mark K
How to split up text,
Hilton
text outside merge cells despite clicking wrap text,
chedd via OfficeKB.com
Re: Date Entered +7, unless another field is greater than 0,
Per Jessen
Re: Text to columns with date format does not work :(,
Rick Rothstein \(MVP - VB\)
More Conditional Formatting,
tvh
Re: seeking help,
Rick Rothstein \(MVP - VB\)
Re: MID and FIND Function for Numbers,
Rick Rothstein \(MVP - VB\)
Re: a little help?,
Pete_UK
Re: Cell resizing,
Gord Dibben
Re: If calculations,
Pete_UK
Re: When saving, Excel prompt me for all worksheet passwords,
Gord Dibben
Re: Excel Autoformating cells,
Gord Dibben
Re: Filter Data From Master Sheet Into Other Worksheets,
Max
Re: can't lookup a value to the left of my variable,
Niek Otten
Re: If statement error check,
Peo Sjoblom
Re: How do retrieve deleted files from excel?,
David Biddulph
Re: Complex Array sorting issue,
Héctor Miguel
Re: Want to unlink calculations,
Otto Moehrbach
Re: name separation,
Rick Rothstein \(MVP - VB\)
Re: SUM with nested VLOOKUPS - can i make it ignore N/As?,
Niek Otten
Re: Finding and Adding,
Niek Otten
Re: Actual Language for Nesting criteria,
Pete_UK
Re: Counting,
Pete_UK
- Message not available
- Re: Counting,
Pete_UK
- Re: Counting,
Pete_UK
- Re: Counting,
Civette
- Re: Counting,
Civette
- Re: Counting,
Pete_UK
- Re: Counting,
Civette
- Re: Counting,
Pete_UK
- Re: Counting,
Harlan Grove
- Re: Counting,
Civette
- Re: Counting,
Civette
- Re: Counting,
Pete_UK
- <Possible follow-ups>
- Re: Counting,
T. Valko
RE: XIRR FUNCTION,
pshepard
Re: Excel Calculation,
T. Valko
Re: VLookup function,
David Biddulph
Re: First Positive on Horizontal Array,
Dave Peterson
Re: Finding selected numbers within a master list,
Pete_UK
Re: Please Help Qtr Mtch,
KristiM
Re: Main worksheet to automatically update figures on other worksheets,
Pete_UK
Re: Separating Text,
Pete_UK
Re: Locking documents in Excel after a template has been created.,
RagDyeR
RE: Formula Display,
Kimbanev
Re: Dropping decimal places whern transfering to AS400?,
David Biddulph
Re: EXCEL SHEET,
David Biddulph
Re: how do i calculate the average of 30+ cells over multiple work,
Ariana
RE: Formula for adding 2 worksheets,
Rich W.
Excel - Min function over 4 separate cells, but ignoring negatives,
griff
Re: Is there a showif formula?,
Mike
Re: Adding rows based on no of rows specified from a given position,
Pete_UK
Re: How to extract text from middle of a string,
bollard
Re: Enabling Macros,
David Price
Re: Help with multi sheet workbook,
David Price
indirect formula syntax,
Graeme
Re: Its a toughie, not sure if its possible.,
Per Jessen
Re: Selecting a diff. worksheet but same cell references using Validat,
Pete_UK
Re: What formula should I use?,
Héctor Miguel
Re: if then statements with calculations,
Harlan Grove
Re: Vlookup combined with Hlookup,
T. Valko
Re: Find a color value,
Héctor Miguel
- Message not available
- Message not available
Re: Nested if's and lookup,
T. Valko
Re: how do I copy and paste a drop down list in excel?,
T. Valko
Re: Is there an INDIRECT function for a RANGE?,
T. Valko
Re: how to copy excel carriage return to notepad w/out the quotations,
Dave Peterson
Hide a sheet with a variable name,
Scott
Re: Need Help with Lookup Formula that Also Puts in Text Where Matchin,
Pete_UK
Re: WHat is wrong with this formula,
Pete_UK
Re: XIRR Function - large IRRs,
Fred Smith
Summing same cells in multiple worksheets,
neilcarden
Re: Searching Multiple sheets in excel,
Gord Dibben
Re: Help with dates,
Rick Rothstein \(MVP - VB\)
Re: How can I make a drop down box visible within a worksheet?,
Kendra510
Re: sumif with multiple conditions,
T. Valko
Re: Hyper link between spread sheets,
MyVeryOwnSelf
Excel 2007 nested function,
David Price
Re: =IF,
PCLIVE
- <Possible follow-ups>
- Re: =IF,
Rick Rothstein \(MVP - VB\)
Re: How to show a whole worksheet on one screen?,
Pete_UK
RE: Help Me Please -,
Mike H
how do i replace #n/a in a vlookup?,
infinite1013
Message not available
Re: IMPORTING DATA MY NUMBERS ARE NOT READ AS NUMBERS,
Gord Dibben
RE: simple formula,
John C
Re: How do I use condiftional formatting to indicate a formula?,
Gord Dibben
Re: LOOKUP Help,
Don Guillett
Re: How do I freeze column names to view when scrolling?,
Alexis
Re: Inserting rows automatically.,
Don Guillett
Re: XIRR Function - #NUM error,
Niek Otten
Re: Add numbers in a column, but exclude percentages in the same colum,
David Biddulph
RE: #n/a in table data table output,
Gary Brown
Re: Delete duplicates in a row,
Don Guillett
Re: lookup question,
Pete_UK
RE: Referencing Cells in a Summary page,
Katintn
Re: Pivot Tables - Can you just list data and not SUM,
Debra Dalgleish
Re: match 2 columns and return value of another,
Don Guillett
Re: exact differnce between 2 dates & time networkdays give round off,
Bob Phillips
converting hourly values into daily values,
Reza
Code to hide sheets,
Tia
Re: SUMPRODUCT question,
Per Jessen
VBE to hide sheets "can i share it as well",
Tia
Re: Conditional Formatting - 3 Rules - Excel 2000,
Max
RE: How to count zeros and not blank in selected range?,
Stefi
Re: Random numbers from several ranges,
Jarek Kujawa
Re: Can you change normal numbers to ordinal numbers ?,
T. Valko
Extract Number of Weekdays (Mon-Fri) & Saturdays for a particular Month/Yr,
Max
Multiple Questions about adding different cells,
Redsphynx
Re: Conditional Formatting for Values in 3 cells,
Peo Sjoblom
Re: ActiveX Control text box,
KMorris
Re: Conditional Formatting, Date,
Gord Dibben
Continuation to equivalent for formula - to Mr. Harlan Grove (and not only...),
ytayta555
OLD PROBLEM without SOLUTION , part ||,
ytayta555
Re: DSUM Criteria - find exact match only,
Peo Sjoblom
Re: Perform a calculation on same cell across many worksheets,
Gord Dibben
Re: SUMPRODUCT AND LEFT,
Don Guillett
Re: returning calculation based on number,
Tim Zych
Re: Countif w/semicolon separated values AND Filter,
T. Valko
Converting specific text to numbers then sum,
Mule
RE: Calculating totals of material with feet and inches,
Gary Brown
Re: countif from different worksheets,
Bob Phillips
Re: Excel 2007 Conditional Formatting only copies absolute,
Spiky
Re: HELP!!! Text count?,
Pete_UK
Re: How to count...,
Rick Rothstein \(MVP - VB\)
Re: Columns labeled with numbers not letters,
Rick Rothstein \(MVP - VB\)
mutiple if statements that then compute a value,
cmac
Re: In Excel, conditional format (font red) referencing another ce,
KMorris
Re: converting question; function, formula, or coding?,
Per Erik Midtrød
Re: combine or if,
Peo Sjoblom
Re: converting hour values to day mean values,
Reza
Re: Percent Function Help,
David Biddulph
- Message not available
- Message not available
- Message not available
Re: Error of slope taking into account error of the data points,
Pete_UK
- Message not available
- Message not available
Differences between Dates,
Jack
RE: Autopopulate text from multiple tabs into list.,
BobT
Re: SUMIF FUNCTION,
PCLIVE
Re: Drop Down Lists,
Don Guillett
RE: Still problems with calculation of time,
Mike H
How do I lock the formatting of my worksheet but still add text?,
Y2Kate
Hide sheets,
Tia
RE: Countif w/semicolon separated values,
crazymfr
Re: Months in Excel Chart,
Don Guillett
Re: Calculating eligibility dates,
Bob Phillips
Re: spreadsheet colum combination,
sajay
Re: Tabela Dinamica,
sajay
Re: Counting incidences of surname and date of birth and rearranging s,
sajay
Summing across multiple worksheets,
HL
VBE "Help",
Tia
Re: Extracting data,
amir2000
Re: Excel problem - sumif with multiple parameters,
Bob Phillips
RE: Complicated Lookup,
Trefor
<Possible follow-ups>
Re: Complicated Lookup,
Bernard Liengme
Text does not carries Over,
Godwin Chan
Re: How do I use the WORKDAY() for a 6days working wk excluding ho,
JP.F
Re: excel,
Max
Searcing foran Excel event fired.,
Dwipayan Das
LOOKUP FUNCTION HELP,
JuanMarin
Re: Counting repeated data in a column,
Bernard Liengme
RE: Multiple value lookups from a table to select & sum data from,
brettster999
Adding multiple cell totals,
D
Re: Simple cell formating question,
Dave Peterson
Re: Easy way to stack column data?,
Don Guillett
Re: sorting array formula,
Héctor Miguel
Re: How do I change date yyyymmdd to a Excel-supported date format?,
David Biddulph
Latest Result,
Graham H
Re: If formula problem,
Jim
It could be due to an error,
Ex Cell
problems with formating and concatonating time [hours],
Bret Bernever
Re: formula ending with a letter,
Don Guillett
Re: Text detector,
Max
need formula for finding opposite (trigo),
jimE
Re: Run formula automatically,
Don Guillett
INDIRECT formula,
Ken
Re: Trying to work out the difference in 2 cells.,
Bernard Liengme
Re: Multiple Criteria to Classify groups,
Mike Middleton
Re: FINDING THE LAST ENTERED NUMBER IN A ROW OF DATA,
Pete_UK
Re: Help with a bsic formula,
Pete_UK
Re: Help with blank cells when concatenating,
Don Guillett
Re: How to get result by using CountIF, if there are 3 conditions to b,
Pete_UK
Re: the value should not be more than 0.8,
sajay
Searching from a table,
gojakie
Re: How can i use lookup for data in reverse column ?,
Sandy Mann
RE: How I unprotect my workbook if I failed to remember my password,
Mike H
Re: How to convert Number into words in EXCEL same or a new cell ?,
Rick Rothstein \(MVP - VB\)
Re: How to convert Number into words in EXCEL same or a new cell ?,
Nayab
count uniques anomaly,
T. Valko
Re: COUNTIF: unique names and values accross several columns.,
Dave Peterson
Wrong count of time,
H. Nissen
Re: Updating Imported Data (Excell 2003),
Ragdyer
Re: Mean separation by LSD value,
Mike Middleton
Re: How to look up a value in a list and return multiple corresponding values,
NoodNutt
Re: YTD average cust calulation,
NoodNutt
RE: Possible getpivotdata with offset?,
ryguy7272
Re: Wrap Text Problem + a little VB :),
NoodNutt
Re: How do I use the WORKDAY() for a 6days working wk excluding holida,
Bob Phillips
RE: Calculate and display year and month,
Teethless mama
Re: Column to row,
vezerid
Associate values in worksheet??,
Jon M
Re: Lookup where column data does not match,
Dave Peterson
Changing the headers on an excel worksheet from Numbers back to le,
Maxine
Filter latest date from multiple date entries,
padmanaban . mm
Counting specific letters in multiple cells,
tohlz
Re: Stop text carries over,
Nayab
Re: Calendar or date formulas,
Pete_UK
yes / no formulas into 1/0,
The snow Queen
Re:How would I attach or assign values to a trendline?,
Dave Curtis
Protect columns with password,
Anders
Re: Count rows after filter,
Héctor Miguel
not working for me,
justin something
How to calculate avg from various rows,
paulk2002
How to calculate an average from various rows???,
paulk2002
Re: #value! Error,
T. Valko
May be a long-shot, but.....,
chuckden
RE: Pivot Tables & Conditional Formatting,
ryguy7272
Data Validation lists update orginal cell with list update,
roniaelm
Restricting cell data amount,
NoodNutt
Re: Set fixed Decimal places with no rounding,
recrit
Re: Updating data in one Worksheet and propagating it to others,
Pete_UK
Re: Link transposed data from one sheet to another for DB purposes,
YMTEO
Re: Copy from another sheet but spreading the data out down the col,
RagDyer
Re: How can I activate spell check in a protected sheet,
jaf
Re: rounding decimals to nearest quarter,
T. Valko
Re: Insert Copied Rows or Drag/Drop Formulas While Protected,
Per Jessen
Re: alphabetical on column c,
Per Jessen
if value is between two numbers,
samuel
Message not available
How do u sort many items out a spread sheet in excel,
csuprano
Re: Nested IF Function not working,
Dave Peterson
Re: split data into seperate worksheets by criteria,
Tieske
Re: Comparing Lists,
Tieske
EQUIVALENT for this FORMULA , please,
ytayta555
FINDING THE DATE 75 DAYS AFTER A SPECIFIED DATE,
vikkib
Re: Isolate text immediately preceding "(",
Ron Rosenfeld
Sorting text and numbers from multiple tabs,
Jessabez
Re: Ungroup "+" on a protected sheet,
Dave Peterson
RE: Change Workbook Password,
Gary Brown
Re: copying from pdf into excel ?,
Gord Dibben
How Do I DO IF with DATE,
Dig
RE: Advice on a couple of things if possible.,
Gary Brown
Re: Counting specific letters in a cell,
Pete_UK
Re: Figuring and adding time in Excel,
vezerid
Re: Nested if/then or array???,
Bob Phillips
Re: If a date range contains a leap year (date),
vezerid
Re: If a date range contains a leap year (date),
Ron Rosenfeld
Re: If a date range contains a leap year (date),
Ron Rosenfeld
Calculate a ratio of two numbers to the total,
rhh29
Re: Linking cell ranges between rows and columns,
vezerid
convert 80521 to 05/21/08,
KKay
Re: How to find the highest name in an alphabetic list?,
vezerid
Formula,
dazoloko via OfficeKB.com
Re: sumbycolor formula,
Bob Phillips
Re: finding and replacing,
Pete_UK
Re: work book open _ event,
Dave Peterson
Re: Copy Left Word,
Pete_UK
Re: taking conditions from one spreadsheet to another,
Pete_UK
Re: Moving The Decimal Point Of Existing Entries,
Pete_UK
Re: Take first word out of cell and put it in a new cell,
Bob Phillips
- Message not available
- Message not available
REALLY easy question,
Thatgirl
Balenciaga Giant Part Time Bag Cream 328B - www.luxury-gift.org,
yxs069
nike air force shoes AFS071107 - www.luxury-gift.org,
yxs069
nike air force shoes AFS071020 - www.luxury-gift.org,
yxs069
Re: Summ figures that are not struck-through,
Héctor Miguel
Using Tabs within the allow users to edit range while sheet protec,
Jess
Countif function,
Paul10r
RE: How to convert data from Landscape to vertical,
Teethless mama
Re: If Then forumal,
NoodNutt
Complicated comparison and highlighting question,
Aimee
Re: how do i substitute filename in a formula,
Pete_UK
Charts not updating,
vitorjose
Help with Formulas,
Nadine
Re: Dragging Down a Formula,
JBoyer
Re: Setting a sale price and rounding up,
Gord Dibben
Re: How do I round a number to the nearest .49 in a cell that has a fo,
Pete_UK
Help with if statement (more than 7),
Blessedx3
Re: Diference between two hours in Minutes,
Pete_UK
RE: Formula to evaluate dates,
Gary Brown
Re: I need to count a row with something in it,
T. Valko
Re: IF and SUMIF,
GoBow777
RE: Vlookup with Multiple like values in the reference column,
bpeltzer
Sum = to greater than, change it to 1,
Kim
string lookup combined with SUM,
bestrugger
Re: Cell Formats,
Pete_UK
Re: Combining information from rows,
vezerid
Re: check certain cells for data before saving file,
vezerid
Re: how do i sort data record on two rows?,
vezerid
Re: excel data in list N1, N7, N13 etc want to transfer to A1, A2, A3,
Pete_UK
Re: pivot tables,
YP Koh
Re: Calculating Average,
Pete_UK
sumif or vlookup help,
Katie
OLD PROBLEM without SOLUTION,
ytayta555
- Re: OLD PROBLEM without SOLUTION,
Pete_UK
- Re: OLD PROBLEM without SOLUTION,
Harlan Grove
- Re: OLD PROBLEM without SOLUTION,
ytayta555
- Re: OLD PROBLEM without SOLUTION,
ytayta555
- Re: OLD PROBLEM without SOLUTION,
ytayta555
- Re: OLD PROBLEM without SOLUTION,
ytayta555
- Re: OLD PROBLEM without SOLUTION,
Gord Dibben
- Re: OLD PROBLEM without SOLUTION,
Harlan Grove
- Re: OLD PROBLEM without SOLUTION,
Harlan Grove
- Re: OLD PROBLEM without SOLUTION,
ytayta555
- Re: OLD PROBLEM without SOLUTION,
ytayta555
- Re: OLD PROBLEM without SOLUTION,
Harlan Grove
- Re: OLD PROBLEM without SOLUTION,
ytayta555
- Re: OLD PROBLEM without SOLUTION,
Harlan Grove
- Re: OLD PROBLEM without SOLUTION,
ytayta555
- Re: OLD PROBLEM without SOLUTION,
ytayta555
- Re: OLD PROBLEM without SOLUTION,
ytayta555
- Re: OLD PROBLEM without SOLUTION,
ytayta555
Re: Advancing lookups and comparisons,
ahern79
Re: How can I make BINGO boards using EXCEL?,
Glenn
count if using columns not range of cells,
Opal
Message not available
Re: I am having some trouble with a long formula and multiple spreadsh,
Pete_UK
- Message not available
- Message not available
extract number from alphanumric,
Hardeep_kanwar
Copy/Past/Transpose Formulas,
jackle298
RE: Find a value Using a lookup table multiple columns and rows,
glasspumpkin
Re: calculate the the diffrence between 2 Dates and time,
Bob Phillips
Re: count if, but not if,
Bob Phillips
RE: Multiple If(AND,
John C
SUMPRODUCT containing txt string search,
sideshowjack
Re: where in excel 2007 is old file properties menu,
Bob Phillips
Re: pull down list and single value allowed,
Pete_UK
Im doing something wrong in Visual basic for sure,
Tia
Re: Searching specific record using VLOOKUP function.,
Roger Govier
Hyperlinks and spaces,
Graham H
Re: =COUNTIFS(M3:M17,"=MAN",P3:P17,"=2000")+(COUNTIFS(M3:M17,"=LHR",P,
Bob Phillips
Re: Worksheet Formula Returning Sum of a Series,
Bob Phillips
- Re: Worksheet Formula Returning Sum of a Series,
monir
- <Possible follow-ups>
- Re: Worksheet Formula Returning Sum of a Series,
Shane Devenshire
- Re: Worksheet Formula Returning Sum of a Series,
Shane Devenshire
- Re: Worksheet Formula Returning Sum of a Series,
monir
- Re: Worksheet Formula Returning Sum of a Series,
monir
- Re: Worksheet Formula Returning Sum of a Series,
monir
- Re: Worksheet Formula Returning Sum of a Series,
Dana DeLouis
- Re: Worksheet Formula Returning Sum of a Series,
monir
- Re: Worksheet Formula Returning Sum of a Series,
Dana DeLouis
- Re: Worksheet Formula Returning Sum of a Series,
monir
- Re: Worksheet Formula Returning Sum of a Series,
Dana DeLouis
- Re: Worksheet Formula Returning Sum of a Series,
Dana DeLouis
- Re: Worksheet Formula Returning Sum of a Series,
monir
- Re: Worksheet Formula Returning Sum of a Series,
Dana DeLouis
- Re: Worksheet Formula Returning Sum of a Series,
Dana DeLouis
- Re: Worksheet Formula Returning Sum of a Series,
monir
- Re: Worksheet Formula Returning Sum of a Series,
Dana DeLouis
- Re: Worksheet Formula Returning Sum of a Series,
monir
- Re: Worksheet Formula Returning Sum of a Series,
Dana DeLouis
- Re: Worksheet Formula Returning Sum of a Series,
monir
- Re: Worksheet Formula Returning Sum of a Series,
Dana DeLouis
- Re: Worksheet Formula Returning Sum of a Series,
monir
- Re: Worksheet Formula Returning Sum of a Series,
monir
- Re: Worksheet Formula Returning Sum of a Series,
Dana DeLouis
Re: How to convert an address file from Word into Excel?,
Mr BT
Comments, is there a way to export them?,
Mr BT
Counta function,
Help
simple timesheet,
Larry
Re: Dual income calculator help,
Pete_UK
Compiling to one sheet,
Ahern79
Re: Countif using multiple references,
K
Re: reference every 19 rows,
Gord Dibben
Re: SUMPRODUCT/COUNTIF,
Bob Phillips
Re: Vlookup Function with multiple worksheets,
T. Valko
Re: Template,
Tieske
Re: Adding a Number and Formula Text and Evaluating,
Gord Dibben
Re: Drop down list help,
Gord Dibben
Re: Create user id fm LName, FName,
willwonka
Re: How do I pull data for consecutive months in an Excel spreadsheet,
Glenn
Re: Countif versus SumProduct,
Pete_UK
Countif with multiple criteria,
Debbie Whitaker
Re: SUM Product formula help needed,
Peo Sjoblom
Re: Filtering in Excel 2007,
Peo Sjoblom
Re: Calculating of time,
Bob Phillips
- Re: Calculating of time,
H. Nissen
- Re: Calculating of time,
Sandy Mann
- Re: Calculating of time,
H. Nissen
- Re: Calculating of time,
Sandy Mann
- Re: Calculating of time,
H. Nissen
- Re: Calculating of time,
Sandy Mann
- Re: Calculating of time,
H. Nissen
- Re: Calculating of time,
Sandy Mann
- Re: Calculating of time,
H. Nissen
- Re: Calculating of time,
H. Nissen
- Re: Calculating of time,
Sandy Mann
- Re: Calculating of time,
H. Nissen
- Re: Calculating of time,
Sandy Mann
- Re: Calculating of time,
Sandy Mann
- Re: Calculating of time,
H. Nissen
- Re: Calculating of time,
Sandy Mann
Re: get a range corresponding to a particular col header,
Spiky
Re: Pivot Table - divide two results,
Carolina
Re: Spreadsheet for bowling games?,
Spiky
Re: excel 2003 drop-down box color changes how,
Gord Dibben
Re: Excel - adding a picture that will pop up when I wand over it?,
Gord Dibben
Re: Need help with a formula,
Roger Govier
Re: vlookup returns #n/a,
Dave Peterson
Re: Sum when cell's value in Named List,
Roger Govier
How to determine the max. value?,
Eric
Re: make a single cell always equal zero,
Spiky
Re: Excel sort ( exclude letters include hyphens)?,
Pete_UK
MSOffice 2007 - Excel - Subtotal Function,
Cheryl S
Re: Need to Count the number of times a value occurs within a dt r,
Gina
Re: how can i determine number of weeks between 2 dates,
Sandy Mann
Re: Help with Functions & formulas,
Bob Phillips
RE:oops problem Setting up spreadsheet to calculate time,
Meenie
Re: On opening a worksheet move focus to a cell based on date,
Nayab
Re: Comments question,
Nayab
Re: Adding more than one maximum,
Max
Re: Can Excel automatically insert current date in a cell?,
Paul D. Simon
Re: how do I attach a scanned pdf file to a cell so that I can bring,
Dave Peterson
Re: sorting datasets on two rows,
anyole
Re: return cell within date range,
Bob Phillips
1st sheet being displayed,
Tia
Re: Elapsed Time,
Bob Phillips
Re: Count occurances of a name over previous 12 months,
Bob Phillips
Re: Conditional Formatting - workdays only,
Mike
Re: Sort function,
Pete_UK
Re: Formulas new in excel 2007 not compatible with 97-03,
T. Valko
Re: Why is the sum formula is not adding correctly?,
joeu2004
Re: Collapsing filtered macro,
Debra Dalgleish
Re: Compare 400 cells to one,
Max
RE: Count a specific month in a column,
Elaine
Re: Dates-Conversion,
ShaneDevenshire
Re: Complex IF formula,
Ron Rosenfeld
Re: Using v-lookup with multiple identifiers,
Pete_UK
Can't find certain date in search,
Ken
Re: Finding text,
Meebers
Re: Use a cell to name a file to be opened.,
Dave Peterson
Re: Auto update worksheets,
Pete_UK
Hyperlink function in an If function,
GoBow777
Search formula referencing range of keywords,
Malvaro
