Excel Worksheet Functions - Page 39

Thread / Thread Starter	Last Post	Replies	Views
Vlookup Array limit? frankjh19701	by frankjh19701	0	1,572
sumproduct between two numbers and wildcard text happyberks	by happyberks	0	1,351
excel tests Dave	by BattyXLS	3	1,660
Vlookup/Index/Match frankjh19701	by frankjh19701	0	974
If adjacent cells both contain a match from a list, they, and 2 more adj. cells are cLING	by cLING	0	1,278
Using SUM for more than 30 number in differents sheets Christian Reyes	by Christian Reyes	0	1,458
total sum in a table of different cells Nanito	by Mazzaropi	3	1,285
need help using vlookup,max and offset functions! glowdark	by glowdark	0	1,358
Using IF function with Multiple Criteria frankjh19701	by frankjh19701	0	1,464
Merging cells graeme_706	by graeme_706	1	949
Help with Looping Macros Chaitanya	by Chaitanya	0	974
OFFSET COLUMN() ROW() - what does this mean? foxyfmu	by wickedchew	1	5,393
MATCH Function rge0036	by rge0036	0	983
Help with a Formula jacestamps	by jacestamps	1	1,171
copy the value, from task bar, in excel NAGABHUSHANAM	by NAGABHUSHANAM	0	2,941
vlookup extract next cell and combine with if hellprey	by hellprey	0	884
Lining up 3 excel sheets/ 4 columns/all different GAnad	by GAnad	0	1,191
Make Cell Equal to File Name (not worksheet) jvanderh	by jvanderh	1	5,776
Networkdays pancho	by Mazzaropi	1	993
Using Vlookup then interpolate,return corresponding value, if not, return other value Wzaman	by Mazzaropi	1	3,024
Apparent bug in CHIINV! Boris	by merlin666	12	2,627
Help with nested IF statement Raven	by Raven	0	943
pull info from every sheet in a Workbook fenway022	by fenway022	0	929
Skip Blank Cells While Copying A List shruthitulsi	by shruthitulsi	0	1,738
How to divide sheet Haik Hakopian	by Haik Hakopian	0	1,177
LOOKUP problem cheddy	by Mazzaropi	1	943
Assigning additional points to scores fetzer	by fetzer	0	809
Help merging excel sheets (2007) on a common field campanellisj	by wickedchew	1	1,212
loan amortization schedule nldilch	by clivewilliam	4	3,137
Excell how to make a cell rotate names when taken off top Vicky in the midwest	by nathaniel	2	3,098
Excel 2007 and Ian Smith VBA merlin666	by merlin666	0	1,754
Recorded Macro Problems GraemeH	by GraemeH	1	996
Inserting missing date/time JWeston	by JWeston	0	1,139
VLOOKUP and IF RBaetz	by wickedchew	1	1,074
Creating an hourly planner from excel data graeme_706	by graeme_706	0	2,302
Help with advanced vlookup and offset (in an index function) Eleni	by Mazzaropi	1	1,972
pls help with conditional formula christina_d	by lauratristin	2	960
VLookup not finding values unless lookup value is manually entered Josh	by lauratristin	6	4,690
Change multiple Chart Titles in different sheets in the same Workbook asprivl	by lauratristin	2	2,981
Custom Validation dalymjl	by lauratristin	2	935
Formula to COUNT the pairing of DIGITS in a list, cell by cell Duran Price	by Duran Price	0	1,657
Degrees, Minutes, Seconds Huw Edwards	by Huw Edwards	0	1,357
Enabling formulas in a semi-protected sheet cbr	by cbr	0	1,123
How to automatically change subsequent sheets after editing a master kmpublishing2	by kmpublishing2	0	1,422
calculate vehicle number plates sequence scroll1	by scroll1	0	1,273
Conditional formula for dates klaesser	by klaesser	1	1,015
VLOOKUP Help Bruceeboy	by wickedchew	1	1,265
Countif question SandyKazmir	by SandyKazmir	1	828
How do I round numbers to the nearest multiple of 10 or 5 in the same cell? NOV705	by wickedchew	1	1,906
Combining SUMPRODUCT with IF - help! John Elford	by John Elford	1	1,574
Adding data to another table in database based on condition chrisjack001	by chrisjack001	0	963
help with macros? kaine	by Sepeteus Jedermann	1	940
delete row macro DeFautT	by Sepeteus Jedermann	1	1,539
How Determine If 2 Dates Are Within Range Of Years eikichionizuka	by eikichionizuka	3	1,526
[HELP] I need some help for vlookup ... harky	by Mazzaropi	1	1,046
Linking cell to filename littlecheets	by Sepeteus Jedermann	1	1,474
Small Decimal Won't Copy LarryAP	by Sepeteus Jedermann	1	1,274
How to establish as assumption Vonar	by Vonar	2	1,012
Create macro to start the time anwitha	by anwitha	0	1,802
combinations of numbers sum to a given amount? TimH	by Fortress	3	6,075
From Outlook to Excel Personal Folder Roy Hobbs	by Roy Hobbs	0	964
Ranking function doverfield	by wickedchew	6	1,496
Return value in table associated with next greatest fuji	by wickedchew	1	1,065
Finding most recent entry across multiple sheets CormacMurphy	by David of XL Plus	1	1,100
Change applied % after a certain value reached? LesB	by wickedchew	1	951
SUMIF Exclude Certain Cell Steph	by lio13	4	2,905
Macro to print filtered results JBRTaylor	by JBRTaylor	0	925
insert refreshable stock price no longer an option jbo	by Almogavar	1	1,728
Search one cell for same data in another cell dtime	by wickedchew	1	956
two-up cell display for date Johndem33	by walterharris	1	724
Sorting and counting cell gundesvan	by gundesvan	0	700
Football score gundesvan	by gundesvan	16	2,115
How to put this formula in percentage? wachinnai	by wachinnai	2	883
Averaging Sections of data ATC123	by wickedchew	1	758
Poll: Pull records based on name in more than 1 column manitouboat	by wickedchew	3	1,006