Excel Worksheet Functions - Page 1001

Thread / Thread Starter	Last Post	Replies	Views
IF & AND Functions together HARSH BAHAL	by Roger Govier	6	473
Sumproduct and wildcards vipa2000	by Domenic	18	1,550
how can i trace position in marks sheet adeel afzal via OfficeKB.com	by Don	3	555
#div/0! how do i supress? vipa2000	by KL	5	695
how can I create a ODBC database in excel Deler9	by Debra Dalgleish	1	656
Needs to Show blank please Steved	by Steved	2	476
Removing '0's' in cells pewe	by pewe	5	707
How do I generate random lottery numbers in Excel? Mark1809	by Ragdyer	7	2,145
Auto Repeat Data Mohd Rosdi	by Dodo	2	684
More Help Needed with Count formula Greegan	by Greegan	4	874
Need help in calculation at specific location Lewis Koh	by Lewis Koh	10	1,219
Auto Repeat Data Mohd Rosdi	by Mohd Rosdi	0	717
Error Handling #N/A with AVERAGE Function - Average of values in Row Sam via OfficeKB.com	by Sam via OfficeKB.com	13	2,762
How do you add numerous subtotals in a spreadsheet? JHoleman1	by Anne Troy	1	525
HELP!!!! sumif or sumproduct ??? :( Wally	by Wally	0	561
My IF(AND passes logical, but doesn't reveal correct results Washdc	by Washdc	6	547
Count Intervals of Filtered TEXT values in Column and Return Count across a Row Sam via OfficeKB.com	by Sam via OfficeKB.com	9	2,169
Extracting Text only jtoy	by CLR	2	646
Strip leading spaces from cell Pete	by CLR	3	803
how to use shift and down arrow keys in a macro? John W	by David McRitchie	1	968
Count number of values in a cell nyc_doc	by nyc_doc	3	1,692
search a series of rows for a specific formating Harris	by Biff	2	668
Excel sue walton	by Flintstone	2	455
Using text and data in formula. Dave the lost	by Dave the lost	2	434
look up number in column eioval	by eioval	2	925
Drop-Down Colours Bal	by Bal	2	638
Formula pull factor from chart based on value of diff field? Bill R	by Anne Troy	3	723
indirect function? Russ	by Russ	6	688
Drop Down Boxes tiab86	by Gord Dibben	2	686
sumproduct problem christophe meresse	by christophe meresse	3	599
Automatic date Brody	by KL	2	486
autosum problems Ryan	by Max	3	536
How do I pull a date from a separate worksheet using the IF functi Jerrod Mason	by Anne Troy	8	796
How can I replace the path of the linked spreadsheet in a cell? Norm	by JMB	2	700
Using the tab key... Greegan	by Anne Troy	2	475
Help with conditional formatiing? abqhusker	by abqhusker	2	644
Conversion formula (Proper Case) Steve	by David McRitchie	6	592
Need help to reflect number of days in a month. Lewis Koh	by Roger Govier	8	928
how do I create or add to a formula . . . Steph	by Bob Phillips	3	509
Totaling Hours in Standard Format Coco	by Bob Phillips	4	744
Password protection of worksheet when copied and pasted. Shansi	by Anne Troy	1	843
Referencing lists in a nested IF formula JTinAtlanta	by Biff	1	554
In Excel, how do we convert text into number (value)? Hersh Levy	by Biff	1	861
I need help with a macro which will copy a worksheet and.. Greegan	by Greegan	2	645
UPDATED - Referencing named Ranges within a Nested IF formula JTinAtlanta	by Biff	1	1,110
How Do I Enter Data Into A Single Cell sinbad	by Paul B	3	471
How do I work with part of a cell entry? JKB	by JKB	4	611
change headers from letter to number/number to letter lazybee	by Biff	1	1,025
Count Function Help Josh O.	by Bob Phillips	4	537
Index, Match, Offset? Not sure which to use Ms. P.	by Ms. P.	4	940
VLOOKUP - dealing with lookup_value differences Cheese	by Biff	1	736
Indirect or Vlookup Function Justin	by Biff	1	860
Need a little help w/ COUNTIF CampFriendNeedsHelp	by Sandy Mann	1	534
filedialog Norm	by Norm	0	700
Can I get Excel not to save a file if certain information is not i Sierra Coating	by Bernie Deitrick	4	561
excel function Adam Pisani	by Adam Pisani	3	533
how do I print a page with only grid lines showing Paul0	by Gord Dibben	2	974
how do I add another page with different cell sizes? Merk	by Gord Dibben	1	615
Excel and access should permit sorting by last character Eriemaster	by Eriemaster	0	783
Import External Data Susie	by Susie	0	745
Quotations and blanks cells (that aren't)... Ingeniero1	by swatsp0p	3	415
Convert to VB Derek Y via OfficeKB.com	by Derek Y via OfficeKB.com	0	389
Possible to insert cell data in the middle of line of text? Bob Smith	by Bob Smith	6	1,040
REALLY COMPLICATED--the sooner you can help the better Derek Y via OfficeKB.com	by Derek Y via OfficeKB.com	4	513
How can I round a number to the nearest "50" or "100" in excel 200 Manny	by Tushar Mehta	2	1,175
My needs are simple-apparently, so am I LSUCHEER	by MrShorty	1	458
Multiple Functions IF, AND, COUNTIF, MATCH Mike	by Ron Coderre	3	678
Borders in an inserted row Amergin	by Amergin	0	459
undefined function error when creating xls pivot from mdb qry andrew	by andrew	0	1,003
time calculation with military time Ron Thetford	by David McRitchie	8	2,160
If Date=x then do y TruffleShuffle	by Sandy Mann	2	530
Help with multiple Index Hamilton013	by Hamilton013	2	441
IF, Match, Index ? which One do I use Barbara	by Roger Govier	13	1,258
Filter mode Julieeeee	by chuck...	1	643
csv format drops a text character when reopened in Excel RivRunR	by Anne Troy	1	560