Excel Worksheet Functions - Page 157

Thread / Thread Starter	Last Post	Replies	Views
skip blank rows when pasting formulas Newsgal	by virendra.telkar	1	507
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	855
Semi transparent chart fill plainolddad	by plainolddad	0	730
IF function mtate	by Sandy Mann	4	274
HOW DO YOU CREATE DROP DOWEN MENUS IN EXCEL? Bren	by Gord Dibben	3	536
How to match sort and lineup 2 sets of data VTALABRAT	by VTALABRAT	0	696
Ref from table to cell Steve	by Steve	0	339
julian dates in Exel danielle	by Alan	1	445
Array Function Question sunfish62	by sunfish62	3	470
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	601
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	957
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,627
Sumif where sum range is more than one column? John Mitchell	by Peo Sjoblom	1	1,143
Problem with function "Worksheet_Change" konpego	by konpego	0	730
validation rule andrewm	by andrewm	7	608
how do i MAX to display the person who got MAX Konrad Walsh	by Aladin Akyurek	3	453
Display count of rows Judy Ward	by Biff	2	823
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	903
Problems with PULL function, INDIRECT.EXT and so forth [email protected]	by sthackwray	4	924
Conditional Format to highlight blank cell DaveMoore	by davidm	4	2,954
Setting a reminder up Shep	by Bob Phillips	2	1,018
How to setup a hyperlink to an indirect function? Skot	by Max	7	3,665
Trend Forecast Help MIVELD	by mangesh_yadav	3	449
Currency format Samir Kapadia	by Mangesh Yadav	6	749
How do I allow users to make a choice in a worksheet? Jim Zavone	by Jim Zavone	2	754
not equal to zero ellebelle	by Bob Phillips	3	991
Help with Formulas please!!! certain_death	by Jerry W. Lewis	1	317
How can I convert an 8 character Hex word to binary for a lookup? Seagondollar	by Seagondollar	5	907
calculating hours bus2408	by Bob Phillips	2	939
Another of Excel's idiosyncrasis Buce	by Bruce	3	401
The ROUND function Louise	by Bob Phillips	3	550
Need formula to count number of books sold Watercolor artist	by Watercolor artist	4	640
Formula for Colin F Barb R.	by Barb R.	0	352
I want data on sheet 1 to input into sheet 2 also walott1	by Neil	2	886
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,185
need Excel function like INDIRECT but can't open all spreadsheets Big Al	by Bob Phillips	1	393
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	323
Copy data in other sheet Moynul Hoque	by Moynul Hoque	0	685
Result in Cell is Wrong Lilbit	by bj	1	293
Help creating single cell Pop-up Bill	by Bill	2	579
Moving formulas Chris White feeling dumb!	by Bob Phillips	3	357
Hyperlink-Programable replacement of Text with Its Actual Address Kathy	by Kathy	2	493
Cell Calculations Lilbit	by Lilbit	4	466
How do I calculate APR for interest-only loans MK Manzer	by N Harkawat	4	2,055
IF Function trhhs	by swatsp0p	2	337
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	422
Get aveages for last few days Sick Puppy	by Domenic	15	975
if greater then 99 then 1 if greater then 199 then two N.R.	by Bob Phillips	2	716
highlighting required fields maryann	by Barb R.	2	940
Dynamic Formula? atran	by Domenic	6	367
Ref from table - complete Steve	by Biff	3	391
Creating a bar graph manually WLMPilot	by Biff	5	883
Function to find row with most current date malik641	by Ron Rosenfeld	3	1,022
lists and validation andrewm	by Debra Dalgleish	3	415
How can I make a cell mandatory and only accept a Y or N? Vicki	by Ron Rosenfeld	1	1,001
Create a pick list to use to go to a text cell in Excel Pegita	by Debra Dalgleish	1	1,147
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	562
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	548
Format text in one cell based on value in another cell Liz C	by Liz C	2	1,359
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	638
How can a formula in a cell automatically update when inserting a. stbookkeeper	by Peo Sjoblom	1	908