Excel Worksheet Functions - Page 1028

Thread / Thread Starter	Last Post	Replies	Views
Max with Multiple Ifs ChrisWWiese	by ChrisWWiese	3	1,929
Include email dist. list into a Excel macro - how? Excel problem/challenge	by Ron de Bruin	1	993
automatically update a field only when data has changed bigdog2112	by Niek Otten	1	755
Date field from text field Jack Deuce	by Gord Dibben	3	826
Lookup Formula BAD	by Teethless mama	2	575
Displays wrong result FirstVette52	by Teethless mama	2	652
Conditional format stoplight based on worst color Morgimo	by Gord Dibben	3	677
How calculate exact # of months between two dates? Mark Livingstone	by Ashish Mathur[_2_]	9	2,316
Searching multiple fields and then print the entire row from resul Vegeta_matt18	by Ashish Mathur[_2_]	2	517
Is it possible to choose a certain amount of rows and have them ex ocean	by ocean	6	573
cond. formating quesiton [email protected]	by T. Valko	1	437
LOOKUP function reversed? Chris	by OssieMac	3	528
Named Array KC Excel Qns	by Dana DeLouis[_3_]	7	466
Excel file link with two worksheet calculation Sky[_2_]	by Sky[_2_]	0	510
countif/sumproduct = criteria with weeknum ummone	by Jacob Skaria	2	2,073
Excel File corrupted a	by a	0	613
Add Range If Q Seanie	by Seanie	0	385
Different twist on ISNUMBER fgwiii[_2_]	by fgwiii[_2_]	6	524
Split astring using Capital letter as identifier Raj[_2_]	by Ron Rosenfeld	11	1,626
Pie charts - showing % & values Lou H[_2_]	by Luke M	1	3,027
Indirect reference ice	by Sam Wilson	2	531
Return date if in range, else return blank LisaL	by Luke M	1	1,461
Help with complex "IF" formula !!! Iriemon	by Sam Wilson	2	458
SUMIF criteria in different column is met? spandangled	by Eduardo	3	1,603
find last populated cell in range of cells Maximus[_2_]	by T. Valko	6	1,531
Unique values LiAD	by Ashish Mathur[_2_]	4	464
Copy line if Kcope8302	by Kcope8302	21	1,809
if condition combined with SMALL kaveran	by Teethless mama	3	442
Function returning unexpected value Paul	by JoeU2004	7	485
alternatives to embedded ifs jaime_ottawa	by Glenn	6	536
IF #N/A ( in a range), "ALERT","OK" Steve	by Steve	7	573
count if with and comparing three columns Johndb	by Johndb	0	607
column information moves to the next column Ashley1381	by Ashley1381	0	516
Sum sheets based on criteria npop03	by Don Guillett	5	755
If, then Joseph[_5_]	by Lars-Åke Aspelin[_2_]	1	568
The date in a excel worksheet is wrong. =now() responds 1-0-1900 David	by Ron Rosenfeld	3	599
Function or If statement help KrissyiP	by Fred Smith[_4_]	1	544
Can users perform a reverse lookup Blue Max	by bcw_now[_2_]	7	709
CORREL w/ condition heidi	by Max	5	6,622
vlookup column based on user input berniean	by Max	3	890
Random Numbers excluding Previous Numbers Brad	by Jim Cone[_2_]	2	1,461
Calculate Future Date but don't want Morocco Mole	by Ron Rosenfeld	6	1,021
Need a Formula , please help ytayta555	by ytayta555	1	445
Vlookup - multiple tabs jkiser	by Ragdyer	5	912
I know I should know this mdj0615	by Fred Smith[_4_]	1	414
If statements Cold1	by Teethless mama	2	595
relative address or reference James C.	by T. Valko	1	579
countif with AND comparing 3 columns Johndb	by Johndb	2	577
Working on a big spreadsheet mdj0615	by Max	5	662
I need to simplify this... j5b9721	by David Biddulph[_2_]	5	536
I need to format a count in a pivot table Golfer2100	by Jason[_14_]	2	433
Indirect reference causes statistical function to throw up a #NUM! JoCa	by Lori	10	840
Fill across worksheet pages Cyara	by Gary''s Student	1	524
Count based on 2 conditions Basenji	by Basenji	4	885
SumProduct meeting two criteria Mindy	by Mindy	4	529
How do I set up a function in excel to give either a < or =? ivory	by ivory	5	1,054
Validation of input against the active directory Sing Chung[_2_]	by Hii Sing Chung	1	1,301
using worksheet name in a formula but not current worksheet Sing Chung	by T. Valko	3	558
counting duplicates and uniques comparing two columns Johndb	by T. Valko	3	820
Help using autofilter & Sumproduct Scott	by T. Valko	4	590
help with IF and VLOOKUP combined Natalie	by Luke M	2	637
Time x Rate Scott A[_2_]	by JoeU2004	2	1,198
Count function Ranjith Kurian[_2_]	by T. Valko	7	521
Sum if Critea 1 and critera 2 are met Nelson	by T. Valko	6	539
lookup value if multiple matches are met Go Bucks!!!	by Go Bucks!!![_2_]	2	645
Conditional Formatting Question libby	by T. Valko	1	408
countif adding AND Johndb	by Johndb	13	907
Rank in ascending order in Excel 2003 Basenji	by T. Valko	5	1,391
Wrong Result with an IF function Thij_rahya	by Thij_rahya[_2_]	6	578
proper writing of a formula YS1107	by YS1107	8	470
How do get the LOOKUP function to not read empty cells as zeros LGriffin	by JoeU2004	9	1,018
Vlookup or use another formula Revned	by T. Valko	2	550
Counting data that meets 3 different Criteria Jenny.S	by Jenny S	20	1,676
calculate tax based on y or N marsjune68	by JoeU2004	3	642
Mutliple Sumproduct criteria PJFry	by smartin	1	528