Excel Worksheet Functions - Page 275

Thread / Thread Starter	Last Post	Replies	Views
function for accessing a database Paul	by Paul	2	652
SUMIF and SUM.NUMBER Rockbear	by Bob Phillips[_3_]	8	1,012
Lookup between two books CSmith	by Shane Devenshire[_2_]	2	831
Pivottable calculated item - how to suppress zero? HMallen	by HMallen	4	1,278
Numerical value of logicals hmm	by hmm	4	793
vlook up two column Hong	by Hong	4	848
Circular Christine[_3_]	by John C[_2_]	3	718
How to collapse Pivot table + icon Yossy	by Yossy	1	975
how to sum all values of a variable that's repeated multiple times NC	by Don Guillett	2	1,129
IF Formulas numbersgirl	by John C[_2_]	5	649
sumif function leaving a blank cell when criteria not met Andy H	by Andy H[_2_]	3	2,277
Macro for deleting rows and serialising the remaing rows Srinivasulu Bhattaram	by Don Guillett	1	1,133
Time and megabytes ACarella	by ACarella	4	856
Sumproduct automatically count number of rows [email protected]	by Ashish Mathur[_2_]	4	937
IF, AND, OR Function Tracey	by Pete_UK	9	641
sumif and numberif Rockbear	by Rockbear	2	543
IF... do nothing vdg_wdebroe[_2_]	by Satti Charvak[_2_]	1	662
Challenge for Anyone to take it on. SO CONFUSED	by Ron Rosenfeld	4	672
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,184
Extracting data from large text files for beginner [email protected]	by bosco_yip[_2_]	1	637
Index with 0 values in range Tang	by Tang	2	486
protect row of cells coltheplumb	by coltheplumb	2	532
how to accumulat the amounts of employees monies from worksheets ampe	by Shane Devenshire[_2_]	1	665
formula to make a running total for three different items ucastores	by Ashish Mathur[_2_]	1	752
EXCEL HYPERLINKS STOPPED WORKING i love my cat	by i love my cat[_2_]	4	2,796
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,334
Excel What Function shows value between highest and lowest number Mike R.[_2_]	by Joerg Mochikun	2	3,766
Viewing Names Colin Hayes	by Colin Hayes	3	723
Conditional if a date is valid Connie	by Shane Devenshire[_3_]	1	569
using the active cell as a reference in a function JFA	by JFA	5	1,078
Match and Tables [email protected]	by Ashish Mathur[_2_]	6	766
is this function correct? Honza	by Rick Rothstein	3	553
numbers convert to formula in csv SteveJ	by SteveJ	2	1,793
3d References AFD at FONO[_2_]	by mhoffmeier[_2_]	7	1,172
Inventory Tracking Sheet Bobby R.	by Bobby R.	2	1,208
IF formulas? Oliv3oyl	by ShaneDevenshire	7	595
Pivot pulling Multiple tabs terri	by terri	2	1,046
Isoloating particular senario from pivot table Christi	by Christi	2	505
Auto number Non null values jayceejay	by ShaneDevenshire	6	1,004
Rolling Average James	by James	2	674
Changing font color if conditions are met Bob	by Bob	4	1,271
How do I set up a counter to keep track of prited copies (2 pages. Mike	by David Biddulph[_2_]	1	578
How do you format a larger font for cell comments ? s-steege[_2_]	by ShaneDevenshire	1	1,277
Index and Match Alia	by T. Valko	3	567
Netwrokdays and EOMONTH Functions return N/A when opening Excel sh Prerna	by Prerna	3	721
CONVERTING NUMBERS TO TEXT Briggs	by Briggs	6	616
VLookup accross multiple worksheets jedman	by franciz	8	731
always calculate last 5 rows even after 1 inserted Picman	by Picman	9	801
Average of Vlookup data JAbels001	by T. Valko	3	798
Un-Synchronous Panes Jon	by Jon	3	694
Calculating Tax % Amin	by ShaneDevenshire	3	513
Pivot Table + Microsoft Query + Current Month THE_RAMONES	by ShaneDevenshire	1	1,057
Help with a Macro [email protected]	by [email protected]	2	531
Linking data between worksheets Pam S.	by Bernard Liengme	1	548
Complicated If Statement - I Think! Dee	by Bernard Liengme	5	585
formula help please tracker	by Glenn	1	544
How to load a worksheet from Internet into a worksheet? Eric	by Eric	3	615
Pasting comma delimited data OnTheEdge	by Dave Curtis	4	1,573
IF Function Kelly	by Ashish Mathur[_2_]	5	650
Average of group! TooN	by Ashish Mathur[_2_]	1	774
Problems using DMAX, DSUM, DAVERAGE with new table theresa	by Bob Phillips[_3_]	1	1,582
event vba irosh	by irosh	4	665
breaking a field out JCM	by Dave Curtis	3	687
Reference column climate	by climate	14	1,195
copy cells using formula Kashyap	by Kashyap	3	645
IF and OR statements bob	by T. Valko	1	491
Lookup less than a number Rod	by T. Valko	6	659
count if question gurmy77	by Ashish Mathur[_2_]	3	676
function to only show unique cells in range (e.g. B2:B20) OnTheEdge	by Ashish Mathur[_2_]	6	850
If statement only shows value in first cell Mea	by Ashish Mathur[_2_]	3	622
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	942
How to determine the value? Eric	by Teethless mama	2	570