Excel Worksheet Functions - Page 176

Thread / Thread Starter	Last Post	Replies	Views
Sum/multiply function Ryan Gerry	by RagDyer	5	657
What Formula to use? Paul Chung	by Paul Chung	4	436
filter text willemeulen[_26_]	by Rick Rothstein	2	370
how do calculate elasped time Nolan Holloway	by Luke M	3	435
struggling with if logical test function neuromoe	by Shane Devenshire[_2_]	2	469
Vlookup to include conditional formats Trish	by Shane Devenshire[_2_]	3	807
AUTOMATICALLY ADJUST COLUMN WIDTHS TO CONTENT DebC	by Rich/rerat	3	1,652
Index match to return all values SauQ	by Bernd P	13	2,983
Macro to HIDE blank rows JForsyth	by JForsyth	6	2,168
Worksheet tabs to turn colors against criteria Neall	by Neall	3	687
VBA for form check boxes dicko1	by [email protected]	4	1,103
Count pricing associated to year Neall	by Jacob Skaria	8	443
Question on looking up data Nick H[_2_]	by Nick H[_2_]	2	331
Using Index and Match Formula Brett[_2_]	by Brett[_2_]	2	570
creating a survey and gathering the data Maddie1020	by fake_be	3	602
Give a cell a name that is variable Neall	by Neall	0	360
Pivot - can we set criteria? Christine[_3_]	by Dave Peterson	1	309
reference table automation Kerry Purdy	by Kerry Purdy	0	306
Convert the series to a formula Humayaun	by Jacob Skaria	1	343
Advanced Filter, Copy to another location Tina	by Roger Govier[_3_]	6	592
Integrating Networkdays() Into Formula Rob	by Pecoflyer[_340_]	1	365
Finding muliple duplicate records in spreadsheet ShagNasty	by Bernd P	4	645
text alignment settings dude_down_under_1	by Rick Rothstein	2	517
Fill Series Humayaun	by Jacob Skaria	1	541
Need to have an index sheet but all other sheets should be hidden Madhu	by Jacob Skaria	1	417
Formula Link[_2_]	by T. Valko	4	360
SUMIF & INDIRECT Returns #Value! Christi	by T. Valko	3	553
VBA code to count rows ub	by Ashish Mathur[_2_]	5	1,538
Pivot tables - new columns SB Lee[_2_]	by Ashish Mathur[_2_]	5	387
Question on Named range with formula DocBrown	by DocBrown	2	385
Averaging question [email protected]	by Shane Devenshire[_2_]	2	340
adding cells then sorting Helen B[_2_]	by smartin	1	393
Solver or Other? Stan	by Dana DeLouis	5	697
highlight dependent cells Lindsay	by T. Valko	2	1,049
Vlookup & 2 variables Marti	by T. Valko	3	1,418
Help With Sum Chris	by Marcelo	2	423
Using worksheet template create tabs against customer list Neall	by Neall	0	967
Conditional Formatting for Changing a Formula HeatherT	by HeatherT	3	450
IF formula and date fields SCP1	by T. Valko	2	837
Linked spreadsheets created in 2003 but not working in 2007 Steve	by Steve	2	576
Lookup question and iferror compatibility Ryan Gerry	by T. Valko	7	923
I am trying to set up a formula to show a subsequent IP Address. jewell	by Shane Devenshire[_2_]	3	330
Highlight rows based on '1' or blank in all columns on a row Scott Lindstrom	by Scott Lindstrom	3	562
Search row of numbers, find highest value. Ice Bear	by Ice Bear	2	892
Excel invoke REST service function with Xpath fn parse result! Rand0m1y	by Rand0m1y	0	1,194
Vlookup not calcuting correctly akemeny	by Pete_UK	3	361
FIle link Shahzad	by Shahzad	0	344
auto save function N Ravinder	by Dave Peterson	2	433
cummulative ditribution functions curious	by curious	0	343
CountIF and Sum in one formula? Scott A[_2_]	by Ashish Mathur[_2_]	8	2,094
SumIF with condition and exception Scott A[_2_]	by Scott A[_2_]	3	810
Cell locking based on domain user Wolter	by Wolter	6	638
indirect with wildcards sam	by sam	3	2,680
Subtotals in very large datasets heather	by Shane Devenshire[_2_]	5	1,891
Calculating number of periods Ari	by Ari	2	1,001
zero denominator Amanda	by Shane Devenshire[_2_]	4	450
VLOOKUP and SUMPRODUCT PAL	by Teethless mama	3	907
Sheet Referencing - autofilling sheet names Pat	by Ashish Mathur[_2_]	2	610
Average except for something lower... Clubber2010	by Ashish Mathur[_2_]	3	360
consolidating or totaling info M.GONZALEZ[_2_]	by Ashish Mathur[_2_]	2	435
recognizing words as numbers...for a formula CONFUSED	by Ashish Mathur[_2_]	2	775
How to VLOOKUP multiple sheets and each sheet have 65536 rows? nginhong	by nginhong	9	1,040
SUM key LAM	by Shane Devenshire[_2_]	1	425
Excel 2003 - Lookup type of question Fran	by Fran	3	463
Copy cell value into blank cells below (full worksheet) SimmoG	by Fesco	4	2,599
indirect / vlookup help Greyling	by Dave Peterson	1	499
Conditional MAX IanC[_2_]	by T. Valko	5	626
Counting patient check in Meebers[_2_]	by Meebers[_2_]	13	863
Calculate hours of work substracting non-working time [email protected]	by [email protected]	2	713
Check Boxes / Collapsing dicko1	by Stephen Bye[_2_]	4	400
Mulitiple Count of occurrences in different columns Ant	by Per Jessen	3	437
Mapping distances with postal codes in an excel spreadsheet [email protected]	by [email protected]	0	489
How to prevent each item date from changing after "TODAY" formula Marvin	by Luke M	2	1,223
Click on cell (or "button"), takes you to appropriate information ahwelch	by Dave Peterson	1	480
Matching data kristy_6278	by kristy_6278	5	437