Excel Worksheet Functions - Page 377

Thread / Thread Starter	Last Post	Replies	Views
Single Quote use in cell reference Eric	by Reitanos	1	1,742
How do I move numbers with formulas behind to new workbook? Linda	by John Bundy	1	450
QP formulas not working in Excel Westech	by Westech	2	824
some worksheet columns don't update formula calculations Vic Abrahamian	by Vic Abrahamian	0	598
Accidental Currency Converted [email protected]	by [email protected]	0	371
vlookup on multiple values samuel	by Teethless mama	3	635
Duplicate entries in single column w/o sorting? scoldiron	by Bernard Liengme	2	483
Goal Seek Goes Haywire Dkline	by Dkline	4	486
Getting Count Formula Working if Column has both number and text Nikhil Joshi	by Peo Sjoblom	1	461
If results for multiple cells gfoster	by Teethless mama	1	335
Function Equivalent need ytayta555	by ytayta555	6	539
can excel alert you when a number is less than a particular value Megglesface	by Megglesface	7	1,077
SUMPRODUCT or another function??? Paul Groth	by Teethless mama	2	374
Percentages and whole numbers Treiva	by Gaurav[_3_]	1	561
Referen to cell on other sheet not working Pieter[_4_]	by Pieter[_4_]	2	356
Need formula like ISBLANK that returns "no value" even if there is aformula in referenced cell insitedge	by Pete_UK	1	1,606
Advanced Criterea in Formulas mpbhammer	by Bob Phillips	2	394
Calulate a value when date is in a range. [email protected]	by Dave	1	351
Function to insert current filename into worksheet? Ginko	by Dave Peterson	2	1,001
Conditonal Formatting TSK	by Max	2	404
How to set Auto-Change letters into Uppercases for Data entry in E Cpviv	by Mike H	3	769
copy text out of a range of cells Mark B	by Pete_UK	3	866
Run a macro when clicking a cell. [email protected]	by [email protected]	9	586
DATE function Learn-more	by Learn-more	5	385
How to protect cell with formula from being entering info TSK	by Arvi Laanemets	1	429
I have 2 items that are selectable in 36 ways; How do I sort 1 & 2 cwhisperer	by cwhisperer	0	304
Offset/match returns #value error Geoff	by Geoff	8	2,808
Copy & Pasting Drop Down Boxes Todd	by Todd	0	669
How to average numbers greater than zero in a pivot table Ken	by Ken	0	591
HOW DO I GET A CELL TO RETURN A NEIGHBORING CELL'S VALUE des-sa	by des-sa[_2_]	6	2,873
Alternative formula for getting totals Victor	by Victor	0	471
Look up duplicate amounts with unique batch numbers JHL	by Dave	3	404
Count for multiple text criterias saneedshelp	by saneedshelp	5	410
Create totals for close-matching names? t_perkins	by Don Guillett	7	476
H or VLookup Help Mark B	by MyVeryOwnSelf	1	327
drop down menus and corresponding hyperlinks Kimmie40	by Pete_UK	1	301
COUNTIF counting incorrectly Dave	by T. Valko	9	672
Formatting cell to show current Quarter S trainer	by S trainer	2	1,032
Using Sum If and an array? Jonathan	by Zack Barresse	5	557
Formula help balterson	by Gord Dibben	3	402
VLOOKUP, but different Cooz	by Herbert Seidenberg	1	297
Sum of Vlookup Patrick C. Simonds	by Gaurav[_3_]	3	627
cell extract Igneshwara reddy[_2_]	by Igneshwara reddy[_2_]	2	415
Fill colors and high contrast Philippeam	by Gord Dibben	4	1,798
Can you create a new array based on the value in a column? Jeff	by Spiky	3	432
Concatenate numbers Colin G	by Ron Rosenfeld	7	353
How to supress #N/A in an array formula. Phil	by Shane Devenshire	5	1,020
Counting Dates Mark Solesbury[_2_]	by Shane Devenshire	3	361
Vacation Planer Erin @ Main Event Caterers	by Cimjet[_2_]	2	547
Sumif data from multiple columns Nick	by T. Valko	4	680
Percentage of the occurance of a word in a date range Art-SNL	by T. Valko	8	526
needing to calculate entries, but no the spaces in some cells joflo65	by joflo65	2	399
Macro To Remove Subtotals from ALL Worksheets vidguru	by vidguru	2	3,974
IF Statement not working Barrett M	by Barrett M[_2_]	8	498
Upgrade from 2002 to 2007 W Wolfe[_2_]	by W Wolfe	4	840
Finding entries across columns bollard	by Max	2	405
Different Language Settings... Trevor Williams	by Trevor Williams	5	487
Need VBA script to auto-insert value upon row insert Phil	by Otto Moehrbach[_2_]	4	965
Move to next line bgkgmg	by Max	1	602
cant insert column get error message sheppey	by Ken Johnson	2	392
CountIF Help Glenn	by Glenn	3	360
What is the formula to calculate electricity consumption TSK	by David Biddulph[_2_]	4	2,147
count months between years dqm	by David Biddulph[_2_]	3	487
Sumif multiple criteria? Alan	by Bob Phillips	3	379
2 Macros running on same module Travis	by Travis	2	448
Pivot table - display all labels (i.e: do not summarise) how to? Martin	by Dave Peterson	1	520
help with functions angel	by Arvi Laanemets	3	332
SUMIF with text bgkgmg	by Pete_UK	1	542
Duplicating/Mirror Data into another worksheet within same workboo TJ	by Pete_UK	1	6,003
Meaning of $ in function or formula Kula	by David Biddulph[_2_]	2	562
"Labels as Names" stopped working [email protected]	by [email protected]	2	490
Tracking cursor location JonStein	by Mike	1	813
compare two lists lark	by Dave	3	585
how do I show the arrow for dropdown menu in excel? dorinc29	by Max	1	1,794
How to set macro to Paste Special Value to next empty column [email protected]	by Max	9	1,381