Excel Worksheet Functions - Page 275

Thread / Thread Starter	Last Post	Replies	Views
function for accessing a database Paul	by Paul	2	637
SUMIF and SUM.NUMBER Rockbear	by Bob Phillips[_3_]	8	992
Lookup between two books CSmith	by Shane Devenshire[_2_]	2	819
Pivottable calculated item - how to suppress zero? HMallen	by HMallen	4	1,244
Numerical value of logicals hmm	by hmm	4	770
vlook up two column Hong	by Hong	4	826
Circular Christine[_3_]	by John C[_2_]	3	706
How to collapse Pivot table + icon Yossy	by Yossy	1	960
how to sum all values of a variable that's repeated multiple times NC	by Don Guillett	2	1,120
IF Formulas numbersgirl	by John C[_2_]	5	630
sumif function leaving a blank cell when criteria not met Andy H	by Andy H[_2_]	3	2,246
Macro for deleting rows and serialising the remaing rows Srinivasulu Bhattaram	by Don Guillett	1	1,089
Time and megabytes ACarella	by ACarella	4	837
Sumproduct automatically count number of rows [email protected]	by Ashish Mathur[_2_]	4	916
IF, AND, OR Function Tracey	by Pete_UK	9	627
sumif and numberif Rockbear	by Rockbear	2	534
IF... do nothing vdg_wdebroe[_2_]	by Satti Charvak[_2_]	1	646
Challenge for Anyone to take it on. SO CONFUSED	by Ron Rosenfeld	4	662
Sum values in columns based on values in named range Mikael Andersson	by Pete_UK	10	1,921
Conditional Formatting a drop down list a02227	by Joerg Mochikun	2	1,158
Extracting data from large text files for beginner [email protected]	by bosco_yip[_2_]	1	619
Index with 0 values in range Tang	by Tang	2	473
protect row of cells coltheplumb	by coltheplumb	2	517
how to accumulat the amounts of employees monies from worksheets ampe	by Shane Devenshire[_2_]	1	653
formula to make a running total for three different items ucastores	by Ashish Mathur[_2_]	1	735
EXCEL HYPERLINKS STOPPED WORKING i love my cat	by i love my cat[_2_]	4	2,680
Sharepoint Linked File Causing #Value Error PatK	by PatK	3	1,874
How do I add additional columns beyond column "IV"? Adding Columns	by Dave Peterson	1	1,317
Excel What Function shows value between highest and lowest number Mike R.[_2_]	by Joerg Mochikun	2	3,694
Viewing Names Colin Hayes	by Colin Hayes	3	708
Conditional if a date is valid Connie	by Shane Devenshire[_3_]	1	556
using the active cell as a reference in a function JFA	by JFA	5	1,045
Match and Tables [email protected]	by Ashish Mathur[_2_]	6	750
is this function correct? Honza	by Rick Rothstein	3	528
numbers convert to formula in csv SteveJ	by SteveJ	2	1,765
3d References AFD at FONO[_2_]	by mhoffmeier[_2_]	7	1,154
Inventory Tracking Sheet Bobby R.	by Bobby R.	2	1,186
IF formulas? Oliv3oyl	by ShaneDevenshire	7	574
Pivot pulling Multiple tabs terri	by terri	2	1,031
Isoloating particular senario from pivot table Christi	by Christi	2	491
Auto number Non null values jayceejay	by ShaneDevenshire	6	984
Rolling Average James	by James	2	655
Changing font color if conditions are met Bob	by Bob	4	1,255
How do I set up a counter to keep track of prited copies (2 pages. Mike	by David Biddulph[_2_]	1	563
How do you format a larger font for cell comments ? s-steege[_2_]	by ShaneDevenshire	1	1,262
Index and Match Alia	by T. Valko	3	551
Netwrokdays and EOMONTH Functions return N/A when opening Excel sh Prerna	by Prerna	3	704
CONVERTING NUMBERS TO TEXT Briggs	by Briggs	6	602
VLookup accross multiple worksheets jedman	by franciz	8	720
always calculate last 5 rows even after 1 inserted Picman	by Picman	9	785
Average of Vlookup data JAbels001	by T. Valko	3	778
Un-Synchronous Panes Jon	by Jon	3	666
Calculating Tax % Amin	by ShaneDevenshire	3	508
Pivot Table + Microsoft Query + Current Month THE_RAMONES	by ShaneDevenshire	1	1,039
Help with a Macro [email protected]	by [email protected]	2	521
Linking data between worksheets Pam S.	by Bernard Liengme	1	534
Complicated If Statement - I Think! Dee	by Bernard Liengme	5	562
formula help please tracker	by Glenn	1	530
How to load a worksheet from Internet into a worksheet? Eric	by Eric	3	604
Pasting comma delimited data OnTheEdge	by Dave Curtis	4	1,565
IF Function Kelly	by Ashish Mathur[_2_]	5	634
Average of group! TooN	by Ashish Mathur[_2_]	1	761
Problems using DMAX, DSUM, DAVERAGE with new table theresa	by Bob Phillips[_3_]	1	1,571
event vba irosh	by irosh	4	646
breaking a field out JCM	by Dave Curtis	3	672
Reference column climate	by climate	14	1,169
copy cells using formula Kashyap	by Kashyap	3	636
IF and OR statements bob	by T. Valko	1	475
Lookup less than a number Rod	by T. Valko	6	644
count if question gurmy77	by Ashish Mathur[_2_]	3	657
function to only show unique cells in range (e.g. B2:B20) OnTheEdge	by Ashish Mathur[_2_]	6	833
If statement only shows value in first cell Mea	by Ashish Mathur[_2_]	3	607
Expanding a named range jayceejay	by jayceejay	3	666
Need to find matching criteria in 1 column, then add amounts in a HeatherJ	by Ashish Mathur[_2_]	4	916
How to determine the value? Eric	by Teethless mama	2	549