Excel Worksheet Functions - Page 179

Thread / Thread Starter	Last Post	Replies	Views
Excel doing strange things Duncan Brown	by smartin	1	574
Count number of occurences in a list Lucas Reece	by T. Valko	12	847
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,368
Using greater than and lesser than formula JGW	by JoeU2004	2	1,357
AutoFit Row Height - How to use so there is no space after text? Jennifer	by Jennifer	0	792
auto complete KCegbe	by Mike H	1	472
unique values among duplicates without considering specific words Simna	by T. Valko	1	349
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	721
How do I allow data entry to one column only? Carmen	by Eduardo	2	835
show or Hide cell comment when mouse hovers in Excel? Abi	by Rick Rothstein	1	1,012
Extracting a month name forom a date Finance Guru	by Rick Rothstein	5	1,494
DATA SUMMARY M.GONZALEZ[_2_]	by Eduardo	1	465
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,955
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	372
RANDBETWEEN problems plb	by RagDyeR	7	649
Complex sum required N Drinkwater	by RagDyeR	3	347
OFFSET function Lynda	by Roger Govier[_3_]	3	411
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	362
macro Protection Warm	by Jacob Skaria	1	333
Automating change via popup to a column of numbers Colin Hayes	by Colin Hayes	0	371
How to delete duplicates and also count them Eddie	by Eddie	4	4,913
IF function feausij	by Eduardo	7	403
i want to automatically save the data after every 2 mins in excel gunjan.chowdhri	by Jacob Skaria	2	531
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	465
AVERAGEIF problem TPaton	by Roger Govier[_3_]	3	782
trouble with Names on multiple sheets [email protected]	by OssieMac	1	401
Insert a new line, without destroying the consistency of the formu HPH	by HPH	6	1,179
Validation List Question, Text in Cell DIffers to that Selected BaggieDan	by Roger Govier[_3_]	3	470
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	781
INDEX - MATCH - OFFSET By Reference Bam	by Bam	2	840
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	352
Computing the item age AG[_3_]	by AG[_3_]	3	435
Separating text in one cell into two cells France	by Gord Dibben	2	483
Sumif Function canuck_heat	by Ragdyer	2	563
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,356
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	595
Text File Question UGScott	by Harlan Grove[_2_]	5	476
Logical operators not working with text??? Slinky[_2_]	by Slinky[_2_]	3	3,314
direction of delta using arrows casey	by Stephen Bye[_2_]	3	1,109
Tricky problem - auto-sorting without VBA philkime	by philkime	7	4,160
excel 2007 Bob M	by Jacob Skaria	1	333
IF function Irish	by T. Valko	5	409
If...rows and columns something68	by something68	3	373
Zero in cell where it is linked to a blank cell - repost texansgal	by Jacob Skaria	4	479
display filter selection from menu labgeek	by labgeek	2	739
Calculating someone's age at a given date Deb	by Sean Timmons	12	979
Filter Blue	by Jarek Kujawa[_2_]	2	382
"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	392
Help for Date counting. shital shah	by Jimmystix	1	363
if function LCCHELP	by JoeU2004	8	381
Problems Kay	by David Biddulph[_2_]	7	395
Adding problem in excel EggMan903	by T. Valko	6	1,058
Last 7 days bbal20	by bbal20	9	845
Unable To Read File - Sumproduct error Fluke[_2_]	by Dave Peterson	9	914