Excel Worksheet Functions - Page 176

Thread / Thread Starter	Last Post	Replies	Views
Sum/multiply function Ryan Gerry	by RagDyer	5	671
What Formula to use? Paul Chung	by Paul Chung	4	439
filter text willemeulen[_26_]	by Rick Rothstein	2	382
how do calculate elasped time Nolan Holloway	by Luke M	3	440
struggling with if logical test function neuromoe	by Shane Devenshire[_2_]	2	481
Vlookup to include conditional formats Trish	by Shane Devenshire[_2_]	3	814
AUTOMATICALLY ADJUST COLUMN WIDTHS TO CONTENT DebC	by Rich/rerat	3	1,657
Index match to return all values SauQ	by Bernd P	13	2,996
Macro to HIDE blank rows JForsyth	by JForsyth	6	2,181
Worksheet tabs to turn colors against criteria Neall	by Neall	3	687
VBA for form check boxes dicko1	by [email protected]	4	1,115
Count pricing associated to year Neall	by Jacob Skaria	8	445
Question on looking up data Nick H[_2_]	by Nick H[_2_]	2	342
Using Index and Match Formula Brett[_2_]	by Brett[_2_]	2	575
creating a survey and gathering the data Maddie1020	by fake_be	3	611
Give a cell a name that is variable Neall	by Neall	0	368
Pivot - can we set criteria? Christine[_3_]	by Dave Peterson	1	313
reference table automation Kerry Purdy	by Kerry Purdy	0	317
Convert the series to a formula Humayaun	by Jacob Skaria	1	349
Advanced Filter, Copy to another location Tina	by Roger Govier[_3_]	6	602
Integrating Networkdays() Into Formula Rob	by Pecoflyer[_340_]	1	378
Finding muliple duplicate records in spreadsheet ShagNasty	by Bernd P	4	663
text alignment settings dude_down_under_1	by Rick Rothstein	2	530
Fill Series Humayaun	by Jacob Skaria	1	542
Need to have an index sheet but all other sheets should be hidden Madhu	by Jacob Skaria	1	424
Formula Link[_2_]	by T. Valko	4	361
SUMIF & INDIRECT Returns #Value! Christi	by T. Valko	3	565
VBA code to count rows ub	by Ashish Mathur[_2_]	5	1,550
Pivot tables - new columns SB Lee[_2_]	by Ashish Mathur[_2_]	5	399
Question on Named range with formula DocBrown	by DocBrown	2	397
Averaging question [email protected]	by Shane Devenshire[_2_]	2	343
adding cells then sorting Helen B[_2_]	by smartin	1	401
Solver or Other? Stan	by Dana DeLouis	5	700
highlight dependent cells Lindsay	by T. Valko	2	1,050
Vlookup & 2 variables Marti	by T. Valko	3	1,428
Help With Sum Chris	by Marcelo	2	426
Using worksheet template create tabs against customer list Neall	by Neall	0	978
Conditional Formatting for Changing a Formula HeatherT	by HeatherT	3	465
IF formula and date fields SCP1	by T. Valko	2	850
Linked spreadsheets created in 2003 but not working in 2007 Steve	by Steve	2	589
Lookup question and iferror compatibility Ryan Gerry	by T. Valko	7	926
I am trying to set up a formula to show a subsequent IP Address. jewell	by Shane Devenshire[_2_]	3	333
Highlight rows based on '1' or blank in all columns on a row Scott Lindstrom	by Scott Lindstrom	3	576
Search row of numbers, find highest value. Ice Bear	by Ice Bear	2	903
Excel invoke REST service function with Xpath fn parse result! Rand0m1y	by Rand0m1y	0	1,202
Vlookup not calcuting correctly akemeny	by Pete_UK	3	369
FIle link Shahzad	by Shahzad	0	353
auto save function N Ravinder	by Dave Peterson	2	441
cummulative ditribution functions curious	by curious	0	351
CountIF and Sum in one formula? Scott A[_2_]	by Ashish Mathur[_2_]	8	2,110
SumIF with condition and exception Scott A[_2_]	by Scott A[_2_]	3	823
Cell locking based on domain user Wolter	by Wolter	6	649
indirect with wildcards sam	by sam	3	2,681
Subtotals in very large datasets heather	by Shane Devenshire[_2_]	5	1,899
Calculating number of periods Ari	by Ari	2	1,014
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	611
Average except for something lower... Clubber2010	by Ashish Mathur[_2_]	3	372
consolidating or totaling info M.GONZALEZ[_2_]	by Ashish Mathur[_2_]	2	436
recognizing words as numbers...for a formula CONFUSED	by Ashish Mathur[_2_]	2	784
How to VLOOKUP multiple sheets and each sheet have 65536 rows? nginhong	by nginhong	9	1,052
SUM key LAM	by Shane Devenshire[_2_]	1	438
Excel 2003 - Lookup type of question Fran	by Fran	3	475
Copy cell value into blank cells below (full worksheet) SimmoG	by Fesco	4	2,602
indirect / vlookup help Greyling	by Dave Peterson	1	500
Conditional MAX IanC[_2_]	by T. Valko	5	636
Counting patient check in Meebers[_2_]	by Meebers[_2_]	13	868
Calculate hours of work substracting non-working time [email protected]	by [email protected]	2	720
Check Boxes / Collapsing dicko1	by Stephen Bye[_2_]	4	410
Mulitiple Count of occurrences in different columns Ant	by Per Jessen	3	456
Mapping distances with postal codes in an excel spreadsheet [email protected]	by [email protected]	0	491
How to prevent each item date from changing after "TODAY" formula Marvin	by Luke M	2	1,238
Click on cell (or "button"), takes you to appropriate information ahwelch	by Dave Peterson	1	486
Matching data kristy_6278	by kristy_6278	5	450