Excel Worksheet Functions - Page 1027

Thread / Thread Starter	Last Post	Replies	Views
Help creating single cell Pop-up Bill	by Bill	2	579
Result in Cell is Wrong Lilbit	by bj	1	292
Copy data in other sheet Moynul Hoque	by Moynul Hoque	0	679
Compare 2 columns & format row moremetrics	by moremetrics	2	323
If (cell a2 is greater than 1, but less than B2 - C2, "X") how do Colin F	by BenjieLop	2	417
need Excel function like INDIRECT but can't open all spreadsheets Big Al	by Bob Phillips	1	393
IF Function returns False instead of 0 BEEJAY	by BeeGee	2	3,181
Pulling my hair out, need some help building a formula Jackanorry	by Jackanorry	2	440
I want data on sheet 1 to input into sheet 2 also walott1	by Neil	2	886
Formula for Colin F Barb R.	by Barb R.	0	352
Need formula to count number of books sold Watercolor artist	by Watercolor artist	4	640
The ROUND function Louise	by Bob Phillips	3	550
Another of Excel's idiosyncrasis Buce	by Bruce	3	396
calculating hours bus2408	by Bob Phillips	2	935
How can I convert an 8 character Hex word to binary for a lookup? Seagondollar	by Seagondollar	5	906
Help with Formulas please!!! certain_death	by Jerry W. Lewis	1	316
not equal to zero ellebelle	by Bob Phillips	3	988
How do I allow users to make a choice in a worksheet? Jim Zavone	by Jim Zavone	2	749
Currency format Samir Kapadia	by Mangesh Yadav	6	749
Trend Forecast Help MIVELD	by mangesh_yadav	3	449
How to setup a hyperlink to an indirect function? Skot	by Max	7	3,665
Setting a reminder up Shep	by Bob Phillips	2	997
Conditional Format to highlight blank cell DaveMoore	by davidm	4	2,949
Problems with PULL function, INDIRECT.EXT and so forth [email protected]	by sthackwray	4	921
Realtime Automatic sorting of data in rows in new work sheet Gazzali	by Gazzali	0	899
How to represent an empty cell in excel formulae? Sibi Melvin	by Max	1	611
an error.type test Maileen	by Maileen	0	392
Display count of rows Judy Ward	by Biff	2	819
how do i MAX to display the person who got MAX Konrad Walsh	by Aladin Akyurek	3	453
validation rule andrewm	by andrewm	7	608
Problem with function "Worksheet_Change" konpego	by konpego	0	730
Sumif where sum range is more than one column? John Mitchell	by Peo Sjoblom	1	1,139
How to sum the last 5 non-blank cells in a row? SunriseCea	by Domenic	4	1,626
find and replace cell reference to a new worksheet Johnny Van	by Johnny Van	0	904
Sorting dates Heather	by Biff	1	491
More- AutoFill with Non-Seqeuntial Cell References ? [email protected]	by [email protected]	4	956
getting name value in cell from If formula Nichole	by Biff	5	388
I need to return the name of a worksheet in another worksheet cell? Rick	by abcd	2	599
Why does this fail? =TEXT(RC3,Number)&" / "&TEXT(R32C,Number) =TEXT(RC3,Number)& / &TEXT(R32C,Number	by garfield-n-odie	2	674
Array Function Question sunfish62	by sunfish62	3	470
julian dates in Exel danielle	by Alan	1	443
Ref from table to cell Steve	by Steve	0	339
How to match sort and lineup 2 sets of data VTALABRAT	by VTALABRAT	0	695
HOW DO YOU CREATE DROP DOWEN MENUS IN EXCEL? Bren	by Gord Dibben	3	515
IF function mtate	by Sandy Mann	4	274
Semi transparent chart fill plainolddad	by plainolddad	0	728
left click on a cell and more cells are highlighted anand sharma	by Gord Dibben	1	833
Worksheet e-mailing Always Frustrated	by Bob Phillips	1	389
conditional formatting Nathan1111	by Dave R.	1	295
skip blank rows when pasting formulas Newsgal	by virendra.telkar	1	507
format cell to recall client name cheryl	by CLR	1	353
RIGHT of character Ivor Williams	by Gord Dibben	2	345
Auto increment over multiple worksheets Ethan	by Gord Dibben	2	1,592
How can i count pasted values in Excel? Dodo	by virendra.telkar	1	378
Converting a link to values to multiple cells. Cesar_us	by Gord Dibben	1	653
Lookup help needed atran	by virendra.telkar	1	477
how do I customize product sales pipeline management template Cine-tal	by Cine-tal	0	1,459
Adding cells based on condition Ted Metro	by Ted Metro	1	1,045
use sumif with array pdberger	by JPW	3	585
How to link cells in seperate spreadsheets without the $ Cesar_us	by Cesar_us	0	395
Improve visibility of Excel AutoFilter Filter selections Cec Tarasoff	by Cec Tarasoff	0	564
Drop down lists are displaying end of list, how to make it top? LynnSouthan	by Debra Dalgleish	3	512
Sorting data in a workbook across multple worksheets Phil	by Phil	7	1,095
Counting Across Multiple Ranges, Based on Condition Stacy	by Stacy	2	659
Find min/max in 2 combined columns Tammi	by Ken Wright	3	493
Pivot Tables dipsy	by Ron Coderre	1	359
Pivot Tables dipsy	by dipsy	2	312
Is there a template for creating outline in Excel as opposed to W Charlie Starnes	by Charlie Starnes	0	904
I want to use if based on two cells (if... and) coblad1357	by Peo Sjoblom	2	304
How can I put the median on a pivot table? JAH	by JAH	0	565
How do I setup criteria in DSUM to sum values NOT equal (<>) Mark Rucker	by Debra Dalgleish	1	1,225
SumIf based on two criteria Mark Williams	by Domenic	1	610
Cond Format:re color 2 cols, skip 2 cols Tat	by Tat	2	716
Global Replacement of Test to Display Kathy	by Kathy	0	394
Limit to the number of items in a cell Jim_Bowie	by Jim_Bowie	2	602