Excel Worksheet Functions - Page 1007

Thread / Thread Starter	Last Post	Replies	Views
how can i perform multivariate analysis in excel 2007? ezza59	by Ron@Buy	1	1,722
Using VLOOKUP to match similar text? lrb	by kay	10	2,711
HELP......I am going insane.... Lynda	by Lynda	6	466
Copy from sheet to sheet when matches criteria jeremiah	by jeremiah	2	937
Vlookup function Karen	by Eduardo	1	347
Counting Dates klafert	by klafert	2	303
Unknown Number Format Freshman	by Freshman	3	439
MAX/MAXA €“ Formula not returning required value EricB	by Jarek Kujawa[_2_]	6	603
Vlook match kay	by kay	2	298
How can I unfreeze curser in Excel 2007? Jim Connelly	by Jacob Skaria	1	734
data matchin kay	by Eduardo	1	333
Count if with partial text match [email protected]	by [email protected]	0	2,661
Count if with partial text match (edited X2) [email protected]	by Shane Devenshire[_2_]	1	846
I need to calculate hours worked from 11pm to 7am minus a lunch Paula Brooks	by Shane Devenshire[_2_]	2	5,217
Save Date tomen24	by Jacob Skaria	1	506
With a Function, how can I get rid of formating codes like <div ? AFSSkier	by Ron Rosenfeld	30	1,712
Count if with partial text match (edited) [email protected]	by [email protected]	2	1,354
Button for Hyperlink Khalil	by Gord Dibben	1	387
In Format - General-How do I change it to an even number like 24 MJH	by Gord Dibben	1	397
Multiple Functions of a Cell Drew	by JCS	3	645
Need help with converting CUSTOM format/TEXT format to DATE format Deo Cleto	by Deo Cleto[_2_]	6	3,202
relative Named Ranges based on worksheet Fr. Robert	by David C[_2_]	5	950
Function or Formula to show the value from above cell ytayta555	by Don Guillett	8	483
How to automatically calculate totals within a Y-N-N/A column Bill638	by Bill638	6	708
Index and Match? j.ruderman[_2_]	by T. Valko	6	372
Replace text with text AH	by Shane Devenshire[_2_]	1	325
Help with a nested IF statement containing AND and OR funtions Trip	by Sheeloo	1	1,294
Pivot table summary functions SB Lee[_2_]	by Shane Devenshire[_2_]	1	463
Need formula Debsdad	by Sheeloo	5	488
Count Unique Values but not Filtered or Hidden Values Lee	by T. Valko	3	931
when i pick a cell, it picks cells below also, how do i stop this cindu	by Gord Dibben	2	744
Formula Question Rae's Formula Question	by Gord Dibben	6	444
Printing and emailing query dragons_lair	by dragons_lair	2	333
back transforming log10 standard error fluff	by JoeU2004	1	1,637
Lookup function Michael	by Jacob Skaria	7	501
variable consolidation ending tab name Seaq	by Seaq	7	405
consolidation sum where ending tab value is changeable Seaq	by Seaq	5	520
BLANK CELLS ARE NOT ACTUALLY BLANK Shilpi	by Shane Devenshire[_2_]	2	501
conditional format date range Derek	by Shane Devenshire[_2_]	2	354
using cell contents to link to other tabs CLGonline	by Shane Devenshire[_2_]	2	472
formula to link to other tabs CLGonline	by Shane Devenshire[_2_]	3	815
360/365, etc. sg	by Joel	11	6,318
Day Off Formula Tia[_3_]	by Roger Govier[_3_]	1	523
formula for transpose surya and siva	by Dave Peterson	1	302
Search dates WELSH_EXCEL	by Gary''s Student	2	386
How to add a cell value to VLOOKUP? engel59	by Max	6	1,097
I cannot copy the columns of formulas in this Workbook::: AHHHHHHHHHHHHHHHH J	by J	6	1,029
Sumproduct issues SteveDB1	by RagDyeR	25	3,967
Nested Functions Limit bbal20	by T. Valko	8	973
fill down sequentially JMC	by Paula Jones, MCT, MIITT	1	816
Matching data kristy_6278	by kristy_6278	5	426
Click on cell (or "button"), takes you to appropriate information ahwelch	by Dave Peterson	1	468
How to prevent each item date from changing after "TODAY" formula Marvin	by Luke M	2	1,201
Mapping distances with postal codes in an excel spreadsheet [email protected]	by [email protected]	0	477
Mulitiple Count of occurrences in different columns Ant	by Per Jessen	3	417
Check Boxes / Collapsing dicko1	by Stephen Bye[_2_]	4	390
Calculate hours of work substracting non-working time [email protected]	by [email protected]	2	693
Counting patient check in Meebers[_2_]	by Meebers[_2_]	13	850
Conditional MAX IanC[_2_]	by T. Valko	5	617
indirect / vlookup help Greyling	by Dave Peterson	1	467
Copy cell value into blank cells below (full worksheet) SimmoG	by Fesco	4	2,582
Excel 2003 - Lookup type of question Fran	by Fran	3	452
SUM key LAM	by Shane Devenshire[_2_]	1	414
How to VLOOKUP multiple sheets and each sheet have 65536 rows? nginhong	by nginhong	9	1,018
recognizing words as numbers...for a formula CONFUSED	by Ashish Mathur[_2_]	2	751
consolidating or totaling info M.GONZALEZ[_2_]	by Ashish Mathur[_2_]	2	419
Average except for something lower... Clubber2010	by Ashish Mathur[_2_]	3	352
Sheet Referencing - autofilling sheet names Pat	by Ashish Mathur[_2_]	2	573
VLOOKUP and SUMPRODUCT PAL	by Teethless mama	3	894
zero denominator Amanda	by Shane Devenshire[_2_]	4	440
Calculating number of periods Ari	by Ari	2	986
Subtotals in very large datasets heather	by Shane Devenshire[_2_]	5	1,804
indirect with wildcards sam	by sam	3	2,650
Cell locking based on domain user Wolter	by Wolter	6	578
SumIF with condition and exception Scott A[_2_]	by Scott A[_2_]	3	784