Excel Worksheet Functions - Page 41

Thread / Thread Starter	Last Post	Replies	Views
Offset/match returns #value error Geoff	by Geoff	8	2,805
How can I add a fixed value to all cells in a table? BMHeiss	by Niek Otten	1	2,805
vlookup with different col_index_num ArcticWolf	by Pete_UK	7	2,803
Pasting charts to Word without Gridlines Brian	by kgander	5	2,803
Median with Quantity Column SDShannonS	by JoeU2004	3	2,803
My dates format list is missing '/' separator. How can I restore. GES in Oregon	by Gord Dibben	2	2,803
how do i get rid of hidden apostrophes in cells? brokenmonkey	by SSHO_99	4	2,801
How to define and select the last (bottom) number in a column? BrendaN_at_Welke_Customs	by T. Valko	24	2,800
Change cell color in protected sheet ansa	by Nic Rigden	2	2,799
Match then lookup Tenacity	by Dave Peterson	9	2,799
countif comparing two columns Johndb	by Ashish Mathur[_2_]	4	2,798
MYSTERY: NESTED INDEX AND MATCH FUNCTIONS JingleRock[_2_]	by T. Valko	28	2,798
VLookup between date ranges ? Steve	by Steve	6	2,796
How do I get Rid of the Circumflex Accent (Caret) tb	by Gord Dibben[_2_]	2	2,794
Data Validation - Custom question (multiple conditions) lukin	by [email protected]	9	2,792
Do not allow Copy/Paste Functionality in a Protected Sheet Prashanth KR	by www.exciter.gr: Custom Excel Functions!	1	2,792
Converting time as 7.5 (which represents 7:30 AM) to 0730 Steve	by Steve	12	2,792
sort option is greyed out in excel mom	by Chip Pearson	1	2,791
Change Cell Color Based on IF Statement Cathy	by Cathy	3	2,791
How do I add up time and minutes in a spreadsheet? Todd B.	by Lynne	3	2,791
use if function to change cell color bigdaddy3	by bigdaddy3	2	2,790
Financial Year Month Number Tiffany	by Ron Rosenfeld	3	2,790
How do you alphabetize street addresses within a column? Rosemarie	by David Biddulph[_2_]	4	2,790
Getting column number from HLOOKUP? [email protected]	by [email protected]	3	2,789
VLOOKUP DUPLICATE VALUES Rj	by Teethless mama	3	2,789
engineering notation in excell berty239	by Gary''s Student	1	2,789
SUMIF and text Silja	by Silja	3	2,787
calculate anniversary of date after specified date slymeat	by Ron Rosenfeld	3	2,787
MAX only Rows in Range where another Row is Not Blank PCLIVE	by T. Valko	3	2,786
How do I compare 2 sets of data and highlight differences? Perplexed1	by olasa	1	2,785
Need help with macro for conditional formatting using number forma Kathy	by OssieMac	1	2,785
COUNTIF across worksheets pdberger	by Mike H	3	2,785
how can i estimate garch parameters(gamma,alpha and beta)in excel garch estimatio	by garch estimatio	0	2,783
Formula for calculating a running balance up to a maximum limit kaw	by Ron Coderre	3	2,783
error - unreadable content in pivot table file - how do I find it BarbC	by ryguy7272	1	2,781
Automatically filling in cells based on another cell's content Ginger	by Ginger	5	2,780
Cell Reference: won't auto-calculate, among other things Lillian2611	by Lillian2611	2	2,780
how to graph a horsepower curve in excel (horsepower vs. rpm) Blue	by Blue	4	2,779
calculate from degrees to degrees/minutes/seconds on excel? C. Hollinger	by Beege	1	2,779
assign a macro to send email in lotus notes from Excel spreadsheet pdaws	by pdaws	0	2,778
HLOOKUP copied across rows with "row index number" changing KUMPFfrog	by KUMPFfrog	3	2,776
change multiple links at once TaralearningExcel	by Paul C	1	2,776
Number of days past due rrupp	by Gord Dibben	2	2,775
Formula won't show sum Parry	by Dennis (The Menace) Hayden[_2_]	20	2,775
Converting a date in Excel 2002 to a Year/Quarter format Jim	by Jim	2	2,775
how do I extract hex digits in a cell and convert to binary prs_013	by George	3	2,775
CELL EQUALS LAST NONBLANK CELL IN A COLUMN Vicky	by T. Valko	5	2,774
Advanced Excel Functions Ebook robert	by jack1090	2	2,774
Stop specific cell from recalculating? Tony Gravagno	by T. Valko	3	2,773
Date Format "stuck" Undrline	by Jim Thomlinson	3	2,773
How to: Find first empty cell in column DW	by DW	18	2,773
How do you rank in order numbers from highest to the lowest? Anika	by JMB	4	2,772
Scientific notation Biocellguy	by MyVeryOwnSelf	2	2,772
How to get rid of #Value when multiplying erika rock	by Peo Sjoblom[_3_]	1	2,771
Subtracting two 2-decimal place numbers gives result 13-decimal places? [email protected]	by Jerry W. Lewis	5	2,771
Count excluding Duplicates GRM via OfficeKB.com	by topola	12	2,770
template timer stopwatch wamay	by Peo Sjoblom	1	2,770
Automatic copying data excluding blank cells Wesley	by Max	6	2,768
Copying a forumula to many cells -but keeping one element static Karl	by Karl	2	2,767
Time format help needed Dan W.	by David Biddulph[_2_]	19	2,767
Conditional formatting for shared worksheet? Dave Dobson	by Dave Dobson	2	2,767
vlookup for same name, multiple instances... Chris_Hatch	by Pete_UK	19	2,766
Hide Negative Numbers or Display as Zero Me	by Peo Sjoblom	8	2,765
How do I auto-filter multiple ranges on one worksheet? AREV	by Gord Dibben	3	2,764
using excel generate random numbers 1 to 52 without repeating Norman	by [email protected]	4	2,764
how do i link merged cells to a merged cell in another worksheet. ibbm	by Max	3	2,763
shortcut has change or move so this shortcut can not open bakerstreet	by JLatham	2	2,763
parsing a full name out into Last, First, Middle Craig	by Ron Rosenfeld	2	2,762
Return column header as solution to lookup Tessa	by Tessa	3	2,761
Fill in Column with a series of repeating numbers mimi	by David Biddulph[_2_]	2	2,760
Help PLEASE! Not sure what answer is: Match? Index? Other? baz	by Conrad Carlberg	7	2,760
how do I lock values in excel nupe1493	by Gary L Brown	1	2,759
auto update an open excel sheet over network, with mutiple users crumkerr	by Frank Kabel	1	2,759
Unable to remove objects pasted into Excel from HTML grid kydan47	by Sasa Stankovic	3	2,759
Vlookup for multiple criteria, multiple worksheets jtoy	by jtoy	4	2,759