Excel Worksheet Functions - Page 174

Thread / Thread Starter	Last Post	Replies	Views
Automatically transpose when pasting data in excel SSD1	by Ashish Mathur	3	1,093
.wb3 file convertion rogersat	by rogersat	0	616
Quarterly tax percentages viz	by Krishnakumar	12	1,298
How do I change a cell's contents to it's formula's value? Cindy	by Biff	1	516
How do I sort dates stored as 1-Jun-05 in order of day & month stuckiniraq	by Max	1	519
CURRENCY INDEX FOR EXCEL NeoWulf	by Bob Phillips	1	481
Multiple text boxes selection Rafisahb	by KL	2	674
Help keep incompetents in business infoman	by Kassie	1	388
copy numbers progressively JERRY	by Debra Dalgleish	5	357
macros khen1	by KL	2	385
Same Name refers to local ranges Mats Samson	by Bob Phillips	6	559
trouble filtering a list. Why isn't column filtering? Pat	by Anne Troy	1	1,083
Combo Box View BBazan	by BBazan	0	327
Need Help with custom function! AndyB	by Blink	5	339
Counting Duplicate Entries No_name	by Domenic	1	461
Macro Question Chris	by Chris	0	460
How do I compare data between spreadsheets? Bryan	by Morrigan	1	544
SumIF is not working DanVDM	by Domenic	3	379
count date ranges murtaza	by RagDyeR	4	720
Can I create a dropdown that will show a 2-month calendar? Vecchia	by optionbase1	1	636
Printing gordo	by gordo	0	385
Validate Cell contents in formlua Jwbuddy386	by bj	1	344
LOOKUP Wilco	by Morrigan	1	281
Merge text list Rosie	by Rosie	2	389
Arithmetical Mode Value for Filtered cells in Multiple Non-Adjacent columns Sam via OfficeKB.com	by Sam via OfficeKB.com	19	1,916
first value > 0 Ted Metro	by N Harkawat	1	382
lookup help Ted Metro	by Mangus Pyke	1	356
If a cell is blank do no let a user print or save? Havenstar	by Havenstar	12	1,227
Excel Analysis Add-in EOMONTH generates #NAME? error Ray	by RagDyer	6	1,161
Ranking Tim Sullivan	by bj	7	585
calculate the number of days from date received Donna	by Morrigan	7	1,491
I need to merge lots of info, w/o copy paste? JWS Wholesale	by JWS Wholesale	0	684
Conditional Formatting Dee	by JE McGimpsey	1	441
perform calculation only if current time is after 10 am julieskennels	by Sandy Mann	7	1,005
excel formula to convert lat/lon degrees to DDD MM SS.SS? cbm	by Paul B	1	1,850
IF and MIN functions JN	by Morrigan	5	314
COUNTIF temporarily missed some cells dstx	by dstx	0	529
Microsoft Excel Spinner's BBazan	by Dave Peterson	2	528
Date conversion Stephanie Myers	by Trevor Shuttleworth	5	417
Problem with compound IF statement Phillycheese5	by Morrigan	11	836
Consecutive Numbers down a column not to Exceed 49 Nelson	by Harlan Grove	6	820
Pivot Table Question carl	by Dominic	2	430
How to lock worksheet and still able to click on grouped rows nathanelz	by Dave Peterson	1	459
Totalling formulas Steved	by Steved	7	392
Vlookup for 2 items Mostafa	by Anne Troy	11	1,168
cell links Dan S	by Mirko Smilevski	2	409
Filtering ? Tarjei Lundarvollen	by Dominic	7	680
Array Function N Harkawat	by Bob Phillips	9	1,292
Issue with sumproduct Steved	by Sandy Mann	8	523
Why are cumulative interest payment calculations different? New Soul	by New Soul	2	672
text formulas Rus	by Tim C	4	440
Data parsing question Dan Neely	by Dan Neely	0	420
percent change stephenm	by JE McGimpsey	5	890
sort list of players by team from player list on separate sheet Robert	by Biff	1	1,133
Making mulitple IF statements. TimM	by Ashish Mathur	2	383
Multi-condition vlookup Hobbeson	by RagDyer	4	603
using VLOOKUP to compare 2 columns to find new information Jessica	by Ashish Mathur	3	2,990
Cells with a value between two dates sumo	by RagDyer	1	361
Listpro A.J	by A.J	0	317
Create summary based on specifc value in a different sheet RayYeung	by RayYeung	0	456
mixing text and formulae in same cell gvm	by Max	9	576
excel paste special should allow text Roger Wagner	by Mangus Pyke	1	945
How to calculate a pay-back period by the accumulated cash-flow automatically? Dmitry Kopnichev	by Dima	7	1,475
How to copy the data in row to column? Suma Charan	by Niek Otten	1	369
Formulae k f h	by Max	6	432
Formular Question annie	by annie	2	313
Conditional format with a formula Mike Echo	by Mike Echo	6	767
how do I set up a pricing template in excel Westiebrigade	by Damon Longworth	1	430
replace function andrewm	by Gordon	3	380
NETWORKDAYS sinbad	by Bob Phillips	2	401
Help with sum up or down in cells Kim Kappel	by Bob Phillips	2	299
What formula I should use: =ROUNDDOWN(H450.18;2) or =TRUNK(H450.18,2) ?? TANDEX	by Bob Phillips	2	339
Can I Find one word in a formula Rod (Brazil)	by Roger Govier	4	502
comments in excel EGYPTIAN SUE	by R.VENKATARAMAN	2	526
DOnt calculate leap year kckar	by kckar	8	637