Excel Worksheet Functions - Page 86

Thread / Thread Starter	Last Post	Replies	Views
Addition Error metude	by David Biddulph[_2_]	3	411
Fixing time of last update Colin Hayes	by Colin Hayes	2	360
Select a range of rows to delete Donna[_3_]	by Gord Dibben	2	566
I need a different formula that can be copied down ND Pard	by ND Pard	2	609
formula to calculate amount of hours downtime spent in days Peter Gonzalez[_2_]	by Bernard Liengme[_2_]	1	2,520
Form 4 Range of time from 1/20/2010 4:00 AM To 1/21/2010 10:00 AM Peter Gonzalez[_2_]	by Pete_UK	2	1,479
What formula do I use to show the last cell with text in a colum Melissa	by Gord Dibben	3	865
Formula Copying qlfl	by Eduardo	1	509
AFTER I SORT AND FILTER A WORKSHEET CAN I DELETE THE FILTERS Angela	by Gord Dibben	1	513
excel is calculating wrong again prpball	by Chip Pearson	3	2,359
Formula bar needing refreshing ?? Steve	by Dave Peterson	6	505
Adding column data based on match in 2nd column - Help GBExcel via OfficeKB.com	by T. Valko	3	765
I want to use LOOKUP to average multiple values for a single crite Gary Brown[_5_]	by Gary Brown[_5_]	0	1,655
format cell custom Number format Dan	by Gary Brown[_5_]	2	507
RANK - Remove repeated ranks for sorting BlueWolverine	by Glenn	9	736
Lookup and tables ANTBOH	by ANTBOH	4	542
how do i count text cells in excel based on variable criteria? anmaka57	by Dave Peterson	2	1,446
keep manual recalculation mode on Greg	by cm	2	617
Create two Data validation lists that are linked(Both change toget VChaseS	by Capt. Cave Man	2	1,400
Match similar names Sam	by Jacob Skaria	3	3,336
excel formula sudheer	by Jacob Skaria	2	410
Average % - this should be easy? Vixter	by Vixter	2	361
Conditional Format - If day = 24 or 25 mjones	by Pete_UK	5	471
If statements Tiffany	by Jacob Skaria	2	461
Lookup or Match with rows and column together Listu	by Listu	6	897
lookup function spark	by Jacob Skaria	1	450
Current Time subtract a specific amount every second Jman	by Jman	4	856
S Curves Marc Shields	by Marc Shields	2	967
Return to next row in first column when entering data in Excel DaddyRay	by L. Howard Kittle	3	5,039
Function doesn't work Neal Carron[_2_]	by Neal Carron[_2_]	2	1,176
ranking with 2 parameters of inverse relation Eddy Stan	by minyeh	3	516
How can I keep a zero (0) at the front of a set of numbers. Myrddin	by Joe User[_2_]	2	1,780
Conditional Formulas MHSGal	by Ashish Mathur[_2_]	5	576
Sorting dates, ignoring year IanC[_2_]	by Ashish Mathur[_2_]	3	869
Data Matching Demosthenes	by Max	2	402
Can't get vlookup nor advance filter to give the desired solution. Coach Andrew[_2_]	by Coach Andrew[_2_]	0	471
Excel formula MAK	by David Biddulph[_2_]	2	523
Creating a Macro the right way? Hvns	by JLatham	2	456
Vlookup not finding matches Andy	by Dave Peterson	7	3,695
HOW DO I INSERT A CALENDAR INTO A DROP DOWN MENU FOR A COLUMN ? rleyba	by Pierre	1	1,770
Locking Cells RTaylor	by Bernard Liengme[_2_]	2	436
Using icon sets with relative references parmstrong	by parmstrong	0	2,268
Conditional Formulas MHSGal	by Al	1	420
How do you use the equivalent of NOT in text? Matt	by T. Valko	2	581
SUMPRODUCT JPDS	by T. Valko	3	494
Define cell as a condition Alexandra Lopes	by Dave Peterson	4	737
Delete Void Invoices Donna[_2_]	by Max	1	389
Sum Workdays Frank	by Frank	3	1,105
Name Ranges... Vixter	by Archimedes' Lever	10	747
MID / LEN trip_to_tokyo[_3_]	by trip_to_tokyo[_3_]	2	406
Countif problems Drew	by Jacob Skaria	1	428
Change positive number to negative number Angie M.	by Jacob Skaria	1	3,278
Sumproduct across mutliple columns JANA	by T. Valko	3	720
Error Alert for Invalid Data doesn't work for data selected in col genegal	by genegal	0	640
Concatenate 4 cells Dgwood90	by Dgwood90	2	407
How do I count only if either/ or exist wildbillyd	by Rick Rothstein	5	2,025
Conditional count cisbell_ddess	by Ashish Mathur[_2_]	2	451
Deleting Worksheet in excel = 2003 / 2007 Sandeep	by Ashish Mathur[_2_]	1	572
Delete Row ABOVE Donna[_2_]	by Ashish Mathur[_2_]	1	658
Calculate percent on numbers in different sheets wissam	by wissam	3	1,815
Calculating Service Fill Rate Mike JF	by Ashish Mathur[_2_]	5	3,384
Filter by multiple colors Michelle	by Michelle	0	2,561
Column To Rows Tony Pass	by Don Guillett[_2_]	3	447
Binary NOT? Mark Scott[_3_]	by Joe User[_2_]	4	4,191
Help on combining two IF statements Sunflower[_2_]	by Mike H	3	676
Sum of Highlighted values Khusro	by CellShocked	5	646
Macro Script help Joe Clueless	by Joe Clueless	4	613
Column To Rows Don Guillett[_2_]	by Don Guillett[_2_]	0	433
sum of cells until reach empty cell phsdave	by Bob Phillips[_4_]	4	1,560
Insert Paste Mike-Lodi	by Mike H	2	398
Removal of Zero vmohan1978	by Khusro	4	508
Popup File Amnon Wilensky	by Amnon Wilensky	3	440
separate contents of one cell into multiple cells Horacio[_4_]	by Dave Peterson	4	1,501
Formula SJL	by SJL	2	417
Lookup function fcociii	by David Biddulph[_2_]	4	446