Excel Worksheet Functions - Page 377

Thread / Thread Starter	Last Post	Replies	Views
Single Quote use in cell reference Eric	by Reitanos	1	1,764
How do I move numbers with formulas behind to new workbook? Linda	by John Bundy	1	458
QP formulas not working in Excel Westech	by Westech	2	840
some worksheet columns don't update formula calculations Vic Abrahamian	by Vic Abrahamian	0	622
Accidental Currency Converted [email protected]	by [email protected]	0	396
vlookup on multiple values samuel	by Teethless mama	3	659
Duplicate entries in single column w/o sorting? scoldiron	by Bernard Liengme	2	496
Goal Seek Goes Haywire Dkline	by Dkline	4	497
Getting Count Formula Working if Column has both number and text Nikhil Joshi	by Peo Sjoblom	1	479
If results for multiple cells gfoster	by Teethless mama	1	347
Function Equivalent need ytayta555	by ytayta555	6	565
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	388
Percentages and whole numbers Treiva	by Gaurav[_3_]	1	581
Referen to cell on other sheet not working Pieter[_4_]	by Pieter[_4_]	2	368
Need formula like ISBLANK that returns "no value" even if there is aformula in referenced cell insitedge	by Pete_UK	1	1,632
Advanced Criterea in Formulas mpbhammer	by Bob Phillips	2	405
Calulate a value when date is in a range. [email protected]	by Dave	1	367
Function to insert current filename into worksheet? Ginko	by Dave Peterson	2	1,025
Conditonal Formatting TSK	by Max	2	422
How to set Auto-Change letters into Uppercases for Data entry in E Cpviv	by Mike H	3	785
copy text out of a range of cells Mark B	by Pete_UK	3	884
Run a macro when clicking a cell. [email protected]	by [email protected]	9	606
DATE function Learn-more	by Learn-more	5	387
How to protect cell with formula from being entering info TSK	by Arvi Laanemets	1	444
I have 2 items that are selectable in 36 ways; How do I sort 1 & 2 cwhisperer	by cwhisperer	0	321
Offset/match returns #value error Geoff	by Geoff	8	2,852
Copy & Pasting Drop Down Boxes Todd	by Todd	0	681
How to average numbers greater than zero in a pivot table Ken	by Ken	0	613
HOW DO I GET A CELL TO RETURN A NEIGHBORING CELL'S VALUE des-sa	by des-sa[_2_]	6	2,893
Alternative formula for getting totals Victor	by Victor	0	483
Look up duplicate amounts with unique batch numbers JHL	by Dave	3	426
Count for multiple text criterias saneedshelp	by saneedshelp	5	423
Create totals for close-matching names? t_perkins	by Don Guillett	7	509
H or VLookup Help Mark B	by MyVeryOwnSelf	1	352
drop down menus and corresponding hyperlinks Kimmie40	by Pete_UK	1	314
COUNTIF counting incorrectly Dave	by T. Valko	9	680
Formatting cell to show current Quarter S trainer	by S trainer	2	1,043
Using Sum If and an array? Jonathan	by Zack Barresse	5	575
Formula help balterson	by Gord Dibben	3	415
VLOOKUP, but different Cooz	by Herbert Seidenberg	1	306
Sum of Vlookup Patrick C. Simonds	by Gaurav[_3_]	3	634
cell extract Igneshwara reddy[_2_]	by Igneshwara reddy[_2_]	2	420
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	445
Concatenate numbers Colin G	by Ron Rosenfeld	7	360
How to supress #N/A in an array formula. Phil	by Shane Devenshire	5	1,030
Counting Dates Mark Solesbury[_2_]	by Shane Devenshire	3	370
Vacation Planer Erin @ Main Event Caterers	by Cimjet[_2_]	2	564
Sumif data from multiple columns Nick	by T. Valko	4	698
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	402
Macro To Remove Subtotals from ALL Worksheets vidguru	by vidguru	2	4,003
IF Statement not working Barrett M	by Barrett M[_2_]	8	522
Upgrade from 2002 to 2007 W Wolfe[_2_]	by W Wolfe	4	858
Finding entries across columns bollard	by Max	2	418
Different Language Settings... Trevor Williams	by Trevor Williams	5	497
Need VBA script to auto-insert value upon row insert Phil	by Otto Moehrbach[_2_]	4	993
Move to next line bgkgmg	by Max	1	631
cant insert column get error message sheppey	by Ken Johnson	2	402
CountIF Help Glenn	by Glenn	3	377
What is the formula to calculate electricity consumption TSK	by David Biddulph[_2_]	4	2,167
count months between years dqm	by David Biddulph[_2_]	3	507
Sumif multiple criteria? Alan	by Bob Phillips	3	392
2 Macros running on same module Travis	by Travis	2	462
Pivot table - display all labels (i.e: do not summarise) how to? Martin	by Dave Peterson	1	529
help with functions angel	by Arvi Laanemets	3	345
SUMIF with text bgkgmg	by Pete_UK	1	555
Duplicating/Mirror Data into another worksheet within same workboo TJ	by Pete_UK	1	6,021
Meaning of $ in function or formula Kula	by David Biddulph[_2_]	2	573
"Labels as Names" stopped working [email protected]	by [email protected]	2	514
Tracking cursor location JonStein	by Mike	1	826
compare two lists lark	by Dave	3	594
how do I show the arrow for dropdown menu in excel? dorinc29	by Max	1	1,812
How to set macro to Paste Special Value to next empty column [email protected]	by Max	9	1,405