Excel Worksheet Functions - Page 1027

Thread / Thread Starter	Last Post	Replies	Views
Help creating single cell Pop-up Bill	by Bill	2	628
Result in Cell is Wrong Lilbit	by bj	1	317
Copy data in other sheet Moynul Hoque	by Moynul Hoque	0	702
Compare 2 columns & format row moremetrics	by moremetrics	2	344
If (cell a2 is greater than 1, but less than B2 - C2, "X") how do Colin F	by BenjieLop	2	422
need Excel function like INDIRECT but can't open all spreadsheets Big Al	by Bob Phillips	1	418
IF Function returns False instead of 0 BEEJAY	by BeeGee	2	3,227
Pulling my hair out, need some help building a formula Jackanorry	by Jackanorry	2	452
I want data on sheet 1 to input into sheet 2 also walott1	by Neil	2	914
Formula for Colin F Barb R.	by Barb R.	0	368
Need formula to count number of books sold Watercolor artist	by Watercolor artist	4	664
The ROUND function Louise	by Bob Phillips	3	569
Another of Excel's idiosyncrasis Buce	by Bruce	3	415
calculating hours bus2408	by Bob Phillips	2	974
How can I convert an 8 character Hex word to binary for a lookup? Seagondollar	by Seagondollar	5	928
Help with Formulas please!!! certain_death	by Jerry W. Lewis	1	322
not equal to zero ellebelle	by Bob Phillips	3	1,027
How do I allow users to make a choice in a worksheet? Jim Zavone	by Jim Zavone	2	804
Currency format Samir Kapadia	by Mangesh Yadav	6	776
Trend Forecast Help MIVELD	by mangesh_yadav	3	460
How to setup a hyperlink to an indirect function? Skot	by Max	7	3,694
Setting a reminder up Shep	by Bob Phillips	2	1,042
Conditional Format to highlight blank cell DaveMoore	by davidm	4	3,002
Problems with PULL function, INDIRECT.EXT and so forth [email protected]	by sthackwray	4	958
Realtime Automatic sorting of data in rows in new work sheet Gazzali	by Gazzali	0	928
How to represent an empty cell in excel formulae? Sibi Melvin	by Max	1	630
an error.type test Maileen	by Maileen	0	419
Display count of rows Judy Ward	by Biff	2	862
how do i MAX to display the person who got MAX Konrad Walsh	by Aladin Akyurek	3	466
validation rule andrewm	by andrewm	7	631
Problem with function "Worksheet_Change" konpego	by konpego	0	777
Sumif where sum range is more than one column? John Mitchell	by Peo Sjoblom	1	1,166
How to sum the last 5 non-blank cells in a row? SunriseCea	by Domenic	4	1,634
find and replace cell reference to a new worksheet Johnny Van	by Johnny Van	0	941
Sorting dates Heather	by Biff	1	512
More- AutoFill with Non-Seqeuntial Cell References ? [email protected]	by [email protected]	4	986
getting name value in cell from If formula Nichole	by Biff	5	391
I need to return the name of a worksheet in another worksheet cell? Rick	by abcd	2	632
Why does this fail? =TEXT(RC3,Number)&" / "&TEXT(R32C,Number) =TEXT(RC3,Number)& / &TEXT(R32C,Number	by garfield-n-odie	2	722
Array Function Question sunfish62	by sunfish62	3	500
julian dates in Exel danielle	by Alan	1	479
Ref from table to cell Steve	by Steve	0	344
How to match sort and lineup 2 sets of data VTALABRAT	by VTALABRAT	0	728
HOW DO YOU CREATE DROP DOWEN MENUS IN EXCEL? Bren	by Gord Dibben	3	574
IF function mtate	by Sandy Mann	4	280
Semi transparent chart fill plainolddad	by plainolddad	0	789
left click on a cell and more cells are highlighted anand sharma	by Gord Dibben	1	903
Worksheet e-mailing Always Frustrated	by Bob Phillips	1	408
conditional formatting Nathan1111	by Dave R.	1	304
skip blank rows when pasting formulas Newsgal	by virendra.telkar	1	531
format cell to recall client name cheryl	by CLR	1	383
RIGHT of character Ivor Williams	by Gord Dibben	2	367
Auto increment over multiple worksheets Ethan	by Gord Dibben	2	1,636
How can i count pasted values in Excel? Dodo	by virendra.telkar	1	392
Converting a link to values to multiple cells. Cesar_us	by Gord Dibben	1	687
Lookup help needed atran	by virendra.telkar	1	501
how do I customize product sales pipeline management template Cine-tal	by Cine-tal	0	1,502
Adding cells based on condition Ted Metro	by Ted Metro	1	1,089
use sumif with array pdberger	by JPW	3	605
How to link cells in seperate spreadsheets without the $ Cesar_us	by Cesar_us	0	432
Improve visibility of Excel AutoFilter Filter selections Cec Tarasoff	by Cec Tarasoff	0	588
Drop down lists are displaying end of list, how to make it top? LynnSouthan	by Debra Dalgleish	3	538
Sorting data in a workbook across multple worksheets Phil	by Phil	7	1,157
Counting Across Multiple Ranges, Based on Condition Stacy	by Stacy	2	705
Find min/max in 2 combined columns Tammi	by Ken Wright	3	519
Pivot Tables dipsy	by Ron Coderre	1	373
Pivot Tables dipsy	by dipsy	2	322
Is there a template for creating outline in Excel as opposed to W Charlie Starnes	by Charlie Starnes	0	967
I want to use if based on two cells (if... and) coblad1357	by Peo Sjoblom	2	322
How can I put the median on a pivot table? JAH	by JAH	0	601
How do I setup criteria in DSUM to sum values NOT equal (<>) Mark Rucker	by Debra Dalgleish	1	1,279
SumIf based on two criteria Mark Williams	by Domenic	1	656
Cond Format:re color 2 cols, skip 2 cols Tat	by Tat	2	754
Global Replacement of Test to Display Kathy	by Kathy	0	415
Limit to the number of items in a cell Jim_Bowie	by Jim_Bowie	2	640