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,168
Match & Index Tekhnikos	by Pete_UK	6	360
Replace values with text Mark	by Pete_UK	1	476
=text(a1,"dddd") question Dylan @ UAFC[_2_]	by T. Valko	10	1,231
Calculate Interest Paid w/ Additional Payments to Principle RyanH	by OlegF	2	1,216
What function should I use Bonnie	by John[_22_]	4	407
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	496
Similar to Q re 2 Countifs, but Sumproduct doesn't work jtujague	by Bob Phillips[_3_]	1	388
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	340
Indirect Alternatives Graham H	by Graham H	4	885
Can I print a blank spreadsheet with gridlines rocky	by Zorro[_2_]	2	5,231
Unexpected Result Hardeep_kanwar[_2_]	by Hardeep_kanwar[_2_]	2	369
Conditional Formatting for dates Melissa44	by Glenn	6	577
How do I Calculate PI in an Excel formula? jollydottie	by Dana DeLouis	22	4,709
Fill Down command Question Bassplayer4x4	by David Biddulph[_2_]	2	630
Formatting text output within formulas Colin Hayes	by Pete_UK	1	495
Formula assistance TSA	by Bob Phillips[_3_]	4	467
Regression P-Value Function BG	by BG	2	2,351
Help with Category Set up Yossy	by Yossy	0	460
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	757
Subtotals Manos	by Suleman Peerzade[_2_]	1	365
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	450
intersection of two tabs in excel betsy	by Ashish Mathur[_2_]	3	1,102
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,386
What-if function JackieW67	by Ashish Mathur[_2_]	2	387
Offset Q Seanie	by T. Valko	6	507
Summing up Data Tom K[_2_]	by Tom K[_2_]	10	981
MAXIMUM # OF X VARIABLES USED FOR MULTIVARIATE REGRESSION? WA	by Jerry W. Lewis	4	3,797
Multiple Item Lookup Chad F	by Chad F[_2_]	33	2,324
Order of the Worksheet tabs across the bottom of the screen Rich Mogy	by Pete_UK	2	484
Workbook Compare utility Tim Zych	by Tim Zych	0	376
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,036
Cell click on one cell selects 2 or 3 cells? Loken	by Gord Dibben	2	2,137
Need to combine multiple cells into on cell papercut	by papercut	8	707
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,345
MROUND error showing tcek	by Jarek Kujawa[_2_]	7	623
autofilter dialog boxes - can i call this up in the Mr BT	by Héctor Miguel	3	495
continuos numbering within a cell automatic numbering	by Rick Rothstein	2	467
copy cells from multiple pages to one sheet w/ if statement GHall	by Otto Moehrbach[_2_]	8	532
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	629
Indirect Sum Joe L.	by Glenn	3	630
Data Validation - Excel 2007 Nadine	by Bernard Liengme	5	1,248
Rounding Question Art	by David Biddulph[_2_]	2	531
match values and return a third one dab	by xlmate	6	694
sheet name HELP PLEASE Mandy	by Mandy	2	351
Consolidate information from multiple pivot tables Clare	by Clare	2	884
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	979
SUMIF function problem Zorba	by David Biddulph[_2_]	6	3,329
Compring Dates? scoz	by Max	4	404
Like SUMIFS, but for multiplication??? EricC	by JE McGimpsey	3	1,969
call range by cell value Roland	by JBeaucaire[_90_]	1	807
Count Ranges Q Seanie	by Bob Phillips[_3_]	2	469
Word Wrap Not Working Nick Wakeham	by Nick Wakeham	0	746
need template for investor payback schedule Laura	by Laura	0	1,547
Amend year E[_2_]	by E[_2_]	4	582
Macro to update active workbook in one folder Mike @ GD	by Mike @ GD	8	601
Find text Tia[_3_]	by Glenn	1	445