microsoft.public.excel.worksheet.functions
- IF statement with logical_value that is similar to this 0<a1<10,
Mortgage Man
- type information in one column and second coloumn will know respo,
Mstotler
- EDATE,
Droodhall
- how do i do this ?,
phil
- selecting multiple sheets,
Shaun
- Put an if statement according to cell format,
Melkett
- Show values from other sheet,
TONY
- Timecards, hours & minutes,
Dixie
- duplicate words,
lbrew
- Extend series using ref cell formula transposed,
Gnomie
- If statements with validation lists,
Tony Houston
- How can I print a drop down list,
milkeyway
- IRR weekly basis cashflow,
alimirfarhad
- validation list with drop down list of options??,
luke013
- dropdown with validation??,
luke013
- file creation date,
munken
- Update Links problem,
andyp161
- Deleting Lead Zeros,
Hardip
- Excel: Add/subtract to existing value in same cell,
DOING MY BEST
- how i make the excel send data or save it to another bad file,
mahmoudsamy_11@hotmail.com
- Excel 2000 VLOOKUP returns #N/A unless press F2 return on source?,
Colin
- USCASCII characters,
The PhoenixTN ICT Team
- Look for the first non-blank cell above!,
Tetsuya Oguma
- move to another cell within a subtotal report within a macro,
NoelH
- sort,
nospam
- Frequency Array and Bin Array,
LabLost
- rolling 12 months,
D
- automatic numbering of rows in excel, how to?,
Linda C.
- Sample selection in Excel,
AndersonsWorks
- I need help converting a column from "cm" to "mm".,
LabLost
- Excel convert 1 row 5 words INTO 1 row 5 columns,
Kristen Kay
- Pivot, Sumproduct or both?,
tim
- Information Rights Management,
Teddy
- Saving into 1 workbook as a different worksheet,
dataman777
- Re: Counting a day of the week,
Gnasher
- Rank based on criteria,
Steve DeBruin
- select a file name for a link?,
Larry M in NE
- Advanced filter does not filter,
sdavies88
- Formulas when dividing with negative numbers,
Performance Nashbar
- Are there functions that perform robust statistics in Excel?,
froot_broot
- Re: HOW DO I CREATE LISTS WITH CELL REFERANCE RULES,
Debra Dalgleish
- validate input of cell A1 to either 8 or 0 based on cell B > 0,
Captnsvo23t
- Formulas not showing results,
sonar
- Open separate window,
Robbin
- Find data using three variables, all of which may repeat.,
Joe R.
- not sure what formula to use,
mark petrak
- Recap Worksheet,
Rob D
- Data Validation Manipulation,
pyarb
- #Name? Error in User Defined VB Function,
idgity
- Excel 2003 - How do I set up a short cut key for the cent symbol?,
TanMan
- Rounding/Significant figures,
cloots
- having a table in excel,
ashaback
- How can I put result of If worksheet function into a different cel,
Janice
- Referencing Cells Using If Functions,
Tonometer@yahoo.com
- How do I save as a web page without losing comments box with pictu,
Gailc
- Input Cell in One variable data table,
Dottore Magistrale
- separating numbers and letters from alphanumeric cell contents,
PH
- Date Problem's,
bperks
- Formula for If Term is on Certain Date then Count,
Krisjhn
- Use a cell's value to set the source file name in link,
Lost in Parsippany
- share excel document,
Aew004
- Create AVGIF function,
plindsay
- Have I exceeded nesting limit,
KeLee
- IF, AND Formulas,
candyyoung
- How do you split one document into two columns?,
joanster00
- Macro virus,
Morrigan
- complex date function,
tjb
- How can I retrieve multiple rows that match one criteria, i.e. a d,
Morgs
- what formula do I use to count right-justified cells in a row?,
Laura
- Message not available
Protecting Columns when another is used,
Malcolm Austin
Nested Subtotal Formula,
nickimu
how do i pull all subtotals from a spreadsheet,
Gracie5139
cell fill colors in excel 2002 sp3,
T
How can I copy and paste the text of a formula?,
Jeff
3D formulas in Excel,
Stef
Date format when using a vlookup,
Rob Laman
Changing data within one row,
timmyg
FU: Distribute info from "summary" page to separate pages under condition,
markx
Pivot Table -- Add column to average Grand Total,
Lynn
Distributed retrival,
Ulf
How can I calculate columns?,
Ninabean
Help with formula that unexpectedly returns an answer,
Geoff C
ActiveCell giving blank value in vbscript,
itstome
x axis labels/scale move to middle of chart w/neg & pos line cht,
rak
Distribute info from "summary" page to separate pages under condition,
markx
Sorting Dates,
allmad
Vlookup on multiple similar entries / NO VBA,
cedequ
Extrahera tal från alfanumeriska strängar,
Anders
I need help calculating dates?,
jeda67
A number of days into weeks and days,
Robert Christie
Find duplicate,
Davor Županić
Hyperlink problem,
Glenn Richardson
cell value change event,
alinasir
RE: Dependant Droplist showing distinct records,
Sara Hopkins
Cannot Print From Excel,
exortec
Help with Ledger/accounting formulas,
jam4jah
Setting up hyperlinks automatically,
symean
Input to populate report worksheet,
victorcab
getting excel to switch to a new row,
caldolegare
total a colum using data from another column,
Duffey
Count unique entries,
BeSmart
Change number to text formula,
Fesk
worksheet is locked on highlight how do I unlock it,
jorge parde
Merging new data,
Louis
Solver returns non binary answer in binary constrained cells,
Navy Student
GETPIVOTDATA - return cell reference, not value,
Slider
Is there a Division funtion in Excel?,
Seaflower
convert date of birth to mos. old now, 30 and 60 days,
Samantha
How do I find address of cell containing maximum value,
Doug
how can i rank a column in excel,
David B.
CELL IS BLANK BUT NEED IT FILLED WITH SPACES TO A SPECIFIC LENGTH,
CHARI
Worksheet Selections in Macros,
Karen
Exl: how to? If column N value =R, then copyentir rowto sheet 2,
Cynthia
words means numbers,
Zack
How do I display a graph from one workbook to another,
Susan
How do I return a blank for VLOOKUP instead of #N/A?,
ExcelBee
is there a blank drlling AFE available,
oil & gas 2488
Calculating Percentage,
mconnolly
Can I sum only highlighted cells in a worksheet?,
Mr Harlow
Excel Lookup with If,
victorcab
How to protect sheet but allow grouping to work,
dwsmha
How...?,
Davor Županić
Comments Help,
Dave 2005
function vba,
Joost
Sum of a row minus two smallest numbers,
Philippe
Combining worksheets,
walshpark
Adding columns to a worksheet,
Traci
Comparing Cells,
EXCEL101
Round function that rounds down if 5,
Mikus
how to change formula bar settings,
eccentric
Add more than 65536 rows?,
Roby36
Counting rows containing data (both numbers and text),
mconnolly
functions with nonadjacent cells,
PCdummy
Drop down lists show button?,
coal_miner
Reference an identical cell on a different page using copy/paste?,
Radar
SUMIF with multiple criteria,
stacyjhaskins
Offset And Vlookup Combo Help!!,
kollizion
Comments,
Dave 2005
Hightlighting Numbers & then all Cells to the right of these Numbers.,
Dave
Paste Link,
Freshman
Message not available
Sort function or macro for the first 4 letters,
Matz
Database type Formulas,
Smejk
how to save/copy data in cell to a series of cells on another pg,
Azrael
graphing algebra equations,
coryriffel011
Making a drop down list/column,
Kim
Overtime Hours,
Zack
Paste question,
SteveR
Creating a formula for down and distance,
Cecil
Formula does not work with 13 digit numbers,
sonar
Need Help,
abdul hanan a via OfficeKB.com
Count down formula,
Foss
Excell Check Digit Formula,
tnelson
Excel 2004 Mac Version - INSERT LINE BREAK IN INFORMULA,
Daniel
Complicated sort function with sort and sum,
Matz
Figuring hours,
scott45
How to consolidate data from multiple worksheets.,
SAR
Any MVP to try this ..,
Mubeen
import text and sort data into excel,
Boozman
Auto Sorting,
Freshman
I cannot edit a graph,
F.C
STPCScut STPCScopy macro missing??,
Gerhard Silbermann
can i store percentage formulas to reuse them?,
Jess
how do I calculate hours using one cell only,
James Fullmer
How do you reference another cell in the criteria of a SUMIF funct,
Hold the Onions
IF function trouble,
raye
Finding text within text,
Cathy Landry
Less i column,
Steved
"tomorrow worksheet function",
Stephany
sum / lookup w error correction,
Robert
um... im lost,
bamboo
Re: Please make it easier to access the IS functions (e.g., isblank) .,
Blue Hornet
Index function works in A2, but not in A10, Why is that? Cant figure it out.,
sonar
- Re: Index function works in A2, but not in A10, Why is that? Cant figure it out.,
Bob Phillips
- Re: Index function works in A2, but not in A10, Why is that? Cant figure it out.,
Sandy Mann
- Re: Index function works in A2, but not in A10, Why is that? Cant figure it out.,
Biff
- Re: Index function works in A2, but not in A10, Why is that? Cant figure it out.,
sonar
- Re: Index function works in A2, but not in A10, Why is that? Cant figure it out.,
Biff
- Re: Index function works in A2, but not in A10, Why is that? Cant figure it out.,
sonar
- Re: Index function works in A2, but not in A10, Why is that? Cant figure it out.,
sonar
- Re: Index function works in A2, but not in A10, Why is that? Cant figure it out.,
Biff
Complicated Formulas,
Andy (Hypnotic_Monkey_Scratcher)
How do a lock a picture to the rest of the spread sheet row entry,
Captain Paul
variable as a cell reference?,
jim sturtz
Creating a league in excel,
Whizz
counting decimal places,
Warren Smith
how to count the number of decimal places in a cell?,
Warren Smith
Automatically copy values,
Pankaj
How do I sort (or group?) a spreadsheet by similar rows?,
steve
add leading "0",
blt
joing (merge) tables by key field,
Alex Kachanov
how to get the name of the sheet in a cell?,
Alexandra
how to spell out number using function in Excel,
Beans
if/then statements,
Molly
How to insert a picture with IF-function,
Alexander
How do I calculate if a date is in a certain time frame?,
Pe66les
Invoice Numbering,
thecashman
Selecting from a Validation Drop Down Box aborts macro,
Lreeder
IF Statements-Circular Reference,
CP
Get other sheet names into a column,
Keyser
making the range a set of data within a column,
RFKFREAK
Re: selecting certain text in long row of text,
Alan
copy certain data from one row,
Jonathan
Adding superscript in text function,
JoeyZaZa
Can I auto fill a cell in one worksheet by typing a code number,
Gomer Pyle
formula for linear regression,
DBane
conditional formula,
Matt
Adding numbers to a running total,
Elizabeth Free
IF Function Help,
capiche
Lookup across multiple worksheets,
DCSwearingen
How can I replicate a conditional sum formula?,
Dan
Help needed with Adapting complex INDEX formula,
sonar
Use of iteration function,
Eddy VG
how to share spreadsheed in excel with a person at another comput.,
jfmom2
Error in http://www.exceltip.com/st/Compare_two_worksheets_using_VBA_in_Microsoft_Exc,
JAtz_DA_WAY
Is there a way to copy multiple worksheets into one, row by row?,
Janet
In Use Message,
MaryAnn
How to make excel not to compute formula,
anoopra
Changing dates entered in 2005 to previous years,
lucy
How do I specify more than one argument for the SUMIF function?,
Paul Chalmers
how to find returns for lump sum & yearly investments,
jackoat
Count the occurence of more than one condition,
wutang1105
Compound interest rate of return on investments,
Laude_in_LA
Formula requireing the system time,
Major Tomm
COUNTIF criteria using date ranges?,
Annie
is date can be filtered to a different cell?,
Morphyus C via OfficeKB.com
autosend for excel worksheets for distribution list option,
Nicole
Can You Translate This Function Into Excel Format?,
iwgunter
Hit enter in cell & move text down in cell, not go to cell below.,
raoul_duke
Signifcant digits,
Daniel Bonallack
how do i convert 536 seconds to 8minutes 56seconds,
bzbjg
Lookup value throughout an array_return adjacent value and summing,
SP
Opening workbook in user-defined folder,
pdberger
Concatenation with leading zeros,
Laura K
I lost the box on the top of Excel that you can type text in???,
andrew
my output appears very small,
Ugonabo
fill series is incorrectly copying result,
Roxy
sort rows in alphabetical order and move the corresponding data,
lianeanddave
EXCEL 2000 AVERAGE function,
TREBUCHET
How to move characters to the end of the string,
Phil
Hyperlink probelm,
Glenn Richardson
Exponential values,
Malotsha
IF ranges for multiple columns greater then less then,
Soccer_Ref
Linest function: data selection problems,
NathanG
Linest function: data not being selected in formula,
NathanG
Collapse rows with duplicates,
mlcrane
Can Excel operate a function based on a true or false result?,
SteveD
look up,
krk
EXCEL WORKSHEET,
Egyptian Sue
Select updated data from a range of columns,
Alylia
opslag,
krk
Difficult Time equation,
bcbjork
Inserting a row with functions,
Elbowhite
Find last occurance of text in range,
farutherford
overtime formula based on dynamic date range?,
kalika
Linking information between workbooks,
Jenny Potter
Summing a variably-sized range,
Titan
creating macros in multiple worksheets,
Shana@KL
SUMIF with 2 conditions,
Simon
Advanced Auto Filtering,
Connie
How do I find the last number in a column of numbers?,
Shyam
Is this possible please if so How. Thankyou.,
Steved
Dynamic VLOOKUP function,
Barb Reinhardt
Showing a unique random number w/o duplicates,
tx12345
Vlookup using a range condition,
John
Select unused number,
drbobsled
'SUM' Tables,
masster
Combine into one please,
Steved
Hourglass comes up when going between split screens.,
jimbcpa
TWO IF,
Bel
EXCEL should be able to split times especially second fractions,
samitoni80
Eliminate empty rows when extracting info from 1 wrksht to another,
TanyaE
if amount <0, put the all line in red,
doudou
Array formula needed,
Ann
Converting text to numbers,
Sara
How do I filter out data by font color in a spreadsheet?,
DeanneJensen
VLOOKUP Help Needed,
ACA Marketing
Default font for Comments,
Liz
Formula for Ratios,
Dave Y
Re: i can not fliter unique records,
Jeni Q
how combine multiple tables into one,
Pinocchio
Having trouble printing selected columns on one sheet.,
vivavegas02
Counting Months,
Farrel
HELP!! I need help w/Conditional Formatting,
anjgoss
Average of numbers within a range meeting certain criteria,
opal23k
Pivot Table - if Formula,
Sabine
Inserting Pictures with IF function,
DrewNov
Not Sorting Problem?,
lawdoggy
Problem, again,
Elbowhite
Autofilters-Remove (Top 10...) and (Custom) options from the drop-,
Jen in SoCA
Copy and Pasting Every Third Row,
teo2099
Modifying Macro,
carl
Retrieving Unique Values From A List - TIP,
ddwebb
Please Help: Adding an equation to a range,
tobriant
Color change - Cell Pointer,
Danny
Excel function to countif a criteria is matced within to columns,
=countif(data!A:A,"001",andif (data!B:B,
Count a value if next to another value...,
Pro_D Mike
Help with Excel Formula VLOOKUP,
Missy
Conditional Formatting Pbm,
RjS, CISSP
Referencing worksheet names,
Rich Hayes
Sum the results of an equation through a series of Cells,
AZ
Complex Macro to perform an operation as it steps down cells?,
Jeni Q
How do I convert time (2:30) to a number (2.5) in a formula?,
tammyj
Drop down list button hidden,
Cathy Landry
Comparing a list to a Calendar worksheet.,
PatrickL
conditional copying of sheets,
SaintJ
put the index back into excel help - I want pop-down of functions,
BerkGA
Saving Version Control,
Rob
How do I get Excel date to change from 1/1/1900?,
Macdad
Counting a range,
Blink
How to update links between wk sheets,
nander
Conditional Format to highlight entrire Row,
shital shah
Re: Add ins for Excel 2000,
jsurdahl
Function-formula help,
Robert M via OfficeKB.com
In Excel,how do I lookup a value and assign it to a list?,
Paul
formula for named cell/range using cell values,
alex
Subtracting date:hour from date:hour,
morten . krog
Please add an INTERPOLATE function. For vector or array data.,
Dan Gauthier
Index and match functions help needed.,
Zak
Hiding text so it doesn't print,
MrEMann
finding matching cells in worksheets,
Marcin Wolku
Validation Problems,
JDG
Returning a Value dependant on a cell which could have different d,
RemySS
font colour change within a IF formula - Help!!,
Andyp
wildcard use in formulas,
Tobias
function/formula help,
suki2shoes
Interest calculation,
JohnP
Date problems,
MrEMann
Cell Offset,
Jon C
Parse text & numbers & format,
dmiami
Help!! with a formula,
Andyp
how to enter numbers value for calculation?,
Joanna
HOW TO FIND DIFF. BETW. 2 DATES, IT SHOULD BE IN YRS, MONTH & DAY,
Mushtaq Ahmed .T
multiple cell editing,
George B.
Conditional Format to Highlight entire Row?,
shital shah
how can i filter data from one sheet and copy to another via formu,
mona
combine text of multiple cells,
Uncle O
mass cell data editing,
George B.
Return Single Instance of Numeric Values from a Column,
Sam via OfficeKB.com
Automatically insert row and copy formula,
Wendy
How to print detailed instructions for all functions in Excel?,
clark
trying to add text,
MM
SUMIF for Dates / Months ?,
ZMAN
Real Value of .UsedRange.Rows.Count,
dazman
How do I add time (in mm:ss) from multiple worksheets?,
Stumped
How can I match data about countries drawn from two database queries?,
tettrick
Searching Excel for a value,
Spottie
Data Validation dependant and unique,
Sara Hopkins
RE: SUMIF function not working,
Matt
Another Reason to Hate Insurance Companies (as if you needed one),
ajricks
Change color to red when fraction is negative,
clive1950
Help with Excel formula,
bb
IF Function or Countif,
Sue
Entering same data, two worksheets,
Mark from Michigan
Duplicates,
Steved
Changing a Link Mid-way Across Worksheets,
Frosty
cell custom format,
mark kubicki
=ppmt,
Principal loan payments
Refreshing drop down cell values...,
Dyce
fill a series of dates excluding holidays,
gsh20
assigning ranks to number ranges,
nikki8327
Ability for Excel to find and replace graphic objects (like Word),
Marjan S
"BLANK" - need to delete,
anjgoss
do I have to manually change PER to amortize a loan out 40 years?,
ldk
Formulas requiring a time stamp,
Major Tomm
Conditional formating help needed,
PCOR
ATTN: Mr. Bob Phillips,
Danny
Check if cell contains certain text,
jhockstr
can not enable macros,
Tricia
Can an IF formula result in a color filled cell in Excel?,
alesia
International Equivalents,
kt
How do I separate a text value with dashes?,
Phil
Carying Forward data with specific information,
sonar
VB Error, combining rows if...,
savvysam
Source Data in Pivot Tables,
cqc
puzzled,
chapm4
formula stays same in cell when new row is inserted,
drandall
vlookup, but ignore errors if #n/a,
Jess
Quick and easy,
chisigs2
Lookup and return,
Delia
errors and printing,
Karen
Excel finds a value that is not in the lookup range,
stumped
How do I input zeroes in a zip code for a mail merge?,
S_Suarez
DATA > TABLE -- 2 variable data tables?,
efarhat
subtact between times,
mreyes
Combo Box,
arich
Nested functions HELP!,
chiefnmd
Formatting Cells - color based,
AngelaG
IF - need to insert a cell value,
AngelaG
Excel - open a new workbook with "own" macro,
Danny
How to autofill data from one sheet into another,
kate
Automatic Sort with VLOOKUP/LARGE Functions,
G
HOW DO I MOVE A DESCRIPTION OR NAME INTO A SUBTOTAL LINE,
BEACHGRANDPA
Update worksheet by comparing two cells,
weeshie73
Sort defaults,
JohnM
copying formulas to another cell,
greg
Data entry for two worksheets,
Mark from Michigan
Nested If with And,
TheLeafs
date shows 1/1/1900,
CycloneGD
Array Formula help pls.,
klam
Nesting Problem,
vgreen
Excel Worksheet crashes when changes are made.,
Alexis
Average of the minimum+50 in a row,
PEA
lookup function bringing in wrong info,
Julieeeee
Re: lookup function bringing in wrong info,
rookerr
Message not available
pivot table to sheets,
Emom
Copy Formula to Different Workbook,
rookerr
COMPARE DATA FOR CHANGES,
SBCPA
Reading data in onther Excel document,
Ernest
Re: I want to convert 10,000 to "Ten Thousand" using Excel Function,
Bob Phillips
SUMIF Returns a #VALUE error when external source is closed,
ghynes
Final week - 2005 Excel User Conference - Ft. Worth, Texas - Sept 16/17,
Damon Longworth
moving cell,
Elbowhite
How do i make a range of cells change colour,
Spiller
IF STATEMENT in multiple workbooks.,
Yunus Patel
Autosum returns an incorrect zero value on the selected cells,
trying hard
LookupV,
Relax
Simple Copy from Worksheet to Worksheet,
emailreynolds
Error using "IF" in Microsoft Excel,
Justin
Sumproduct / Max array formula problem,
Andibevan
plz help,
yassar hayat
print bottom row repeat on every page,
nilesh
Date Language setting,
Office user
How do I set up an automatic running average in Excel,
shantagor
QUOTE NUMBERS,
paulh
Calculating the right formula,
michaelas
backing sales tax out of a total including sales tax,
trent
Using Sheet names in formulas,
Kirk
working with dates,
Pe66les
convert a PDF file on the Web to Excel,
Skippy
Matching a sampling # to it's row #number,
Jane
Newbe Help with count/countif function,
Cybertech
how can I blank out columns that are not being used,
rnooner
Cleaning up data from Crystal Report,
Leslie Coover
Lookup - Pro-rate formula,
Mal
How do you format a cell for % varience for multiple answers,
Brian, the Acctman
Re: How do I create a Map with an Excel worksheet?,
roblo
IF Statement??,
Cathy Landry
inserting a VISIO drawing into a worksheet,
Kurt Schoenrock
Product formula help,
Elbowhite
Formula for appending data,
DS
Caculating a "staircase" discount,
Thomas Refsdal
column to column conditional formatting won't work, need formula,
rrupp
How to transfer info from PDF file to excel (lists)????????,
towergrl@hotmail.com
Freeze frame printing,
excell wondering
Drop Down List Autofill,
Rita
Re: create a multivariable regression in excel without using array,
Conrad Carlberg
Re: Weeknum,
hhalle
Vlookup then OFFSET over and down,
mendozalaura
Drop - Down Box,
vaca
create default cell value,
BitsofColour
Formula Problem,
Jeanette
Exclude non-numeric data from calculation,
jostermi
Counting Match Pairs In Rows,
bmb2200
formula to identify weekend dates,
Cathy Landry
combine date one column, with time another column into third?,
psalyers
Is it possible to split a cell within a cell?,
MSFreak
Re: working with sub-totaled data without the detail,
rose
Create a master worksheet based on 2 different worksheets,
Kristina
moving the formula "average" over one column in a macro,
drumstu
formula with changing cell ranges,
Grant
IF statements/formula problem,
Admiral70
Excel for inventory aging?,
Patrick
Lookup function help,
marlea
display Calendar for Excel field entry?,
John Paul
Do I have a corrupt shared Excel 2003 File?,
sdsti
Help with formula...please,
Wutnik
Payment formula Question,
Bill R
Cell reference,
exploringexcel
how do you count checkboxes in excel2003,
plhanlon
use replace to edit a formula with wildcards,
koskyil
Pivot Tables - Named Range,
dipsy
School assignment: Excel worksheets.,
Mike U.
minimum along rows,
hochungwa
How do I total amounts on various sheets in excel?,
ExcelNewby
Function to return the active sheet name,
Will
excel, printing data in columns,
Nac
Identifying bottom of list,
T De Villiers
Range Changes with the Months,
T De Villiers
page numbering,
ksm1510
Counting Blanks,
T De Villiers
Editing Array Formula,
Robert_Steel
Countif using dates,
Bugaglugs
How do I delete the same item from all pages of a workbook?,
Suz
Best 8,
Eddie
Not including blank fields in pivot tables,
Bhupinder Rayat
coutif with 3 criteria including brackets,
Ray
randomly select value WITHOUT changing,
Doyle Brunson
How can I merge and link workbooks into one summary workbook?,
Sylvia
Time format in excel,
oldkrot
Could you help me to calculate overtime,
Svetlana
CREATE A SUM BASED ON DATES,
Gordon.Ferguson
RE: cover #s to text,
Rowan
how to change colour of text in true or false formula,
linda
How do I calculate time,
Amy Forster
Struggling Again With A VLOOKUP,
JohnK
Worksheet VBA function - not recognized,
G Lykos
Numbers converted into amount in words in English?,
Kapila
Formula for Calculating a Floating Date,
ksp
Help with IF & Average Functions,
Cybertech
Function Help Please ....,
SVTF
No Match,
francesrivera
Is there a way to reverse the layout of your colums?,
Jess
How to get pivot table Time field to appear correctly,
wccmgr
Question about Emailing,
Dolphin
How can I get fonts bigger on my dropdown list?,
BetMo
counting filtered items,
mar10
How do I do this?,
jtees4
Find certain text in a column and return statement,
TelecomAuditor
Need a help with the IF/ IFCOUNT function,
Xenos
Update of cell values after insert row?,
dazman
IF - Nesting... almost got it - need a bit of help,
AngelaG
Need insert a dash in between last 4 digits in text string,
Phil
Target.Address syntax,
Coolboy55
How can perform a summation?,
Leebo
drop down lists/validation tables,
mkingsley
Automatic Date Entry,
Neil
Nested IF AND OR function Inexplicable error,
MichaelC
sumproduct w/horizontal range not working,
dcd123
Spell Check an Unlocked Cell in a Protected Spreadsheet,
Jill E
Selecting a Worksheet Range,
Coolboy55
How do I calculate operating expense,
KAE1994
Links,
ynissel
Logic Tree, MS help = useless,
roffler
I need to insert a drop down menu in a cell?,
mccoyander
Create a print macro that would automatically select print area?,
wastedwings
Make an =if show - instead of 0,
Cube Farmer
Can I modify Excel 2003 color palette to accept Pantone colors?,
snowmobile
formulas using text,
bob
IF is not carrying out the FALSE part,
derekbrown
Getpivotdata - Excel 2000 vs. Excel 2002 and later,
giffordm
VLookup and HLookup at the same time,
Steven
Check to see if cell data is within a range,
mwrfsu
move one row to another in excel (worksheet),
Officer Cofer
merging sheet1 to sheet2,
RyanFC
If Statement Using Wild Cards,
Jasmine
custom cell number,
zander
Editing countif formulae,
Dean F
Generalised version of LINEST using QR Decomposition,
Will
counting date entries by month & year,
Di
I want to use the same function as SUMIF, but for two criterias,
Lars F
Max number of IF statements,
ynissel
I'm Having Problems with EOMONTH,
Ronni T. Vasquez M.
Date Range and calculation,
vgreen
Copy Formula - EXACTLY,
G
Recalculating a Regression Output in Data Analysis,
karin
Selecting Rows,
Coolboy55
save as macro/for password,
Dedrie
Automatically Sort By Reference Amount?,
G
Lookup and return multiple Values,
Neil
Workbook formulas,
fs1
Next Row,
Neil
In Format>Cell>Numbers>currency>Symbol Please add "Rs. India",
Surendera M Bhanot
Convert Text (letter) To Number Excel,
reloadinternet
Large function,
Sandy
Weeknum Function,
AnitaML
Splitting a Target Figure,
oldgit99
Help! Formula between the sheets,
ReBecca
Age with mont in decimal,
UPRAYUP
#N/A! to be blank please.,
Steved
unbalanced data in ANOVA,
The student
Sum of comma seperated values in cell(Reposting),
xcelion
Help with VLookup function,
JohnK
Referencing data in different worksheet based on month name,
cosmo_canuck
How to insert picture and automatically size to cell?,
ursa_nz
How to insert a picture that automatically sizes to size of cell?,
ursa_nz
Excel formula help?,
CKL
creating a rate schedule,
Melissa
Help with IF function,
Jim
Conditional Average,
Kstalker
Is it possible to place a stopwatch in Excel,
Kari
this may be simple, sumif question,
jim sturtz
what exactly are relational operators in Excel? All math symbol?,
JC
Countif based on 2 criteria,
N E Body
pivot tables reports - altering display of (blank) cells,
cak
I need help,
Natasha78
Help using the 'If' function to automatically fill in other cells,
Bugaglugs
Moving data in financial forecast,
ashleyfox
How do I calculated total hours per week,
FrankF
use only the first 3 letters of cell data,
N E Body
excel does not open file in network,
Bram
Convert numbers into its equivalent in words?(12 to Twelve),
AAMC
Formula to lookup Multiple Column Text and then Count Result,
ShelbyMan
Lookup Function Problems,
FFW
Modify A Formula To Include AND,
carl
Re: Naming Worksheets,
Dave Peterson
cell format limits,
Mike
Conversion of Cell Contents into a Functional Worksheet name ?,
GMJT
how do I add minutes and seconds together in excel,
BeirutBomber
Customizing MSOffice 2K Format toolbar.,
Mubeen
need assistance with merging cells,
Helen
#REF! help,
bill gras
Subtracting cell contents - I can't believe it's not working!,
drumz
IF RESULT OF FORMULA IS 0 WRITE EXTIMATOR,
byron
have a date cell pop up a monthly calendar to choose a date,
lillywhite
VLOOKUP using a cell calculated with NOW returns Error,
Chris Berding
web page numbers,
overtime101
totals from a tabel,
Streep
Calulating Age Formula,
YUMBUG
Nesting excel greater than 7 arguments,
Chris Berding
macros in personal.xls file,
Steve E
copying data,
Rick, United Kingdom
I am trying to set a letter grade for my students, HELP,
UTI Rod
VLOOKUP, INDEX, MATCH... What to choose,
Piloulondon
number to text,
torpido
How to auto number cells that have colour,
Dave
using item#s to link cells,
IndianRelic
Need if Statement,
nander
How to make repeat long numbers shortcut ?,
toyota58
Counting Multiple Values In A Cell,
DiamondDean
MOD function computation error,
Marian Megami V
Unprotect Cells depending on Cell value,
Abes
Need Help on Lookup function,
David
accessing an address stored in another cell,
SteveR
complex conditional formulas in excel using "IF",
jdmas
Keep all cells in one row together?,
bknight
sumif with similar cells,
Mosqui
Value between 2 dates,
AG
Help with SumIf,
retro
Excel sumif functions?,
John S via OfficeKB.com
Counting Unique Values Given Criteria,
carl
In Excel, how do I setup sequential numbering on an invoice?,
Kostumeroom
Will Excel produce invoices from a spreadsheet?,
officequeen
Min and Max,
carl
Hide Empty Rows When Printing,
Bob
cell values,
don . wick
double vlookup in same function,
Streep
coverting rows to columns,
Rebecca
countif criteria only one word of few doesn't work,
dcd123
function CELL() to return the formula in the referenced cell,
Streep
binary bit word,
Don
Can you sort a column in Excel that's different by colored font?,
JHoleman1
Pivot Table - Average of counts,
Dan in NY
how do i replace ( with / without changing format to fraction,
Splt Window Diner
filtered values can displayed in certain cell,
Morphyus C via OfficeKB.com
LOOKUP problem!!!,
G
range names or check box,
ynissel
how do I place the sheet tab name in my spreadsheet by formula?,
DRHannay
Group Contraction/Expansion in Protected Worksheet,
rj
Large Index Match Lookup,
Qaspec
Average function and two criteria,
Paula M
Convert Zip Code to County,
Michael
Help needed in finding specific series via row.,
hadmybreaktoday
Sorting Data question,
RPIJG
Can I make the data_field in the getpivotdata formula a cellrefere,
Henk
can u use formulas between tabs in a worksheet?,
Rocky
Lookup ADDRESS of GETPIVOTDATA Subtotal/Cell,
X
Password Protect,
Dedrie
Do Loop,
BobBarker
Positive Results,
lmthomas
having one more than one column index number,
Angel aAlegria
Text spacing in drop down lists,
Cathy Landry
Inventory Control,
Glenn
need information,
Angel aAlegria
Required fields with comments,
Cathy Landry
Match - #N/A,
comish4lif
How do I create a pivot table from multiple pages of data?,
PT Cruiser
Number of paychecks in a month?,
jkh1978
update cell in other worksheet based...,
mwrfsu
How do I use a "check(ed) box" as a criteria in an "=if" statement,
Bill Bromback
Insert blank row and issue a sum,
Walter Haddock
URGENT - Help with choice of formula,
Piloulondon
calculate a MEDIAN using multiple criteria?,
MetricsShiva
DGet vs VLookup,
earth21994
flag date within a cell after 15 days have past?,
SAUDIA
Check to see if a cell is populated,
bbmerc
Format not Really What It Pretends to Be,
VAF
Conditional formatting wth more than 3 conditions,
Sue
plot graph and place it in a cell possible?,
Ross
why does undo feature not work after value entered?,
dachsieluvr
aging formulas,
Susan
Subtract number of Working Days,
Casey
Update a Date Quarterly,
BD
how do I protect a worksheet and still use a checkbox control,
JayS
Lookup min & column heading,
Greg
Find duplicates then calculate..???,
daleuk
Maps of countries of the World.,
Carl Michael Jewitt
indirect function to reference cell on different sheet,
Dolemite
Can this be done? Conditional formatting,
AngelaG
Maximum If Help,
RFJ
Control function for copy/paste,
Vicky
Trouble with Image Control on a worksheet,
MChrist
Average if Help,
RFJ
Find the sum of Comma Seperated Values In a Cell,
xcelion
DATE (MOD) Function,
Robert
Function to convert Time String to Time,
Andibevan
Need to be done in 2 hours!!!! VLOOKUP returning #REF for unique I,
Kay
Hyperlink function without openening new Explorer every time,
nijunge
HOW TO CONVERT NUMERICAL VALUE IN TO ENGLISH TEXT,
KRISHNAMOHAN
How to protect different cells by diff. passwords?,
Mlavi
Using Vlookup to compare and validate data,
Big Jones
negative sumif,
Sue Sumif
woorkbook,
Exxalis
Triple occurence formula,
toyota58
Function 2 divide a number (ie $1.00) by % (ie 25%) to = ($4.00)?,
Gonecoastal1
My Quest with Time!!,
Philip
Validation for a cell,
Freshman
Visible rows and functions that work,
tracy
Dedrie, FORMATTING SUBTOTALS,
Robert
Excel Formula help,
pothgulla
how do i copy rows using critera in a formula?,
tim_302ford
Apostrophes instead of equals in Excel,
ARH
Identifying an item in one col/row and searching an entire spreads,
Bennie
mailing labels,
hitson
Work Schedule - Automaticaly filling name?,
YanYan
Why cant I use =countif(Jan:Mar!$b3),
Puzzler
Re: I have 12 scores over 12 weeks . I want to average the highest 5,
Bob Phillips
How do I change the format of a cell based on what I input?,
Husker87
Auto repeate parts of functions,
cjb
What do I need so I can open an Excel worksheet for editing?,
Kait
How do I convert a number of minutes into hours and minutes?,
gyrkin
Column Headers Not Fixed,
Cabby
Can a worksheet date itself?,
Scout
links to same files in different folders,
Henk
SUMPRODUCT by Date (numeric) value,
Jeanette
Rank based on Totals,
B . Baumgartner
filter/lookup question,
Qaspec
Formula needed,
Admiral70
USING NAMES IN FORMULAS,
Bill R
Excel should calculate exponentials properly (right to left),
expatrie
Linking cells,
Dee
Nested If with VLOOKUP's and AND function,
GBO
complex?? Q about Conditional formatting,
AngelaG
transfer one worksheet to another worksheet without losing format.,
TwiztidKitten
VLOOKUP - problem in stock request,
sonar
is there a way to add single digits within a single cell?,
ceci
how to auto assign po numbers in Excel,
Cathy Landry
text search help please?,
phil
Finding a function in Excel,
JSK
HOW DO I ADD A PRINTABLE BACKGROUND IN EXCEL,
andi
How to make "common factor" formula ?,
toyota58
number cell increment +1 when dragging down box,
Johnny Cake
Formatting Subtotals,
Dedrie
How do you make calculations between different tabs?,
Andrew1029
Please help!! Vacation Accrual Formula,
MissNadine
Hide Rows / Columns - complex question,
lw new guest
Problems with Copy and Paste in Excel,
signal2noise
Tricky maybe,
Frazcmankfar
How can I convert a scanned PDF paper document into EXCEL format.,
chasnick
RE: Can the =CELL formula be used to determine the worksheet tab name.,
ajaworowicz
MERGING COLUMNS WITH DUPLICATE INFO.,
PatrickL
wild cards in formulas and functions,
Carla at work
Hide columns & rows that contain "0" or blank in a range of cells,
lw new guest
How do i link Excel chart to Outlook automatic emails?,
beatacl
Drop down list,
timboellis
Formula help ... moving to next cell everyday,
chisigs2
Linking spreadsheets,
sbg1275
Formula to combine text?,
coal_miner
Pull down cell to access n&a spreadsheet,
bankprofessor
Need help adding :,
Mark
Vlookup problem,
Big Jones
How do I print two sheets in same workbook duplex?,
Suess0112
Formula to activate macro,
coal_miner
RE: How to make the cell or font color red if the number is negative?,
RODY
RE: WHAT'S THE FORMULA FOR CALCULATING OVERTIME IN 1 CELL? EXAMPLE: 8.,
RODY
Setting Purely BLANK Cell,
yokato95
Fourier Analysis,
jordon
Simple selection, but hey, I'm no guru!!,
Director
hyperlink,
IT05
blocking cells,
confused of nottingham
copy text between 2 open workbooks via macro,
bigdaddy3
Selecting Random Data,
Willie
Help on ifsum,
TYE
Help - basic formula question,
ReBecca
Autofilter - Link to 2nd worksheet?,
Kingsley H via OfficeKB.com
how to reference external refereces from a list,
FalconArt
Excel Function With Multiple Criteria,
mye0417
Adding the same cell in different worksheets. Can that cell be variable?,
ro
time sheet calculations,
emmcee
Re: How do I stretch the height of a font in Excel 2003,
Dave Peterson
Problem with Find and Replace,
mjhill01
Vacation Accrual Formula,
MissNadine
Nested "If" Function,
Ms. P.
Help for a newbie?,
rehr0001
sumproduct wildcats,
Mosqui
column won't sum,
CK
Linking with equals sign doesn't always work,
marty53
sharing rows of data across multiple worksheets within a workbook,
deedle93
Return unique fields only - but not a filter?,
Matt
re: Rand function,
Susan Hayes
Can I Somehow load a Spread Sheet thru a Scanner,
murashid
Average of count in pivot tables,
Dan in NY
Linking changing values (cells) between worksheets.,
Tumbleweed
Tools - Option - "move selection after enter",
jules75
GPA formula,
ladyrosemerry
Formula to get Relative Folder Reference to data in another file?,
RocketDude
sum product problem,
spirosu
Linking arrays and Worksheet names,
gsimmons2005
worksheets lookups,
JJC
Counting weeks,
Rick, United Kingdom
Overlapping or Duplicate Date & Time,
Mike
How can I do a lookup and get multiple row results?,
Rashmi
count function not working, keeps displaying 0,
dnm
sumif function,
dnm
Drop Down button with functions?,
hummus19
formula results take up to 2 lines if needed, but keep border,
smurf
How do I get the color format to follow the data when referencing.,
Color formatting while referencing
lookup with offset?,
GEORGIA
Count nonblank AND fill color,
Purseus
how to find duplicate cells in large array of numbers,
wonkywombat
copy text from 1 workbook to another by macro,
bigdaddy3
How do I use the "Proper" function? The instructions are vague.,
Polly
Sort columns by content,
Jane
formula to divide a monthly bill...,
Kim
Conditional formatting a full row triggered by a single cell,
neilcarden
If formula evaluating 2 cells contents,
N E Body
Re: vlookup fails on data from a pivot table,
Pat
#Value must be 0,
Conditional Formatting
worksheets vlookups,
JJC
Can I import a folder's contents as a dropdown list?,
Terp
Converting negative/positive numbers to a CSV (Comma-delimited .TX,
Frustrated Excel user
SUM, OFFSET and CELL("address"),
Quizarate
How can I copy a row as result of an IF function,
jantoni
formula suggestion,
Amandle
Is there an opposite function to "Concatenate" in Excel?,
drbonne
Which function?,
Tapsa
Reverse false and combine with true true value,
Emmie99
Need to merge columns,
Jay T
formula to use when number of rows changes dynamically,
confused
Saving onto Floppy Disk,
woodbunny
Row Sequencing,
Mark
Create conditional IF to format cells using 6 different colours,
NZJen
Assign values to text,
Town of Exeter
How do I sort worksheets in excel? i.e. Order them by date,
Nick
sumif on 2 criteria with worksheetprotection enabled,
Ed Wien 72
Finding an Excel value using one repeating & another value?,
Joe R.
customising toolbar.,
Mubeen
subtotal - multiple criteria,
mdma
Look up a value as close as possible to ....,
Mayo
formulas,
lou kynoch
Can I make the number in one cell automatically appear elsewhere?,
holmeshouse
Conditional formatting a full row triggered by a single cell reference...,
neilcarden
Month Counter,
ExcelMonkey
Sum product -Is column value in range/list,
confused
Conditional functions,
Big Jones
Missing linked file - can still be referenced but can't find it!,
dziw
the option to send an exle file as an attachment is not there,
Sandeep
excel, how do I get sumif with two criterias?,
Mosqui
how do I convert euro values to GBP in excel,
ReBecca
cell formatting?? and making it so that it will move to the first option on a listing,
ratt
How do I create an equivalent VLOOKUP function using FIND?,
dan
Pivot style return,
Matt
New Data Consolidation Question,
Excel Dummy
time conversion frustration,
harryhoo
finding end of document,
Jeanne
data analysis on fields with words not numbers,
Rebecca
Using Excel link (hyper?) and list functions,
iamgpop
Find Min of a row, but only greater than zero?,
RocketDude
calculate odd days interest,
oneswtmom
How do I calculate total hours by rate of pay?,
FrankF
How do I convert Meters to Feet and Inches?,
Dave S
Sumif with a twist?,
Bruce
lookup and sum,
Marc S
watermark,
sue
Absoluet Reference,
ChrisK
Re: how do i use the proper command,
JE McGimpsey
text has numerical values,
TXEagle
'vlookup' and/or 'if' help!,
lawdoggy
HELP HELP HELP HELP HELP,
PatrickL
IF STATEMEMNTS,
Judy
- RE: IF STATEMEMNTS,
David Billigmeier
- Re: IF STATEMEMNTS,
JE McGimpsey
- Re: IF STATEMEMNTS,
Judy
- Re: IF STATEMEMNTS,
JE McGimpsey
- Re: IF STATEMEMNTS,
Judy
- Re: IF STATEMEMNTS,
JE McGimpsey
- Re: IF STATEMEMNTS,
Sandy Mann
- Re: IF STATEMEMNTS,
JE McGimpsey
- Re: IF STATEMEMNTS,
Harlan Grove
- Re: IF STATEMEMNTS,
JE McGimpsey
- Re: IF STATEMEMNTS,
Judy
- Re: IF STATEMEMNTS,
JE McGimpsey
- Re: IF STATEMEMNTS,
Harlan Grove
Unwanted rounding of large number,
Candyman
Adding Column in an Excel Sheet by Command,
Dhiraj
why formulas have stopped working in Excel?,
queenjude
filter 15 worksheets so i can print all on one page,
kristie626
day/month/year in incorrect format for date format,
M&A_Jack
Grouping,
Vitruvius
all worksheets have 2 descimals,
Elaine
when editing a comment box,
Melissa1
Combine functions into one cell,
michael_fett@hotmail.com
circular drop down list on different pages,
Cbh35711
MsgBox with condition and showing details,
viddom
How can i get an If formula in excel to edit another cell?,
Jimmy Hoffa
Select by multiple criteria (Excel 2003),
Picman
count and limit radio button selections,
klintonselkirk
I need a system for keeping up with church members and finances?,
2marymary
unique alpha's in order,
ceemo
a question of differences,
AmyTaylor
EXCEL: Is there a way to insert a picture into a comment?,
m.l.v.
results display in filter function,
Morphyus C via OfficeKB.com
Purge macros,
Don_S
select a string of characters,
Did
multiple results when using filter function,
Morphyus C via OfficeKB.com
Running filters using a macro,
MarcusA
collect data from different worksheet,
sheva
Copying formulas with mixed references,
TMcMillin
conditional sum question,
Devlin
Future Value,
Juan Solis
Re: IF on the cell that contains it ?,
miko
preparing data for statistical analysis,
Jootje
Using COUNTIF,
Mouldydc
Sum If or DSUM help?,
towl
re auto cloring of cells,
bigdaddy3
CSV file importing to other software,
stevieD1981
sum or similar with conditions,
CHRIS K
I have saved an incorrect worksheet over the right one.,
Emma
Averaging across worksheets,
Pelham
can an excel spreadsheet be set to remove all hyperlinks,
lopv
Using LARGE Function,
Michael
Can conditional sum use wildcards in the formula?,
Chris
Two cell accumulator,
Bill
Illinois Personal Information Protection Act,
ktyson
how would I count dates (not # of days) in cells that fall betwee.,
sailingscotts
date criteria to select range,
Kstalker
- Re: date criteria to select range,
Max
- Re: date criteria to select range,
Max
- Re: date criteria to select range,
Kstalker
- Re: date criteria to select range,
Max
- Re: date criteria to select range,
Biff
- Re: date criteria to select range,
Max
- Re: date criteria to select range,
Kstalker
- Re: date criteria to select range,
Max
- Re: date criteria to select range,
Max
- Re: date criteria to select range,
Kstalker
- Re: date criteria to select range,
Kstalker
- Re: date criteria to select range,
Max
- Re: date criteria to select range,
Kstalker
- Re: date criteria to select range,
Max
- Re: date criteria to select range,
Kstalker
- Re: date criteria to select range,
Max
- Re: date criteria to select range,
Max
- Re: date criteria to select range,
Kstalker
- Re: date criteria to select range,
Max
- Re: date criteria to select range,
Biff
- Re: date criteria to select range,
Max
- Re: date criteria to select range,
Kstalker
- Re: date criteria to select range,
Max
- Re: date criteria to select range,
Kstalker
- Re: date criteria to select range,
Max
- Re: date criteria to select range,
Biff
Can Conditional Sum use wildcards?,
Chris
if statement,
pwoodix
Remove variable text in cells,
BHalberstater
RE: Cannot insert a row in Excel spreadsheet,
les nienhuis
I cannot edit my excel. How do I do it,
Excel Worksheets
IF function?,
YanYan
1 will be City, 2 will be Roskill and so on please.,
Steved
Validation List, Automatic Colors,
YanYan
1=City, 2=Roskill,
Steved
Hiding Rows using conditions,
Looney
Minimum Value & Cell Cross Referencing,
Johnny
help,
jtees4
vlookup backwards,
jtoy
Need help with a function I'm not sure exists,
Cervantes
How do I undo an action when multiple sheets are selected?,
Jared
Using certain data from lists in other cells in Excel.,
jandrewscott
Compare Data,
Tommy
simultaneous entry lookup problems,
arieck
Data Validation,
Roger Melton
Kilometres Calculator,
Steved
insert verticle lines between columns,
Glenn
Email only the filtered data,
stefani13
Creating & Combining Macro to Functions,
Wanda H.
Calculation,
Eric
How can I rank numbers based on other numbers?,
NoelMouse
sumif and colored fonts..,
Murph
Multi-conditions with SUMPRODUCT and COUNTIF,
MikeDH
How can I get the XIRR funct to work for a positive first number?,
Asiapro
Look up function and Max function,
karim
How can I return a cross referenced cell value?,
JR
Thanx David,
Mir Khan
V-Lookuo,
John
Count values in a cell,
Margarita Curbelo
filling information from one cell and filling another.,
Dianne
Automate the Text Import Wizard (Fixed Width),
Yagnesh
Unique Values,
JohnGuts
Delete text while numbers remain intact,
Sugar_grrl
Array index, match problem,
RAP
- RE: Array index, match problem,
Duke Carey
- RE: Array index, match problem,
RAP
- Re: Array index, match problem,
Bob Phillips
- Re: Array index, match problem,
Bob Phillips
- Re: Array index, match problem,
RAP
- Re: Array index, match problem,
RAP
- Re: Array index, match problem,
Bob Phillips
- Re: Array index, match problem,
RAP
- Re: Array index, match problem,
Bob Phillips
- Re: Array index, match problem,
Alan Beban
- Re: Array index, match problem,
Harlan Grove
- Re: Array index, match problem,
Alan Beban
- Re: Array index, match problem,
Harlan Grove
- Re: Array index, match problem,
Alan Beban
- Re: Array index, match problem,
Harlan Grove
- Re: Array index, match problem,
Alan Beban
- Re: Array index, match problem,
Harlan Grove
- Re: Array index, match problem,
Alan Beban
- Re: Array index, match problem,
Alan Beban
- Re: Array index, match problem,
Harlan Grove
- Re: Array index, match problem,
Alan Beban
- Re: Array index, match problem,
Alan Beban
- Re: Array index, match problem,
Harlan Grove
- Re: Array index, match problem,
Alan Beban
- Re: Array index, match problem,
Harlan Grove
- Re: Array index, match problem,
Harlan Grove
- Re: Array index, match problem,
Alan Beban
colors,
Mir Khan
substitute for =,
CEN7272 - ExcelForums.com
Compare Text in 2 worksheets where verbiage is slightly different,
annem
How do I use the PROPER function?,
Lynn in Tulsa
=concatenate With A Space,
nander
Add items in column 3 if column 1 and 2 conditions are met,
DB16
Extract data from one Worksheet to another,
extract data fr. one worksheet to anothe
AND function in Excel,
Big Jones
Timesheet Date Calculation,
HRMSN
VLookup Problems,
Pritch14
Can wildcards be used in the Logic Test of an Excel "IF" function?,
Monte
NUF schedule,
papy
IFSUM,
TYE
How prevent formulas to get external references/path to current workbook?,
Gunnar Johansson
excel date problem,
Saiju Mammen
How do I change the number on copy sheet so I don't have to renam,
crystal
How to do matrix operation with complex number elements in Excel,
WILSON CHIRAMAL
if functions,
HARSH BAHAL
Formula to determine shift,
Liz
Subtracting dates?,
Bill R
formula,
ste997
Problem with formula in Excel,
Bill R
NEED HELP! Cannot figure out complex function,
tiger
"IF" Function limited to 7 in a formula.... need 14,
VonSinkum
colums in uppercase only,
Dino Thomas
Payment formula problem..,
Bill R
how do i count how many people are working between two times in e,
APYDS
DSUM gives a #VALUE! error and I can't work out why!,
Treasurer John
SUM.IF...probable fingertrouble,
Borken
Sum function across multiple sheets,
neta
How do I set up an automated numbering system For my "Invoice Num,
Frank Medina & Associates
First Number in a Cell,
Kelly O.
PorductLog,
lucas_php
HD I build funct @if cell=AorBorC then ...else if cell=DorE then,
Jocko_MacDuff116
Dividing by unknown to get a number,
bundyloco
Microsoft Excel 2000 Subtotals with Group Name,
rhodyman10
How can i swap between the tabs in excel?,
CC
Complex =mid formula,
foff
Excell:Move from any Cell Sheet 1 to any cell Sheet 2 etc.,
eldo
Displaying info in a new tab in excel,
Khamul
time math,
USAOz
Re: formula that will subtract a number that relates to text,
CLR
countif question,
yeedao
Data From One Worksheet To Be Used In A Cell In A Different Worksheet,
ratt
Array Formula? Lists?,
FB
Removing Duplicates from a list,
JohnGuts
Look up function,
karim
Need help with Excel formula!!,
Need formula!!
Test IF Two Numeric Values Match (from two separate Dynamic Ranges),
Sam via OfficeKB.com
How do i keep a running balance without adding rows each time?,
park
RE: Blank cells,
Bill R
If(ISBLANK),
Bill R
Whether 3 diff fields are blank determines several different resul,
Bill R
How to hide unused cells when running accumulated totals,
grano2
Modifying A Formula,
carl
how can i make a cell always show text in caps,
thomas donino
Display single value for multiple ranges?,
Chris McDannold
Adding an ongoing value to an Average,
biggcheese
I there a way to not print a cell(s)?,
K Whitman
How do I expand columns in a table and auto change vlookup in wrks,
jlc
Stumped by a lookup scenario,
atomlin
adding zero's to a text cell,
Jennifer
Re: Validate cells have data,
Jim Simpson
how do I format a cell reference to move as source changes,
KGray
Summing a column,
Al Ramirez
Removing $$ Reference in cells,
Castor
Excel & MINITAB generated regression equations are different,
Earl E
Array formula returning terminated employees,
malik641
ENTER DATA EXCELL SO RELATED DATA APPEARS,
VICKIO66
Setting up page template,
John Sullivan
adding day (sunday, Monday) to date,
RickyDee
How do I set up an array using countif for 2 separate arguments.,
crich
How do I use a conditional (IF) statement in Data Validation?,
LindaB
Consecutive numbers in 1 cell,
LMiller
Re: Mode-1,
akyurek
editing custom dialog boxes,
Shadowrift
Use Range Name in Macro,
Blue Hornet
variable across all worksheets?,
Joe
MATCH Formula,
Sandy
I want to link, not just copy,Word source text to a text box in Ex,
Carrie K
Using a cell reference of a sheet in Vlookup,
crazybass2
Sumproduct Formula,
Mike
Vlookup question,
flourboy
Auto Filter,
lehigh46
Changing the max length of a worksheet name,
Dedrie
excel function cumipmt,
Computer Bob
"END mode?",
Roland
how do i maintain one worksheet from data from multiple worksheet,
Nensie Michel
Step value,
geza
Need Address Formula,
Gary
differences in groups of numbers,
pm
HELP: How to Repeat Cell Content into a Second Worksheet ?,
Vince
Listing data from multiple worksheets,
scottcts
cell shows 20. Formula shows 20. why not 540/27,
griswold
How do I use wild cards in nested array formulas?,
hopeit
Troubleshoot resetting hyperlink base to a network drive,
Diane
Line adherence,
exile
Running a Daily MTD average.,
Mike Punko
INDIRECT(ADDRESS... Across worksheets,
MikeDH
How do I remove hyphens from a product UPC?,
skpdpnt
How to use the "Fr" function, what is agrument,
Shirley
Identifying Cells with formulas,
VETcalc
Date Function,
Dee
Conditional Formatting?,
djn
Create a Macro to jump to next cell,
Programming Cells
Functions,
Rachel
merge multiple row cells of text corresponding to one row of data,
roberta t williams
Count blank cells since last entry,
Luke
sorting cells according to all cells in column A,
Jootje
Can I change a cell and cause an automatic change in other cells,
Swissmiss
Adding dates to get a date,
hssmith
DATA/VALIDATION/SETTINGS,
DATA/VALIDATION/SETTINGS
Stock qoute quiry in Excel 97 doesn't work,
mik
Macro Help,
douglascfast
Display each row as one recrd per page,
spardacus
How to convert DATE and TIME to text,
ice_pack
Excel worksheet function that will return the currency for a cell,
funmi_Bash
Look up for all sheets,
sgm020
Excel help!,
Excel help!
Working with Lists in Excel 2003,
ksp
HOW DO I HAVE A CELL DISPLAY INFORMATION BASED ON 2 OTHER CELLS,
CC
Freezing rows & columns,
Michael
Freezing rows and columns,
Michael
Tab Properties,
JohnHill
Need help with HLOOKUP and MATCH functions,
BEAR94
Filter not finding all cells in columns,
yowee
how do i unhide column after saving file,
moodysmb
Conditional Validation,
TTomSawyer
vlookup,
Tanya
Equity buildup calculation,
JimDandy
Need Help with SUM function,
spackler
Formula ? Return value from rightmost non-blank cell in a row of,
tgdavis
Excel Help,
JDeegan
Time Calculation,
Conditional Formatting
Indirect and Address in Reference to other sheets,
MikeDH
need help with formula,
jeremy via OfficeKB.com
conditional count,
Karen
How do I use turn GETPIVOTDATA function off?,
jwam
RE: Can I place a formula/cell reference in the Header/footer Exce,
james
Sumif function with remote cell references,
hennis
Sum rows in groups,
sandy
How do I consolidate data from many pages to appear on one page,
LUCKY44
function to find which cells add up to a given total?,
jbourgui
Problem with Solver and Integer constraints,
dave . rafkind
How do I calculate without decimals in excel?,
upstate
"Saturday as a work day?,
keith m
CNTRL + END is not working properly,
tgdavis
How to calc percentage,
excelgurudummy
how to reverse a range/array?,
peter dmz
subtract 10 from every number in a column,
gimianame
... If - Then ...,
Dr. Darrell
Dialog box needs to pop up (Excel),
Aimee
Australian "Payroll Calculator" worksheet??????,
Shazinoz
return most frequent objects/numbers in large worksheet?,
trav
Average from 2 unsorted lists,
KevinE
Average MTD percentage,
Mike Punko
Re: Formula for average recorded blood pressure readings in 1 colu,
BLUOVAL
delete #N/A's in Excel,
Mjoddie
importing data from Excel worksheet to another worksheet,
jbrick
Annual From Monthly Cashflow,
santosh kumar
fiscal quarter data validation,
Doug Glancy
Search Function,
mattsheffield
Conditional Lookup Functions,
Rlmccants
Compare 2 column list across 2 sheets,
GerryK
how do I calculate hours from a schedule,
GTT
What's faster? 1 workbook or multiple workbooks?,
WTG
is there a way to export just 1 worksheet of an entire workbook,
lizzie14
adding extra text into an existing column,
Zach
Can someone please help me,
stevenmorrison
Re: HOW DO I TOTAL A FILTERED LIST TO EXCLUDE THOSE EXCLUDED BY FILTE.,
Charlie
Goto statement in an IF function,
=\
Data Validation for Weekday entries only,
Casey
Creating an Excel TOC,
Brad
Spreadsheet sorts when saved,
Dena
Tournament Schedulizer?,
Dominic
add zeros,
Matt
How do I calculate a MTD total - yesterdays sales in Excel?,
skcaton
Changing the Name of the Column in Excel,
Santosh Budalakoti
Deleting rows based on a cell value,
JPriest
How do I change column headings from A,B,C to actual words?,
LCMom01
Returning list values,
bruner
Assigning ranges for values (e.g., $1,005 the range is ">$1K to 5K,
jennifer
Running Total with conditions,
Midnight404
Index of protected sheets,
Alan P
sorry,
ckiraly
Date & Time problem,
ckiraly
Time Sheet Function,
HRMSN
Removing text characters,
Scott
Need combinations of values from a list to add up to a specific Va,
GUY
Converting Excel to PDF,
Thomas Cox
QUARTILES in Excel,
Francisco
VBA for converting data into various CASES.,
Philip
How Do I Get The Difference In Hours and Mins,
medicom06
in an excell worksheet,
legin2
Performing a convolution in a worksheet,
peter dmz
How to average every 10 numeric values,
emel24
How do I find a missing number in a sequence of numbers?,
Nash
numbers contain hyphens to dates,
bill gras
Need help with Converting Rows of data into 2 columns,
Steve
VLOOKUP, LOOKUP without repeating??,
Brandon Williams
how do I open a spreadsheet from excel in works?,
Lola1954
User ID's,
CCloud
Is there a currency conversion tool in Excel XP?,
Gaitej
expanding range to reflect entries,
ijyoung
add DSum function that functions horizontally.,
RHusmann
Replacing #N/A with other text,
Dave
Count number of runs above or below average,
waxwing
Printing auto-filter settings,
Scott buckwalter
IF Function,
Excelhelp