Excel Worksheet Functions - Page 702

Thread / Thread Starter	Last Post	Replies	Views
Skip blank columns with LOOKUP formula HuskerBronco	by Biff	7	1,924
select highest value jk	by Naveen	1	884
How to match bits to a certain value Matt	by Biff	1	650
Auto size a pivot table to a page size .	by steven1001	1	1,643
sumif and range validation c991257	by Peo Sjoblom	3	543
Countif with Two Criteria ForSale	by Biff	2	388
Conditional Count 2 Columns rileym	by Joerg	1	490
Grabbing the filtered data in a list? [email protected]	by JMB	3	592
How do I auto-highlight a 'below limit' number in an average dj	by dj	2	457
add blank space in cell if first name is not blank stef	by Dave Peterson	6	1,478
How do I calculate the inflection point? rgoyan	by Gary''s Student	3	6,626
How do I do a two level Vlookup? molsansk	by daddylonglegs	6	2,218
Scroll bars without control tabs CJ	by davesexcel	3	658
keeping a running total in a single cell shrtdawg73	by Gord Dibben	10	2,597
Change text based on other cell criteria? ansoriano1	by Gord Dibben	2	535
how do I create formula to sum hours & min's Susan	by Harald Staff	4	548
to convert columns to rows having mulit independent group columns Quacy	by Gord Dibben	1	1,226
Help getting first column data based on criteria? Tami	by Ron Coderre	5	1,005
Conditional formatting similar to shading alternating rows Conan Kelly	by Gord Dibben	10	1,790
VLOOKUP and its properties pepenacho	by Biff	1	783
IF(OR Function with years Wzbell	by Bob Phillips	7	482
Average if is not greater than today jermsalerms	by Die_Another_Day	5	702
how do I combine two pivot table? Lisa	by David	1	3,710
CUMIPMT David	by David	4	697
saving workbook to destination file automatically mikespeck	by JLatham	5	701
Grabbing the filtered data in a list? [email protected]	by [email protected]	0	545
How can I get a worksheet name appear in a cell? Gary	by Ron de Bruin	1	365
Need to automate unique identifier MLK	by Max	6	571
Looking for help creating dynamic list numbers Excl	by Excl	4	608
USE KEYBOARD TO SELECT ALL SHEETS enos newt gribble	by Gord Dibben	4	1,160
How do I sort records that are on two lines in a spreadsheet? ecox	by Gord Dibben	2	555
Due Date with year using IF for several cells Wzbell	by Bob Phillips	1	362
sumproduct with dates Bumblebee	by Bumblebee	2	492
IF Function cheetah	by cheetah	3	490
Looking for help generating list numbers with reference Excl	by CLR	1	486
How to automatically create hyperlinks with excel sams9	by Jim Cone	1	703
how to install microsoft exel pashupati	by Otto Moehrbach	1	698
How can I edit cell notes while track changes is turned on? bluebird	by bluebird	0	466
If function calculating date extrudebg	by extrudebg	1	423
Vlookup, return zero if not found molsansk	by Carim	2	3,154
Excel "IF" function stevieboy1313	by stevieboy1313	4	408
Lookup vertically to next cell with data scott	by bpeltzer	1	813
Independent column widths Kathleen	by CLR	2	540
IF function returning incorrect result Hillary E.	by daddylonglegs	2	1,061
Sorting by 5 digit & 5 digit plus 4 zip codes D Marie	by Otto Moehrbach	1	1,813
formula won't paste from one cell to another with current cell inf kentndebra	by Niek Otten	1	607
IF Function cheetah	by Toppers	1	357
Lookup in one column petercummins	by petercummins	2	398
lookup column label based on data in cell Aaron	by Toppers	1	562
alerts gambit	by starguy	3	571
Counting total for multiple criteria [email protected]	by [email protected]	2	559
Pivot Table Help Debby Bunce	by Debby Bunce	4	417
Lookup and Sum [email protected]	by Toppers	6	797
Pivot column disappears after external data refresh Fabio Missana	by Fabio Missana	0	893
Need help with formula for Weekly Value ARTCGAL	by ARTCGAL	4	525
countcolor Pascal	by Bob Phillips	1	932
Consolidating a Row of data from many worksheets xlsuser42	by xlsuser42	0	640
Saveing workbook to a file as todays date daily mikespeck	by mikespeck	0	663
Multiples of 4 in an IF statement Barry Clark	by Barry Clark	3	1,070
Inserting Blank rows after every row upto 2500 rows Manju	by Don Guillett	8	1,106
Calculating number of hours accross days MTLeslie	by daddylonglegs	6	631
Autofill Sequence quincythequill	by shail	7	516
validating cells in the same row has unique values Volkan Akyuz	by Volkan Akyuz	2	563
Pivot Table Help Debby Bunce	by Debby Bunce	0	377
Formula auditing inactive mthomas4	by mthomas4	0	601
Dropdown frustration Invoice	by Biff	1	549
counting unique items(values or text) guneet_ahuja	by guneet_ahuja	11	1,322
Index function and changing criteria help. [email protected]	by Max	5	735
Combining LOOKUP and COUNTIF functions kate_suzanne	by Leo Heuser	2	692
VLOOKUP over multiple sheets Jaisenm	by Biff	9	889
Auto Date in a cell if other cell is greater than 1 Shaggy	by Shaggy	7	525
excel formula question Mona	by tukjodjam	3	480
Formula Referencing data on multiple worksheets ChrisPrather	by BOBODD	6	707
Moving Rows to another sheet based on an entry Liketoknow	by Liketoknow	0	513
Paste Special SallyGirl	by Desert Piranha	2	388