Excel Worksheet Functions - Page 179

Thread / Thread Starter	Last Post	Replies	Views
Excel doing strange things Duncan Brown	by smartin	1	559
Count number of occurences in a list Lucas Reece	by T. Valko	12	836
open and close files Chi	by Chi	2	361
add multiple numbers in one cell with those numbers remaining visi TD	by Harlan Grove[_2_]	7	2,341
Using greater than and lesser than formula JGW	by JoeU2004	2	1,340
AutoFit Row Height - How to use so there is no space after text? Jennifer	by Jennifer	0	778
auto complete KCegbe	by Mike H	1	455
unique values among duplicates without considering specific words Simna	by T. Valko	1	334
easy formula question j lunis	by T. Valko	2	385
Negative Dates and/or Times watermt	by watermt	3	403
lookup cell reference and copy contents and comment from a range GarySW	by GarySW	0	706
How do I allow data entry to one column only? Carmen	by Eduardo	2	816
show or Hide cell comment when mouse hovers in Excel? Abi	by Rick Rothstein	1	989
Extracting a month name forom a date Finance Guru	by Rick Rothstein	5	1,487
DATA SUMMARY M.GONZALEZ[_2_]	by Eduardo	1	457
Max Price and Min Price paid for an item F. GOMEZ	by Rick Rothstein	1	488
lookup to bring back multiple values zakfalls	by T. Valko	3	1,922
Conditional Formatting SharonR	by Tom Hutchins	4	389
keeping formula the same in a workbook when adding a row to one sh jcrowe	by Eduardo	1	558
How to remove double data? marycler	by Eduardo	2	334
SUMIFS Issue CFitz	by Bob Phillips[_3_]	5	364
RANDBETWEEN problems plb	by RagDyeR	7	623
Complex sum required N Drinkwater	by RagDyeR	3	340
OFFSET function Lynda	by Roger Govier[_3_]	3	405
way to view excel workbook only by password protection S.REYNA	by Jacob Skaria	1	419
Retrieve Data to Pivot Table "On Demand" Steve Haack	by Roger Govier[_3_]	1	354
macro Protection Warm	by Jacob Skaria	1	331
Automating change via popup to a column of numbers Colin Hayes	by Colin Hayes	0	361
How to delete duplicates and also count them Eddie	by Eddie	4	4,899
IF function feausij	by Eduardo	7	399
i want to automatically save the data after every 2 mins in excel gunjan.chowdhri	by Jacob Skaria	2	520
Summary sheet auto update SUMMARY SHEET AUTO UPDATE FROM WORKBOOKS	by SUMMARY SHEET AUTO UPDATE FROM WORKBOOKS	0	718
Why copying the sheet to diff file changes font color? Fesco	by zakfalls	1	578
Sum based on date greater than and a specific status adding to a t SusanG	by SusanG	4	453
AVERAGEIF problem TPaton	by Roger Govier[_3_]	3	774
trouble with Names on multiple sheets [email protected]	by OssieMac	1	394
Insert a new line, without destroying the consistency of the formu HPH	by HPH	6	1,173
Validation List Question, Text in Cell DIffers to that Selected BaggieDan	by Roger Govier[_3_]	3	463
search through dates smudgedwhiteink	by Simon Lloyd[_249_]	1	392
How to populate a cell based on font color/threshold ascottbag-hcm	by Joerg Mochikun	1	766
INDEX - MATCH - OFFSET By Reference Bam	by Bam	2	807
Count cells with a date falling within a 30 day period. Rob	by Jacob Skaria	2	1,321
Check result if same as other cell on row art	by T. Valko	1	304
Calculating Link[_2_]	by JoeU2004	2	337
Computing the item age AG[_3_]	by AG[_3_]	3	423
Separating text in one cell into two cells France	by Gord Dibben	2	475
Sumif Function canuck_heat	by Ragdyer	2	555
Using more than one list in a drop-down Des_2001	by Gord Dibben	2	356
How do I make coloured drop down lists in Excel? Ã‰annaD	by Gord Dibben	3	2,344
How to change the number of rows in a worksheet. Bloo	by Gord Dibben	3	405
How do I update all worksheets at startup? kit493	by Gord Dibben	2	445
Pivot Table Question Steve Haack	by Steve Haack	0	354
Error in VLOOKUP Kris	by Harlan Grove[_2_]	4	587
Text File Question UGScott	by Harlan Grove[_2_]	5	465
Logical operators not working with text??? Slinky[_2_]	by Slinky[_2_]	3	3,295
direction of delta using arrows casey	by Stephen Bye[_2_]	3	1,092
Tricky problem - auto-sorting without VBA philkime	by philkime	7	4,138
excel 2007 Bob M	by Jacob Skaria	1	325
IF function Irish	by T. Valko	5	396
If...rows and columns something68	by something68	3	357
Zero in cell where it is linked to a blank cell - repost texansgal	by Jacob Skaria	4	465
display filter selection from menu labgeek	by labgeek	2	731
Calculating someone's age at a given date Deb	by Sean Timmons	12	961
Filter Blue	by Jarek Kujawa[_2_]	2	379
"Remembering" Cell Values Harlan	by JLatham	4	398
Aging by netting negatives in other age buckets for the customer Maniv	by Sean Timmons	3	1,717
TIMESHEET Link[_2_]	by Bam	1	391
how do I use array references in VLOOKUP()? tsimkus	by Lori	2	329
Excell formula required. If a^b=C....... a = ? Rod neale	by Dave Peterson	3	376
Help for Date counting. shital shah	by Jimmystix	1	358
if function LCCHELP	by JoeU2004	8	372
Problems Kay	by David Biddulph[_2_]	7	386
Adding problem in excel EggMan903	by T. Valko	6	1,043
Last 7 days bbal20	by bbal20	9	839
Unable To Read File - Sumproduct error Fluke[_2_]	by Dave Peterson	9	906