Excel Worksheet Functions - Page 377

Thread / Thread Starter	Last Post	Replies	Views
Single Quote use in cell reference Eric	by Reitanos	1	1,778
How do I move numbers with formulas behind to new workbook? Linda	by John Bundy	1	474
QP formulas not working in Excel Westech	by Westech	2	856
some worksheet columns don't update formula calculations Vic Abrahamian	by Vic Abrahamian	0	637
Accidental Currency Converted [email protected]	by [email protected]	0	401
vlookup on multiple values samuel	by Teethless mama	3	670
Duplicate entries in single column w/o sorting? scoldiron	by Bernard Liengme	2	507
Goal Seek Goes Haywire Dkline	by Dkline	4	499
Getting Count Formula Working if Column has both number and text Nikhil Joshi	by Peo Sjoblom	1	481
If results for multiple cells gfoster	by Teethless mama	1	359
Function Equivalent need ytayta555	by ytayta555	6	567
can excel alert you when a number is less than a particular value Megglesface	by Megglesface	7	1,085
SUMPRODUCT or another function??? Paul Groth	by Teethless mama	2	400
Percentages and whole numbers Treiva	by Gaurav[_3_]	1	584
Referen to cell on other sheet not working Pieter[_4_]	by Pieter[_4_]	2	372
Need formula like ISBLANK that returns "no value" even if there is aformula in referenced cell insitedge	by Pete_UK	1	1,644
Advanced Criterea in Formulas mpbhammer	by Bob Phillips	2	416
Calulate a value when date is in a range. [email protected]	by Dave	1	384
Function to insert current filename into worksheet? Ginko	by Dave Peterson	2	1,044
Conditonal Formatting TSK	by Max	2	434
How to set Auto-Change letters into Uppercases for Data entry in E Cpviv	by Mike H	3	795
copy text out of a range of cells Mark B	by Pete_UK	3	900
Run a macro when clicking a cell. [email protected]	by [email protected]	9	619
DATE function Learn-more	by Learn-more	5	399
How to protect cell with formula from being entering info TSK	by Arvi Laanemets	1	447
I have 2 items that are selectable in 36 ways; How do I sort 1 & 2 cwhisperer	by cwhisperer	0	335
Offset/match returns #value error Geoff	by Geoff	8	2,863
Copy & Pasting Drop Down Boxes Todd	by Todd	0	688
How to average numbers greater than zero in a pivot table Ken	by Ken	0	627
HOW DO I GET A CELL TO RETURN A NEIGHBORING CELL'S VALUE des-sa	by des-sa[_2_]	6	2,900
Alternative formula for getting totals Victor	by Victor	0	493
Look up duplicate amounts with unique batch numbers JHL	by Dave	3	440
Count for multiple text criterias saneedshelp	by saneedshelp	5	424
Create totals for close-matching names? t_perkins	by Don Guillett	7	522
H or VLookup Help Mark B	by MyVeryOwnSelf	1	355
drop down menus and corresponding hyperlinks Kimmie40	by Pete_UK	1	329
COUNTIF counting incorrectly Dave	by T. Valko	9	690
Formatting cell to show current Quarter S trainer	by S trainer	2	1,046
Using Sum If and an array? Jonathan	by Zack Barresse	5	585
Formula help balterson	by Gord Dibben	3	416
VLOOKUP, but different Cooz	by Herbert Seidenberg	1	324
Sum of Vlookup Patrick C. Simonds	by Gaurav[_3_]	3	648
cell extract Igneshwara reddy[_2_]	by Igneshwara reddy[_2_]	2	429
Fill colors and high contrast Philippeam	by Gord Dibben	4	1,813
Can you create a new array based on the value in a column? Jeff	by Spiky	3	457
Concatenate numbers Colin G	by Ron Rosenfeld	7	371
How to supress #N/A in an array formula. Phil	by Shane Devenshire	5	1,043
Counting Dates Mark Solesbury[_2_]	by Shane Devenshire	3	379
Vacation Planer Erin @ Main Event Caterers	by Cimjet[_2_]	2	568
Sumif data from multiple columns Nick	by T. Valko	4	705
Percentage of the occurance of a word in a date range Art-SNL	by T. Valko	8	540
needing to calculate entries, but no the spaces in some cells joflo65	by joflo65	2	412
Macro To Remove Subtotals from ALL Worksheets vidguru	by vidguru	2	4,004
IF Statement not working Barrett M	by Barrett M[_2_]	8	530
Upgrade from 2002 to 2007 W Wolfe[_2_]	by W Wolfe	4	868
Finding entries across columns bollard	by Max	2	431
Different Language Settings... Trevor Williams	by Trevor Williams	5	512
Need VBA script to auto-insert value upon row insert Phil	by Otto Moehrbach[_2_]	4	996
Move to next line bgkgmg	by Max	1	643
cant insert column get error message sheppey	by Ken Johnson	2	415
CountIF Help Glenn	by Glenn	3	389
What is the formula to calculate electricity consumption TSK	by David Biddulph[_2_]	4	2,168
count months between years dqm	by David Biddulph[_2_]	3	512
Sumif multiple criteria? Alan	by Bob Phillips	3	402
2 Macros running on same module Travis	by Travis	2	471
Pivot table - display all labels (i.e: do not summarise) how to? Martin	by Dave Peterson	1	540
help with functions angel	by Arvi Laanemets	3	357
SUMIF with text bgkgmg	by Pete_UK	1	564
Duplicating/Mirror Data into another worksheet within same workboo TJ	by Pete_UK	1	6,036
Meaning of $ in function or formula Kula	by David Biddulph[_2_]	2	581
"Labels as Names" stopped working [email protected]	by [email protected]	2	523
Tracking cursor location JonStein	by Mike	1	839
compare two lists lark	by Dave	3	603
how do I show the arrow for dropdown menu in excel? dorinc29	by Max	1	1,821
How to set macro to Paste Special Value to next empty column [email protected]	by Max	9	1,422