Excel Worksheet Functions - Page 492

Thread / Thread Starter	Last Post	Replies	Views
Unable to paste in worksheet Ifatooki[_2_]	by Gord Dibben	4	730
Conditional formatting changing relative when copied to other cell robbin	by Gord Dibben	1	626
Looking up data by row and column (Arrays, Lookups, Index, Match?? Victoria@DIG	by Max	3	572
How do I get a total adding cells from other sheets for a roll-up John Boy	by Gord Dibben	1	434
Identify top 20 clients/coditional formatting relo rob	by Max	5	507
traspose data with formulas Darshan	by T. Valko	3	400
Can the If function be used on blank cells? oldsquid	by oldsquid	3	348
Converting month name to number Mats Samson	by Ron Coderre	8	1,260
date specific formula jdvanhemert	by Bernard Liengme	1	547
counting periods Excel Eric	by Peo Sjoblom	1	976
Can I create a dropdown list to select multiple items Oct1196	by Debra Dalgleish	2	1,195
Comparing two lists ExcelHelpNeeded	by Darrilyn	3	630
Array - matching data UKMAN	by T. Valko	6	314
Invoicing Problem carl	by Toppers	1	404
Conditional Formating carl	by Beege	4	415
vlookup not looking through all the values vlad	by Michael	1	383
Autofill rolf	by Michael	2	380
Calculating Time Mike Archer	by Sandy Mann	5	371
PIVOT and lookup CJ	by CJ	0	264
Moving Subtotals PHisaw	by PHisaw	0	293
grouping conor wardie	by Jimbo213	3	299
open ftp file with password Kevin	by Kevin	1	878
VBA Password Question Danny	by Danny	0	368
I do not want a hyperlink to be automatic when you click on that c Jamie	by Jamie	2	479
Easy one... NWO	by Peo Sjoblom	7	463
blank error Jeze77	by Jeze77	0	339
Data Import Alexey	by ryguy7272	1	358
Converting Hours:Minutes to Decimal Michael[_2_]	by Rick Rothstein \(MVP - VB\)	2	1,824
Compare and Return Value Joanne	by Joanne	4	499
conditional: stop function under certain condition kana	by Pranav Vaidya	1	441
Expert VBE help for cell color change JVANWORTH	by JVANWORTH	8	449
Conditional Named Ranges Tevuna	by Tevuna	2	1,063
Filter setting dNd BdN	by Max	3	469
Yearfrac error? mthomas4	by Ron Rosenfeld	3	3,785
need help with networkdays formula aashishtaneja	by Mike H	1	620
sumproduct? anand	by RagDyeR	5	379
to John Boy bj	by bj	0	388
Count difference based on Range Richhall	by Richhall	2	434
Using Excel Solver or Goalseek on multiple Sheets in a Workbook au AlfredR	by AlfredR	2	2,494
how to sum items in a column if there exists some more refernces Dileep[_2_]	by Mike H	1	434
Want to display financial formula result... not the formula Army Guy[_2_]	by David Biddulph[_2_]	2	394
How to read the value of a cell Hell-fire[_3_]	by Max	17	1,176
vLookup from 2 different lists NolanC	by NolanC	3	341
how do I add a various check boxes to a list in a specific cell lets	by lets	0	448
auto SUM bottom page LP	by JE McGimpsey	2	2,026
find first and last in row of numbers anand	by Max	2	736
Date Conversion dd.mm.yyyy to dd/mm/yyyy ScottRA	by T. Valko	1	906
concatenation nandkishor	by JMB	2	455
formula question David	by T. Valko	3	374
Adding values from a different worksheet sue	by T. Valko	2	343
counting the number of times a word appears Adrienne[_2_]	by T. Valko	5	1,156
protected file rio	by rio	0	301
How do you truncate 2.22 to just 0.22? Crackles McFarly	by Crackles McFarly	6	805
how do i put color in a cell based on data in a second cell Diogie	by Diogie	5	744
how do i transfer necessary rows/data from a master sheet victorssb	by Don Guillett	1	441
Formula for finding data from 2 worksheets Donna	by Darrilyn	9	735
how do i transfer necessary rows/data from a master excel sheet victorssb	by victorssb	0	489
Macros I think Rick	by Don Guillett	1	303
Time and lunch breaks mndpy	by bj	5	1,019
Test cell interior color by worksheet function? Skimmer	by Skimmer	7	608
i need help with formula Mandy	by Gord Dibben	4	351
Paste changing cell contents to consecutive cells in a column meggy	by Gord Dibben	3	545
how to prevent a worksheet from being recalculated? z.entropic	by Chip Pearson	1	441
Invoice Formula carl	by carl	0	412
Conditional Formatting Help mndpy	by JE McGimpsey	5	351
Conditional formatting and time mndpy	by Darrilyn	1	665
Pivot table and customer analysis ExcelHelpNeeded	by Darrilyn	1	684
VLOOK up returning #N/A even though value exists in lookup array [email protected]	by Dave Peterson	1	904
Concatenate function adding double quotes to both ends of results SqtYork	by SqtYork	0	1,494
Phone with/without area code format barnabas	by Peo Sjoblom	2	1,269
sumproduct bllank function handling Walter Briscoe	by Walter Briscoe	0	383
Excel 2K and parsing data Ed	by Ed	2	536
using a formula for a column or range lks1	by lks1	2	327
Linking Excell Spread sheets TomLama	by TomLama	2	335
filter dropdown menu so 2nd drop menu is customized menugal	by Ron Coderre	1	1,193