Excel Worksheet Functions - Page 1027

Thread / Thread Starter	Last Post	Replies	Views
Help creating single cell Pop-up Bill	by Bill	2	580
Result in Cell is Wrong Lilbit	by bj	1	293
Copy data in other sheet Moynul Hoque	by Moynul Hoque	0	686
Compare 2 columns & format row moremetrics	by moremetrics	2	324
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	394
IF Function returns False instead of 0 BEEJAY	by BeeGee	2	3,185
Pulling my hair out, need some help building a formula Jackanorry	by Jackanorry	2	441
I want data on sheet 1 to input into sheet 2 also walott1	by Neil	2	887
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	641
The ROUND function Louise	by Bob Phillips	3	551
Another of Excel's idiosyncrasis Buce	by Bruce	3	401
calculating hours bus2408	by Bob Phillips	2	939
How can I convert an 8 character Hex word to binary for a lookup? Seagondollar	by Seagondollar	5	908
Help with Formulas please!!! certain_death	by Jerry W. Lewis	1	317
not equal to zero ellebelle	by Bob Phillips	3	992
How do I allow users to make a choice in a worksheet? Jim Zavone	by Jim Zavone	2	755
Currency format Samir Kapadia	by Mangesh Yadav	6	749
Trend Forecast Help MIVELD	by mangesh_yadav	3	450
How to setup a hyperlink to an indirect function? Skot	by Max	7	3,666
Setting a reminder up Shep	by Bob Phillips	2	1,020
Conditional Format to highlight blank cell DaveMoore	by davidm	4	2,955
Problems with PULL function, INDIRECT.EXT and so forth [email protected]	by sthackwray	4	924
Realtime Automatic sorting of data in rows in new work sheet Gazzali	by Gazzali	0	904
How to represent an empty cell in excel formulae? Sibi Melvin	by Max	1	614
an error.type test Maileen	by Maileen	0	392
Display count of rows Judy Ward	by Biff	2	825
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	734
Sumif where sum range is more than one column? John Mitchell	by Peo Sjoblom	1	1,144
How to sum the last 5 non-blank cells in a row? SunriseCea	by Domenic	4	1,628
find and replace cell reference to a new worksheet Johnny Van	by Johnny Van	0	908
Sorting dates Heather	by Biff	1	492
More- AutoFill with Non-Seqeuntial Cell References ? [email protected]	by [email protected]	4	958
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	601
Why does this fail? =TEXT(RC3,Number)&" / "&TEXT(R32C,Number) =TEXT(RC3,Number)& / &TEXT(R32C,Number	by garfield-n-odie	2	675
Array Function Question sunfish62	by sunfish62	3	471
julian dates in Exel danielle	by Alan	1	445
Ref from table to cell Steve	by Steve	0	339
How to match sort and lineup 2 sets of data VTALABRAT	by VTALABRAT	0	696
HOW DO YOU CREATE DROP DOWEN MENUS IN EXCEL? Bren	by Gord Dibben	3	538
IF function mtate	by Sandy Mann	4	274
Semi transparent chart fill plainolddad	by plainolddad	0	730
left click on a cell and more cells are highlighted anand sharma	by Gord Dibben	1	860
Worksheet e-mailing Always Frustrated	by Bob Phillips	1	392
conditional formatting Nathan1111	by Dave R.	1	295
skip blank rows when pasting formulas Newsgal	by virendra.telkar	1	508
format cell to recall client name cheryl	by CLR	1	353
RIGHT of character Ivor Williams	by Gord Dibben	2	346
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	379
Converting a link to values to multiple cells. Cesar_us	by Gord Dibben	1	655
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,460
Adding cells based on condition Ted Metro	by Ted Metro	1	1,047
use sumif with array pdberger	by JPW	3	586
How to link cells in seperate spreadsheets without the $ Cesar_us	by Cesar_us	0	400
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	514
Sorting data in a workbook across multple worksheets Phil	by Phil	7	1,105
Counting Across Multiple Ranges, Based on Condition Stacy	by Stacy	2	661
Find min/max in 2 combined columns Tammi	by Ken Wright	3	494
Pivot Tables dipsy	by Ron Coderre	1	363
Pivot Tables dipsy	by dipsy	2	313
Is there a template for creating outline in Excel as opposed to W Charlie Starnes	by Charlie Starnes	0	933
I want to use if based on two cells (if... and) coblad1357	by Peo Sjoblom	2	308
How can I put the median on a pivot table? JAH	by JAH	0	568
How do I setup criteria in DSUM to sum values NOT equal (<>) Mark Rucker	by Debra Dalgleish	1	1,229
SumIf based on two criteria Mark Williams	by Domenic	1	615
Cond Format:re color 2 cols, skip 2 cols Tat	by Tat	2	719
Global Replacement of Test to Display Kathy	by Kathy	0	396
Limit to the number of items in a cell Jim_Bowie	by Jim_Bowie	2	604