Excel Worksheet Functions - Page 275

Thread / Thread Starter	Last Post	Replies	Views
function for accessing a database Paul	by Paul	2	647
SUMIF and SUM.NUMBER Rockbear	by Bob Phillips[_3_]	8	1,000
Lookup between two books CSmith	by Shane Devenshire[_2_]	2	828
Pivottable calculated item - how to suppress zero? HMallen	by HMallen	4	1,268
Numerical value of logicals hmm	by hmm	4	785
vlook up two column Hong	by Hong	4	839
Circular Christine[_3_]	by John C[_2_]	3	714
How to collapse Pivot table + icon Yossy	by Yossy	1	969
how to sum all values of a variable that's repeated multiple times NC	by Don Guillett	2	1,128
IF Formulas numbersgirl	by John C[_2_]	5	638
sumif function leaving a blank cell when criteria not met Andy H	by Andy H[_2_]	3	2,270
Macro for deleting rows and serialising the remaing rows Srinivasulu Bhattaram	by Don Guillett	1	1,132
Time and megabytes ACarella	by ACarella	4	853
Sumproduct automatically count number of rows [email protected]	by Ashish Mathur[_2_]	4	930
IF, AND, OR Function Tracey	by Pete_UK	9	634
sumif and numberif Rockbear	by Rockbear	2	538
IF... do nothing vdg_wdebroe[_2_]	by Satti Charvak[_2_]	1	652
Challenge for Anyone to take it on. SO CONFUSED	by Ron Rosenfeld	4	669
Sum values in columns based on values in named range Mikael Andersson	by Pete_UK	10	1,938
Conditional Formatting a drop down list a02227	by Joerg Mochikun	2	1,179
Extracting data from large text files for beginner [email protected]	by bosco_yip[_2_]	1	628
Index with 0 values in range Tang	by Tang	2	476
protect row of cells coltheplumb	by coltheplumb	2	525
how to accumulat the amounts of employees monies from worksheets ampe	by Shane Devenshire[_2_]	1	664
formula to make a running total for three different items ucastores	by Ashish Mathur[_2_]	1	745
EXCEL HYPERLINKS STOPPED WORKING i love my cat	by i love my cat[_2_]	4	2,795
Sharepoint Linked File Causing #Value Error PatK	by PatK	3	1,915
How do I add additional columns beyond column "IV"? Adding Columns	by Dave Peterson	1	1,324
Excel What Function shows value between highest and lowest number Mike R.[_2_]	by Joerg Mochikun	2	3,758
Viewing Names Colin Hayes	by Colin Hayes	3	713
Conditional if a date is valid Connie	by Shane Devenshire[_3_]	1	562
using the active cell as a reference in a function JFA	by JFA	5	1,077
Match and Tables [email protected]	by Ashish Mathur[_2_]	6	766
is this function correct? Honza	by Rick Rothstein	3	544
numbers convert to formula in csv SteveJ	by SteveJ	2	1,785
3d References AFD at FONO[_2_]	by mhoffmeier[_2_]	7	1,167
Inventory Tracking Sheet Bobby R.	by Bobby R.	2	1,206
IF formulas? Oliv3oyl	by ShaneDevenshire	7	584
Pivot pulling Multiple tabs terri	by terri	2	1,046
Isoloating particular senario from pivot table Christi	by Christi	2	501
Auto number Non null values jayceejay	by ShaneDevenshire	6	994
Rolling Average James	by James	2	664
Changing font color if conditions are met Bob	by Bob	4	1,266
How do I set up a counter to keep track of prited copies (2 pages. Mike	by David Biddulph[_2_]	1	567
How do you format a larger font for cell comments ? s-steege[_2_]	by ShaneDevenshire	1	1,273
Index and Match Alia	by T. Valko	3	561
Netwrokdays and EOMONTH Functions return N/A when opening Excel sh Prerna	by Prerna	3	715
CONVERTING NUMBERS TO TEXT Briggs	by Briggs	6	606
VLookup accross multiple worksheets jedman	by franciz	8	729
always calculate last 5 rows even after 1 inserted Picman	by Picman	9	790
Average of Vlookup data JAbels001	by T. Valko	3	788
Un-Synchronous Panes Jon	by Jon	3	684
Calculating Tax % Amin	by ShaneDevenshire	3	510
Pivot Table + Microsoft Query + Current Month THE_RAMONES	by ShaneDevenshire	1	1,049
Help with a Macro [email protected]	by [email protected]	2	524
Linking data between worksheets Pam S.	by Bernard Liengme	1	542
Complicated If Statement - I Think! Dee	by Bernard Liengme	5	575
formula help please tracker	by Glenn	1	539
How to load a worksheet from Internet into a worksheet? Eric	by Eric	3	611
Pasting comma delimited data OnTheEdge	by Dave Curtis	4	1,573
IF Function Kelly	by Ashish Mathur[_2_]	5	640
Average of group! TooN	by Ashish Mathur[_2_]	1	764
Problems using DMAX, DSUM, DAVERAGE with new table theresa	by Bob Phillips[_3_]	1	1,581
event vba irosh	by irosh	4	664
breaking a field out JCM	by Dave Curtis	3	684
Reference column climate	by climate	14	1,188
copy cells using formula Kashyap	by Kashyap	3	645
IF and OR statements bob	by T. Valko	1	486
Lookup less than a number Rod	by T. Valko	6	654
count if question gurmy77	by Ashish Mathur[_2_]	3	672
function to only show unique cells in range (e.g. B2:B20) OnTheEdge	by Ashish Mathur[_2_]	6	842
If statement only shows value in first cell Mea	by Ashish Mathur[_2_]	3	616
Expanding a named range jayceejay	by jayceejay	3	684
Need to find matching criteria in 1 column, then add amounts in a HeatherJ	by Ashish Mathur[_2_]	4	933
How to determine the value? Eric	by Teethless mama	2	568