Excel Worksheet Functions - Page 285

Thread / Thread Starter	Last Post	Replies	Views
sumproduct Bryan De-Lara[_2_]	by Bryan De-Lara[_2_]	7	571
characters which are matching between Data 1 & Data 2 Karan	by Max	12	944
Find and show fill color mulldoon	by John C[_2_]	4	492
I think it's an IF function but I am not sure Tim	by Tim	3	490
Comparing on 2 worksheets Roman	by Roman	5	563
Conditional count if question force530	by Sheeloo[_3_]	4	473
Last business day Hitchhiker42	by Hitchhiker42	7	942
Removing apostraphes from a group of cells on an Excel spreadsheet woodeaglevigil	by Rick Rothstein	3	475
EDATE Function JAD	by Ron Rosenfeld	4	562
center word over a gridline go1doug	by Sheeloo[_3_]	1	420
How to debug formula problems Stefan Froehlich	by Sheeloo[_3_]	1	538
Filter data using a formula R G[_2_]	by T. Valko	2	2,968
validation Formula RK	by John C[_2_]	4	454
Array? PAL	by PAL	6	396
Time Between Failure Maintenance	by ~L	5	726
SumIf with NA ArthurJ	by Sheeloo[_3_]	7	1,316
Auto PRINT file path & Date on Excel work sheet ? Harsh	by muddan madhu	1	1,694
Sum Leanne M (Aussie)	by Bernie Deitrick	1	344
=+IF(P14=0,"",AVERAGE(D14:O14)) RJJ	by Mike H	2	698
Conditional formatting ukredskin	by muddan madhu	2	414
Why is my cell displaying the formula ? STARR	by Mike H	1	438
What does the 'Map Network Drive' function do? cravingmad	by Mike H	1	1,124
copy rows climate	by climate	2	362
sum based on 2 criteria within a table herkimer	by herkimer	8	646
Function/Formula for Text Conversion Rauf	by Teethless mama	3	544
IF AND calculations with date Ranking by type, and the dashes[_2_]	by John C[_2_]	5	481
Cocatenate not showing leading zeros MS Excel 2003 AuthorizedUserPF	by Snailspace	6	591
Files on Toolbar cravingmad	by cravingmad	2	498
Remove Row numbers and Column letters from a specifice workbook ArcticWolf	by RonaldoOneNil	3	2,143
Drop Down Menu - Populate a list of matching words. Cpviv	by Max	3	1,312
download file of 200 name, addr.etc to excel file - how? please ad Tony V.	by Gary''s Student	1	596
Rounding up Kavi	by David Biddulph[_2_]	1	395
Formatting Date not working Chad[_3_]	by David Biddulph[_2_]	4	421
Changing values in cell based on system date [email protected]	by [email protected]	2	752
Conditional Formatting ignoring cells with a format already Jon Dow[_2_]	by ShaneDevenshire	2	482
How to make random numbers stay the same wyobuff	by ShaneDevenshire	4	5,201
Why is there 0.01 difference when I set up sum function in excel? Question	by joeu2004	1	573
Open HTML file, but doesn't copy correctly Kmason5727	by Kmason5727	0	867
Replace the final value (0) created by fomulas jwang036	by jwang036	5	536
Extract text within ( ) M	by Ron Rosenfeld	11	1,097
why use + sign in following formula? =+Q290*10 Sasser	by Gord Dibben	5	451
Absolute formulas Rockbear	by Roger Govier[_3_]	4	534
MACRO recording to be for all new sheets Christine[_3_]	by Gord Dibben	4	587
3-dimensional matrix XL comp.	by John C[_2_]	5	4,362
An either/or function HeatherBelle	by John C[_2_]	6	827
conditional formating less than % of previous day Big_Tater	by Big_Tater[_2_]	5	452
Lookup and match then return data from another sheet Charlie510	by Charlie510	6	829
How do I incorporate a formula to calculate many months releases? soconfused	by Sean Timmons	3	623
Arrrghhh! Help a newbie please with highlighting!!! MM	by ~L	5	391
Pivot Tables and Groupings RobFJ[_2_]	by Roger Govier[_3_]	2	456
Enter formula that uses values from other cells charliedog	by John C[_2_]	11	961
Add/Revise data in separate spreadsheets all at once Military Mom Too	by Flo Saforo	6	487
HLOOKUP, VLOOKUP, LOOKUP??? Connie Martin	by Connie Martin	10	1,076
Formula tmcwhorter	by muddan madhu	1	373
Date range lookup....tough one! deeds	by deeds	18	965
basic sum with a variable twist Leanne M (Aussie)	by Leanne M (Aussie)	3	459
Calculating future dates using WORKDAY & specific requirements seltzer	by John C[_2_]	7	814
Rouding to Multiple Decimals Esssa	by MartinW[_2_]	3	481
Info function which identfies a formula ArthurJ	by Gary''s Student	2	344
How to check all three cells are greater than 0% and then lookup v Len	by Len	7	758
How to flag the items that net off each other AG[_3_]	by AG[_3_]	3	518
Copying formulae [email protected]	by Simon Lloyd[_2_]	1	434
MACRO recording to be for all new sheets Susan	by Susan	0	421
multiple row selecting climate	by Susan	3	552
Database - mulitple selection Christine[_3_]	by Pete_UK	1	425
copying comments box chesjak	by Max	1	425
Using Name of worksheet in cell Ernie Fenwick	by Ernie Fenwick	2	390
Decimals Constant to 0.50 or Nearest Integer Esssa	by David Biddulph[_2_]	3	967
Text String Formula Q Seanie	by Seanie	4	444
Copy cells from one file into another Lenchik	by Roger Govier[_3_]	1	528
Changing Data Source on Multiple Pivot Tables at once marjhan	by Roger Govier[_3_]	1	2,660
How can I copy and paste only on the unhiden cells? meili	by meili	3	550
Calculating Percentage of Total macaskillh	by ShaneDevenshire	3	454
paste without formular Tracy Lo	by Gord Dibben	1	360
random decimal [email protected]	by ShaneDevenshire	5	1,094