Excel Worksheet Functions - Page 936

Thread / Thread Starter	Last Post	Replies	Views
How do I round up fractions to the next whole number? JHL1927	by batfish	4	1,269
NORMAL DISTRIBUTION FLKULCHAR	by FLKULCHAR	13	1,609
Sorting by Scripture Sue McDonald	by FinRazel	2	373
how can I sort alphanumeric entries by number in excel beasleyb	by Dave Peterson	1	1,419
max value aaaist	by DOR	15	1,101
Macro Save File (Unique file name) SJC	by SJC	5	1,469
Freezing panes--splitting spreadsheet into quarters Mary	by Oggie Ben Doggie	4	1,102
Section Breaks smokemyocom	by Chip Pearson	1	902
IF statement using multiple criteria Joe Gieder	by Joe Gieder	1	408
Monthly Totals Jasmine	by Jasmine	4	427
Clear Cell based on event w/o macro? Paul987	by Paul987	2	658
Search multiple values & return single value - seperate worksheets JANA	by Bruno Campanini	4	1,064
I can see th formula result in the dialog box but not in the cell Worried	by JE McGimpsey	1	677
Last value & if,then Angie A.	by Angie A.	8	386
How do I delete or remove additional blank pages of a worksheet? Kim	by Ian	1	749
the scroll wheel button should have an optional pan feature chandler117	by Sloth	1	1,006
How do I multiply cell value by percentage? Kelly P.	by Kelly P.	4	1,168
Clear Contents Macro SJC	by SJC	3	753
cell format in Excel 2002 SP3 will not accept long numbers spkersh	by JE McGimpsey	1	911
populating a list box with weekly dates John in Surrey	by Biff	1	677
What is wrong with this formula? scott45	by Roger Govier	10	659
Sumif() help jhorsley	by Paul Sheppard	1	385
Lookup? for more than one criteria Annette	by mbarron	2	523
Updated cells David French	by David French	0	512
How can I get Excel to find the first number in a list greater tha krowlan	by Bernie Deitrick	3	1,603
Joint ranking (never seen a satisfactory answer!) [email protected]	by Bernie Deitrick	6	702
How do you enter a ratio e.g. 100:1 into a cell? Catcher	by Search33	1	296
troubleshoot absolute value Sus	by Bob Phillips	3	566
Index and Match - the next step MoonWeazel	by Bob Phillips	5	587
is there a macro which will allow me to copy/paste another documen Laura.J	by Laura.J	0	270
Omit the first word from a cell contain text Bhupinder Rayat	by Roger Govier	8	1,208
Unique value in a list news.zen.co.uk	by Ian	1	365
Button in Excel that will save the form? Jason	by Anne Troy	1	373
Sumif - double columns Mats W.	by Roger Govier	2	473
Repositioning a cell based on its value Paul987	by Alok	1	484
Search multiple values to return single values JANA	by Max	8	1,386
Combine Indirect and Sumif dcd123	by dcd123	3	1,054
My view has changed, I want same view as when opening excel migalfarucci	by Anne Troy	1	792
Leave cell data (IF(ISNA(VLOOKUP) is TRUE instead of returning blank (" ") or #NA [email protected]	by Arvi Laanemets	6	3,029
Excel Formula Error VikiFynn	by Dave Peterson	1	324
loosing test fomat after using replace command Richard Miller	by Dave Peterson	1	390
Sum values Col.A w/ indntcal values in Col.B, w/o naming Col.B val STILLA	by STILLA	4	444
Remove single spaces Bruno	by Ron Rosenfeld	1	1,700
Is there a way I can autofilter columns instead of rows Brian A.	by Brian A.	0	487
How to compare two cells for the same numbers sun1x	by sun1x	13	934
Match Infomation Trying Hard	by Mladen_Dj	1	465
Summing large columns Muttley	by Ron Rosenfeld	1	454
subtraction in a list of numbers that resets with a label. gtslabs	by Bruno Campanini	5	786
Finding constants in formulas Co-op Bank	by John in Surrey	1	462
text as an argument of SUM function katarina07	by William Horton	2	638
Conditional formating using formulas arifnj	by arifnj	4	838
Across a worksheet, which cells I have formatted as locked? ZM	by Ian	3	648
Difference between Cells Jim	by hideki	2	517
Capturing a date field once only Rob Svilts	by Rob Svilts	2	466
zeros generated by a calculated item in pivot table Frederic	by Ian	3	878
how do you split a cell within the same column? Sher	by arno	2	698
How to see macro code of a password protected macro without a password? Dmitry Kopnichev	by Norman Jones	5	2,017
now() AccessHelp	by topola	5	334
How do I show the contents of a dropdown without showing the box? Dropdown despair!	by arno	1	435
i want to find a value in a refference array Hasty	by Biff	1	374
how do i only see subtotals in a pivot and hide the detail GGG	by Arvi Laanemets	1	780
how can I get analysis toolpack for anova calculations rachel1027	by Mike Middleton	3	967
how to hide the formula Thomas	by Arvi Laanemets	1	472
auto cut and paste... cjjoo	by Anne Troy	1	507
Pivot Table Fields smck	by smck	2	753
Create a summary list without using PivotTables? Jaye	by Jaye Cavallo	8	517
Deleting Duplicates dcost@sovereignbank	by Ashish Mathur	5	586
Converging two lookups? (would save me AEONS of time!) Lee Harris	by Lee Harris	1	493
find an average from a range, utilizing all data 0 Chase	by Ashish Mathur	4	638
What formula/fn would I use to count multiple condition records? Joshcat99	by Ashish Mathur	3	587
Need crosstab function in excel patrick	by Mladen_Dj	2	1,428
Can you copy multiple tabs from formulas to values w/o paste spec? Brent	by Brent	2	1,247
shorten formula PACable	by Roger Govier	8	679
Multi-lookups on variable data C.Pflugrath	by C.Pflugrath	0	600
Help...Need to modify data within a column in a .csv file [email protected]	by Ken Wright	11	1,092