Excel Worksheet Functions - Page 571

Thread / Thread Starter	Last Post	Replies	Views
Running Total Ashley	by Bernard Liengme	1	362
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	449
Getting a second page on a template.... Irene Fernandez	by JLatham	1	598
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	451
Price Lookup Joe Black	by T. Valko	13	1,097
Macro For Consolidating WorkBooks carl	by Max	1	538
Macro To consolidate All Open Workbooks Into One Workbook carl	by Anne Troy[_2_]	3	1,372
draw a floor plan to scale in excel MRPEDE	by Dave Peterson	5	1,748
Excel fomula xpert 1	by JE McGimpsey	3	344
count cells,containing text, based on more than one criteria? Sarfraz	by Domenic	1	687
Finding a count above average Don	by Domenic	1	571
What does the "&" do in a function? JPreeshl	by Ragdyer	5	384
Formula help lccubb	by lccubb	8	457
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	592
SUMPRODUCT I Think!! DP7	by Bob Umlas[_2_]	1	382
Comparing a column of names lorik	by T. Valko	1	408
Help to to create a Formula or Macro Dinesh	by Toppers	3	377
naming cells using insert name define Educating Rita	by John	2	742
Basic question about what formulas look at. Randy	by T. Valko	3	512
Need page number & total pages in worksheet - not header or footer vonzott	by Gord Dibben	1	1,059
How do I insert template in new sheet of pre-existing excel file? frustrated	by Gord Dibben	5	1,925
How to Insert Columns in a big Sheet... JV	by Paul B	2	834
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	522
When opening an excel file in Windows Explore, it opens to a grey. pwink44	by pwink44	2	1,207
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,272
Comparing multiple columns in two sheets [email protected]	by Lori	1	1,349
Problem with LOOKUP function J	by T. Valko	5	463
Index Match not working terri	by terri	2	1,027
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	716
Row Limitations and Functions Kirk P.	by Kirk P.	0	464
XIRR KC	by Ron Rosenfeld	3	1,058
Sumproduct (I think?) Sandy	by Sandy	5	423
Number of Months and Days between 2 dates? Jean	by JE McGimpsey	3	785
How do i "Sort" my Excel 2007 worksheet Parvaiz	by Parvaiz	3	1,032
sum/division calculation involving vlookup with array? markx	by markx	2	1,373
Macros gets disabled by default chakradhar	by Dave F	1	458
Countif SeanHooke	by Peo Sjoblom	2	346
Max (A1:A1), relating to other cells Mark Solesbury	by Pete_UK	2	529
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	494
Is it poss to have a double array in Excel 2003? Beads	by Philip J Smith	2	420
Count Number of Duplicate Occurances Scott Halper	by Scott Halper	7	561
Bar Graph [email protected]	by Philip J Smith	1	314
ctrl + tab (first in, first out history) with excel sheets? urlwolf	by Gary''s Student	4	712
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,059
Hlookup for row 3 and 4 dilettante	by dilettante	2	846
=(INDIRECT(ADDRESS(ROW(),#))) with SUMPRODUCT returning #VALUE! Brian Williams	by Brian Williams[_2_]	7	1,499
how to add different picture to each contact in database in Excel Shkol	by Shkol	0	524
Issue with "ToggleFormsDesign" a method of Excel workbook UK	by UK	0	606
saving macros in personal workbook porbeagle	by bj	1	460
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	458
shade cells based on conditions - i have more than 3 conditions Mo2	by T. Valko	3	1,196
How to determine the values from a list? Eric	by Eric	7	554
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,031
Multiplying specific data within a range to get column totals MsChief	by MsChief	2	643
A partial transpostion Grd	by Grd	2	366
Countif time S.C	by S.C	4	680
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	589
Convert phone to *** manjunath	by manjunath	2	463
Multiple workbook sheet numbers! JG[_2_]	by Dave Peterson	4	476
IF Logical Function & Blank Cells Jim	by JE McGimpsey	1	1,454
Insert Incremental sheet names in a workbook Sinner	by Dave Peterson	2	695