Excel Worksheet Functions - Page 242

Thread / Thread Starter	Last Post	Replies	Views
Can I format a cell to round a number by 50 basis points (0.5)? daveb	by Biff	1	1,298
How do I add items within the last 12 months? Kevbro7189	by Ron Rosenfeld	3	515
loan/lease repayment using IPMT/CUMIPMT zardozoz	by zardozoz	2	1,328
how to average and use sum min and count within one cell gwtechie72	by JE McGimpsey	4	757
Make sequential numbers each time sheet is opened Darrell Shuman	by JE McGimpsey	1	927
"BVE as text entry" sdtech	by Bob Umlas	4	455
how can I check a worksheet for duplicate entries or numbers? RFI	by JE McGimpsey	1	624
grinds CW	by RWN	2	349
can't make it work, I need help kynhart	by Govind	2	386
Array Formulas for Geometric Standard Deviation and Sharpe Zeelotes	by Zeelotes	6	1,367
need some tips! cjjoo	by cjjoo	4	605
Need help with arrays (I think) rbhedal	by Biff	3	460
desperate measures cjjoo	by cjjoo	0	418
count with 2 conditions for many rows ? kevink79	by kevink79	4	336
conditional unlocking of cells hiryuu	by hiryuu	1	434
replace macro? andrewm	by Bob Phillips	1	458
Multiple Reference Lookup [email protected]	by Shmoo	1	373
conditional sum - number of arguments problem LesLdh	by LesLdh	4	842
Data Issues Paul	by bpeltzer	3	413
Frequency & Time Terry	by Terry	2	447
scanning a table? bobthedinosaur	by bobthedinosaur	3	567
Can I link single cells in a spreadsheet to another worksheet? tywebb76	by ufo_pilot	2	518
Dealing with worksheet groups Bob K	by Bob K	0	577
smallest right margin on excel spreadsheet Les S	by jahoobob	1	1,245
if statement based on "starts with " Todd F.	by Todd F.	4	3,875
Problem with Calculating Worksheets Karen	by Karen	2	419
How can I keep my cell borders permanent? karstens	by jahoobob	1	3,019
Sort, Copy, Paste..without Autofilter..Anyone??? jeffg	by Arvi Laanemets	1	546
Array... Sort of... Egon	by Alan Beban	2	480
insert scrollbar into a cell in Excel Nick	by Nick	0	821
calculating percentages Louise	by [email protected]	4	506
assigning macro to toolbar button tjb	by tjb	2	638
Formula help Rehanna	by Biff	9	393
Shading or Choosing closest lacosta	by Biff	5	399
date format Chris Lane	by Chris Lane	3	370
Macro Wade Barrett	by Lilliabeth	1	400
Repeat Macro tvkodde26	by Harlan Grove	5	569
Formuls updating Adam	by Adam	2	512
Pivot - need to recount based on results Kreed	by Kreed	2	536
Remove data from certain rows and place in new row or spreadsheet John	by Vacation's Over	1	521
Lookup function (maybe) Brad	by Domenic	1	357
advanced filtering jiwolf	by Peo Sjoblom	2	460
Modify cell size in worksheet Neal	by Neal	0	635
Formulas Leonard	by Leonard	2	450
Why do my rows automatically hide in Excel? jessgust	by Daniel CHEN	1	1,066
I've protected a wksht and now I can't tab from column to column carol b	by Daniel CHEN	2	494
Date Range Jim	by bpeltzer	1	432
Multiple vlookup arguments ichall	by ichall	2	973
Stumped on Formula Jessamynhp	by Per Erik Midtrød	1	354
Rank - Specific match only Tim Elhatton	by Tim Elhatton	2	2,182
excel Leonard	by Leonard	0	396
negative percentage in parenthetical format Dana	by Sloth	1	1,042
Highlight Range - wrong macro, please edit. Danny	by Danny	8	915
Rankif? Lee Harris	by Domenic	4	584
On Excel what does ##### mean when it is in a cell? Tyler	by Jezebel	4	941
Conditional Formatting Using If Statement On Opening Of Workbook Bill Foley	by Bill Foley	11	1,448
formula "next month same day" Ubi bene ..	by Ron Rosenfeld	2	2,088
Return unique fields only - but not a filter? Matt	by Ron Rosenfeld	7	657
vlookup formula alpa	by George Nicholson	1	477
Consolidating from Several Workbooks Chad A.	by Chad A.	0	361
Help with two formulas John	by John	5	362
Automatic shading of cells based on dates??? Pedros	by Pedros	3	1,204
sum function not summing??? RedHeadedMenace	by Peo Sjoblom	7	475
Unlock formulas and unhide sheets AnisaF	by JMB	1	530
If formula using 2 or more columns Wendy - Payroll	by Peo Sjoblom	1	629
Dates eternal_cat via OfficeKB.com	by eternal_cat via OfficeKB.com	2	498
Need help with finding duplicate entries Phil	by Max	6	675
SUM returns wrong result MarkN	by Jerry W. Lewis	5	967
Help I Am Ready To Give Up kynhart	by JMB	3	653
how to contruct formula Elaine	by JMB	1	336
create a team meeting planner Cookie	by Cookie	0	744
Need formula to have date in cell B2 rounded to first of next mont RamseyR	by ScottO	3	941
Ineed help with arrays (I think) Robert	by Norman Jones	2	425
Insert menu...Define FLKULCHAR	by Norman Jones	4	864
highlight/color cells with specific character inside markx	by Bob Phillips	6	959