Excel Worksheet Functions - Page 558

Thread / Thread Starter	Last Post	Replies	Views
Remove the #DIV/0! Corey	by David Biddulph[_2_]	3	503
Conditional formating for text dazp1970	by Max	1	427
convert standard number to time format TEA	by T. Valko	1	1,105
Count Employee Work Time - Don't Double-count Overlapping Apts. J	by J	0	1,432
How do I calculate dates and times, w/answer of days & hours Debby_Jo	by Fred Smith	4	816
Excel lists lizM	by Mike Rogers	2	307
Find number of unique entries within a date range Gayla	by JMB	2	1,003
stock quote help, VLOOKUP or what?? Carl LaFong	by Carl LaFong	9	716
Wrap Text problem in Excel ExcelRon	by ExcelRon	2	446
Pivot Table: new column with a calculation Bethshep	by Debra Dalgleish	1	1,558
drop down lists Mike	by Ragdyer	1	334
Which fuction! Be18	by Pete_UK	2	440
Return Frequently occuring Rows, based on COUNT Brooks	by Pete_UK	4	735
Pivot Table Question Me	by Debra Dalgleish	1	359
above and to the left of the worksheet window are scroll bars, scr [email protected]	by Gary''s Student	1	445
compare dates Thea	by Pete_UK	1	682
autofit text that is pulling data from another tab NANGO	by NANGO	0	421
RANDBETWEEN pkeegs	by [email protected]	6	734
Finding text in one field, and then totally another Tom D[_3_]	by Pete_UK	1	407
#value! for calculating date NANGO	by Pete_UK	2	473
Is a date in summer or winter? Thea	by Thea	3	1,194
Labview timestamp conversion BillO	by BillO	3	2,324
Lookup joec	by joec	1	367
IF statement comparing month and year separately spence	by George Nicholson	6	1,085
Non-consecutive criteria database functions dee	by Peo Sjoblom	1	460
Count of Data Based on Multiple Columns Chris Hofer	by Chris Hofer	6	934
Auto response of one column to another Colin Hayes	by Trevor Shuttleworth	3	400
DCount returns incorrect Result dee	by dee	2	433
Sumproduct Q Sean	by Sean	4	427
Conditional Sum prongacct07	by Duke Carey	3	361
I HAVE AN EXCEL FILE 3 COLUMNS , WHICH I HAVE TO ADD ON THE THIRD rosygucci	by rosygucci	4	385
Formula to lookup data and enter it in another WB joec	by joec	0	489
Auto extend formula down a column Sandy	by Sandy	0	1,320
Updating lookup table DanTX	by DanTX	0	414
Summing Catherine	by Catherine	4	411
Index/Match problem Lisa	by T. Valko	7	655
Total instances of the same numbers from one column? Aimcorep	by PCLIVE	2	516
repeating data in column to empty cells below without overwriting jeffchina	by Max	1	1,102
Need formula or Macro Help Atomic	by Tom Hutchins	1	414
automatic and manual calculation not working BobS9895	by Tom D[_3_]	1	787
Sorting Protected Worksheet Marge	by Dave Peterson	4	707
Formatting Date Cell with No Values Curtis	by Curtis	2	314
Indirect.ext doesn't work when sent to someone without morefunc ad Rich Hayes	by Rich Hayes	0	584
Columns are numbers (instead of letters). How to revert? XLS bobcat	by Dave Peterson	1	726
Macro Data Entry Validation Sandy	by vezerid	4	595
Average 6000 data points in sets of 10 Vikash	by [email protected]	2	973
D-sum and Grouping slow down problem Ben	by pshepard	2	1,796
Summarize multiple spreadsheets onto one Golf Nut[_2_]	by Golf Nut[_2_]	0	312
Locking Data Chris Hofer	by Chris Hofer	0	385
change font color based on a value Golf Nut[_2_]	by Ron Coderre	1	572
Print Visable Data Only Mitesh	by Bernie Deitrick	1	339
Print Visible Data Only Mitesh	by Bernie Deitrick	1	381
How do I insert a calculated cell range into an excel function Gary Wallis	by pshepard	2	965
Look up query JaB	by Toppers	1	307
Sum or Count using set range Rayasiom	by Rayasiom	3	576
Concatenate 2 cells, and have one cell value display as bold? Pierre	by Pierre	3	6,295
Subtracting sumed figures from the YR before sarah	by vezerid	1	458
Hour Calcuation Karan	by Toppers	3	377
Code needs simplifying Sandy	by Don Guillett	5	405
count Darrell_Sarrasin	by Susan	11	637
hello! and heelp manu	by Dave Peterson	3	354
mainframe file to excel spreadsheet Dave Cox	by Dave Peterson	5	4,538
Calculating rates using sumproduct masterkeys	by masterkeys	0	518
VLOOKUP problem Mortir	by Niek Otten	2	522
how to show if a table contains the same data Heine	by Joerg	2	354
Excel 2007 SUMIFS [email protected]	by [email protected]	2	1,017
pull down menus Montana	by Mike Monahan	7	829
linking data in various files, each file has 18 worksheets KerryMay	by KerryMay	0	587
entering a formula Moof	by Stan Brown	5	424
Same result on two worksheets Patrick Murray	by Mike	2	393
Copying Columns of Text - WS Functions do not work correctly Dixfield Guy	by Dixfield Guy	2	544
IF/AND/OR Formula Help? Carol	by T. Valko	7	447
What formula do I use for copying cell information between workboo Darren	by Darren	2	389
Excel inventory Sheet for workday month Monique	by Monique	1	681
Formatting help required... John	by Black country boy	1	331