Excel Worksheet Functions - Page 541

Thread / Thread Starter	Last Post	Replies	Views
Pop up Calendar error Klee	by Klee	6	549
percentages of subtotals Miaplacidus	by Roger Govier	1	349
Transpose a text string while copying adjacent column data to new willc	by willc	5	692
ISTEXT TRUE then copy formula from cell X E Cobb	by David Biddulph[_2_]	7	1,703
Linked cells and text wrap / autofit function Ken H	by Dave Peterson	1	903
Change time h:mm to a decimal number based on hours Snort5525	by Snort5525	6	1,044
array range in seperate sheets cass calculator	by cass calculator	2	502
Listing names and id and corresponding software NeedExcelHelp07	by JLatham	3	551
dynamically changing text color Dave	by Peo Sjoblom	4	1,721
Unhandled exception - Not implemented Aggie	by Aggie	0	658
Identify & List unique values from a list using functions/formulas momtoaj	by T. Valko	3	1,740
how to push data to another cell Wawa	by JE McGimpsey	1	1,129
Accounting for Duplicates in Rank [email protected]	by Gary''s Student	4	430
Excel, date-sensitive, 2-part formulas kblostyankee	by kblostyankee	3	754
=OR and =IF Help Pam	by Pam	3	421
vlookup error [email protected]	by [email protected]	5	599
how to sort column with cell pairs muggeschiss	by vezerid	5	2,001
Dynamic Avarage ano	by ano	11	819
Require mandatory info input in order for Exel to save changes. VHG	by JE McGimpsey	3	528
How do i set up a dropdown listbox of values in a column of cells TheRulie	by vezerid	2	541
Returning same value cell in a column but different row. [email protected]	by vezerid	4	507
Conditional Formatting - Draw Line every 10th Row Sam via OfficeKB.com	by vezerid	16	1,627
add text to cell user3307	by user3307	3	335
update worksheet keeping formula user3307	by user3307	8	799
Color changing of fonts by using the IF function sadat	by DazzaData	1	551
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,414
Displaying Excel data in flattened hierarchy Nagesh	by Harimau	1	1,771
SUMPRODUCT assistance SDH	by JE McGimpsey	1	414
Fraction Formatting and Averages mrgou[_2_]	by EP	3	362
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	494
Trace Precedent George Cuartero	by JE McGimpsey	1	489
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	590
Number of Saturdays within a range of dates Ruben	by Daniel.M	4	1,788
HELP JohnG	by Rick Rothstein \(MVP - VB\)	3	402
Filling down w/o dragging Zb Kornecki	by Alka	6	495
average last four rows in a column LoveKeIIy	by Don Guillett	3	1,389
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	695
Returning cells with the same value in a column, but on different rows. [email protected]	by Gord Dibben	1	491
how do i change a full excel sheet to proper after it has been ty. peter	by Gord Dibben	2	517
Hide VBA code help GerryK	by GerryK	3	1,426
Help with Pivot Table and totals erick-flores	by erick-flores	0	563
27-May-2007 is a WORKDAY? [email protected]	by MM	4	419
Time after midnight Steved	by Steved	2	1,074
Sumif with criteria help Shannan	by Peo Sjoblom	3	526
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	429
Setting up a database in excel Shay[_2_]	by MH[_2_]	7	475
count not working in pivot table erick-flores	by erick-flores	0	415
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	513
moving items within the page Alan	by vezerid	1	404
return N/A when no first match but do nothing if no second match CathyH	by CathyH	2	477
How do i add a new entry to an existing drop-down list in Excel? ABD	by Peo Sjoblom	2	2,052
Coomplete the formula marwildfw	by Duke Carey	1	400
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	463
vlookup problem when value absent new_121	by new_121	2	383
autofill @ intervals jejkskpj	by jejkskpj	2	764
how to call the event of other worksheet chad	by Bob Phillips	1	458
Worksheet formulas Thomas	by Bob Phillips	3	316
COUNTIF oddity Phil C	by Mike H	1	338
Comparing worksheets enna49	by enna49	2	618
How to create a macro to help with lookup. Jman	by Jman	3	498
Advanced Filter to another location Jman	by Jman	4	936
HOW DO I SET UP A PRECEDENCE DIAGRAM? G Heard	by ShaneDevenshire	1	4,566
sumif/sumproduct formula help Robert	by Robert	2	475
Date Calculation LeapYear	by Ron Rosenfeld	5	401