microsoft.public.excel.worksheet.functions
- Formula to Check Values between to variables,
John
- not copying correct value,
Martin Wheeler
- Re: how to convert csv format to separet columns in excel,
Alan
- Help with Match Function,
yanf7
- Re: Why doesn't the DDB function work all the time?,
mphell0
- select rows,
4benny
- Scoring/Ranking 2 Columns of Stock Symbols,
Bohica
- Re: How to display seconds on time stamp?,
Ron de Bruin
- Re: Extract last name and insert into a different field.,
Ron de Bruin
- Re: Can't move between worksheets,
Bill Kuunders
- Re: conditional formatting - Highest,
Ken Wright
- Miscellaneous,
Irina
- V Look Up Function Problems,
tweacle
- Re: forwarding cell data,
davesexcel
- Re: Countif????,
Bob Phillips
- RE: problem using Range Names in VLOOKUP,
CLR
- excel does not open up any workbook,
presenting_j
- Re: Help With A Macro,
Bob Phillips
- Copy-Paste sheets - error in the dates,
Aninha
- Re: Creating a formula by using data in another file,
davesexcel
- Re: Create Lookup Table,
Andy
- Re: how can i multiply two columns,
Chip Pearson
- Re: excel ?,
SteveG
- Re: Save copy of folder with linked files,
davesexcel
- RE: VLOOKUP to return first hit,
Ron Coderre
- Remove all formatting,
ragtopcaddy
- Re: Formula for Excel,
Bernard Liengme
- Re: Calculated Field/Item in a Pivot,
Roger Govier
- Copt data with specific criteria,
Decreenisi
- Calculated Field in A Pivot,
Matt D Francis
- How to use if statement,
whiteswan
- Re: AVERAGE DAYS OPEN IF BETWEEN DATES,
Bob Phillips
- Rounding Error when adding or subtracting two cells,
mtheo
- Re: format a drop-down box from a range of cell from another work...,
Roger Govier
- Incrementing numbers,
Floyd107
- Re: pls help again!,
Dav
- Linking formulas in new sheets based on a template?,
Olle Svensson
- common entry reporting,
Jeff
- I have more than 6 conditions when using conditional formatting?,
Magda
- Re: How do I run Excel 95 macros in Excel 2003,
Peo Sjoblom
- Re: How can I make the rows go into a random order?,
David J. Braden
- Drop-Down List,
DolittleDustoff
- Re: dates into ages,
Peo Sjoblom
- Re: Reference cell location,
Peo Sjoblom
- Re: Lookup Assistance,
L. Howard Kittle
- Re: Is there a formula tutorial online ...............................,
Peo Sjoblom
- Re: How do I sum a range of data (column) that has #num! in some cells,
Dave Peterson
- Re: Using a Text Cell to Reference a Worksheet Name,
Max
- Re: Counting blank cells until value is reached,
daddylonglegs
- Message not available
- Message not available
- Goal Seel To get Average!?,
Neo1
- Re: I have lost the in cell drop down in validation,
Ken Wright
- Re: How do I get multiple matches when using the Vlookup function?,
Biff
- Re: look up functions,
Biff
- Can this be done with Domain Functions?,
Johnny Meredith
- Re: List info if criteria is met?,
Roger Govier
- Function giving a result for number within a range,
TNickW
- Re: converting julian day and year to a date?,
Roger Govier
- Re: range_lookup in lookup functions,
Biff
- Re: only printing certain rows,
Ron de Bruin
- Re: information function - does cell contain reference,
JE McGimpsey
- RE: creating macro working across multiple sheets,
Duke Carey
- Re: Problems with formulas and sorting,
Dave Peterson
- How can I use numbers to define range for Max() ?,
excel12345
- Re: Subtototal display is in different order than 2002, why?,
JE McGimpsey
- Employees,
Rosco58
- Re: How do I correct error using the =IF(AND(formula in excel?,
Bob Phillips
- Re: How can i see on excel feet and inches from decimal system?,
Bernard Liengme
- Re: How do I show True as a value in Excel B2 if Cell B1 is bold?,
JE McGimpsey
- hours and minutes multiplied by wage,
Tom
- hours, minutes multiplied by wage,
Tom
- Re: Sumproduct with 2 criteria,
Bernard Liengme
- Re: Dynamic Lists,
Don Guillett
- Re: IF function, i think??? please help.,
Bernard Liengme
- If Formulas,
Reefaman
- Re: sumproduct looking at multiple sheets,
Domenic
- Re: How do I do a Reverse Find/Search in Excel?,
Peo Sjoblom
- Find Formula Problem,
thigley986
- Re: calculate number of days btw dates,
Peo Sjoblom
- Re: Extract the hour from a cell showing the date and time,
Andy
- Re: How do I lock selected cells, so only I can change them?,
Richard Buttrey
- Re: How do I protect multiple sheets at one time?,
VETcalc
- List Box with macro,
VETcalc
- Re: has anybody come across this before?,
Dave Peterson
- assign macro,
PH NEWS
- Re: how to use spellnumber formula,
Bob Phillips
- Re: counting if two columns contain the same numbers,
Don Guillett
- Count Multiple Criteria,
Brian
- Calculation on lookup,
sfi
- Re: Page Break Problem,
Jim Cone
Re: ask 2 function,
Niek Otten
Get data,
Decreenisi
Re: How do I restore column & row cell references,
Roger Govier
Labels,
PH NEWS
Re: importing on protected sheet?,
Dave Peterson
Re: Checking Blank Cells,
Dav
Can function in one cell change value or function in another cell?,
me
Re: Formula Help!!!,
Dav
Lookup Formula Help - PLEASE!,
VickyC
Re: Formatting of cells,
Bob Phillips
Is anyone on here with DVS Reporter???,
mariasa
Re: Accessing the sheetname in a cell,
R..VENKATARAMAN
Re: Help with this formula please!,
Biff
Calculating age.,
pinehead
Looking up a value based on date and time, what's wrong?,
Margo Guda
Re: How to prevent copied data from appearing until triggered by anoth,
ScottO
Re: Variable criteria formula,
Biff
Formula to subtract a date from current date,
Fidelio1st
sorting with RANK/VLOOKUP (problem with equal ranks),
hip
Offset Function Trouble, Please Help,
Rabbit
Re: Would like one cell to both count and multiply a range of cells,
Ragdyer
Lining Tables,
pinehead
Re: Macro Question,
Ken Wright
find a text - help,
edagostini
getpivotdata,
Mac
Re: how towrite inside margin,
Bernard Liengme
Formula question,
pinehead
Re: Using VLOOKUP with abitlity to choose from multiple defined names.,
Ardus Petus
Help again please,
Keith Crooks
AVERAGE of the previous meaningful cells,
Gilbert De Ceulaer
Re: How can I change the color of an "IF" function answer?,
Bob Phillips
Database,
gordo
Nested If statement revisited,
pdgood
Information retrieval functions,
Jasen
How can I make an excel cell equal to the value of a frame object text box,
directionalman
Nest IF statement workaround,
theresaluff
Re: Creating Array from Pivot Table,
Ken Wright
Re: Need macro to delete all text cells in an Excel range,
Ken Wright
Re: Excel should automaticaly update a feild when printing ex:Version,
Ken Wright
Opening workbooks with names taken from another workbook,
Gilbert De Ceulaer
Re: Payroll equation for SS taxes,
Max
Re: How do I identify cells with matching numbers within a column.,
Biff
Need Help With Formula/Function,
scchang
Re: Macro - Return to starting cell,
JE McGimpsey
<Possible follow-ups>
Re: Macro - Return to starting cell,
R..VENKATARAMAN
Find Matching Text In Col A move to Col B,
J.J.
ACCTINTM problems after upgrading to Excel 2003,
Andrew Edwards
How can I make an excel cell equal to the value of a text box,
directionalman@xxxxxxxxx
Re: Saved spreadsheet - now can't work on it - choices all greyed out,
Don Guillett
put data from cells into other cells,
Keith Crooks
Read Only File Problems,
tweacle
Counting Data,
Colin Thornton
Transforming Multiple Rows into 2 columns,
wilsonds
Re: display a range of data when triggered by a specific condition,
RagDyeR
Re: I am use (=IF(A2=1,"90") in a few cell i need to then add them up,
Niek Otten
Negative Percentage?,
MikeMc
auto copy only selected cells,
Keith Crooks
Re: insert columns macro is putting 2 columns instead of 1,
Don Guillett
VLOOKUP False Problem,
broadway05
Multiple accessing of an excel file,
s_aboobaker@xxxxxxxxxxx
Re: lookup a value and return cells,
Biff
pls help me,
jai
Re: How to convert VLOOPUP error value #NA to 0?,
RagDyeR
Re: Pivot Tables,
Debra Dalgleish
Data validation two criteria,
Graham Haughs
Inserting Worksheets,
Leslie Coover
Re: Creating a master worksheet,
Gilbert De Ceulaer
Help with a read only frustration.,
tweacle
Run a macro automatically on workbook open,
tweacle
Calculating sales commision HELP!!!!!!!,
spunkysezza
What formula would I use?,
Leo V.
vlookup with two criteria,
hollister22nh
Upload multiple text files into 1 excel worksheet + put the filename as the first column in the worksheet,
Aster
Re: Calculating monthly totals,
Arvi Laanemets
Re: Nesting the SUBSTITUTE formula,
Arvi Laanemets
Re: return multiple rows of data based on criteria,
Biff
Re: Number combinations,
Biff
Command Button protection problems????,
Chris Watson
Re: Vlookup...,
Biff
Re: Vlookup...,
Gilbert De Ceulaer
Re: Vlookup...,
Gilbert De Ceulaer
Re: Vlookup...,
Gilbert De Ceulaer
Re: Worksheets/Forms,
CLR
Re: how to combine text into a cell???,
wjohnson
Re: formatting multiple worksheets,
dominicb
Re: SumProduct w/WildCard,
Don Guillett
Re: sumif/if with conditions "HELP",
SteveG
Re: Excel Checkbox can be regconized in a formula and be executed,
Dave Peterson
Sorting with Multiple Rows per Entry,
Andrew Roberts
- Message not available
- Message not available
Formula for counting multiple variables in a spreadsheet,
smorgan
Re: Refresh data from an Excel sheet,
Sierras
Re: calculating the future value of an investment in excel,
Niek Otten
- Message not available
- Message not available
Re: Returning Macro to Starting Cell,
Bob Phillips
Re: how do i calculate over time per day,
KipHartman
Sorting List to a new sheet,
jermsalerms
Re: How can I use "VLOOKUP" with cells containing both Text & Numbers?,
Niek Otten
Re: How do I calcualte APR on Variable Rate Mortgages?,
Niek Otten
Added up # of cells containing a specified word,
jermsalerms
Re: Calculating Percentage Rent,
Niek Otten
A function that looks for a value on a sheet on unknown column or row,
Paul134
Re: SUMIF across worksheets,
Bob Phillips
Why sometimes excel returns error just because function parameters are linked?,
Paul134
Re: How can I prefill a text field with leading 0s?,
Bob Phillips
Re: Counting Errors,
daddylonglegs
Difference between two months,
leitek.com
Re: Cell Formatting...,
Peo Sjoblom
Re: dos from excel vba?,
Dave Peterson
How to show all formula's,
MichaelJDrake
How to protect formula's, but allow autofilter,
MichaelJDrake
Re: wts wrong with this statement,
Jason
Re: =SUM(($C$1:$C$7>=--"10/01/2004")*($C$1:$C$7<=--"09/30/2005")*(H$1:,
Bob Phillips
Re: CANNOT COLOR MY WORKSHEET TABS, TAB COLOR NOT IN FORMAT,
Niek Otten
RE: count number of occurances of a word in a range,
Ron Coderre
lookup related with defined name,
KrunoG
Re: Sum returning 0,
Niek Otten
Re: problem with replicate formula,
Niek Otten
AutoComplete not functioning correctly,
JCLSB
Finding matching cell data,
SRL
Re: Properties of a document, help!,
Bob Phillips
copying multiple selections,
adinic
Sqlrequest only return one value,
AY Xu
excel vertical function,
noxx
Better way to do this,
v4mpy
Re: Worksheets,
natei6
Return Pay Date,
Kaye
Using last cell in a column that is not empty in a calculation,
Leo V.
Calculating an average based on 2 and 3 criteria,
craggergirl
Re: Nested If Limit,
Biff
Nested if then else statement,
tzip123
Re: In excel the tabs at the bottom of the page are gone.,
Paul B
Re: IF function and combo boxes,
dmexcel
Re: formula starts : =+ what does plus indicate?,
RagDyer
Adding a row to worksheet does not update cell references in another.,
blausen
Re: indirect using name,
Harlan Grove
Re: Excel: How to choose data on two separate rows in the same col,
RicardoE
Re: Why does the Pivot table iin Excel add a 2 to my name?,
Debra Dalgleish
parsing a cell using |,
exceluser2
exchanging values amoung sheets,
havey
diverting output,
-az
Pivot Table Groups,
Chris
Re: Concatenate,
Bob Phillips
Re: Divide a cell by 2 and then add that together,
JE McGimpsey
Large Function,
wjohnson
Re: Row Expansion,
Otto Moehrbach
Re: Copy Sheets Macro,
Dave Peterson
RE: Urgent date/scheduling calc needed,
Gary L Brown
Re: Format a column wihtout using "Format-Cells-Number-category-et,
Dave Peterson
Re: Adding specific cells in column,
Trevor Shuttleworth
Re: how to turn positive to negative values in excel,
Bob Phillips
add, multiply then divide,
Zetman
Convert string of digits into a date,
Scott Lolmaugh
Re: can you rank more than 7 items? how?,
daddylonglegs
Re: Multiple True's in IF Formula's,
Beege
creating groups based upon correlations,
Boom1
RE: CHITEST worksheet function - bug?,
fred_y_Ohio
Re: Help with =MOD,
Biff
Re: If/cross referencing functions,
Biff
Re: Formatting Question,
Ron Rosenfeld
How to Sum with two if statements,
jliz2803
Re: Alpha characters problem?,
Biff
Re: vlookup on large text in cells,
SteveC
Target Cells,
Bohdon
I need help adding cells together?,
jacse
Re: countif more than one sheet/tab and sumproduct,
Bernard Liengme
Re: I NEED HELP WITH CONDITIONAL FORMATTING,
Bernard Liengme
Auto Import OR Searching TXT Data,
mrscreensaver
Excel color functions,
foxspirit
Rounding,
cld5044
List date adjacent to duplicates?,
smoore
- Re: List date adjacent to duplicates?,
Biff
- Re: List date adjacent to duplicates?,
Biff
- Re: List date adjacent to duplicates?,
smoore
- Re: List date adjacent to duplicates?,
Beege
- Re: List date adjacent to duplicates?,
smoore
- Re: List date adjacent to duplicates?,
Biff
- Re: List date adjacent to duplicates?,
Biff
- Re: List date adjacent to duplicates?,
smoore
- Re: List date adjacent to duplicates?,
Biff
- Re: List date adjacent to duplicates?,
Biff
- Re: List date adjacent to duplicates?,
Biff
- Re: List date adjacent to duplicates?,
smoore
Re: Why is my tab key not working properly any more in Excel?,
Dave Peterson
Re: Finding Duplicates,
Ozzie via OfficeKB.com
Re: Password Protecting Sheets in Excel So Others Can't See Certain Sh,
Dave Peterson
Combine functions?,
~suky~
Totaling up a column,
jliz2803
Re: How do I calculate formulas for yes/no data,
Don Guillett
Using a column of data from 1 worksheet to extract data from another worksheet,
banderson@xxxxxxxx
A weekly equivalent of EOMONTH,
andrewc
Re: Calculating % when 0 is 100%,
Niek Otten
printing to pdf file,
dmexcel
Re: Formula for area conversation,
Niek Otten
subtraction formula,
Mart
Re: Message Box to appear Thursday midday!,
Bob Phillips
moving x column values into x row values,
havey
How do I display "Help" Text in my own functions,
Gazzr
Re: Formatting #N/A,
Peo Sjoblom
What if analysis, can this be DONE??,
Barbara Harris
Re: Can I set up a signal in Excel to let me know when my due date is.,
rsenn
Re: Sort a list with uneven row information,
Paul B
i need to find duplicates! ASAP,
mj
VB and Excel,
conspiringfate
cell A1=worksheet name,
TerryAnnThomas
automatic offset cell location when there is a value in a selected cell.,
kuansheng
getting data from another spreadsheet,
Nelson
Re: How do I include a supporting help file for a excel function?,
Niek Otten
Re: Formula creation...if possible,
Barb Reinhardt
Re: too long sumif help,
Bob Phillips
More help!,
C Tate
Re: Vlookup always gives me #NA,
SteveG
Re: Complicated If Equation,
SteveG
Re: set all column formats to Text,
Trevor Shuttleworth
IF statements and ranges,
Idz21
IF statments and ranges,
Idz21
Re: Formals with IF and Then,
Tim C
Re: SUMPRODUCT help again!,
daddylonglegs
selecting values from raw data,
cebu2b
Re: subtracting time,
Bob Phillips
vlookup in if,
Alec Green
Re: create a drop down list,
Chip Pearson
Compare cells,
mtpsuresh
Ifs and Ands - I'm confused!,
C Tate
Re: Conditional Formatting in one column using data in two columns,
Bob Phillips
Differentiating data by year into columns,
Toon
Re: Formatting Charts from Pivots,
Debra Dalgleish
Re: how do i link to a pivot table to get data dynamically,
Debra Dalgleish
TRIM formula,
XL
Re: Can you change the function of the fill handle on a cell in Excel,
RagDyeR
running a macro from a list,
rufusf
Re: Formula's,
anyways
Help with max() fonction,
anyways
Re: How do I set up a cell for blinking due dates,
JE McGimpsey
Re: Summary Worksheet from Multiple Workbooks,
Ron de Bruin
Hyperlink Help Urgent,
kaiser1778
Re: Creating my own user defined function help statements,
Niek Otten
disabling the copy paste function in a cell,
sam
Count rows with specific attributes in VBA,
Steve Newhouse
Re: =AVERAGE(IF(INT(MONTH(C:C)+2/3)=4,
daddylonglegs
Re: Hours multiplied by money,
Dav
Adding Up cells in one colum IF cell in another column is yes,
HKW
Workday function including sat, excluding sun,
Handyy
Re: what if the result of a formula is text,
daddylonglegs
Re: Excell 2000,
Bob Phillips
Re: IF X = Reverse of Y True = 1 False = 0,
Bob Phillips
Re: COLOUR,
Bob Phillips
Re: INDEX then MATCH,
Biff
Re: "300" notfound?,
Biff
Re: Increasing number of columns beyond IV,
Biff
Re: increasing a value everytime excel is opened?,
Peo Sjoblom
Re: Excel 2000 worksheet is off centered for viewing,
Peo Sjoblom
function to add or remove,
Michael Hayes
Convert real number to an h:mm:ss display,
Tom Weyand
Re: If 2 cols meet a criteria then sum the 3rd column,
Dave Peterson
Regression intercept to 0,
squalidae
Help with a problem have tried a number of things,
dexman
Re: How validation dropdown list open when cell is picked?.,
Debra Dalgleish
Re: random numbers,
daddylonglegs
Re: How do i ignore letters in a formula?,
daddylonglegs
If statements,
kieffer
Removing blank cells in a column,
Dallas101
Re: How do I set up Reminders in an excel spreadsheet?,
Flintstone
Re: Using colors outside the standard palette,
Bob Phillips
Re: Find value grater than X but less than Y,
Bob Phillips
Currency to Text,
mytipi
Re: Return Totals from Certain Criteria,
daddylonglegs
Re: Dividing a time span into shifts - overlapping days,
Biff
Re: Imported Data creates blank cells that aren't really blank,
CLR
Adding to Summed Figures,
Copper via OfficeKB.com
number anagram,
spyshot
Re: Colomn of various dates, count & give % of all under 1 year, etc.,
SteveG
Re: sumproduct help,
Domenic
Searching a column and returning a yes or no answer,
mrscreensaver
Re: Mail Merge in Excel,
Don Guillett
Need assistance: Count non-blank within date range,
Paul
Re: dynamic print area,
neillcato
function for finding repeats in a column...,
killertofu
Re: Formula to Sum Cells that Hold If Formulas,
Bob Phillips
Count non-contiguous cells where value is greater than 0,
anre5180
Possible index/match problem?,
smoore
Find,
jonathan9560
Cant figure out formula?,
oxicottin
updating date!,
via135
Re: calculating years/months with YEARFRAC?,
SteveG
Re: YEARFRAC formula question,
SteveG
Re: Countif,
Bob Phillips
Re: Adding A "Timer" to a Macro,
Bob Phillips
Calculate Start Dates based on Need-By Date?,
GB
Re: AVERAGEIF AND SUMIF AND COUNTIF,
Don Guillett
Commas in indian style,
SVC
Re: Gray vs Black Lines,
Max
Re: view page breaks,
Dave Peterson
Re: Text Error Message,
Dave Peterson
search string command to answer simple Yes or No,
mrscreensaver
Sort data into order of product,
Jackmac
2 columns,
darkbearpooh1
compare date to column data,
Custermd
compare date ranges to set up eq,
Custermd
Re: How do I write the word "sample" across a sheet?,
Bob Phillips
Re: calculate time periods,
daddylonglegs
Year and Date Funtions,
Corey na
Excluding in Excel,
Kuba