Excel Worksheet Functions - Page 179

Thread / Thread Starter	Last Post	Replies	Views
Excel doing strange things Duncan Brown	by smartin	1	573
Count number of occurences in a list Lucas Reece	by T. Valko	12	845
open and close files Chi	by Chi	2	370
add multiple numbers in one cell with those numbers remaining visi TD	by Harlan Grove[_2_]	7	2,362
Using greater than and lesser than formula JGW	by JoeU2004	2	1,353
AutoFit Row Height - How to use so there is no space after text? Jennifer	by Jennifer	0	791
auto complete KCegbe	by Mike H	1	463
unique values among duplicates without considering specific words Simna	by T. Valko	1	347
easy formula question j lunis	by T. Valko	2	394
Negative Dates and/or Times watermt	by watermt	3	412
lookup cell reference and copy contents and comment from a range GarySW	by GarySW	0	718
How do I allow data entry to one column only? Carmen	by Eduardo	2	833
show or Hide cell comment when mouse hovers in Excel? Abi	by Rick Rothstein	1	1,004
Extracting a month name forom a date Finance Guru	by Rick Rothstein	5	1,494
DATA SUMMARY M.GONZALEZ[_2_]	by Eduardo	1	463
Max Price and Min Price paid for an item F. GOMEZ	by Rick Rothstein	1	498
lookup to bring back multiple values zakfalls	by T. Valko	3	1,953
Conditional Formatting SharonR	by Tom Hutchins	4	397
keeping formula the same in a workbook when adding a row to one sh jcrowe	by Eduardo	1	564
How to remove double data? marycler	by Eduardo	2	342
SUMIFS Issue CFitz	by Bob Phillips[_3_]	5	370
RANDBETWEEN problems plb	by RagDyeR	7	648
Complex sum required N Drinkwater	by RagDyeR	3	346
OFFSET function Lynda	by Roger Govier[_3_]	3	410
way to view excel workbook only by password protection S.REYNA	by Jacob Skaria	1	439
Retrieve Data to Pivot Table "On Demand" Steve Haack	by Roger Govier[_3_]	1	361
macro Protection Warm	by Jacob Skaria	1	333
Automating change via popup to a column of numbers Colin Hayes	by Colin Hayes	0	370
How to delete duplicates and also count them Eddie	by Eddie	4	4,913
IF function feausij	by Eduardo	7	402
i want to automatically save the data after every 2 mins in excel gunjan.chowdhri	by Jacob Skaria	2	529
Summary sheet auto update SUMMARY SHEET AUTO UPDATE FROM WORKBOOKS	by SUMMARY SHEET AUTO UPDATE FROM WORKBOOKS	0	724
Why copying the sheet to diff file changes font color? Fesco	by zakfalls	1	585
Sum based on date greater than and a specific status adding to a t SusanG	by SusanG	4	463
AVERAGEIF problem TPaton	by Roger Govier[_3_]	3	780
trouble with Names on multiple sheets [email protected]	by OssieMac	1	399
Insert a new line, without destroying the consistency of the formu HPH	by HPH	6	1,178
Validation List Question, Text in Cell DIffers to that Selected BaggieDan	by Roger Govier[_3_]	3	469
search through dates smudgedwhiteink	by Simon Lloyd[_249_]	1	403
How to populate a cell based on font color/threshold ascottbag-hcm	by Joerg Mochikun	1	773
INDEX - MATCH - OFFSET By Reference Bam	by Bam	2	832
Count cells with a date falling within a 30 day period. Rob	by Jacob Skaria	2	1,327
Check result if same as other cell on row art	by T. Valko	1	312
Calculating Link[_2_]	by JoeU2004	2	351
Computing the item age AG[_3_]	by AG[_3_]	3	435
Separating text in one cell into two cells France	by Gord Dibben	2	482
Sumif Function canuck_heat	by Ragdyer	2	562
Using more than one list in a drop-down Des_2001	by Gord Dibben	2	367
How do I make coloured drop down lists in Excel? Ã‰annaD	by Gord Dibben	3	2,355
How to change the number of rows in a worksheet. Bloo	by Gord Dibben	3	417
How do I update all worksheets at startup? kit493	by Gord Dibben	2	449
Pivot Table Question Steve Haack	by Steve Haack	0	360
Error in VLOOKUP Kris	by Harlan Grove[_2_]	4	593
Text File Question UGScott	by Harlan Grove[_2_]	5	474
Logical operators not working with text??? Slinky[_2_]	by Slinky[_2_]	3	3,312
direction of delta using arrows casey	by Stephen Bye[_2_]	3	1,109
Tricky problem - auto-sorting without VBA philkime	by philkime	7	4,158
excel 2007 Bob M	by Jacob Skaria	1	332
IF function Irish	by T. Valko	5	409
If...rows and columns something68	by something68	3	372
Zero in cell where it is linked to a blank cell - repost texansgal	by Jacob Skaria	4	477
display filter selection from menu labgeek	by labgeek	2	738
Calculating someone's age at a given date Deb	by Sean Timmons	12	977
Filter Blue	by Jarek Kujawa[_2_]	2	381
"Remembering" Cell Values Harlan	by JLatham	4	404
Aging by netting negatives in other age buckets for the customer Maniv	by Sean Timmons	3	1,742
TIMESHEET Link[_2_]	by Bam	1	401
how do I use array references in VLOOKUP()? tsimkus	by Lori	2	333
Excell formula required. If a^b=C....... a = ? Rod neale	by Dave Peterson	3	389
Help for Date counting. shital shah	by Jimmystix	1	362
if function LCCHELP	by JoeU2004	8	379
Problems Kay	by David Biddulph[_2_]	7	393
Adding problem in excel EggMan903	by T. Valko	6	1,053
Last 7 days bbal20	by bbal20	9	845
Unable To Read File - Sumproduct error Fluke[_2_]	by Dave Peterson	9	914