Excel Worksheet Functions - Page 541

Thread / Thread Starter	Last Post	Replies	Views
Pop up Calendar error Klee	by Klee	6	556
percentages of subtotals Miaplacidus	by Roger Govier	1	349
Transpose a text string while copying adjacent column data to new willc	by willc	5	702
ISTEXT TRUE then copy formula from cell X E Cobb	by David Biddulph[_2_]	7	1,710
Linked cells and text wrap / autofit function Ken H	by Dave Peterson	1	910
Change time h:mm to a decimal number based on hours Snort5525	by Snort5525	6	1,050
array range in seperate sheets cass calculator	by cass calculator	2	510
Listing names and id and corresponding software NeedExcelHelp07	by JLatham	3	554
dynamically changing text color Dave	by Peo Sjoblom	4	1,724
Unhandled exception - Not implemented Aggie	by Aggie	0	666
Identify & List unique values from a list using functions/formulas momtoaj	by T. Valko	3	1,747
how to push data to another cell Wawa	by JE McGimpsey	1	1,136
Accounting for Duplicates in Rank [email protected]	by Gary''s Student	4	430
Excel, date-sensitive, 2-part formulas kblostyankee	by kblostyankee	3	755
=OR and =IF Help Pam	by Pam	3	421
vlookup error [email protected]	by [email protected]	5	604
how to sort column with cell pairs muggeschiss	by vezerid	5	2,008
Dynamic Avarage ano	by ano	11	827
Require mandatory info input in order for Exel to save changes. VHG	by JE McGimpsey	3	540
How do i set up a dropdown listbox of values in a column of cells TheRulie	by vezerid	2	551
Returning same value cell in a column but different row. [email protected]	by vezerid	4	517
Conditional Formatting - Draw Line every 10th Row Sam via OfficeKB.com	by vezerid	16	1,637
add text to cell user3307	by user3307	3	336
update worksheet keeping formula user3307	by user3307	8	800
Color changing of fonts by using the IF function sadat	by DazzaData	1	561
How to select a cell to the left of the right aligned cell with th Dima	by Dima	2	612
Normalize score austuni	by Harimau	2	1,422
Displaying Excel data in flattened hierarchy Nagesh	by Harimau	1	1,774
SUMPRODUCT assistance SDH	by JE McGimpsey	1	414
Fraction Formatting and Averages mrgou[_2_]	by EP	3	363
Count blank with multiple criteria Twishlist	by T. Valko	3	1,517
How to sum unique values in a column moondaddy	by ShaneDevenshire	3	3,986
Corrosponding excel generated numbers with 1st row numbers Anne_Nev	by JLatham	1	504
Trace Precedent George Cuartero	by JE McGimpsey	1	492
VLOOKUP question utilizing the right and left of a given column ineed the mid too dont know how to incorporate. TIA for help EP	by EP	1	591
Number of Saturdays within a range of dates Ruben	by Daniel.M	4	1,796
HELP JohnG	by Rick Rothstein \(MVP - VB\)	3	402
Filling down w/o dragging Zb Kornecki	by Alka	6	498
average last four rows in a column LoveKeIIy	by Don Guillett	3	1,390
help on GPA formulas with null value JohnG	by JE McGimpsey	1	451
Exported file to WP as merge. Now is corrupt. Data lost. Help Patty	by JE McGimpsey	5	696
Returning cells with the same value in a column, but on different rows. [email protected]	by Gord Dibben	1	498
how do i change a full excel sheet to proper after it has been ty. peter	by Gord Dibben	2	518
Hide VBA code help GerryK	by GerryK	3	1,427
Help with Pivot Table and totals erick-flores	by erick-flores	0	569
27-May-2007 is a WORKDAY? [email protected]	by MM	4	420
Time after midnight Steved	by Steved	2	1,075
Sumif with criteria help Shannan	by Peo Sjoblom	3	529
Transpose a String carl	by Rick Rothstein \(MVP - VB\)	10	877
Date Format ACarella	by ACarella	6	410
For Danielle FC	by Mike H	1	411
SUMIF with dates RHfactor	by T. Valko	2	438
Setting up a database in excel Shay[_2_]	by MH[_2_]	7	487
count not working in pivot table erick-flores	by erick-flores	0	424
HLOOKUP second column Kelly	by DazzaData	7	680
Returning other cells with the same value in a column, but different row. [email protected]	by PCLIVE	1	411
Tabbing to cells artgrl8163	by Peo Sjoblom	2	518
moving items within the page Alan	by vezerid	1	414
return N/A when no first match but do nothing if no second match CathyH	by CathyH	2	487
How do i add a new entry to an existing drop-down list in Excel? ABD	by Peo Sjoblom	2	2,057
Coomplete the formula marwildfw	by Duke Carey	1	401
how to extend the column limit on a worksheet Jackie	by Duke Carey	1	545
File Calculation tj	by tj	4	343
building list from a column of data driller	by driller	3	470
vlookup problem when value absent new_121	by new_121	2	383
autofill @ intervals jejkskpj	by jejkskpj	2	771
how to call the event of other worksheet chad	by Bob Phillips	1	459
Worksheet formulas Thomas	by Bob Phillips	3	317
COUNTIF oddity Phil C	by Mike H	1	344
Comparing worksheets enna49	by enna49	2	619
How to create a macro to help with lookup. Jman	by Jman	3	507
Advanced Filter to another location Jman	by Jman	4	942
HOW DO I SET UP A PRECEDENCE DIAGRAM? G Heard	by ShaneDevenshire	1	4,566
sumif/sumproduct formula help Robert	by Robert	2	478
Date Calculation LeapYear	by Ron Rosenfeld	5	408