Excel Worksheet Functions - Page 492

Thread / Thread Starter	Last Post	Replies	Views
Unable to paste in worksheet Ifatooki[_2_]	by Gord Dibben	4	786
Conditional formatting changing relative when copied to other cell robbin	by Gord Dibben	1	645
Looking up data by row and column (Arrays, Lookups, Index, Match?? Victoria@DIG	by Max	3	587
How do I get a total adding cells from other sheets for a roll-up John Boy	by Gord Dibben	1	455
Identify top 20 clients/coditional formatting relo rob	by Max	5	564
traspose data with formulas Darshan	by T. Valko	3	426
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,274
date specific formula jdvanhemert	by Bernard Liengme	1	558
counting periods Excel Eric	by Peo Sjoblom	1	990
Can I create a dropdown list to select multiple items Oct1196	by Debra Dalgleish	2	1,225
Comparing two lists ExcelHelpNeeded	by Darrilyn	3	644
Array - matching data UKMAN	by T. Valko	6	322
Invoicing Problem carl	by Toppers	1	422
Conditional Formating carl	by Beege	4	433
vlookup not looking through all the values vlad	by Michael	1	401
Autofill rolf	by Michael	2	402
Calculating Time Mike Archer	by Sandy Mann	5	392
PIVOT and lookup CJ	by CJ	0	276
Moving Subtotals PHisaw	by PHisaw	0	307
grouping conor wardie	by Jimbo213	3	308
open ftp file with password Kevin	by Kevin	1	895
VBA Password Question Danny	by Danny	0	380
I do not want a hyperlink to be automatic when you click on that c Jamie	by Jamie	2	492
Easy one... NWO	by Peo Sjoblom	7	476
blank error Jeze77	by Jeze77	0	348
Data Import Alexey	by ryguy7272	1	371
Converting Hours:Minutes to Decimal Michael[_2_]	by Rick Rothstein \(MVP - VB\)	2	1,840
Compare and Return Value Joanne	by Joanne	4	519
conditional: stop function under certain condition kana	by Pranav Vaidya	1	460
Expert VBE help for cell color change JVANWORTH	by JVANWORTH	8	458
Conditional Named Ranges Tevuna	by Tevuna	2	1,091
Filter setting dNd BdN	by Max	3	516
Yearfrac error? mthomas4	by Ron Rosenfeld	3	3,864
need help with networkdays formula aashishtaneja	by Mike H	1	635
sumproduct? anand	by RagDyeR	5	401
to John Boy bj	by bj	0	396
Count difference based on Range Richhall	by Richhall	2	449
Using Excel Solver or Goalseek on multiple Sheets in a Workbook au AlfredR	by AlfredR	2	2,551
how to sum items in a column if there exists some more refernces Dileep[_2_]	by Mike H	1	458
Want to display financial formula result... not the formula Army Guy[_2_]	by David Biddulph[_2_]	2	408
How to read the value of a cell Hell-fire[_3_]	by Max	17	1,194
vLookup from 2 different lists NolanC	by NolanC	3	355
how do I add a various check boxes to a list in a specific cell lets	by lets	0	460
auto SUM bottom page LP	by JE McGimpsey	2	2,041
find first and last in row of numbers anand	by Max	2	760
Date Conversion dd.mm.yyyy to dd/mm/yyyy ScottRA	by T. Valko	1	925
concatenation nandkishor	by JMB	2	477
formula question David	by T. Valko	3	396
Adding values from a different worksheet sue	by T. Valko	2	351
counting the number of times a word appears Adrienne[_2_]	by T. Valko	5	1,260
protected file rio	by rio	0	318
How do you truncate 2.22 to just 0.22? Crackles McFarly	by Crackles McFarly	6	819
how do i put color in a cell based on data in a second cell Diogie	by Diogie	5	753
how do i transfer necessary rows/data from a master sheet victorssb	by Don Guillett	1	460
Formula for finding data from 2 worksheets Donna	by Darrilyn	9	750
how do i transfer necessary rows/data from a master excel sheet victorssb	by victorssb	0	504
Macros I think Rick	by Don Guillett	1	321
Time and lunch breaks mndpy	by bj	5	1,035
Test cell interior color by worksheet function? Skimmer	by Skimmer	7	640
i need help with formula Mandy	by Gord Dibben	4	360
Paste changing cell contents to consecutive cells in a column meggy	by Gord Dibben	3	563
how to prevent a worksheet from being recalculated? z.entropic	by Chip Pearson	1	456
Invoice Formula carl	by carl	0	429
Conditional Formatting Help mndpy	by JE McGimpsey	5	410
Conditional formatting and time mndpy	by Darrilyn	1	681
Pivot table and customer analysis ExcelHelpNeeded	by Darrilyn	1	704
VLOOK up returning #N/A even though value exists in lookup array [email protected]	by Dave Peterson	1	931
Concatenate function adding double quotes to both ends of results SqtYork	by SqtYork	0	1,528
Phone with/without area code format barnabas	by Peo Sjoblom	2	1,294
sumproduct bllank function handling Walter Briscoe	by Walter Briscoe	0	395
Excel 2K and parsing data Ed	by Ed	2	558
using a formula for a column or range lks1	by lks1	2	335
Linking Excell Spread sheets TomLama	by TomLama	2	346
filter dropdown menu so 2nd drop menu is customized menugal	by Ron Coderre	1	1,246