Excel Worksheet Functions - Page 157

Thread / Thread Starter	Last Post	Replies	Views
skip blank rows when pasting formulas Newsgal	by virendra.telkar	1	508
conditional formatting Nathan1111	by Dave R.	1	295
Worksheet e-mailing Always Frustrated	by Bob Phillips	1	392
left click on a cell and more cells are highlighted anand sharma	by Gord Dibben	1	864
Semi transparent chart fill plainolddad	by plainolddad	0	732
IF function mtate	by Sandy Mann	4	274
HOW DO YOU CREATE DROP DOWEN MENUS IN EXCEL? Bren	by Gord Dibben	3	544
How to match sort and lineup 2 sets of data VTALABRAT	by VTALABRAT	0	696
Ref from table to cell Steve	by Steve	0	340
julian dates in Exel danielle	by Alan	1	448
Array Function Question sunfish62	by sunfish62	3	473
Why does this fail? =TEXT(RC3,Number)&" / "&TEXT(R32C,Number) =TEXT(RC3,Number)& / &TEXT(R32C,Number	by garfield-n-odie	2	675
I need to return the name of a worksheet in another worksheet cell? Rick	by abcd	2	603
getting name value in cell from If formula Nichole	by Biff	5	388
More- AutoFill with Non-Seqeuntial Cell References ? [email protected]	by [email protected]	4	967
Sorting dates Heather	by Biff	1	492
find and replace cell reference to a new worksheet Johnny Van	by Johnny Van	0	908
How to sum the last 5 non-blank cells in a row? SunriseCea	by Domenic	4	1,629
Sumif where sum range is more than one column? John Mitchell	by Peo Sjoblom	1	1,144
Problem with function "Worksheet_Change" konpego	by konpego	0	736
validation rule andrewm	by andrewm	7	613
how do i MAX to display the person who got MAX Konrad Walsh	by Aladin Akyurek	3	454
Display count of rows Judy Ward	by Biff	2	825
an error.type test Maileen	by Maileen	0	392
How to represent an empty cell in excel formulae? Sibi Melvin	by Max	1	614
Realtime Automatic sorting of data in rows in new work sheet Gazzali	by Gazzali	0	904
Problems with PULL function, INDIRECT.EXT and so forth [email protected]	by sthackwray	4	928
Conditional Format to highlight blank cell DaveMoore	by davidm	4	2,955
Setting a reminder up Shep	by Bob Phillips	2	1,021
How to setup a hyperlink to an indirect function? Skot	by Max	7	3,670
Trend Forecast Help MIVELD	by mangesh_yadav	3	451
Currency format Samir Kapadia	by Mangesh Yadav	6	754
How do I allow users to make a choice in a worksheet? Jim Zavone	by Jim Zavone	2	759
not equal to zero ellebelle	by Bob Phillips	3	995
Help with Formulas please!!! certain_death	by Jerry W. Lewis	1	318
How can I convert an 8 character Hex word to binary for a lookup? Seagondollar	by Seagondollar	5	910
calculating hours bus2408	by Bob Phillips	2	942
Another of Excel's idiosyncrasis Buce	by Bruce	3	401
The ROUND function Louise	by Bob Phillips	3	551
Need formula to count number of books sold Watercolor artist	by Watercolor artist	4	642
Formula for Colin F Barb R.	by Barb R.	0	353
I want data on sheet 1 to input into sheet 2 also walott1	by Neil	2	887
Pulling my hair out, need some help building a formula Jackanorry	by Jackanorry	2	441
IF Function returns False instead of 0 BEEJAY	by BeeGee	2	3,187
need Excel function like INDIRECT but can't open all spreadsheets Big Al	by Bob Phillips	1	394
If (cell a2 is greater than 1, but less than B2 - C2, "X") how do Colin F	by BenjieLop	2	417
Compare 2 columns & format row moremetrics	by moremetrics	2	324
Copy data in other sheet Moynul Hoque	by Moynul Hoque	0	686
Result in Cell is Wrong Lilbit	by bj	1	293
Help creating single cell Pop-up Bill	by Bill	2	581
Moving formulas Chris White feeling dumb!	by Bob Phillips	3	359
Hyperlink-Programable replacement of Text with Its Actual Address Kathy	by Kathy	2	499
Cell Calculations Lilbit	by Lilbit	4	468
How do I calculate APR for interest-only loans MK Manzer	by N Harkawat	4	2,056
IF Function trhhs	by swatsp0p	2	338
Control Toolbox John Data	by Bob Phillips	3	588
RECORDED MACRO PASTE'S DATE DIFFERENTLY TO MANUAL PASTE Pauldecan	by Pauldecan	0	587
Help creating dynamic refrence cells Bill	by Bill	0	423
Get aveages for last few days Sick Puppy	by Domenic	15	976
if greater then 99 then 1 if greater then 199 then two N.R.	by Bob Phillips	2	721
highlighting required fields maryann	by Barb R.	2	944
Dynamic Formula? atran	by Domenic	6	386
Ref from table - complete Steve	by Biff	3	406
Creating a bar graph manually WLMPilot	by Biff	5	888
Function to find row with most current date malik641	by Ron Rosenfeld	3	1,023
lists and validation andrewm	by Debra Dalgleish	3	416
How can I make a cell mandatory and only accept a Y or N? Vicki	by Ron Rosenfeld	1	1,006
Create a pick list to use to go to a text cell in Excel Pegita	by Debra Dalgleish	1	1,152
how do i get the name of a newly added sheet that i add with Sheets.Add in a vba macro in excel? Daniel	by Alex	1	567
is there anyway in an excel macro to reorder the sheet tabs from left to right? Daniel	by Anne Troy	2	981
Excell linked to outlook contacts Tofolo	by JPW	1	550
Format text in one cell based on value in another cell Liz C	by Liz C	2	1,362
in vba what command is used to determine if a particular cell on a particular sheet changed? some kind of event? how to get the old and new value of the cell? Daniel	by Chip Pearson	1	716
Cannot protect worksheet if it includes a list Elladene	by Elladene	0	640
How can a formula in a cell automatically update when inserting a. stbookkeeper	by Peo Sjoblom	1	909