Excel Worksheet Functions - Page 807

Thread / Thread Starter	Last Post	Replies	Views
Sumif data from multiple columns Nick	by T. Valko	4	684
Vacation Planer Erin @ Main Event Caterers	by Cimjet[_2_]	2	551
Counting Dates Mark Solesbury[_2_]	by Shane Devenshire	3	364
How to supress #N/A in an array formula. Phil	by Shane Devenshire	5	1,020
Concatenate numbers Colin G	by Ron Rosenfeld	7	353
Can you create a new array based on the value in a column? Jeff	by Spiky	3	432
Fill colors and high contrast Philippeam	by Gord Dibben	4	1,798
cell extract Igneshwara reddy[_2_]	by Igneshwara reddy[_2_]	2	415
Sum of Vlookup Patrick C. Simonds	by Gaurav[_3_]	3	629
VLOOKUP, but different Cooz	by Herbert Seidenberg	1	301
Formula help balterson	by Gord Dibben	3	404
Using Sum If and an array? Jonathan	by Zack Barresse	5	559
Formatting cell to show current Quarter S trainer	by S trainer	2	1,032
COUNTIF counting incorrectly Dave	by T. Valko	9	672
drop down menus and corresponding hyperlinks Kimmie40	by Pete_UK	1	303
H or VLookup Help Mark B	by MyVeryOwnSelf	1	331
Create totals for close-matching names? t_perkins	by Don Guillett	7	477
Count for multiple text criterias saneedshelp	by saneedshelp	5	411
Look up duplicate amounts with unique batch numbers JHL	by Dave	3	406
Alternative formula for getting totals Victor	by Victor	0	474
HOW DO I GET A CELL TO RETURN A NEIGHBORING CELL'S VALUE des-sa	by des-sa[_2_]	6	2,873
How to average numbers greater than zero in a pivot table Ken	by Ken	0	591
Copy & Pasting Drop Down Boxes Todd	by Todd	0	669
Offset/match returns #value error Geoff	by Geoff	8	2,808
I have 2 items that are selectable in 36 ways; How do I sort 1 & 2 cwhisperer	by cwhisperer	0	304
How to protect cell with formula from being entering info TSK	by Arvi Laanemets	1	429
DATE function Learn-more	by Learn-more	5	385
Run a macro when clicking a cell. [email protected]	by [email protected]	9	590
copy text out of a range of cells Mark B	by Pete_UK	3	870
How to set Auto-Change letters into Uppercases for Data entry in E Cpviv	by Mike H	3	771
Conditonal Formatting TSK	by Max	2	404
Function to insert current filename into worksheet? Ginko	by Dave Peterson	2	1,003
Calulate a value when date is in a range. [email protected]	by Dave	1	351
Advanced Criterea in Formulas mpbhammer	by Bob Phillips	2	394
Need formula like ISBLANK that returns "no value" even if there is aformula in referenced cell insitedge	by Pete_UK	1	1,608
Referen to cell on other sheet not working Pieter[_4_]	by Pieter[_4_]	2	356
Percentages and whole numbers Treiva	by Gaurav[_3_]	1	565
SUMPRODUCT or another function??? Paul Groth	by Teethless mama	2	378
can excel alert you when a number is less than a particular value Megglesface	by Megglesface	7	1,079
Function Equivalent need ytayta555	by ytayta555	6	540
If results for multiple cells gfoster	by Teethless mama	1	336
Getting Count Formula Working if Column has both number and text Nikhil Joshi	by Peo Sjoblom	1	463
Goal Seek Goes Haywire Dkline	by Dkline	4	490
Duplicate entries in single column w/o sorting? scoldiron	by Bernard Liengme	2	483
vlookup on multiple values samuel	by Teethless mama	3	639
Accidental Currency Converted [email protected]	by [email protected]	0	373
some worksheet columns don't update formula calculations Vic Abrahamian	by Vic Abrahamian	0	600
QP formulas not working in Excel Westech	by Westech	2	827
How do I move numbers with formulas behind to new workbook? Linda	by John Bundy	1	452
Single Quote use in cell reference Eric	by Reitanos	1	1,745
help with formula - Soth	by John Bundy	1	390
Condiitonal formatting-colored cell Diane	by Diane	6	313
Excel 2007 nrodADAA	by nrodADAA	4	327
conditional formatting KSP	by akphidelt	1	444
Aging reports LBoyd	by Fred Smith[_4_]	2	452
Show dates based on criteria slaga	by T. Valko	3	419
Formula Halp - If or Lookup Diane	by Diane	5	354
Sum If Help Maggie0507	by Maggie0507	5	353
SUMIF Criteria JC	by David Biddulph[_2_]	5	354
Formula problem Joyce	by Gaurav[_3_]	2	442
If Question carl	by Gary''s Student	3	437
text for numbers bgkgmg	by Lars-Åke Aspelin[_2_]	1	392
Need help with formula Ed B.	by Susan	2	347
Calculate totals for a range of names t_perkins[_2_]	by [email protected]	10	963
Formula problem GVegas	by Teethless mama	2	438
Formula To Keep Certain Cells Blank Dave	by David Biddulph[_2_]	7	477
Reference sheets KKcags	by Marcelo	1	390
lookup/match mult values Keep It Simple Stupid	by T. Valko	3	340
new cell for each day Libby	by Dave Peterson	5	363
new cell each day Libby	by David Biddulph[_2_]	8	402
Making formula results not visible in a cell mp smith	by T. Valko	2	423
Two-variable Data Table - Problem with result/output Chanpheng Botham	by akphidelt	1	1,348
IF Function with ISBLANK Steve M[_3_]	by Steve M[_3_]	10	1,468
using multiple sheets from a workbook in a formula Megglesface	by Gord Dibben	4	434
gathering multiple spreadsheets into one Mark B	by Mark B	2	314