Excel Worksheet Functions - Page 541

Thread / Thread Starter	Last Post	Replies	Views
Pop up Calendar error Klee	by Klee	6	548
percentages of subtotals Miaplacidus	by Roger Govier	1	349
Transpose a text string while copying adjacent column data to new willc	by willc	5	691
ISTEXT TRUE then copy formula from cell X E Cobb	by David Biddulph[_2_]	7	1,679
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,043
array range in seperate sheets cass calculator	by cass calculator	2	500
Listing names and id and corresponding software NeedExcelHelp07	by JLatham	3	550
dynamically changing text color Dave	by Peo Sjoblom	4	1,719
Unhandled exception - Not implemented Aggie	by Aggie	0	657
Identify & List unique values from a list using functions/formulas momtoaj	by T. Valko	3	1,735
how to push data to another cell Wawa	by JE McGimpsey	1	1,114
Accounting for Duplicates in Rank [email protected]	by Gary''s Student	4	429
Excel, date-sensitive, 2-part formulas kblostyankee	by kblostyankee	3	751
=OR and =IF Help Pam	by Pam	3	421
vlookup error [email protected]	by [email protected]	5	597
how to sort column with cell pairs muggeschiss	by vezerid	5	1,997
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	537
Returning same value cell in a column but different row. [email protected]	by vezerid	4	505
Conditional Formatting - Draw Line every 10th Row Sam via OfficeKB.com	by vezerid	16	1,625
add text to cell user3307	by user3307	3	333
update worksheet keeping formula user3307	by user3307	8	796
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	611
Normalize score austuni	by Harimau	2	1,412
Displaying Excel data in flattened hierarchy Nagesh	by Harimau	1	1,769
SUMPRODUCT assistance SDH	by JE McGimpsey	1	411
Fraction Formatting and Averages mrgou[_2_]	by EP	3	361
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,982
Corrosponding excel generated numbers with 1st row numbers Anne_Nev	by JLatham	1	488
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	589
Number of Saturdays within a range of dates Ruben	by Daniel.M	4	1,785
HELP JohnG	by Rick Rothstein \(MVP - VB\)	3	401
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	449
Exported file to WP as merge. Now is corrupt. Data lost. Help Patty	by JE McGimpsey	5	692
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	516
Hide VBA code help GerryK	by GerryK	3	1,423
Help with Pivot Table and totals erick-flores	by erick-flores	0	560
27-May-2007 is a WORKDAY? [email protected]	by MM	4	416
Time after midnight Steved	by Steved	2	1,072
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	409
For Danielle FC	by Mike H	1	408
SUMIF with dates RHfactor	by T. Valko	2	429
Setting up a database in excel Shay[_2_]	by MH[_2_]	7	471
count not working in pivot table erick-flores	by erick-flores	0	407
HLOOKUP second column Kelly	by DazzaData	7	679
Returning other cells with the same value in a column, but different row. [email protected]	by PCLIVE	1	408
Tabbing to cells artgrl8163	by Peo Sjoblom	2	511
moving items within the page Alan	by vezerid	1	403
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,047
Coomplete the formula marwildfw	by Duke Carey	1	397
how to extend the column limit on a worksheet Jackie	by Duke Carey	1	545
File Calculation tj	by tj	4	342
building list from a column of data driller	by driller	3	461
vlookup problem when value absent new_121	by new_121	2	382
autofill @ intervals jejkskpj	by jejkskpj	2	764
how to call the event of other worksheet chad	by Bob Phillips	1	456
Worksheet formulas Thomas	by Bob Phillips	3	314
COUNTIF oddity Phil C	by Mike H	1	338
Comparing worksheets enna49	by enna49	2	616
How to create a macro to help with lookup. Jman	by Jman	3	498
Advanced Filter to another location Jman	by Jman	4	934
HOW DO I SET UP A PRECEDENCE DIAGRAM? G Heard	by ShaneDevenshire	1	4,564
sumif/sumproduct formula help Robert	by Robert	2	474
Date Calculation LeapYear	by Ron Rosenfeld	5	399