Excel Worksheet Functions - Page 571

Thread / Thread Starter	Last Post	Replies	Views
Running Total Ashley	by Bernard Liengme	1	361
Return an empty cell instead of "VALUE" rhhince[_2_]	by Teethless mama	2	1,076
Referencing another WB's cells, but not formulas/values. anna	by Fred Smith	3	448
Getting a second page on a template.... Irene Fernandez	by JLatham	1	597
Possible to create multiple-selection drop-down box in Excel? Jenty56	by Debra Dalgleish	1	604
Bringing conditional data from another Worksheet Nikki	by Toppers	2	450
Price Lookup Joe Black	by T. Valko	13	1,097
Macro For Consolidating WorkBooks carl	by Max	1	537
Macro To consolidate All Open Workbooks Into One Workbook carl	by Anne Troy[_2_]	3	1,371
draw a floor plan to scale in excel MRPEDE	by Dave Peterson	5	1,747
Excel fomula xpert 1	by JE McGimpsey	3	343
count cells,containing text, based on more than one criteria? Sarfraz	by Domenic	1	686
Finding a count above average Don	by Domenic	1	568
What does the "&" do in a function? JPreeshl	by Ragdyer	5	384
Formula help lccubb	by lccubb	8	449
Sumproduct does not work after editing data Jackie K	by Toppers	2	465
Using value stored in cell in formula Philip Gabe	by Bob Umlas[_2_]	1	591
SUMPRODUCT I Think!! DP7	by Bob Umlas[_2_]	1	380
Comparing a column of names lorik	by T. Valko	1	407
Help to to create a Formula or Macro Dinesh	by Toppers	3	375
naming cells using insert name define Educating Rita	by John	2	742
Basic question about what formulas look at. Randy	by T. Valko	3	511
Need page number & total pages in worksheet - not header or footer vonzott	by Gord Dibben	1	1,053
How do I insert template in new sheet of pre-existing excel file? frustrated	by Gord Dibben	5	1,924
How to Insert Columns in a big Sheet... JV	by Paul B	2	833
Converting numbers and number formatting to a CSV file ? Cecilia	by Gary''s Student	1	1,167
About Worksheets & Workbooks. Bharat	by Gary''s Student	1	515
When opening an excel file in Windows Explore, it opens to a grey. pwink44	by pwink44	2	1,200
Conditional formatting Constantly Amazed	by Toppers	9	491
If Statments: Want TRUE if a value = any of the given values Augabog	by T. Valko	4	1,269
Comparing multiple columns in two sheets [email protected]	by Lori	1	1,333
Problem with LOOKUP function J	by T. Valko	5	463
Index Match not working terri	by terri	2	1,026
Use find to select entire rows with a cell with that value Franky88	by Franky88	2	4,281
Using IF and MIN Teri	by Bob Phillips	4	517
date formula Dreamstar_1961	by T. Valko	5	452
which function do i need? Alison	by tim m	1	361
Approximate matches with vlookup? Keith R	by T. Valko	2	713
Row Limitations and Functions Kirk P.	by Kirk P.	0	458
XIRR KC	by Ron Rosenfeld	3	1,057
Sumproduct (I think?) Sandy	by Sandy	5	422
Number of Months and Days between 2 dates? Jean	by JE McGimpsey	3	764
How do i "Sort" my Excel 2007 worksheet Parvaiz	by Parvaiz	3	1,025
sum/division calculation involving vlookup with array? markx	by markx	2	1,362
Macros gets disabled by default chakradhar	by Dave F	1	457
Countif SeanHooke	by Peo Sjoblom	2	346
Max (A1:A1), relating to other cells Mark Solesbury	by Pete_UK	2	526
Multiple CountIF in 1 function JS[_2_]	by Peo Sjoblom	1	369
how to link excel worksheets with a reference (indexed) key field. reji	by Philip J Smith	1	493
Is it poss to have a double array in Excel 2003? Beads	by Philip J Smith	2	410
Count Number of Duplicate Occurances Scott Halper	by Scott Halper	7	561
Bar Graph [email protected]	by Philip J Smith	1	309
ctrl + tab (first in, first out history) with excel sheets? urlwolf	by Gary''s Student	4	709
Excel: # in a cell if a # is repeated in a row dilettante	by dilettante	2	508
Keyboard Shortcut for right-click on sheet tab Bhupinder Rayat	by Bhupinder Rayat	2	7,029
Hlookup for row 3 and 4 dilettante	by dilettante	2	840
=(INDIRECT(ADDRESS(ROW(),#))) with SUMPRODUCT returning #VALUE! Brian Williams	by Brian Williams[_2_]	7	1,493
how to add different picture to each contact in database in Excel Shkol	by Shkol	0	523
Issue with "ToggleFormsDesign" a method of Excel workbook UK	by UK	0	606
saving macros in personal workbook porbeagle	by bj	1	458
Finding the date using the number of the week in a year Bhupinder Rayat	by Bhupinder Rayat	2	886
Condition on Time Chris	by Chris	8	454
shade cells based on conditions - i have more than 3 conditions Mo2	by T. Valko	3	1,185
How to determine the values from a list? Eric	by Eric	7	552
How to search my past question ? Eric	by T. Valko	1	357
How to avoid duplicate string value input in one column? Wavelet	by T. Valko	1	1,030
Multiplying specific data within a range to get column totals MsChief	by MsChief	2	642
A partial transpostion Grd	by Grd	2	366
Countif time S.C	by S.C	4	679
VLLOKUP AND SPACES toolman	by T. Valko	3	348
SumIF column A = x and Column B = x OR x A Heeps	by Teethless mama	2	585
Convert phone to *** manjunath	by manjunath	2	460
Multiple workbook sheet numbers! JG[_2_]	by Dave Peterson	4	470
IF Logical Function & Blank Cells Jim	by JE McGimpsey	1	1,453
Insert Incremental sheet names in a workbook Sinner	by Dave Peterson	2	694