Excel Worksheet Functions - Page 492

Thread / Thread Starter	Last Post	Replies	Views
Unable to paste in worksheet Ifatooki[_2_]	by Gord Dibben	4	795
Conditional formatting changing relative when copied to other cell robbin	by Gord Dibben	1	658
Looking up data by row and column (Arrays, Lookups, Index, Match?? Victoria@DIG	by Max	3	589
How do I get a total adding cells from other sheets for a roll-up John Boy	by Gord Dibben	1	470
Identify top 20 clients/coditional formatting relo rob	by Max	5	575
traspose data with formulas Darshan	by T. Valko	3	438
Can the If function be used on blank cells? oldsquid	by oldsquid	3	366
Converting month name to number Mats Samson	by Ron Coderre	8	1,284
date specific formula jdvanhemert	by Bernard Liengme	1	560
counting periods Excel Eric	by Peo Sjoblom	1	999
Can I create a dropdown list to select multiple items Oct1196	by Debra Dalgleish	2	1,235
Comparing two lists ExcelHelpNeeded	by Darrilyn	3	656
Array - matching data UKMAN	by T. Valko	6	333
Invoicing Problem carl	by Toppers	1	434
Conditional Formating carl	by Beege	4	443
vlookup not looking through all the values vlad	by Michael	1	410
Autofill rolf	by Michael	2	408
Calculating Time Mike Archer	by Sandy Mann	5	404
PIVOT and lookup CJ	by CJ	0	285
Moving Subtotals PHisaw	by PHisaw	0	312
grouping conor wardie	by Jimbo213	3	320
open ftp file with password Kevin	by Kevin	1	908
VBA Password Question Danny	by Danny	0	385
I do not want a hyperlink to be automatic when you click on that c Jamie	by Jamie	2	503
Easy one... NWO	by Peo Sjoblom	7	477
blank error Jeze77	by Jeze77	0	357
Data Import Alexey	by ryguy7272	1	373
Converting Hours:Minutes to Decimal Michael[_2_]	by Rick Rothstein \(MVP - VB\)	2	1,852
Compare and Return Value Joanne	by Joanne	4	529
conditional: stop function under certain condition kana	by Pranav Vaidya	1	467
Expert VBE help for cell color change JVANWORTH	by JVANWORTH	8	460
Conditional Named Ranges Tevuna	by Tevuna	2	1,104
Filter setting dNd BdN	by Max	3	526
Yearfrac error? mthomas4	by Ron Rosenfeld	3	3,868
need help with networkdays formula aashishtaneja	by Mike H	1	645
sumproduct? anand	by RagDyeR	5	401
to John Boy bj	by bj	0	399
Count difference based on Range Richhall	by Richhall	2	464
Using Excel Solver or Goalseek on multiple Sheets in a Workbook au AlfredR	by AlfredR	2	2,563
how to sum items in a column if there exists some more refernces Dileep[_2_]	by Mike H	1	471
Want to display financial formula result... not the formula Army Guy[_2_]	by David Biddulph[_2_]	2	421
How to read the value of a cell Hell-fire[_3_]	by Max	17	1,201
vLookup from 2 different lists NolanC	by NolanC	3	363
how do I add a various check boxes to a list in a specific cell lets	by lets	0	470
auto SUM bottom page LP	by JE McGimpsey	2	2,054
find first and last in row of numbers anand	by Max	2	775
Date Conversion dd.mm.yyyy to dd/mm/yyyy ScottRA	by T. Valko	1	936
concatenation nandkishor	by JMB	2	480
formula question David	by T. Valko	3	397
Adding values from a different worksheet sue	by T. Valko	2	364
counting the number of times a word appears Adrienne[_2_]	by T. Valko	5	1,275
protected file rio	by rio	0	326
How do you truncate 2.22 to just 0.22? Crackles McFarly	by Crackles McFarly	6	820
how do i put color in a cell based on data in a second cell Diogie	by Diogie	5	761
how do i transfer necessary rows/data from a master sheet victorssb	by Don Guillett	1	470
Formula for finding data from 2 worksheets Donna	by Darrilyn	9	753
how do i transfer necessary rows/data from a master excel sheet victorssb	by victorssb	0	515
Macros I think Rick	by Don Guillett	1	329
Time and lunch breaks mndpy	by bj	5	1,041
Test cell interior color by worksheet function? Skimmer	by Skimmer	7	645
i need help with formula Mandy	by Gord Dibben	4	362
Paste changing cell contents to consecutive cells in a column meggy	by Gord Dibben	3	571
how to prevent a worksheet from being recalculated? z.entropic	by Chip Pearson	1	461
Invoice Formula carl	by carl	0	430
Conditional Formatting Help mndpy	by JE McGimpsey	5	425
Conditional formatting and time mndpy	by Darrilyn	1	692
Pivot table and customer analysis ExcelHelpNeeded	by Darrilyn	1	716
VLOOK up returning #N/A even though value exists in lookup array [email protected]	by Dave Peterson	1	940
Concatenate function adding double quotes to both ends of results SqtYork	by SqtYork	0	1,537
Phone with/without area code format barnabas	by Peo Sjoblom	2	1,301
sumproduct bllank function handling Walter Briscoe	by Walter Briscoe	0	403
Excel 2K and parsing data Ed	by Ed	2	571
using a formula for a column or range lks1	by lks1	2	349
Linking Excell Spread sheets TomLama	by TomLama	2	358
filter dropdown menu so 2nd drop menu is customized menugal	by Ron Coderre	1	1,260