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	584
How do I get a total adding cells from other sheets for a roll-up John Boy	by Gord Dibben	1	454
Identify top 20 clients/coditional formatting relo rob	by Max	5	563
traspose data with formulas Darshan	by T. Valko	3	421
Can the If function be used on blank cells? oldsquid	by oldsquid	3	362
Converting month name to number Mats Samson	by Ron Coderre	8	1,273
date specific formula jdvanhemert	by Bernard Liengme	1	557
counting periods Excel Eric	by Peo Sjoblom	1	989
Can I create a dropdown list to select multiple items Oct1196	by Debra Dalgleish	2	1,224
Comparing two lists ExcelHelpNeeded	by Darrilyn	3	643
Array - matching data UKMAN	by T. Valko	6	322
Invoicing Problem carl	by Toppers	1	420
Conditional Formating carl	by Beege	4	433
vlookup not looking through all the values vlad	by Michael	1	398
Autofill rolf	by Michael	2	399
Calculating Time Mike Archer	by Sandy Mann	5	390
PIVOT and lookup CJ	by CJ	0	274
Moving Subtotals PHisaw	by PHisaw	0	305
grouping conor wardie	by Jimbo213	3	307
open ftp file with password Kevin	by Kevin	1	894
VBA Password Question Danny	by Danny	0	379
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	370
Converting Hours:Minutes to Decimal Michael[_2_]	by Rick Rothstein \(MVP - VB\)	2	1,840
Compare and Return Value Joanne	by Joanne	4	518
conditional: stop function under certain condition kana	by Pranav Vaidya	1	459
Expert VBE help for cell color change JVANWORTH	by JVANWORTH	8	455
Conditional Named Ranges Tevuna	by Tevuna	2	1,089
Filter setting dNd BdN	by Max	3	516
Yearfrac error? mthomas4	by Ron Rosenfeld	3	3,862
need help with networkdays formula aashishtaneja	by Mike H	1	630
sumproduct? anand	by RagDyeR	5	399
to John Boy bj	by bj	0	394
Count difference based on Range Richhall	by Richhall	2	447
Using Excel Solver or Goalseek on multiple Sheets in a Workbook au AlfredR	by AlfredR	2	2,550
how to sum items in a column if there exists some more refernces Dileep[_2_]	by Mike H	1	454
Want to display financial formula result... not the formula Army Guy[_2_]	by David Biddulph[_2_]	2	405
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	354
how do I add a various check boxes to a list in a specific cell lets	by lets	0	458
auto SUM bottom page LP	by JE McGimpsey	2	2,041
find first and last in row of numbers anand	by Max	2	758
Date Conversion dd.mm.yyyy to dd/mm/yyyy ScottRA	by T. Valko	1	924
concatenation nandkishor	by JMB	2	474
formula question David	by T. Valko	3	393
Adding values from a different worksheet sue	by T. Valko	2	350
counting the number of times a word appears Adrienne[_2_]	by T. Valko	5	1,179
protected file rio	by rio	0	317
How do you truncate 2.22 to just 0.22? Crackles McFarly	by Crackles McFarly	6	818
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	458
Formula for finding data from 2 worksheets Donna	by Darrilyn	9	748
how do i transfer necessary rows/data from a master excel sheet victorssb	by victorssb	0	500
Macros I think Rick	by Don Guillett	1	319
Time and lunch breaks mndpy	by bj	5	1,029
Test cell interior color by worksheet function? Skimmer	by Skimmer	7	630
i need help with formula Mandy	by Gord Dibben	4	359
Paste changing cell contents to consecutive cells in a column meggy	by Gord Dibben	3	561
how to prevent a worksheet from being recalculated? z.entropic	by Chip Pearson	1	453
Invoice Formula carl	by carl	0	426
Conditional Formatting Help mndpy	by JE McGimpsey	5	407
Conditional formatting and time mndpy	by Darrilyn	1	678
Pivot table and customer analysis ExcelHelpNeeded	by Darrilyn	1	700
VLOOK up returning #N/A even though value exists in lookup array [email protected]	by Dave Peterson	1	922
Concatenate function adding double quotes to both ends of results SqtYork	by SqtYork	0	1,517
Phone with/without area code format barnabas	by Peo Sjoblom	2	1,291
sumproduct bllank function handling Walter Briscoe	by Walter Briscoe	0	394
Excel 2K and parsing data Ed	by Ed	2	555
using a formula for a column or range lks1	by lks1	2	335
Linking Excell Spread sheets TomLama	by TomLama	2	345
filter dropdown menu so 2nd drop menu is customized menugal	by Ron Coderre	1	1,222