Excel Worksheet Functions - Page 176

Thread / Thread Starter	Last Post	Replies	Views
Sum/multiply function Ryan Gerry	by RagDyer	5	656
What Formula to use? Paul Chung	by Paul Chung	4	434
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	468
Vlookup to include conditional formats Trish	by Shane Devenshire[_2_]	3	777
AUTOMATICALLY ADJUST COLUMN WIDTHS TO CONTENT DebC	by Rich/rerat	3	1,646
Index match to return all values SauQ	by Bernd P	13	2,974
Macro to HIDE blank rows JForsyth	by JForsyth	6	2,168
Worksheet tabs to turn colors against criteria Neall	by Neall	3	686
VBA for form check boxes dicko1	by [email protected]	4	1,101
Count pricing associated to year Neall	by Jacob Skaria	8	441
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	560
creating a survey and gathering the data Maddie1020	by fake_be	3	601
Give a cell a name that is variable Neall	by Neall	0	360
Pivot - can we set criteria? Christine[_3_]	by Dave Peterson	1	306
reference table automation Kerry Purdy	by Kerry Purdy	0	304
Convert the series to a formula Humayaun	by Jacob Skaria	1	342
Advanced Filter, Copy to another location Tina	by Roger Govier[_3_]	6	592
Integrating Networkdays() Into Formula Rob	by Pecoflyer[_340_]	1	364
Finding muliple duplicate records in spreadsheet ShagNasty	by Bernd P	4	644
text alignment settings dude_down_under_1	by Rick Rothstein	2	514
Fill Series Humayaun	by Jacob Skaria	1	539
Need to have an index sheet but all other sheets should be hidden Madhu	by Jacob Skaria	1	414
Formula Link[_2_]	by T. Valko	4	360
SUMIF & INDIRECT Returns #Value! Christi	by T. Valko	3	548
VBA code to count rows ub	by Ashish Mathur[_2_]	5	1,537
Pivot tables - new columns SB Lee[_2_]	by Ashish Mathur[_2_]	5	382
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	687
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	422
Using worksheet template create tabs against customer list Neall	by Neall	0	956
Conditional Formatting for Changing a Formula HeatherT	by HeatherT	3	447
IF formula and date fields SCP1	by T. Valko	2	657
Linked spreadsheets created in 2003 but not working in 2007 Steve	by Steve	2	574
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	329
Highlight rows based on '1' or blank in all columns on a row Scott Lindstrom	by Scott Lindstrom	3	556
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	359
FIle link Shahzad	by Shahzad	0	343
auto save function N Ravinder	by Dave Peterson	2	432
cummulative ditribution functions curious	by curious	0	343
CountIF and Sum in one formula? Scott A[_2_]	by Ashish Mathur[_2_]	8	2,090
SumIF with condition and exception Scott A[_2_]	by Scott A[_2_]	3	805
Cell locking based on domain user Wolter	by Wolter	6	635
indirect with wildcards sam	by sam	3	2,678
Subtotals in very large datasets heather	by Shane Devenshire[_2_]	5	1,889
Calculating number of periods Ari	by Ari	2	1,001
zero denominator Amanda	by Shane Devenshire[_2_]	4	449
VLOOKUP and SUMPRODUCT PAL	by Teethless mama	3	907
Sheet Referencing - autofilling sheet names Pat	by Ashish Mathur[_2_]	2	592
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	774
How to VLOOKUP multiple sheets and each sheet have 65536 rows? nginhong	by nginhong	9	1,038
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	497
Conditional MAX IanC[_2_]	by T. Valko	5	625
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	712
Check Boxes / Collapsing dicko1	by Stephen Bye[_2_]	4	398
Mulitiple Count of occurrences in different columns Ant	by Per Jessen	3	432
Mapping distances with postal codes in an excel spreadsheet [email protected]	by [email protected]	0	487
How to prevent each item date from changing after "TODAY" formula Marvin	by Luke M	2	1,222
Click on cell (or "button"), takes you to appropriate information ahwelch	by Dave Peterson	1	480
Matching data kristy_6278	by kristy_6278	5	433