Excel Worksheet Functions - Page 248

Thread / Thread Starter	Last Post	Replies	Views
text as an argument of SUM function katarina07	by William Horton	2	638
Finding constants in formulas Co-op Bank	by John in Surrey	1	462
subtraction in a list of numbers that resets with a label. gtslabs	by Bruno Campanini	5	791
Summing large columns Muttley	by Ron Rosenfeld	1	455
Match Infomation Trying Hard	by Mladen_Dj	1	465
How to compare two cells for the same numbers sun1x	by sun1x	13	939
Is there a way I can autofilter columns instead of rows Brian A.	by Brian A.	0	488
Remove single spaces Bruno	by Ron Rosenfeld	1	1,700
Sum values Col.A w/ indntcal values in Col.B, w/o naming Col.B val STILLA	by STILLA	4	449
loosing test fomat after using replace command Richard Miller	by Dave Peterson	1	390
Excel Formula Error VikiFynn	by Dave Peterson	1	324
Leave cell data (IF(ISNA(VLOOKUP) is TRUE instead of returning blank (" ") or #NA [email protected]	by Arvi Laanemets	6	3,034
My view has changed, I want same view as when opening excel migalfarucci	by Anne Troy	1	792
Combine Indirect and Sumif dcd123	by dcd123	3	1,057
Search multiple values to return single values JANA	by Max	8	1,386
Repositioning a cell based on its value Paul987	by Alok	1	489
Sumif - double columns Mats W.	by Roger Govier	2	474
Button in Excel that will save the form? Jason	by Anne Troy	1	378
Unique value in a list news.zen.co.uk	by Ian	1	365
Omit the first word from a cell contain text Bhupinder Rayat	by Roger Govier	8	1,208
is there a macro which will allow me to copy/paste another documen Laura.J	by Laura.J	0	270
Index and Match - the next step MoonWeazel	by Bob Phillips	5	588
troubleshoot absolute value Sus	by Bob Phillips	3	567
How do you enter a ratio e.g. 100:1 into a cell? Catcher	by Search33	1	296
Joint ranking (never seen a satisfactory answer!) [email protected]	by Bernie Deitrick	6	703
How can I get Excel to find the first number in a list greater tha krowlan	by Bernie Deitrick	3	1,604
Updated cells David French	by David French	0	514
Lookup? for more than one criteria Annette	by mbarron	2	525
Sumif() help jhorsley	by Paul Sheppard	1	385
What is wrong with this formula? scott45	by Roger Govier	10	659
populating a list box with weekly dates John in Surrey	by Biff	1	679
cell format in Excel 2002 SP3 will not accept long numbers spkersh	by JE McGimpsey	1	911
Clear Contents Macro SJC	by SJC	3	753
How do I multiply cell value by percentage? Kelly P.	by Kelly P.	4	1,168
the scroll wheel button should have an optional pan feature chandler117	by Sloth	1	1,007
How do I delete or remove additional blank pages of a worksheet? Kim	by Ian	1	749
Last value & if,then Angie A.	by Angie A.	8	386
I can see th formula result in the dialog box but not in the cell Worried	by JE McGimpsey	1	677
Search multiple values & return single value - seperate worksheets JANA	by Bruno Campanini	4	1,064
Clear Cell based on event w/o macro? Paul987	by Paul987	2	658
Monthly Totals Jasmine	by Jasmine	4	427
IF statement using multiple criteria Joe Gieder	by Joe Gieder	1	408
Section Breaks smokemyocom	by Chip Pearson	1	906
Freezing panes--splitting spreadsheet into quarters Mary	by Oggie Ben Doggie	4	1,102
Macro Save File (Unique file name) SJC	by SJC	5	1,470
max value aaaist	by DOR	15	1,101
how can I sort alphanumeric entries by number in excel beasleyb	by Dave Peterson	1	1,420
Sorting by Scripture Sue McDonald	by FinRazel	2	373
NORMAL DISTRIBUTION FLKULCHAR	by FLKULCHAR	13	1,609
How do I round up fractions to the next whole number? JHL1927	by batfish	4	1,273
conditional search Nick	by Nick	0	335
convert time imported as text to time format for calculations batfish	by batfish	3	1,883
Sum Product HJ	by Alan	4	548
Proper Function not working kimi5564	by RagDyer	1	1,458
Average Calculation smallcap	by RagDyer	6	628
How many similar functions can be put in one cell? Forrest	by Ron Rosenfeld	20	1,782
Here's an EASY one for you, not me :( barbierim	by Ron Rosenfeld	4	467
another interesting thing... Nick Dangr	by Ron Rosenfeld	5	518
combo boxes martin	by martin	0	377
Copy complete row Joel	by Richard Buttrey	1	384
adding amounts according to labels Wayne Cameron	by RagDyer	1	370
Estimating figures Jordan	by Jordan	0	376
Pivot calculated field not summing correctly cgcordry	by cgcordry	0	446
print files & subfiles fo we can organize them BILL ORR	by Anne Troy	1	453
merging columns - one date, one time batfish	by Ron Rosenfeld	2	458
SUMPRODUCT question Lee Harris	by JMB	4	496
Deleting links to other spreadsheets KarenH	by JMB	2	1,052
Something like CEILING or FLOOR gusvenables	by Ron Rosenfeld	3	648
Fiancial Calendar garretts run kid	by Fred Smith	1	337
conditional search ph2da00	by Stefi	2	404
What Formula Q John	by John	2	352
Sumproduct and offset Maarten	by [email protected]	4	898
How to convert numeric value to mins and addimg mins to Hrs. ramana	by Niek Otten	1	510
Formula to give 5%rise in a figure if it occurs b/wn 2 dates lwhat	by Gary''s Student	1	681
Advanced Filters Louise	by Louise	9	566