Excel Worksheet Functions - Page 156

Thread / Thread Starter	Last Post	Replies	Views
I need to simplify this... j5b9721	by David Biddulph[_2_]	5	542
Working on a big spreadsheet mdj0615	by Max	5	711
countif with AND comparing 3 columns Johndb	by Johndb	2	609
relative address or reference James C.	by T. Valko	1	587
If statements Cold1	by Teethless mama	2	599
I know I should know this mdj0615	by Fred Smith[_4_]	1	429
Vlookup - multiple tabs jkiser	by Ragdyer	5	925
Need a Formula , please help ytayta555	by ytayta555	1	453
Calculate Future Date but don't want Morocco Mole	by Ron Rosenfeld	6	1,035
Random Numbers excluding Previous Numbers Brad	by Jim Cone[_2_]	2	1,476
vlookup column based on user input berniean	by Max	3	909
CORREL w/ condition heidi	by Max	5	6,644
Can users perform a reverse lookup Blue Max	by bcw_now[_2_]	7	731
Function or If statement help KrissyiP	by Fred Smith[_4_]	1	554
The date in a excel worksheet is wrong. =now() responds 1-0-1900 David	by Ron Rosenfeld	3	617
If, then Joseph[_5_]	by Lars-Åke Aspelin[_2_]	1	588
Sum sheets based on criteria npop03	by Don Guillett	5	802
column information moves to the next column Ashley1381	by Ashley1381	0	540
count if with and comparing three columns Johndb	by Johndb	0	621
IF #N/A ( in a range), "ALERT","OK" Steve	by Steve	7	584
alternatives to embedded ifs jaime_ottawa	by Glenn	6	564
Function returning unexpected value Paul	by JoeU2004	7	498
if condition combined with SMALL kaveran	by Teethless mama	3	458
Copy line if Kcope8302	by Kcope8302	21	1,823
Unique values LiAD	by Ashish Mathur[_2_]	4	469
find last populated cell in range of cells Maximus[_2_]	by T. Valko	6	1,542
SUMIF criteria in different column is met? spandangled	by Eduardo	3	1,613
Help with complex "IF" formula !!! Iriemon	by Sam Wilson	2	475
Return date if in range, else return blank LisaL	by Luke M	1	1,482
Indirect reference ice	by Sam Wilson	2	541
Pie charts - showing % & values Lou H[_2_]	by Luke M	1	3,056
Split astring using Capital letter as identifier Raj[_2_]	by Ron Rosenfeld	11	1,640
Different twist on ISNUMBER fgwiii[_2_]	by fgwiii[_2_]	6	540
Add Range If Q Seanie	by Seanie	0	390
Excel File corrupted a	by a	0	632
countif/sumproduct = criteria with weeknum ummone	by Jacob Skaria	2	2,085
Excel file link with two worksheet calculation Sky[_2_]	by Sky[_2_]	0	525
Named Array KC Excel Qns	by Dana DeLouis[_3_]	7	478
LOOKUP function reversed? Chris	by OssieMac	3	536
cond. formating quesiton [email protected]	by T. Valko	1	456
Is it possible to choose a certain amount of rows and have them ex ocean	by ocean	6	578
Searching multiple fields and then print the entire row from resul Vegeta_matt18	by Ashish Mathur[_2_]	2	523
How calculate exact # of months between two dates? Mark Livingstone	by Ashish Mathur[_2_]	9	2,337
Conditional format stoplight based on worst color Morgimo	by Gord Dibben	3	692
Displays wrong result FirstVette52	by Teethless mama	2	663
Lookup Formula BAD	by Teethless mama	2	579
Date field from text field Jack Deuce	by Gord Dibben	3	833
automatically update a field only when data has changed bigdog2112	by Niek Otten	1	765
Include email dist. list into a Excel macro - how? Excel problem/challenge	by Ron de Bruin	1	1,001
Max with Multiple Ifs ChrisWWiese	by ChrisWWiese	3	1,938
Array Function? Johnnie[_2_]	by Johnnie[_2_]	4	560
why does the dateif function result in an error in Excel 2003? Cheryl	by Mike H	5	1,589
Alarm function, disable sound if data is erased offdah3z	by Bernard Liengme[_3_]	1	709
Remove Password Zita	by Gord Dibben	3	920
Drop Down Lists: Allow option of adding own data if not in drop do ruperthouse	by Gord Dibben	8	1,628
How the data may stay on top with scroll ? Vladimir Nikolov	by Eduardo	1	516
Formating a cell Smiley[_2_]	by Rick Rothstein	5	515
Custom Format or use function? Lisa W	by Rick Rothstein	4	581
Conditional Formatting - Looking for Red/Yellow/Green Icons, w/ wo mikevanv	by mikevanv	0	2,018
Cross Reference fgwiii[_2_]	by Eduardo	1	525
Count Columns, Return Content Leah G	by Mike H	6	605
Sums Natalie	by Eduardo	1	516
Highlight a row with the current date. sword_fishx	by T. Valko	11	3,042
format number to date Picodillo	by T. Valko	8	653
Micro Ganesh Kumar	by Jacob Skaria	2	484
Counting Column Cul	by Shane Devenshire[_2_]	3	397
Formula for calculator Table Sky[_2_]	by Sky[_2_]	8	497
Selecting rows within a range JCG	by Don Guillett	5	467
VLOOKUP or MATCH and/or INDEX to extract value on a given date Don Kline[_2_]	by Max	7	1,021
auto scrol doune for hyperlink. rajaiy	by Dave Peterson	2	548
Please help VBA code not working properly send email when due dates Tia[_3_]	by Tia[_3_]	0	1,049
Why doesn't it print the colours? EN	by EN	8	469
Formula not updating nzcass	by Jacob Skaria	1	679
using the Cell function WT	by T. Valko	2	551
Lookup dates and values Suan	by Max	5	605