Excel Worksheet Functions - Page 406

Thread / Thread Starter	Last Post	Replies	Views
How do you calculate number of workdays from dates entered? [email protected]	by [email protected]	0	733
How to total rows in Excel with non-value cells like "included"? HR	by HR	2	733
Counting dates, within a list of dates jrheinschm	by Bob Phillips	7	733
Loan amortization schedule should have subtotals for each year Lianyi	by Fred Smith	2	733
Negative percent formula Bob	by Bob	2	733
how do I create a if-then formula? karen	by Andy Wiggins	1	733
Looking for formula index/match-type that returns an array Tom	by Duke Carey	1	733
Can you delete multiple worksheets with one command? pebel	by Gord Dibben	2	733
Multiple IF functions sonicj	by Michael	3	733
how can i fill a table with values from repeated regressions buragotch	by Tushar Mehta	4	733
Display material and activity lintan	by Frank Kabel	4	733
Pivot Not Updateing Steve	by Debra Dalgleish	6	733
sum offset question sd	by sd	5	733
Combining Defined Names to New Name For Validation TheSpankster22	by Frank Kabel	1	733
Inserting blank rows for missing data in order to transpose [email protected]	by Otto Moehrbach[_2_]	3	732
How sum numbers in the same cell and entry JC-PS	by Héctor Miguel	2	732
worksheet has numbers where the letters are on top of the columns Linda	by David Biddulph[_2_]	3	732
Account codes Gary	by Gary	9	732
CountIf Question Alpruett	by T. Valko	7	732
Search table for string return next columns value mikpits	by T. Valko	3	732
convert text to number in excel The IC Teacher	by ShaneDevenshire	8	732
date picker Andre ZA	by Gord Dibben	3	732
vlookup lloyd	by Jeff Gordon	10	732
Using IF function then Autofill-increments down a reference cell Twinspot	by Twinspot	2	732
Is there a way to make a link to a specific tab in excel? Carlee	by Send2Steph	6	732
Return value based on checkboxes selected -- IF() LOOKUP() William Horton	by William Horton	3	732
Copy entire row from another sheet onto first sheet if a unique text matches Smeghead	by Gizzmo	1	732
Looking up/Validating Info in database Lady Success	by Lady Success	2	732
Week Number. GEM	by Bernard Liengme	3	732
Deleting the text without deleting the formula gems04	by Gord Dibben	3	732
How do I change the sizes of individual cells not whole sheet? Loadsheet Maker	by Pete_UK	2	732
Consolidate Excel Data from multiple sheets into one rodw	by Herbert Seidenberg	1	732
Summing Values/Outputs of IF formulae shadesoflife	by T. Valko	10	732
using vlookup and hyperlink MJ	by MJ	6	732
Getting rid of Macro and Update Prompt Kat[_3_]	by Luke M	1	732
Formulas with dates loulou	by Luke M	3	732
hide columns on a protected sheet Rose	by Gord Dibben	2	732
If formula current/expired/blank Warren Jo	by Dana DeLouis[_3_]	3	732
Averaging Sections of data ATC123	by wickedchew	1	732
Formatting a two-variable data table via sarpi	by via sarpi	0	732
Return a Header Value with 2 vlookup criteria BDAvs	by isabelle	1	732
If and (and) formula to allow a zero answer inthestands	by Ken Wright	8	732
Setting All Worksheets To The Same Scroll Position wormdazzler	by Nick Hodge	2	732
how do i model discounts in excel solver Samir Syed	by Samir Syed	0	732
sumProduct (gimme a 1 if this is true, gimme the value) what is th Scott	by Max	8	732
Renaming Sequential Rows to create serial numbers forceten32	by Max	4	732
How to Append the Data to the Master Table Shiva	by Shiva	7	732
INDIRECT.EXT problem with missing worksheets Barb Reinhardt	by Ron Rosenfeld	7	732
Compare 2 columns, and create a list of items that are in both lists ruby2sdy	by Ashish Mathur	3	732
Can logical formulas be used to build accounts receivable workshe. Kev270	by Peo Sjoblom	2	732
return significant digits of a cell Chace	by Bernard Liengme	2	732
Vlookup with 3 or more conditions LondonLion	by Dave Peterson	1	732
If Then, not using values, or not counting blanks Need Help 123	by Max	8	732
calculate future date kevrgallagher	by Fred Smith	3	732
how do I add a calendar function to excel as a drop down? Dennis	by Ron de Bruin	1	732
Cannot enter formula in a cell after removing a circular formula Big Corona	by Big Corona	0	732
index / match function Lisa	by Peo Sjoblom	3	732
formatting numbers jonas	by Gord Dibben	3	732
vlookup and named ranges Domenic	by Domenic	0	732
advanced filter BorisS	by vezerid	1	732
Pivot Charts / Tables [email protected]	by Debra Dalgleish	1	732
Returning value next to the nth occurrence of a particular number. daikontim	by Ron Rosenfeld	4	732
Can a cell be set to accept input only once? Simple Gifts	by David McRitchie	1	732
merge 2 spreadsheets info to 1 JulesVern	by broro183	1	732
Using IF statement compare cell ID with data in another column tru connie	by connie	3	732
Virus error opening all files whipwil	by torbar	2	732
How on Earth do I use the GHK Function? Charles Matheson	by Ken Wright	3	732
forecasting Harry	by John Bundy	3	731
Sumproduct or lookup vito	by Jim	5	731
i need to generate a "distance" graph given x and y locations sneha	by sneha	8	731
fx="<="&B3 ?? Daniel	by Peo Sjoblom	3	731
Conditional formatting does not change when values change. ?? Texana	by Texana	4	731
how to identify unique list of 200 random entries from a list of 3 tjb	by Bernd P	3	731
how to find gst work sheets New User	by Bernard Liengme	1	731
If result of formula is "" (Blank) why is this considered a num. Frank Winston	by Harlan Grove	8	731