Excel Worksheet Functions - Page 512

Thread / Thread Starter	Last Post	Replies	Views
sumproduct - multiple conditions Marcotte A	by Peo Sjoblom	7	535
Summaryt Report Fritz	by HERZHIS	7	354
remove preceding zeros Bruce	by Roseygains	2	575
spreadsheets ray shoey	by Don Guillett	2	419
Unexpected #N/A error from INDEX-MATCH combo [email protected]	by [email protected]	2	1,140
Paste Specil function in excel 2003 malati	by Ron Coderre	1	558
separate an address street/city,state,zip within a cell? Puzzled	by Puzzled	6	2,512
Forecast and Trends steph44haf	by Colin Foster	5	798
Dynamic cell reference using INDIRECT.. [email protected][_2_]	by [email protected][_2_]	4	914
Preserve format, right tab using concatenate bearspa	by NickHK	1	627
my excel worksheet will not display gridlines jomba	by Pranav Vaidya	3	997
PLEASE HELP!! FORMULA TO RETURN A SHEETS NAME/REFERENCE. Chaz	by JLatham	4	753
Keeping column name in view when scrolling Geoman	by JLatham	2	1,116
R squared David	by David	11	1,401
calender S S	by Gord Dibben	1	439
Lookup values in 2 columns, count and then multiply??? HELP! DebbieV	by Pete_UK	4	854
Function explaination need hoachen	by Pete_UK	2	495
Formula displays, not value aramancam	by Kimo	7	550
RENAMING WORKSHEETS LEOPARDSHIDEAWAY	by Bob Phillips	1	524
Export data in cell as the subject line in an email BCassedy	by BCassedy	0	912
Month name to number of months YTD Tasha	by Sandy Mann	7	624
Date Formula Craig	by Craig	2	396
Trying to match up variables to a common list and confirm DebKnight56	by cheryl	12	1,041
Help with Index / Match function Livin	by ryguy7272	2	648
Trying to find Matches and Give a Result cheryl	by cheryl	5	809
Converting from Norwegian Krone to US Dollars format Jamie	by Peo Sjoblom	7	3,759
Workbook_BeforeClose Question Sashi	by Gord Dibben	7	685
Future Value Payment Series RogerManiccia@ebs	by RogerManiccia@ebs	0	658
VLOOKUP using two criteria Josh Johansen	by bj	6	2,264
Large Based on Criteria Peanut	by Peanut	4	647
Attn: Bob Phillips (or any expert!)... help with formula Toppers	by Roger Govier[_2_]	7	493
vlookup returning a value in more than one cell LTaylor	by Pete_UK	16	1,494
Excel 2003 Excel0247	by T. Valko	3	402
How do I total a long list of time calcs? dporter	by dporter	2	528
column alignment Bigmac	by Gord Dibben	1	480
Work Sheet failed to open fully & stuck at one cell only ScaredSoul	by Gord Dibben	3	1,260
Copying a formula which uses indirect() BarryL	by Harlan Grove	5	607
Copy from one sheet to another nabanco	by Gord Dibben	3	346
Subtract a future month from the current month to get remaining m. Fletch	by Peo Sjoblom	1	675
concatenate expression error philr	by Pranav Vaidya	2	603
Finding the value of x bpiepkorn	by John Bundy	4	1,017
IF dpal	by dpal	4	408
I want to use a link to return all data matching a criteria Dave	by Dave	2	613
How to merge data in Excel - one sheet to template sheet? Gabriela	by Gabriela	2	1,234
Vlookup returns #N/A correctly...but... Linda	by Ron Rosenfeld	5	525
How can Iextend a cell conditional formating to an entire line ? Luc Bongoy	by Max	2	573
Vlookup returns #N/A correctly...but...need formula in another col Linda	by Linda	0	684
Excel count based on value in another column Richhall	by Toppers	2	922
Worksheet Renaming Eric	by Mike H	1	498
Average with #div Alin Stanciu	by [email protected]	3	463
Rounding problems Ste101	by Pete_UK	6	518
TREND function for a polynomial fit results in a linear fit chenke01	by chenke01	2	1,156
Letters to represent numbers AlexG	by CLR	3	786
How to format cell to display "NIL" if value of cell is zero in Ex Suyog	by tomek gomek	3	1,517
Need to creat dependent drop down list manu	by papou	2	672
how do i separate 2 strings of a cell in different cells? Bona	by Toppers	1	726
DATE Jamal A M	by Toppers	2	346
How to calculate the Date occurs Blue Fish	by Blue Fish	2	508
assigning values to one cell which will change the formula in anot Darren	by Stephane Quenson	1	542
Need a formula, please! JessB	by Arvi Laanemets	3	405
Difference of two dates Zafar	by David Biddulph[_2_]	3	634
How to run a macro with the IF command deancarpenter	by deancarpenter	4	625
Average nesting within Sumproduct? Twishlist	by T. Valko	3	538
Sheet Background does not print Corey	by Corey	3	290
STDEV function on selected values Tetsuya Oguma	by Jerry W. Lewis	1	609
LOOKUP Formula Kimo	by T. Valko	15	1,138
Extracting Rows to Make A Totals Sheet Savage	by Max	5	602
Can excel list combinations BOJO	by Max	1	2,112
Function in objects. Anderflash	by Anderflash	5	516
Sorting dates Old Keith	by Old Keith	6	505
Graphs not updating MLK	by MLK	2	794
plus 1 alex	by Gord Dibben	10	828
Counting unique items based on date DKS	by Ron Coderre	19	1,423
Finding The MAX Value carl	by Jim Thomlinson	6	794
sum question Rebecca1	by Harlan Grove	2	420