Excel Worksheet Functions - Page 512

Thread / Thread Starter	Last Post	Replies	Views
sumproduct - multiple conditions Marcotte A	by Peo Sjoblom	7	504
Summaryt Report Fritz	by HERZHIS	7	344
remove preceding zeros Bruce	by Roseygains	2	555
spreadsheets ray shoey	by Don Guillett	2	408
Unexpected #N/A error from INDEX-MATCH combo [email protected]	by [email protected]	2	1,127
Paste Specil function in excel 2003 malati	by Ron Coderre	1	548
separate an address street/city,state,zip within a cell? Puzzled	by Puzzled	6	2,472
Forecast and Trends steph44haf	by Colin Foster	5	778
Dynamic cell reference using INDIRECT.. [email protected][_2_]	by [email protected][_2_]	4	890
Preserve format, right tab using concatenate bearspa	by NickHK	1	617
my excel worksheet will not display gridlines jomba	by Pranav Vaidya	3	980
PLEASE HELP!! FORMULA TO RETURN A SHEETS NAME/REFERENCE. Chaz	by JLatham	4	726
Keeping column name in view when scrolling Geoman	by JLatham	2	1,099
R squared David	by David	11	1,380
calender S S	by Gord Dibben	1	421
Lookup values in 2 columns, count and then multiply??? HELP! DebbieV	by Pete_UK	4	836
Function explaination need hoachen	by Pete_UK	2	481
Formula displays, not value aramancam	by Kimo	7	542
RENAMING WORKSHEETS LEOPARDSHIDEAWAY	by Bob Phillips	1	500
Export data in cell as the subject line in an email BCassedy	by BCassedy	0	892
Month name to number of months YTD Tasha	by Sandy Mann	7	607
Date Formula Craig	by Craig	2	382
Trying to match up variables to a common list and confirm DebKnight56	by cheryl	12	1,022
Help with Index / Match function Livin	by ryguy7272	2	625
Trying to find Matches and Give a Result cheryl	by cheryl	5	798
Converting from Norwegian Krone to US Dollars format Jamie	by Peo Sjoblom	7	3,704
Workbook_BeforeClose Question Sashi	by Gord Dibben	7	664
Future Value Payment Series RogerManiccia@ebs	by RogerManiccia@ebs	0	643
VLOOKUP using two criteria Josh Johansen	by bj	6	2,243
Large Based on Criteria Peanut	by Peanut	4	637
Attn: Bob Phillips (or any expert!)... help with formula Toppers	by Roger Govier[_2_]	7	482
vlookup returning a value in more than one cell LTaylor	by Pete_UK	16	1,458
Excel 2003 Excel0247	by T. Valko	3	386
How do I total a long list of time calcs? dporter	by dporter	2	511
column alignment Bigmac	by Gord Dibben	1	461
Work Sheet failed to open fully & stuck at one cell only ScaredSoul	by Gord Dibben	3	1,247
Copying a formula which uses indirect() BarryL	by Harlan Grove	5	595
Copy from one sheet to another nabanco	by Gord Dibben	3	331
Subtract a future month from the current month to get remaining m. Fletch	by Peo Sjoblom	1	653
concatenate expression error philr	by Pranav Vaidya	2	571
Finding the value of x bpiepkorn	by John Bundy	4	967
IF dpal	by dpal	4	398
I want to use a link to return all data matching a criteria Dave	by Dave	2	594
How to merge data in Excel - one sheet to template sheet? Gabriela	by Gabriela	2	1,207
Vlookup returns #N/A correctly...but... Linda	by Ron Rosenfeld	5	510
How can Iextend a cell conditional formating to an entire line ? Luc Bongoy	by Max	2	542
Vlookup returns #N/A correctly...but...need formula in another col Linda	by Linda	0	663
Excel count based on value in another column Richhall	by Toppers	2	911
Worksheet Renaming Eric	by Mike H	1	474
Average with #div Alin Stanciu	by [email protected]	3	450
Rounding problems Ste101	by Pete_UK	6	506
TREND function for a polynomial fit results in a linear fit chenke01	by chenke01	2	1,137
Letters to represent numbers AlexG	by CLR	3	767
How to format cell to display "NIL" if value of cell is zero in Ex Suyog	by tomek gomek	3	1,494
Need to creat dependent drop down list manu	by papou	2	659
how do i separate 2 strings of a cell in different cells? Bona	by Toppers	1	708
DATE Jamal A M	by Toppers	2	338
How to calculate the Date occurs Blue Fish	by Blue Fish	2	478
assigning values to one cell which will change the formula in anot Darren	by Stephane Quenson	1	529
Need a formula, please! JessB	by Arvi Laanemets	3	397
Difference of two dates Zafar	by David Biddulph[_2_]	3	621
How to run a macro with the IF command deancarpenter	by deancarpenter	4	603
Average nesting within Sumproduct? Twishlist	by T. Valko	3	519
Sheet Background does not print Corey	by Corey	3	290
STDEV function on selected values Tetsuya Oguma	by Jerry W. Lewis	1	588
LOOKUP Formula Kimo	by T. Valko	15	1,121
Extracting Rows to Make A Totals Sheet Savage	by Max	5	586
Can excel list combinations BOJO	by Max	1	2,095
Function in objects. Anderflash	by Anderflash	5	503
Sorting dates Old Keith	by Old Keith	6	482
Graphs not updating MLK	by MLK	2	768
plus 1 alex	by Gord Dibben	10	802
Counting unique items based on date DKS	by Ron Coderre	19	1,398
Finding The MAX Value carl	by Jim Thomlinson	6	773
sum question Rebecca1	by Harlan Grove	2	407