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,169
Match & Index Tekhnikos	by Pete_UK	6	361
Replace values with text Mark	by Pete_UK	1	483
=text(a1,"dddd") question Dylan @ UAFC[_2_]	by T. Valko	10	1,236
Calculate Interest Paid w/ Additional Payments to Principle RyanH	by OlegF	2	1,223
What function should I use Bonnie	by John[_22_]	4	408
Shortin my current formula TheKickerDude	by TheKickerDude	8	368
How do I set up worksheet tabs to change based on a workbook cell LJVG	by Otto Moehrbach[_2_]	1	506
Similar to Q re 2 Countifs, but Sumproduct doesn't work jtujague	by Bob Phillips[_3_]	1	396
Randomize cells in single column Guy[_2_]	by Guy[_2_]	2	584
Conditional Formatting alarson01	by Paul C	4	425
Can I use COUNTIF for 2 separate IF queries? Kerry	by Kerry	5	373
if query2- urgent requried deen	by Don Guillett	1	350
Indirect Alternatives Graham H	by Graham H	4	890
Can I print a blank spreadsheet with gridlines rocky	by Zorro[_2_]	2	5,239
Unexpected Result Hardeep_kanwar[_2_]	by Hardeep_kanwar[_2_]	2	380
Conditional Formatting for dates Melissa44	by Glenn	6	577
How do I Calculate PI in an Excel formula? jollydottie	by Dana DeLouis	22	4,719
Fill Down command Question Bassplayer4x4	by David Biddulph[_2_]	2	639
Formatting text output within formulas Colin Hayes	by Pete_UK	1	503
Formula assistance TSA	by Bob Phillips[_3_]	4	470
Regression P-Value Function BG	by BG	2	2,361
Help with Category Set up Yossy	by Yossy	0	463
XL2000: Depdendent Validations and IF Statement LPS	by Ashish Mathur[_2_]	3	457
Formula help? Tom	by Mike H	2	462
CHANGE CURRENCY TO ZAR lpplumbers	by David Biddulph[_2_]	1	759
Subtotals Manos	by Suleman Peerzade[_2_]	1	366
Many sheets combined on one Becca	by Suleman Peerzade[_2_]	2	336
VLOOKUP Rob H	by T. Valko	3	390
question about using MS Query in Excel Gina[_2_]	by Héctor Miguel	1	457
intersection of two tabs in excel betsy	by Ashish Mathur[_2_]	3	1,109
Formula help Tom	by T. Valko	2	477
Cond. Format Data Bars of range based on values of another range alexmo	by Fred Smith[_4_]	4	1,387
What-if function JackieW67	by Ashish Mathur[_2_]	2	388
Offset Q Seanie	by T. Valko	6	518
Summing up Data Tom K[_2_]	by Tom K[_2_]	10	987
MAXIMUM # OF X VARIABLES USED FOR MULTIVARIATE REGRESSION? WA	by Jerry W. Lewis	4	3,807
Multiple Item Lookup Chad F	by Chad F[_2_]	33	2,334
Order of the Worksheet tabs across the bottom of the screen Rich Mogy	by Pete_UK	2	490
Workbook Compare utility Tim Zych	by Tim Zych	0	382
Count rows with criteria from two columns? Bert Hyman	by T. Valko	3	458
WORKDAYS formula in excel Clareabella	by Ron Rosenfeld	9	873
Merge and Center in Excel Mykee Nodalo	by Marsh	2	888
Random Sort selected cells Guy[_2_]	by Guy[_2_]	4	1,044
Cell click on one cell selects 2 or 3 cells? Loken	by Gord Dibben	2	2,144
Need to combine multiple cells into on cell papercut	by papercut	8	717
Copy text msao	by msao	4	403
filters and quartile formula rwilliam	by rwilliam	0	1,810
Changing the result of a formula to a real number. coldindetroit	by Gord Dibben	2	1,355
MROUND error showing tcek	by Jarek Kujawa[_2_]	7	632
autofilter dialog boxes - can i call this up in the Mr BT	by Héctor Miguel	3	503
continuos numbering within a cell automatic numbering	by Rick Rothstein	2	476
copy cells from multiple pages to one sheet w/ if statement GHall	by Otto Moehrbach[_2_]	8	539
if query deen	by deen	0	326
Sum of 2 or 3 values in one cell, displayed in other cell csoumy	by Gord Dibben	4	400
HELP!!!!! Coje	by Simon Lloyd[_65_]	2	318
Finding the number of times a word is used in a range of cells Ray Hill	by Ray Hill	8	639
Indirect Sum Joe L.	by Glenn	3	635
Data Validation - Excel 2007 Nadine	by Bernard Liengme	5	1,259
Rounding Question Art	by David Biddulph[_2_]	2	540
match values and return a third one dab	by xlmate	6	704
sheet name HELP PLEASE Mandy	by Mandy	2	351
Consolidate information from multiple pivot tables Clare	by Clare	2	892
traffic light based on 3 different conditions [email protected]	by David Biddulph[_2_]	6	1,257
v-Lookup between values and give result -Help Yossy	by T. Valko	4	986
SUMIF function problem Zorba	by David Biddulph[_2_]	6	3,339
Compring Dates? scoz	by Max	4	404
Like SUMIFS, but for multiplication??? EricC	by JE McGimpsey	3	1,972
call range by cell value Roland	by JBeaucaire[_90_]	1	814
Count Ranges Q Seanie	by Bob Phillips[_3_]	2	477
Word Wrap Not Working Nick Wakeham	by Nick Wakeham	0	756
need template for investor payback schedule Laura	by Laura	0	1,549
Amend year E[_2_]	by E[_2_]	4	583
Macro to update active workbook in one folder Mike @ GD	by Mike @ GD	8	609
Find text Tia[_3_]	by Glenn	1	445