Excel Worksheet Functions - Page 126

Thread / Thread Starter	Last Post	Replies	Views
="Z" dual use? Scott Calkins via OfficeKB.com	by bj	5	522
Creating random passwords Tony	by N Harkawat	2	1,098
Excel VB Run-time error '50290' Bruce Blackman	by Bruce Blackman	0	2,313
how do i create a timesheet TeeTee	by TeeTee	0	383
Count and convert text Boenerge	by JE McGimpsey	1	451
What formula will sort data in a separate worksheet%3f Excel_Challenged	by Nick	1	454
How do I create a formula using data from another page? Mimi	by Mimi	2	652
Sum numbers based on the contents of another cell Doreen	by JulieD	5	903
Sum if or some sort of match formula JavyD	by Bob Phillips	3	504
Block entries Boenerge	by Boenerge	2	411
Excel macro Mick the quick.	by David McRitchie	1	321
Indent within a row marilyn	by David McRitchie	3	1,500
compare two columns and remove duplicates Moni39	by David McRitchie	3	1,199
Excel add-in Harvey	by Bob Phillips	5	448
convert Julian date Doug	by Ron	3	1,170
Search string with multiple criteria fLiPMoD£	by Harlan Grove	2	1,371
Please see posting on 05/04/05 does anyone know how to group post? sra	by sra	0	581
sort by more than 3 columns jenn	by Peo Sjoblom	3	449
How to use functions in one cell to get text in another cell rlb	by Ken Wright	8	525
Conditional Formatting Error ddate	by ddate	0	1,521
Automatically shifting data, part II S. Stone	by S. Stone	0	351
Calculation for Ebay worksheet. greggin via OfficeKB.com	by greggin via OfficeKB.com	3	655
Importing data from a different workbook Mike	by David McRitchie	1	527
formula auditing toolbar leola	by leola	0	522
protect from printing scott	by JE McGimpsey	1	423
# of occurrences gbeard	by JE McGimpsey	1	493
M/S Visual C++ Run Time Error when attempting to use functions Cooper	by Cooper	0	468
Show detail Sunryzz	by Sunryzz	0	631
how to convert julian date to regular calendar date Ron	by Max	5	2,004
Formula/function alm09	by Bob Phillips	3	475
Enable Automatic Update for Web Query Terri	by Terri	0	685
Enable Automatic Update for Web Query Terri	by Terri	0	605
Excel 2002: I get formulae displaying in cells rather than value Matilda	by Dave Peterson	2	524
excel msoffice97 files will not work in excel msoffice2000 Duane Broadwell	by Dave Peterson	1	508
DCOUNT in Excel CharlieW	by Peo Sjoblom	1	878
Wildcard MATCH() breaks on long (?) strings [email protected]	by [email protected]	6	809
Fomatting part of a formula to be Bold font KimberlyC	by [email protected]	7	761
Unwanted character [email protected]	by Ron Coderre	2	402
how do I get excel to ignore blank cells in formulas rbignami	by Biff	1	1,081
Subtracting numbers Annette	by CLR	3	420
Unwanted character [email protected]	by David McRitchie	2	367
how to convert rpt files to xls AV	by Harlan Grove	1	2,020
Simplify formula Luke	by Harlan Grove	37	5,034
adding worksheets with conditions Niall D	by Niall D	4	510
using cells.numberformat maxzsim	by Bob Phillips	2	792
Excel formulas are slow to update Jools	by Aladin Akyurek	2	1,039
VB find (true false) Wildman	by Bob Phillips	6	729
Lookup problems thecuzin	by	1	458
Protect sheet and allow grouping of columns Job	by Job	2	1,282
Countin Dates Steve J	by Daniel.M	4	385
Deleting ALL duplicates using Pearson's code [email protected]	by Bernie Deitrick	2	559
Trailing spaces in Pivot tables Fred	by Tom Ogilvy	1	584
Concatenate text and numbers? CLR	by Dave Peterson	8	1,054
Retrieving a Reference automandc	by automandc	4	478
Printing from email without Word/Excel mejsunflower	by	1	367
Number anagram pav55	by pav55	5	623
Conditional Average Ignoring Blanks Dirk Friedrichs via OfficeKB.com	by Dirk Friedrichs via OfficeKB.com	2	778
Working time and days Nortos	by Bob Phillips	5	1,108
Sumproduct with a vLookup, multiple criteria Tom F	by Tom F	3	1,416
Countif with cell reference Nick	by Nick	2	629
COUNT NON-BLANK CELLS WITH REFERENCE TO ANOTHER COLUMN carricka	by Peo Sjoblom	1	1,348
why does ON = Ambiguous in substitution formula? waladd	by waladd	5	755
Undo a array Scott Calkins via OfficeKB.com	by Scott Calkins via OfficeKB.com	3	657
How do I set an automatic date stamp into a cell in Excel? Nilla_Brown	by Bob Phillips	1	1,080
merging two excel spreadsheets - track changes from original Kasia	by Kasia	0	1,247
Dates/Amounts calcs KJo	by KJo	4	439
How to create a worksheet to accelerate debts Excel_Challenged	by Excel_Challenged	0	428
Averages and Counts from different columns sonofroy	by sonofroy	21	1,557
Visual Basic code available for all open workbooks KristiB	by Chip Pearson	5	738
Search a Column by text length kb_63	by Rob	2	693
how fill adatabasein domino designer with information of excel zoy	by zoy	0	489
how do I remove a link between worksheeta? Weeksboro	by Contractdiva	2	517
How to lock worksheet formatting? TANDEX	by Contractdiva	1	643
Date formula Jordan	by Jordan	2	359
How do I set up formulas with letters and numbers? lisaw	by lisaw	3	600