Excel Worksheet Functions - Page 179

Thread / Thread Starter	Last Post	Replies	Views
Excel doing strange things Duncan Brown	by smartin	1	585
Count number of occurences in a list Lucas Reece	by T. Valko	12	857
open and close files Chi	by Chi	2	377
add multiple numbers in one cell with those numbers remaining visi TD	by Harlan Grove[_2_]	7	2,376
Using greater than and lesser than formula JGW	by JoeU2004	2	1,369
AutoFit Row Height - How to use so there is no space after text? Jennifer	by Jennifer	0	801
auto complete KCegbe	by Mike H	1	480
unique values among duplicates without considering specific words Simna	by T. Valko	1	363
easy formula question j lunis	by T. Valko	2	399
Negative Dates and/or Times watermt	by watermt	3	418
lookup cell reference and copy contents and comment from a range GarySW	by GarySW	0	730
How do I allow data entry to one column only? Carmen	by Eduardo	2	849
show or Hide cell comment when mouse hovers in Excel? Abi	by Rick Rothstein	1	1,024
Extracting a month name forom a date Finance Guru	by Rick Rothstein	5	1,504
DATA SUMMARY M.GONZALEZ[_2_]	by Eduardo	1	475
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,968
Conditional Formatting SharonR	by Tom Hutchins	4	410
keeping formula the same in a workbook when adding a row to one sh jcrowe	by Eduardo	1	575
How to remove double data? marycler	by Eduardo	2	354
SUMIFS Issue CFitz	by Bob Phillips[_3_]	5	379
RANDBETWEEN problems plb	by RagDyeR	7	658
Complex sum required N Drinkwater	by RagDyeR	3	355
OFFSET function Lynda	by Roger Govier[_3_]	3	423
way to view excel workbook only by password protection S.REYNA	by Jacob Skaria	1	450
Retrieve Data to Pivot Table "On Demand" Steve Haack	by Roger Govier[_3_]	1	375
macro Protection Warm	by Jacob Skaria	1	343
Automating change via popup to a column of numbers Colin Hayes	by Colin Hayes	0	382
How to delete duplicates and also count them Eddie	by Eddie	4	4,922
IF function feausij	by Eduardo	7	413
i want to automatically save the data after every 2 mins in excel gunjan.chowdhri	by Jacob Skaria	2	543
Summary sheet auto update SUMMARY SHEET AUTO UPDATE FROM WORKBOOKS	by SUMMARY SHEET AUTO UPDATE FROM WORKBOOKS	0	731
Why copying the sheet to diff file changes font color? Fesco	by zakfalls	1	596
Sum based on date greater than and a specific status adding to a t SusanG	by SusanG	4	477
AVERAGEIF problem TPaton	by Roger Govier[_3_]	3	790
trouble with Names on multiple sheets [email protected]	by OssieMac	1	412
Insert a new line, without destroying the consistency of the formu HPH	by HPH	6	1,191
Validation List Question, Text in Cell DIffers to that Selected BaggieDan	by Roger Govier[_3_]	3	482
search through dates smudgedwhiteink	by Simon Lloyd[_249_]	1	413
How to populate a cell based on font color/threshold ascottbag-hcm	by Joerg Mochikun	1	792
INDEX - MATCH - OFFSET By Reference Bam	by Bam	2	853
Count cells with a date falling within a 30 day period. Rob	by Jacob Skaria	2	1,339
Check result if same as other cell on row art	by T. Valko	1	325
Calculating Link[_2_]	by JoeU2004	2	364
Computing the item age AG[_3_]	by AG[_3_]	3	447
Separating text in one cell into two cells France	by Gord Dibben	2	495
Sumif Function canuck_heat	by Ragdyer	2	569
Using more than one list in a drop-down Des_2001	by Gord Dibben	2	381
How do I make coloured drop down lists in Excel? Ã‰annaD	by Gord Dibben	3	2,367
How to change the number of rows in a worksheet. Bloo	by Gord Dibben	3	429
How do I update all worksheets at startup? kit493	by Gord Dibben	2	449
Pivot Table Question Steve Haack	by Steve Haack	0	371
Error in VLOOKUP Kris	by Harlan Grove[_2_]	4	602
Text File Question UGScott	by Harlan Grove[_2_]	5	488
Logical operators not working with text??? Slinky[_2_]	by Slinky[_2_]	3	3,326
direction of delta using arrows casey	by Stephen Bye[_2_]	3	1,114
Tricky problem - auto-sorting without VBA philkime	by philkime	7	4,160
excel 2007 Bob M	by Jacob Skaria	1	343
IF function Irish	by T. Valko	5	424
If...rows and columns something68	by something68	3	384
Zero in cell where it is linked to a blank cell - repost texansgal	by Jacob Skaria	4	491
display filter selection from menu labgeek	by labgeek	2	752
Calculating someone's age at a given date Deb	by Sean Timmons	12	990
Filter Blue	by Jarek Kujawa[_2_]	2	393
"Remembering" Cell Values Harlan	by JLatham	4	416
Aging by netting negatives in other age buckets for the customer Maniv	by Sean Timmons	3	1,747
TIMESHEET Link[_2_]	by Bam	1	405
how do I use array references in VLOOKUP()? tsimkus	by Lori	2	345
Excell formula required. If a^b=C....... a = ? Rod neale	by Dave Peterson	3	404
Help for Date counting. shital shah	by Jimmystix	1	376
if function LCCHELP	by JoeU2004	8	394
Problems Kay	by David Biddulph[_2_]	7	407
Adding problem in excel EggMan903	by T. Valko	6	1,067
Last 7 days bbal20	by bbal20	9	846
Unable To Read File - Sumproduct error Fluke[_2_]	by Dave Peterson	9	927