Excel Worksheet Functions - Page 246

Thread / Thread Starter	Last Post	Replies	Views
excel sheet bootom half sheet goes behind top part of sheet rob	by Gord Dibben	2	1,114
Match & Index Tekhnikos	by Pete_UK	6	355
Replace values with text Mark	by Pete_UK	1	452
=text(a1,"dddd") question Dylan @ UAFC[_2_]	by T. Valko	10	1,216
Calculate Interest Paid w/ Additional Payments to Principle RyanH	by OlegF	2	1,194
What function should I use Bonnie	by John[_22_]	4	392
Shortin my current formula TheKickerDude	by TheKickerDude	8	354
How do I set up worksheet tabs to change based on a workbook cell LJVG	by Otto Moehrbach[_2_]	1	481
Similar to Q re 2 Countifs, but Sumproduct doesn't work jtujague	by Bob Phillips[_3_]	1	379
Randomize cells in single column Guy[_2_]	by Guy[_2_]	2	576
Conditional Formatting alarson01	by Paul C	4	414
Can I use COUNTIF for 2 separate IF queries? Kerry	by Kerry	5	361
if query2- urgent requried deen	by Don Guillett	1	319
Indirect Alternatives Graham H	by Graham H	4	825
Can I print a blank spreadsheet with gridlines rocky	by Zorro[_2_]	2	5,215
Unexpected Result Hardeep_kanwar[_2_]	by Hardeep_kanwar[_2_]	2	353
Conditional Formatting for dates Melissa44	by Glenn	6	555
How do I Calculate PI in an Excel formula? jollydottie	by Dana DeLouis	22	4,604
Fill Down command Question Bassplayer4x4	by David Biddulph[_2_]	2	618
Formatting text output within formulas Colin Hayes	by Pete_UK	1	447
Formula assistance TSA	by Bob Phillips[_3_]	4	458
Regression P-Value Function BG	by BG	2	2,339
Help with Category Set up Yossy	by Yossy	0	445
XL2000: Depdendent Validations and IF Statement LPS	by Ashish Mathur[_2_]	3	447
Formula help? Tom	by Mike H	2	454
CHANGE CURRENCY TO ZAR lpplumbers	by David Biddulph[_2_]	1	739
Subtotals Manos	by Suleman Peerzade[_2_]	1	357
Many sheets combined on one Becca	by Suleman Peerzade[_2_]	2	328
VLOOKUP Rob H	by T. Valko	3	386
question about using MS Query in Excel Gina[_2_]	by Héctor Miguel	1	437
intersection of two tabs in excel betsy	by Ashish Mathur[_2_]	3	1,094
Formula help Tom	by T. Valko	2	457
Cond. Format Data Bars of range based on values of another range alexmo	by Fred Smith[_4_]	4	1,341
What-if function JackieW67	by Ashish Mathur[_2_]	2	379
Offset Q Seanie	by T. Valko	6	490
Summing up Data Tom K[_2_]	by Tom K[_2_]	10	964
MAXIMUM # OF X VARIABLES USED FOR MULTIVARIATE REGRESSION? WA	by Jerry W. Lewis	4	3,747
Multiple Item Lookup Chad F	by Chad F[_2_]	33	2,269
Order of the Worksheet tabs across the bottom of the screen Rich Mogy	by Pete_UK	2	466
Workbook Compare utility Tim Zych	by Tim Zych	0	365
Count rows with criteria from two columns? Bert Hyman	by T. Valko	3	442
WORKDAYS formula in excel Clareabella	by Ron Rosenfeld	9	861
Merge and Center in Excel Mykee Nodalo	by Marsh	2	870
Random Sort selected cells Guy[_2_]	by Guy[_2_]	4	1,015
Cell click on one cell selects 2 or 3 cells? Loken	by Gord Dibben	2	2,127
Need to combine multiple cells into on cell papercut	by papercut	8	664
Copy text msao	by msao	4	393
filters and quartile formula rwilliam	by rwilliam	0	1,794
Changing the result of a formula to a real number. coldindetroit	by Gord Dibben	2	1,329
MROUND error showing tcek	by Jarek Kujawa[_2_]	7	611
autofilter dialog boxes - can i call this up in the Mr BT	by Héctor Miguel	3	478
continuos numbering within a cell automatic numbering	by Rick Rothstein	2	458
copy cells from multiple pages to one sheet w/ if statement GHall	by Otto Moehrbach[_2_]	8	514
if query deen	by deen	0	319
Sum of 2 or 3 values in one cell, displayed in other cell csoumy	by Gord Dibben	4	393
HELP!!!!! Coje	by Simon Lloyd[_65_]	2	303
Finding the number of times a word is used in a range of cells Ray Hill	by Ray Hill	8	619
Indirect Sum Joe L.	by Glenn	3	613
Data Validation - Excel 2007 Nadine	by Bernard Liengme	5	1,224
Rounding Question Art	by David Biddulph[_2_]	2	520
match values and return a third one dab	by xlmate	6	676
sheet name HELP PLEASE Mandy	by Mandy	2	346
Consolidate information from multiple pivot tables Clare	by Clare	2	872
traffic light based on 3 different conditions [email protected]	by David Biddulph[_2_]	6	1,251
v-Lookup between values and give result -Help Yossy	by T. Valko	4	966
SUMIF function problem Zorba	by David Biddulph[_2_]	6	3,273
Compring Dates? scoz	by Max	4	391
Like SUMIFS, but for multiplication??? EricC	by JE McGimpsey	3	1,954
call range by cell value Roland	by JBeaucaire[_90_]	1	791
Count Ranges Q Seanie	by Bob Phillips[_3_]	2	450
Word Wrap Not Working Nick Wakeham	by Nick Wakeham	0	737
need template for investor payback schedule Laura	by Laura	0	1,535
Amend year E[_2_]	by E[_2_]	4	560
Macro to update active workbook in one folder Mike @ GD	by Mike @ GD	8	591
Find text Tia[_3_]	by Glenn	1	428