Excel Worksheet Functions - Page 1005

Thread / Thread Starter	Last Post	Replies	Views
How to change the number of rows in a worksheet. Bloo	by Gord Dibben	3	399
How do I make coloured drop down lists in Excel? Ã‰annaD	by Gord Dibben	3	2,339
Using more than one list in a drop-down Des_2001	by Gord Dibben	2	351
Sumif Function canuck_heat	by Ragdyer	2	549
Separating text in one cell into two cells France	by Gord Dibben	2	470
Computing the item age AG[_3_]	by AG[_3_]	3	418
Calculating Link[_2_]	by JoeU2004	2	332
Check result if same as other cell on row art	by T. Valko	1	299
Count cells with a date falling within a 30 day period. Rob	by Jacob Skaria	2	1,314
INDEX - MATCH - OFFSET By Reference Bam	by Bam	2	766
How to populate a cell based on font color/threshold ascottbag-hcm	by Joerg Mochikun	1	756
search through dates smudgedwhiteink	by Simon Lloyd[_249_]	1	385
Validation List Question, Text in Cell DIffers to that Selected BaggieDan	by Roger Govier[_3_]	3	459
Insert a new line, without destroying the consistency of the formu HPH	by HPH	6	1,166
trouble with Names on multiple sheets [email protected]	by OssieMac	1	387
AVERAGEIF problem TPaton	by Roger Govier[_3_]	3	759
Sum based on date greater than and a specific status adding to a t SusanG	by SusanG	4	446
Why copying the sheet to diff file changes font color? Fesco	by zakfalls	1	568
Summary sheet auto update SUMMARY SHEET AUTO UPDATE FROM WORKBOOKS	by SUMMARY SHEET AUTO UPDATE FROM WORKBOOKS	0	714
i want to automatically save the data after every 2 mins in excel gunjan.chowdhri	by Jacob Skaria	2	509
IF function feausij	by Eduardo	7	399
How to delete duplicates and also count them Eddie	by Eddie	4	4,895
Automating change via popup to a column of numbers Colin Hayes	by Colin Hayes	0	355
macro Protection Warm	by Jacob Skaria	1	323
Retrieve Data to Pivot Table "On Demand" Steve Haack	by Roger Govier[_3_]	1	348
way to view excel workbook only by password protection S.REYNA	by Jacob Skaria	1	412
OFFSET function Lynda	by Roger Govier[_3_]	3	395
Complex sum required N Drinkwater	by RagDyeR	3	334
RANDBETWEEN problems plb	by RagDyeR	7	616
SUMIFS Issue CFitz	by Bob Phillips[_3_]	5	358
How to remove double data? marycler	by Eduardo	2	328
keeping formula the same in a workbook when adding a row to one sh jcrowe	by Eduardo	1	550
Conditional Formatting SharonR	by Tom Hutchins	4	363
lookup to bring back multiple values zakfalls	by T. Valko	3	1,776
Max Price and Min Price paid for an item F. GOMEZ	by Rick Rothstein	1	462
DATA SUMMARY M.GONZALEZ[_2_]	by Eduardo	1	453
Extracting a month name forom a date Finance Guru	by Rick Rothstein	5	1,483
show or Hide cell comment when mouse hovers in Excel? Abi	by Rick Rothstein	1	981
How do I allow data entry to one column only? Carmen	by Eduardo	2	809
lookup cell reference and copy contents and comment from a range GarySW	by GarySW	0	702
Negative Dates and/or Times watermt	by watermt	3	395
easy formula question j lunis	by T. Valko	2	379
unique values among duplicates without considering specific words Simna	by T. Valko	1	328
auto complete KCegbe	by Mike H	1	444
AutoFit Row Height - How to use so there is no space after text? Jennifer	by Jennifer	0	764
Using greater than and lesser than formula JGW	by JoeU2004	2	1,294
add multiple numbers in one cell with those numbers remaining visi TD	by Harlan Grove[_2_]	7	2,331
open and close files Chi	by Chi	2	359
Count number of occurences in a list Lucas Reece	by T. Valko	12	829
Excel doing strange things Duncan Brown	by smartin	1	552
using percentages in conditional formatting Rolando	by Sheeloo	1	699
How do I keep 3-D reference the same when inserting one row on one jcrowe	by Harlan Grove[_2_]	12	840
Alpha-sort addresses, ignoring first 1-3 numerals lalah725	by Harlan Grove[_2_]	7	467
Posting problem Link[_2_]	by Link[_2_]	3	426
How to use keyboard to enter the drop down list? Alan	by Alan	2	1,030
Worksheet Tabs two_tone	by two_tone[_2_]	2	342
Unique/Distinct Dropdown List Shawn	by Shawn	9	1,971
How to get the caliculation process Window in Excel vishnu	by Sheeloo	1	498
Stop cell changing Mia	by Mia	3	474
Formula Link[_2_]	by David Biddulph[_2_]	1	426
Formula in Excel Help Please TMansell	by JAS	3	311
Convert 0 value cells to "text" brucas	by brucas	7	1,684
How to enter a database function to average the annual salary? maria	by [email protected]	4	1,751
Creating Serial Additions of Numbers Formatted "M-N" In Merged and Unmerged Cells Patient Guy	by Patient Guy	2	892
Counting Kris	by Kris	2	320
Changing $ format to a written format JGW	by fake_be	2	352
Max Price and Min Price paid for an item - Rephrsed F. GOMEZ	by Ashish Mathur[_2_]	4	776
Protect sheet but be able to merge cells Protect Sheet but be able to merge cells	by Dave Peterson	1	599
sorting with custom data haywardfun	by Jacob Skaria	1	406
Create an edit field Neall	by Bob Bridges[_2_]	1	346
calculations of weekends only tmj8901	by Ron Rosenfeld	2	1,694
Formula for IF a cell contains value texansgal	by Bob Bridges[_2_]	1	382
Need help with Hlookup - need to return values below the matched c ACornell	by ACornell	2	485
Rounding Errors in 2007 Jacqueline	by Meebers[_2_]	14	1,852
Split by characters Elton Law[_2_]	by Greg Lovern	7	682