Excel Worksheet Functions - Page 512

Thread / Thread Starter	Last Post	Replies	Views
sumproduct - multiple conditions Marcotte A	by Peo Sjoblom	7	548
Summaryt Report Fritz	by HERZHIS	7	356
remove preceding zeros Bruce	by Roseygains	2	590
spreadsheets ray shoey	by Don Guillett	2	419
Unexpected #N/A error from INDEX-MATCH combo [email protected]	by [email protected]	2	1,151
Paste Specil function in excel 2003 malati	by Ron Coderre	1	559
separate an address street/city,state,zip within a cell? Puzzled	by Puzzled	6	2,525
Forecast and Trends steph44haf	by Colin Foster	5	801
Dynamic cell reference using INDIRECT.. [email protected][_2_]	by [email protected][_2_]	4	927
Preserve format, right tab using concatenate bearspa	by NickHK	1	637
my excel worksheet will not display gridlines jomba	by Pranav Vaidya	3	1,018
PLEASE HELP!! FORMULA TO RETURN A SHEETS NAME/REFERENCE. Chaz	by JLatham	4	769
Keeping column name in view when scrolling Geoman	by JLatham	2	1,129
R squared David	by David	11	1,412
calender S S	by Gord Dibben	1	445
Lookup values in 2 columns, count and then multiply??? HELP! DebbieV	by Pete_UK	4	872
Function explaination need hoachen	by Pete_UK	2	510
Formula displays, not value aramancam	by Kimo	7	556
RENAMING WORKSHEETS LEOPARDSHIDEAWAY	by Bob Phillips	1	527
Export data in cell as the subject line in an email BCassedy	by BCassedy	0	926
Month name to number of months YTD Tasha	by Sandy Mann	7	635
Date Formula Craig	by Craig	2	397
Trying to match up variables to a common list and confirm DebKnight56	by cheryl	12	1,053
Help with Index / Match function Livin	by ryguy7272	2	653
Trying to find Matches and Give a Result cheryl	by cheryl	5	811
Converting from Norwegian Krone to US Dollars format Jamie	by Peo Sjoblom	7	3,763
Workbook_BeforeClose Question Sashi	by Gord Dibben	7	696
Future Value Payment Series RogerManiccia@ebs	by RogerManiccia@ebs	0	660
VLOOKUP using two criteria Josh Johansen	by bj	6	2,272
Large Based on Criteria Peanut	by Peanut	4	648
Attn: Bob Phillips (or any expert!)... help with formula Toppers	by Roger Govier[_2_]	7	494
vlookup returning a value in more than one cell LTaylor	by Pete_UK	16	1,504
Excel 2003 Excel0247	by T. Valko	3	403
How do I total a long list of time calcs? dporter	by dporter	2	540
column alignment Bigmac	by Gord Dibben	1	494
Work Sheet failed to open fully & stuck at one cell only ScaredSoul	by Gord Dibben	3	1,269
Copying a formula which uses indirect() BarryL	by Harlan Grove	5	613
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	681
concatenate expression error philr	by Pranav Vaidya	2	614
Finding the value of x bpiepkorn	by John Bundy	4	1,019
IF dpal	by dpal	4	409
I want to use a link to return all data matching a criteria Dave	by Dave	2	625
How to merge data in Excel - one sheet to template sheet? Gabriela	by Gabriela	2	1,277
Vlookup returns #N/A correctly...but... Linda	by Ron Rosenfeld	5	533
How can Iextend a cell conditional formating to an entire line ? Luc Bongoy	by Max	2	586
Vlookup returns #N/A correctly...but...need formula in another col Linda	by Linda	0	696
Excel count based on value in another column Richhall	by Toppers	2	925
Worksheet Renaming Eric	by Mike H	1	500
Average with #div Alin Stanciu	by [email protected]	3	467
Rounding problems Ste101	by Pete_UK	6	526
TREND function for a polynomial fit results in a linear fit chenke01	by chenke01	2	1,167
Letters to represent numbers AlexG	by CLR	3	804
How to format cell to display "NIL" if value of cell is zero in Ex Suyog	by tomek gomek	3	1,532
Need to creat dependent drop down list manu	by papou	2	680
how do i separate 2 strings of a cell in different cells? Bona	by Toppers	1	735
DATE Jamal A M	by Toppers	2	349
How to calculate the Date occurs Blue Fish	by Blue Fish	2	520
assigning values to one cell which will change the formula in anot Darren	by Stephane Quenson	1	544
Need a formula, please! JessB	by Arvi Laanemets	3	405
Difference of two dates Zafar	by David Biddulph[_2_]	3	643
How to run a macro with the IF command deancarpenter	by deancarpenter	4	633
Average nesting within Sumproduct? Twishlist	by T. Valko	3	548
Sheet Background does not print Corey	by Corey	3	290
STDEV function on selected values Tetsuya Oguma	by Jerry W. Lewis	1	618
LOOKUP Formula Kimo	by T. Valko	15	1,141
Extracting Rows to Make A Totals Sheet Savage	by Max	5	612
Can excel list combinations BOJO	by Max	1	2,114
Function in objects. Anderflash	by Anderflash	5	523
Sorting dates Old Keith	by Old Keith	6	517
Graphs not updating MLK	by MLK	2	806
plus 1 alex	by Gord Dibben	10	828
Counting unique items based on date DKS	by Ron Coderre	19	1,436
Finding The MAX Value carl	by Jim Thomlinson	6	806
sum question Rebecca1	by Harlan Grove	2	433