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,286
NORMAL DISTRIBUTION FLKULCHAR	by FLKULCHAR	13	1,626
Sorting by Scripture Sue McDonald	by FinRazel	2	375
how can I sort alphanumeric entries by number in excel beasleyb	by Dave Peterson	1	1,458
max value aaaist	by DOR	15	1,112
Macro Save File (Unique file name) SJC	by SJC	5	1,503
Freezing panes--splitting spreadsheet into quarters Mary	by Oggie Ben Doggie	4	1,135
Section Breaks smokemyocom	by Chip Pearson	1	925
IF statement using multiple criteria Joe Gieder	by Joe Gieder	1	425
Monthly Totals Jasmine	by Jasmine	4	438
Clear Cell based on event w/o macro? Paul987	by Paul987	2	685
Search multiple values & return single value - seperate worksheets JANA	by Bruno Campanini	4	1,091
I can see th formula result in the dialog box but not in the cell Worried	by JE McGimpsey	1	692
Last value & if,then Angie A.	by Angie A.	8	389
How do I delete or remove additional blank pages of a worksheet? Kim	by Ian	1	774
the scroll wheel button should have an optional pan feature chandler117	by Sloth	1	1,023
How do I multiply cell value by percentage? Kelly P.	by Kelly P.	4	1,202
Clear Contents Macro SJC	by SJC	3	817
cell format in Excel 2002 SP3 will not accept long numbers spkersh	by JE McGimpsey	1	944
populating a list box with weekly dates John in Surrey	by Biff	1	707
What is wrong with this formula? scott45	by Roger Govier	10	679
Sumif() help jhorsley	by Paul Sheppard	1	392
Lookup? for more than one criteria Annette	by mbarron	2	537
Updated cells David French	by David French	0	527
How can I get Excel to find the first number in a list greater tha krowlan	by Bernie Deitrick	3	1,632
Joint ranking (never seen a satisfactory answer!) [email protected]	by Bernie Deitrick	6	720
How do you enter a ratio e.g. 100:1 into a cell? Catcher	by Search33	1	305
troubleshoot absolute value Sus	by Bob Phillips	3	579
Index and Match - the next step MoonWeazel	by Bob Phillips	5	600
is there a macro which will allow me to copy/paste another documen Laura.J	by Laura.J	0	272
Omit the first word from a cell contain text Bhupinder Rayat	by Roger Govier	8	1,244
Unique value in a list news.zen.co.uk	by Ian	1	366
Button in Excel that will save the form? Jason	by Anne Troy	1	390
Sumif - double columns Mats W.	by Roger Govier	2	488
Repositioning a cell based on its value Paul987	by Alok	1	499
Search multiple values to return single values JANA	by Max	8	1,418
Combine Indirect and Sumif dcd123	by dcd123	3	1,083
My view has changed, I want same view as when opening excel migalfarucci	by Anne Troy	1	831
Leave cell data (IF(ISNA(VLOOKUP) is TRUE instead of returning blank (" ") or #NA [email protected]	by Arvi Laanemets	6	3,046
Excel Formula Error VikiFynn	by Dave Peterson	1	333
loosing test fomat after using replace command Richard Miller	by Dave Peterson	1	411
Sum values Col.A w/ indntcal values in Col.B, w/o naming Col.B val STILLA	by STILLA	4	462
Remove single spaces Bruno	by Ron Rosenfeld	1	1,709
Is there a way I can autofilter columns instead of rows Brian A.	by Brian A.	0	510
How to compare two cells for the same numbers sun1x	by sun1x	13	955
Match Infomation Trying Hard	by Mladen_Dj	1	472
Summing large columns Muttley	by Ron Rosenfeld	1	463
subtraction in a list of numbers that resets with a label. gtslabs	by Bruno Campanini	5	801
Finding constants in formulas Co-op Bank	by John in Surrey	1	483
text as an argument of SUM function katarina07	by William Horton	2	662
Conditional formating using formulas arifnj	by arifnj	4	867
Across a worksheet, which cells I have formatted as locked? ZM	by Ian	3	677
Difference between Cells Jim	by hideki	2	531
Capturing a date field once only Rob Svilts	by Rob Svilts	2	482
zeros generated by a calculated item in pivot table Frederic	by Ian	3	886
how do you split a cell within the same column? Sher	by arno	2	711
How to see macro code of a password protected macro without a password? Dmitry Kopnichev	by Norman Jones	5	2,047
now() AccessHelp	by topola	5	336
How do I show the contents of a dropdown without showing the box? Dropdown despair!	by arno	1	458
i want to find a value in a refference array Hasty	by Biff	1	391
how do i only see subtotals in a pivot and hide the detail GGG	by Arvi Laanemets	1	797
how can I get analysis toolpack for anova calculations rachel1027	by Mike Middleton	3	993
how to hide the formula Thomas	by Arvi Laanemets	1	494
auto cut and paste... cjjoo	by Anne Troy	1	519
Pivot Table Fields smck	by smck	2	773
Create a summary list without using PivotTables? Jaye	by Jaye Cavallo	8	536
Deleting Duplicates dcost@sovereignbank	by Ashish Mathur	5	622
Converging two lookups? (would save me AEONS of time!) Lee Harris	by Lee Harris	1	517
find an average from a range, utilizing all data 0 Chase	by Ashish Mathur	4	655
What formula/fn would I use to count multiple condition records? Joshcat99	by Ashish Mathur	3	605
Need crosstab function in excel patrick	by Mladen_Dj	2	1,447
Can you copy multiple tabs from formulas to values w/o paste spec? Brent	by Brent	2	1,265
shorten formula PACable	by Roger Govier	8	707
Multi-lookups on variable data C.Pflugrath	by C.Pflugrath	0	628
Help...Need to modify data within a column in a .csv file [email protected]	by Ken Wright	11	1,115