Excel Worksheet Functions - Page 47

Thread / Thread Starter	Last Post	Replies	Views
Copying "Exact" Function Nats_uk[_2_]	by Dave Peterson[_2_]	2	571
Repeat Sort in Excel 2007 Kevin K[_2_]	by Peter Lingenfelter	4	2,175
Formula to get date from text string Sara	by Roger Govier[_8_]	2	5,098
Which function will shorten IF-THEN-ELSE ? Jack Ryan	by Jack Ryan	0	635
Formula to obtain result from non exact sequence match The Hit Man	by The Hit man	2	904
Sum Formula dilemma - Can yu Solve? Tom	by ozgrid.com	3	599
question related to Data Vaildation Dharmesh[_2_]	by Ms-Exl-Learner	1	697
SUMIF using value from MOD function Steve Vincent	by T. Valko	2	1,570
How do I use advance filter correctly? David	by Ashish Mathur[_2_]	2	705
V Lookup and Multiple Values owl	by Ashish Mathur[_2_]	2	676
Auto updating muiltiple spreadsheets in Excel 2007 iBob	by Ron de Bruin	1	698
Why does forumula show in cell instead of formula result? Ashley	by Dave Peterson[_2_]	2	1,865
How do I calculate the 3 sigma of a number? OGWONE	by David Biddulph[_2_]	1	3,329
Linking multiple databases to one summary page BK	by BK	0	1,177
Excel Doc Carmelbeetle13	by Carmelbeetle13	0	533
Linking sheets which must update the date first. iBob	by iBob	0	496
count number of columns based on values across a row r2rcode	by Luke M[_4_]	1	1,329
Need help with if function Donna	by Donna	0	534
Can you hyperlink to a hyperlink? dalguypm	by Don Guillett[_2_]	1	488
Need help with if function Donna	by Luke M[_4_]	2	544
Looping Format Totoshi	by Totoshi	3	520
count the number of rows with entries greater than zero r2rcode	by Luke M[_4_]	1	1,878
excel dobbers	by Luke M[_4_]	1	560
circular formula gives different values jolly	by Luke M[_4_]	1	626
Find a number in a column then return a value from another cel Mark Dullingham	by Mark Dullingham	0	1,463
to find the difference between time Jogi	by ozgrid.com	2	939
Dropdown Query Dharmesh[_2_]	by ozgrid.com	1	622
Pivot from multiple sheets Radhakant Panigrahi	by Radhakant Panigrahi	0	538
LINECOLOUR CHANGE IN EXCEL WORKSHEET? khanal	by Jacob Skaria	3	725
Fixing a formula to read a general format? Zuo	by Per Jessen[_2_]	1	534
Copying text from multiple cells. Spearhead	by Gord Dibben	1	583
evaluate afdmello	by T. Valko	3	461
How to insert maths symbols into an excell function? Maths symbols on excell	by Billns	1	1,418
FUNCTION wilt	by Stan Brown	3	462
EXCEL-Numbers in Sequence The Gasell	by Herbert Seidenberg	3	1,088
FORMULA??? WILT	by Rick Rothstein	1	510
EXCELL Dewald van der Merwe	by Dewald van der Merwe	0	547
Cell Referencing WLMPilot	by WLMPilot	5	717
IN EXCEL GARRY	by Bernard Liengme[_2_]	1	647
How do I auto Expand a cell for printing only? Learning As I Go	by Dave Peterson[_2_]	1	686
Sort by Colour Colin Hayes	by bala_vb	3	649
how do you have the headings scroll down the page as you move dow Donna B	by bala_vb	2	2,452
Excel 2007 Error message when trying to record Macro Beth	by Manju Manjoo	1	1,591
Individual sheet protection in shared workbook Sunil Pradhan[_2_]	by Dennis	1	1,950
Search for cell value Jen_T	by Bernard Liengme[_2_]	3	604
Excel Formula to colourfill cells when condition met Ferdy	by Dave Peterson[_2_]	2	808
Multiple condition data validation IanC[_2_]	by IanC[_2_]	3	2,104
Totalling Subtotals Less Than 1 Mickey	by T. Valko	2	578
Find first and last cells in range, return info beside mjones	by T. Valko	3	1,377
Add across sheets by criteria sbrodginski	by T. Valko	3	972
Match Formula for three fields to produce result AHK	by T. Valko	5	947
Need help with CountIF function Flo	by Ashish Mathur[_2_]	2	668
#value! in linked document TamIam	by Ashish Mathur[_2_]	3	630
Column Lookup? Doug	by Chip Pearson	3	671
Date and Time Jen_T	by Chip Pearson	8	696
conditional count TimW	by Ashish Mathur[_2_]	4	638
Question using countif Tim JA	by Ashish Mathur[_2_]	11	1,368
if-then functions Becky	by Shane Devenshire[_2_]	2	604
Best 3 Consecutive Months Desoto	by Shane Devenshire[_2_]	13	1,641
COUNT FORMULA??? psd364	by Lars-Åke Aspelin[_4_]	6	549
Sorting in a Pivot Table unselected fields Marc	by Shane Devenshire[_2_]	1	809
How can I set a "page end" point on a large worksheet? kpetefaith	by Dave Peterson[_2_]	3	6,493
How to have Sheet1 list Sheet2 rows matching text? DevourU	by Naftoli	7	876
Delete previous cell content Craig	by Craig	2	710
Can a pivot table be redirected to an external source? KarenK	by bala_vb	2	1,051
if-then statements or functions Becky	by Nadine	3	661
Excel File Size Nadine	by Nadine	9	1,866
fv of a periodical unequal investment KEDIAANIL	by Fred Smith[_4_]	2	564
Limit Cell Content Bob Zimmerman	by T. Valko	4	1,008
convert 200701 to Jan-07 CW	by Gary''s Student	1	621
Replacing one text with three in IF(ISERROR(FIND.......Max Steve	by Steve	4	1,027
extract hyperlink with worksheet RRRYBAlex	by RRRYBAlex	0	747
Can I use a Reference inside a SUMIF or COUNTIF Function? Albie	by Glyn[_2_]	11	3,948
long printing on a plotter Jeff	by Luke M[_4_]	1	1,827
formula for visible cells jpstormy	by jpstormy	3	912