Excel Worksheet Functions - Page 39

Thread / Thread Starter	Last Post	Replies	Views
Vlookup Array limit? frankjh19701	by frankjh19701	0	1,543
sumproduct between two numbers and wildcard text happyberks	by happyberks	0	1,333
excel tests Dave	by BattyXLS	3	1,636
Vlookup/Index/Match frankjh19701	by frankjh19701	0	950
If adjacent cells both contain a match from a list, they, and 2 more adj. cells are cLING	by cLING	0	1,245
Using SUM for more than 30 number in differents sheets Christian Reyes	by Christian Reyes	0	1,430
total sum in a table of different cells Nanito	by Mazzaropi	3	1,244
need help using vlookup,max and offset functions! glowdark	by glowdark	0	1,334
Using IF function with Multiple Criteria frankjh19701	by frankjh19701	0	1,452
Merging cells graeme_706	by graeme_706	1	933
Help with Looping Macros Chaitanya	by Chaitanya	0	942
OFFSET COLUMN() ROW() - what does this mean? foxyfmu	by wickedchew	1	5,342
MATCH Function rge0036	by rge0036	0	955
Help with a Formula jacestamps	by jacestamps	1	1,159
copy the value, from task bar, in excel NAGABHUSHANAM	by NAGABHUSHANAM	0	2,915
vlookup extract next cell and combine with if hellprey	by hellprey	0	857
Lining up 3 excel sheets/ 4 columns/all different GAnad	by GAnad	0	1,166
Make Cell Equal to File Name (not worksheet) jvanderh	by jvanderh	1	5,739
Networkdays pancho	by Mazzaropi	1	972
Using Vlookup then interpolate,return corresponding value, if not, return other value Wzaman	by Mazzaropi	1	2,992
Apparent bug in CHIINV! Boris	by merlin666	12	2,601
Help with nested IF statement Raven	by Raven	0	920
pull info from every sheet in a Workbook fenway022	by fenway022	0	905
Skip Blank Cells While Copying A List shruthitulsi	by shruthitulsi	0	1,710
How to divide sheet Haik Hakopian	by Haik Hakopian	0	1,170
LOOKUP problem cheddy	by Mazzaropi	1	933
Assigning additional points to scores fetzer	by fetzer	0	793
Help merging excel sheets (2007) on a common field campanellisj	by wickedchew	1	1,187
loan amortization schedule nldilch	by clivewilliam	4	3,114
Excell how to make a cell rotate names when taken off top Vicky in the midwest	by nathaniel	2	3,045
Excel 2007 and Ian Smith VBA merlin666	by merlin666	0	1,733
Recorded Macro Problems GraemeH	by GraemeH	1	979
Inserting missing date/time JWeston	by JWeston	0	1,119
VLOOKUP and IF RBaetz	by wickedchew	1	1,058
Creating an hourly planner from excel data graeme_706	by graeme_706	0	2,276
Help with advanced vlookup and offset (in an index function) Eleni	by Mazzaropi	1	1,954
pls help with conditional formula christina_d	by lauratristin	2	945
VLookup not finding values unless lookup value is manually entered Josh	by lauratristin	6	4,652
Change multiple Chart Titles in different sheets in the same Workbook asprivl	by lauratristin	2	2,940
Custom Validation dalymjl	by lauratristin	2	923
Formula to COUNT the pairing of DIGITS in a list, cell by cell Duran Price	by Duran Price	0	1,636
Degrees, Minutes, Seconds Huw Edwards	by Huw Edwards	0	1,348
Enabling formulas in a semi-protected sheet cbr	by cbr	0	1,087
How to automatically change subsequent sheets after editing a master kmpublishing2	by kmpublishing2	0	1,400
calculate vehicle number plates sequence scroll1	by scroll1	0	1,258
Conditional formula for dates klaesser	by klaesser	1	958
VLOOKUP Help Bruceeboy	by wickedchew	1	1,251
Countif question SandyKazmir	by SandyKazmir	1	808
How do I round numbers to the nearest multiple of 10 or 5 in the same cell? NOV705	by wickedchew	1	1,885
Combining SUMPRODUCT with IF - help! John Elford	by John Elford	1	1,543
Adding data to another table in database based on condition chrisjack001	by chrisjack001	0	954
help with macros? kaine	by Sepeteus Jedermann	1	918
delete row macro DeFautT	by Sepeteus Jedermann	1	1,522
How Determine If 2 Dates Are Within Range Of Years eikichionizuka	by eikichionizuka	3	1,519
[HELP] I need some help for vlookup ... harky	by Mazzaropi	1	1,025
Linking cell to filename littlecheets	by Sepeteus Jedermann	1	1,462
Small Decimal Won't Copy LarryAP	by Sepeteus Jedermann	1	1,252
How to establish as assumption Vonar	by Vonar	2	993
Create macro to start the time anwitha	by anwitha	0	1,781
combinations of numbers sum to a given amount? TimH	by Fortress	3	6,058
From Outlook to Excel Personal Folder Roy Hobbs	by Roy Hobbs	0	944
Ranking function doverfield	by wickedchew	6	1,458
Return value in table associated with next greatest fuji	by wickedchew	1	1,043
Finding most recent entry across multiple sheets CormacMurphy	by David of XL Plus	1	1,077
Change applied % after a certain value reached? LesB	by wickedchew	1	932
SUMIF Exclude Certain Cell Steph	by lio13	4	2,865
Macro to print filtered results JBRTaylor	by JBRTaylor	0	907
insert refreshable stock price no longer an option jbo	by Almogavar	1	1,714
Search one cell for same data in another cell dtime	by wickedchew	1	946
two-up cell display for date Johndem33	by walterharris	1	712
Sorting and counting cell gundesvan	by gundesvan	0	689
Football score gundesvan	by gundesvan	16	2,098
How to put this formula in percentage? wachinnai	by wachinnai	2	875
Averaging Sections of data ATC123	by wickedchew	1	731
Poll: Pull records based on name in more than 1 column manitouboat	by wickedchew	3	976