Excel Worksheet Functions - Page 557

Thread / Thread Starter	Last Post	Replies	Views
Set day of week to display in date field SaipanRick	by SaipanRick	2	470
What formula would transpose stale dated cells? Debbie	by MartinW	2	620
Counting Days Belinda7237	by Belinda7237	2	613
Using text to lookup different table arrays in vlookup. stuart	by stuart	2	935
Cost Charge Conundrum kjh198	by kjh198	2	356
Reference cell above in a subtotaled sheet Rubystarx	by Rubystarx	2	443
BAG_DEG_DOLU_SAY (COUNTA) ibrahim Ozcan	by David Biddulph[_2_]	2	311
Referencing several cells with IF? andim	by Mike H	2	438
worksheet LOCKED James8309	by Spiky	2	337
sop for excel in pharmaceutical industry laxmi	by laxmi	2	1,040
Update robzrob	by robzrob	2	431
Gathering rows of data from multiple wrkbks to single column SaipanRick	by SaipanRick	2	789
Sorting data in multiple columns Sadie5757	by Spiky	2	475
a cell in excel will not display the formula total John	by Spiky	2	480
How to format range of cells using Conditional Formatting-Excel? bookmanu3	by leimst	2	527
Sorting issues KKT	by Bernard Liengme	2	344
Microsoft Word robzrob	by Reitanos	2	344
writing a formula to distinguish a letter and a number noel	by Beege	2	871
Excel insert question Kevin W[_2_]	by Kevin W[_2_]	2	429
Skipping every other column for an Average. Empy	by Empy	2	792
Match then Vlookup [email protected]	by [email protected]	2	381
Trying to get contents of cell linked through IF function. bman1965	by bman1965	2	326
Complicated SUM IF formula mckzach	by T. Valko	2	548
formula question JaneSmith	by Spiky	2	439
IF Formula Nickie	by Nickie	2	342
Calculating results from cells containing formulas Zakynthos	by Zakynthos	2	357
Trouble trying to do a 'Count IF' Logikal1	by Bob Phillips[_3_]	2	433
Search a column for values, return a value from adj column Adam	by Bob Phillips[_3_]	2	578
Tidy lookup PBcorn	by PBcorn	2	415
Drop Down Menus IainM21	by Marcelo	2	551
Consecutive dates in each excel worksheet? JESSEKA	by JESSEKA	2	1,342
If then formula pakmount	by mjmeyer	2	341
Finding Zeros Seahorsenerd	by David Biddulph[_2_]	2	457
Macro based on Cell Value NPell	by NPell	2	722
Form on Excel joaniemic	by Gord Dibben	2	300
Averaging excluding blanks--Multiple Tabs DaS	by DaS	2	693
Simple Adding/Subtraction and format of cell. - HELP!!! James8309	by David Biddulph[_2_]	2	377
Subtotal Len	by Len	2	367
Shortcut Key Date Format Daniel L. Lieberman	by Daniel L. Lieberman	2	422
Summing across multiple sheets using a changeable reference cell ajnmx	by ajnmx	2	757
receive one value using two or more criteria billdad	by Dave	2	334
Data validation: want input restricted to date value or N/A Rachel Garrett	by Rachel Garrett	2	6,937
Ignore zero in subtotal formula Sarah (OGI)	by RinTinTin	2	5,611
Sumif as a fuction of If using multiple criteria AMB	by PCLIVE	2	403
Split the cell Vanja	by Vanja	2	344
Minusing 17.5% off a column of figures Sue	by Mike H	2	381
To calculate escalation cost for the construction industry vmohan1978	by Mohan	2	4,884
Sorry for the repost, but still need some advice chris	by Don Guillett	2	410
Comparing Model Numbers without a giant IF statement Shawn Conn	by Shawn Conn	2	435
Counting bold cells in table rows John	by Gord Dibben	2	960
Average of select range of numbers W Palermo	by T. Valko	2	462
How do I Exclude a list of dates in a date calculation? Ryan	by Ron	2	405
Dependent drop-down boxes Christine	by ryguy7272	2	413
What Does -- Mean? Minitman	by Minitman	2	420
lease commitments Desperatesusy	by Desperatesusy	2	817
adding a control button with a filter Belinda7237	by Belinda7237	2	473
Inserting rows in a protected sheet - Office 2003 Todd A	by Todd A	2	1,093
Conditional Sum Vernon	by Vernon	2	318
if function with extras. MARY	by PCLIVE	2	345
Help with the first sheet to be automated. Igneshwara reddy[_2_]	by Igneshwara reddy[_2_]	2	397
too many different cell formats sonshinegirl	by Dave Peterson	2	427
Remembering lookups Aitchy	by Nayab	2	380
Graph of 2nd serious in the Line type graph is not connected Frank Situmorang[_2_]	by Frank Situmorang[_2_]	2	984
How can I conditionally hide or display data in a cell? mrsphyl	by Spiky	2	627
cell - wrap kmah	by PCLIVE	2	339
Add a letter "E" Steved	by Steved	2	305
Pull data from various worksheet JMac[_2_]	by JMac[_2_]	2	468
Help Optimizing a Sheet to improve performance Vulcan	by Bob Flanagan[_2_]	2	697
repeating values [email protected]	by Teethless mama	2	496
Either percentage or dollar discount formula KHiggins2008	by KHiggins2008	2	1,118
ASSESSMENT FORMULA Tia[_3_]	by Dennis	2	604
Complicated lookup Bill	by Bill	2	496
Formula, text and currency in same cell [email protected]	by driller	2	1,667
Adding text columns ARS_MEL	by Dave Curtis	2	429
count only certain cells Robert-Alpha[_2_]	by Mike H	2	396