Excel Worksheet Functions - Page 571

Thread / Thread Starter	Last Post	Replies	Views
Running Total Ashley	by Bernard Liengme	1	371
Return an empty cell instead of "VALUE" rhhince[_2_]	by Teethless mama	2	1,088
Referencing another WB's cells, but not formulas/values. anna	by Fred Smith	3	461
Getting a second page on a template.... Irene Fernandez	by JLatham	1	607
Possible to create multiple-selection drop-down box in Excel? Jenty56	by Debra Dalgleish	1	617
Bringing conditional data from another Worksheet Nikki	by Toppers	2	463
Price Lookup Joe Black	by T. Valko	13	1,100
Macro For Consolidating WorkBooks carl	by Max	1	549
Macro To consolidate All Open Workbooks Into One Workbook carl	by Anne Troy[_2_]	3	1,379
draw a floor plan to scale in excel MRPEDE	by Dave Peterson	5	1,756
Excel fomula xpert 1	by JE McGimpsey	3	351
count cells,containing text, based on more than one criteria? Sarfraz	by Domenic	1	697
Finding a count above average Don	by Domenic	1	582
What does the "&" do in a function? JPreeshl	by Ragdyer	5	389
Formula help lccubb	by lccubb	8	469
Sumproduct does not work after editing data Jackie K	by Toppers	2	473
Using value stored in cell in formula Philip Gabe	by Bob Umlas[_2_]	1	605
SUMPRODUCT I Think!! DP7	by Bob Umlas[_2_]	1	385
Comparing a column of names lorik	by T. Valko	1	417
Help to to create a Formula or Macro Dinesh	by Toppers	3	391
naming cells using insert name define Educating Rita	by John	2	753
Basic question about what formulas look at. Randy	by T. Valko	3	521
Need page number & total pages in worksheet - not header or footer vonzott	by Gord Dibben	1	1,066
How do I insert template in new sheet of pre-existing excel file? frustrated	by Gord Dibben	5	1,938
How to Insert Columns in a big Sheet... JV	by Paul B	2	847
Converting numbers and number formatting to a CSV file ? Cecilia	by Gary''s Student	1	1,175
About Worksheets & Workbooks. Bharat	by Gary''s Student	1	522
When opening an excel file in Windows Explore, it opens to a grey. pwink44	by pwink44	2	1,222
Conditional formatting Constantly Amazed	by Toppers	9	501
If Statments: Want TRUE if a value = any of the given values Augabog	by T. Valko	4	1,286
Comparing multiple columns in two sheets [email protected]	by Lori	1	1,358
Problem with LOOKUP function J	by T. Valko	5	472
Index Match not working terri	by terri	2	1,040
Use find to select entire rows with a cell with that value Franky88	by Franky88	2	4,291
Using IF and MIN Teri	by Bob Phillips	4	527
date formula Dreamstar_1961	by T. Valko	5	464
which function do i need? Alison	by tim m	1	374
Approximate matches with vlookup? Keith R	by T. Valko	2	716
Row Limitations and Functions Kirk P.	by Kirk P.	0	471
XIRR KC	by Ron Rosenfeld	3	1,070
Sumproduct (I think?) Sandy	by Sandy	5	424
Number of Months and Days between 2 dates? Jean	by JE McGimpsey	3	792
How do i "Sort" my Excel 2007 worksheet Parvaiz	by Parvaiz	3	1,041
sum/division calculation involving vlookup with array? markx	by markx	2	1,384
Macros gets disabled by default chakradhar	by Dave F	1	470
Countif SeanHooke	by Peo Sjoblom	2	359
Max (A1:A1), relating to other cells Mark Solesbury	by Pete_UK	2	538
Multiple CountIF in 1 function JS[_2_]	by Peo Sjoblom	1	381
how to link excel worksheets with a reference (indexed) key field. reji	by Philip J Smith	1	509
Is it poss to have a double array in Excel 2003? Beads	by Philip J Smith	2	440
Count Number of Duplicate Occurances Scott Halper	by Scott Halper	7	574
Bar Graph [email protected]	by Philip J Smith	1	324
ctrl + tab (first in, first out history) with excel sheets? urlwolf	by Gary''s Student	4	722
Excel: # in a cell if a # is repeated in a row dilettante	by dilettante	2	520
Keyboard Shortcut for right-click on sheet tab Bhupinder Rayat	by Bhupinder Rayat	2	7,079
Hlookup for row 3 and 4 dilettante	by dilettante	2	854
=(INDIRECT(ADDRESS(ROW(),#))) with SUMPRODUCT returning #VALUE! Brian Williams	by Brian Williams[_2_]	7	1,510
how to add different picture to each contact in database in Excel Shkol	by Shkol	0	531
Issue with "ToggleFormsDesign" a method of Excel workbook UK	by UK	0	614
saving macros in personal workbook porbeagle	by bj	1	467
Finding the date using the number of the week in a year Bhupinder Rayat	by Bhupinder Rayat	2	896
Condition on Time Chris	by Chris	8	464
shade cells based on conditions - i have more than 3 conditions Mo2	by T. Valko	3	1,208
How to determine the values from a list? Eric	by Eric	7	566
How to search my past question ? Eric	by T. Valko	1	364
How to avoid duplicate string value input in one column? Wavelet	by T. Valko	1	1,041
Multiplying specific data within a range to get column totals MsChief	by MsChief	2	654
A partial transpostion Grd	by Grd	2	379
Countif time S.C	by S.C	4	692
VLLOKUP AND SPACES toolman	by T. Valko	3	358
SumIF column A = x and Column B = x OR x A Heeps	by Teethless mama	2	598
Convert phone to *** manjunath	by manjunath	2	463
Multiple workbook sheet numbers! JG[_2_]	by Dave Peterson	4	487
IF Logical Function & Blank Cells Jim	by JE McGimpsey	1	1,465
Insert Incremental sheet names in a workbook Sinner	by Dave Peterson	2	708