Excel Worksheet Functions - Page 702

Thread / Thread Starter	Last Post	Replies	Views
Skip blank columns with LOOKUP formula HuskerBronco	by Biff	7	1,905
select highest value jk	by Naveen	1	874
How to match bits to a certain value Matt	by Biff	1	609
Auto size a pivot table to a page size .	by steven1001	1	1,563
sumif and range validation c991257	by Peo Sjoblom	3	534
Countif with Two Criteria ForSale	by Biff	2	382
Conditional Count 2 Columns rileym	by Joerg	1	484
Grabbing the filtered data in a list? [email protected]	by JMB	3	571
How do I auto-highlight a 'below limit' number in an average dj	by dj	2	454
add blank space in cell if first name is not blank stef	by Dave Peterson	6	1,452
How do I calculate the inflection point? rgoyan	by Gary''s Student	3	6,562
How do I do a two level Vlookup? molsansk	by daddylonglegs	6	2,199
Scroll bars without control tabs CJ	by davesexcel	3	633
keeping a running total in a single cell shrtdawg73	by Gord Dibben	10	2,563
Change text based on other cell criteria? ansoriano1	by Gord Dibben	2	528
how do I create formula to sum hours & min's Susan	by Harald Staff	4	530
to convert columns to rows having mulit independent group columns Quacy	by Gord Dibben	1	1,197
Help getting first column data based on criteria? Tami	by Ron Coderre	5	900
Conditional formatting similar to shading alternating rows Conan Kelly	by Gord Dibben	10	1,759
VLOOKUP and its properties pepenacho	by Biff	1	770
IF(OR Function with years Wzbell	by Bob Phillips	7	470
Average if is not greater than today jermsalerms	by Die_Another_Day	5	690
how do I combine two pivot table? Lisa	by David	1	3,686
CUMIPMT David	by David	4	687
saving workbook to destination file automatically mikespeck	by JLatham	5	676
Grabbing the filtered data in a list? [email protected]	by [email protected]	0	526
How can I get a worksheet name appear in a cell? Gary	by Ron de Bruin	1	353
Need to automate unique identifier MLK	by Max	6	555
Looking for help creating dynamic list numbers Excl	by Excl	4	594
USE KEYBOARD TO SELECT ALL SHEETS enos newt gribble	by Gord Dibben	4	1,143
How do I sort records that are on two lines in a spreadsheet? ecox	by Gord Dibben	2	531
Due Date with year using IF for several cells Wzbell	by Bob Phillips	1	347
sumproduct with dates Bumblebee	by Bumblebee	2	480
IF Function cheetah	by cheetah	3	470
Looking for help generating list numbers with reference Excl	by CLR	1	465
How to automatically create hyperlinks with excel sams9	by Jim Cone	1	687
how to install microsoft exel pashupati	by Otto Moehrbach	1	646
How can I edit cell notes while track changes is turned on? bluebird	by bluebird	0	448
If function calculating date extrudebg	by extrudebg	1	405
Vlookup, return zero if not found molsansk	by Carim	2	3,110
Excel "IF" function stevieboy1313	by stevieboy1313	4	399
Lookup vertically to next cell with data scott	by bpeltzer	1	795
Independent column widths Kathleen	by CLR	2	530
IF function returning incorrect result Hillary E.	by daddylonglegs	2	1,035
Sorting by 5 digit & 5 digit plus 4 zip codes D Marie	by Otto Moehrbach	1	1,792
formula won't paste from one cell to another with current cell inf kentndebra	by Niek Otten	1	589
IF Function cheetah	by Toppers	1	352
Lookup in one column petercummins	by petercummins	2	395
lookup column label based on data in cell Aaron	by Toppers	1	547
alerts gambit	by starguy	3	560
Counting total for multiple criteria [email protected]	by [email protected]	2	546
Pivot Table Help Debby Bunce	by Debby Bunce	4	410
Lookup and Sum [email protected]	by Toppers	6	792
Pivot column disappears after external data refresh Fabio Missana	by Fabio Missana	0	872
Need help with formula for Weekly Value ARTCGAL	by ARTCGAL	4	516
countcolor Pascal	by Bob Phillips	1	926
Consolidating a Row of data from many worksheets xlsuser42	by xlsuser42	0	619
Saveing workbook to a file as todays date daily mikespeck	by mikespeck	0	649
Multiples of 4 in an IF statement Barry Clark	by Barry Clark	3	1,035
Inserting Blank rows after every row upto 2500 rows Manju	by Don Guillett	8	1,082
Calculating number of hours accross days MTLeslie	by daddylonglegs	6	617
Autofill Sequence quincythequill	by shail	7	476
validating cells in the same row has unique values Volkan Akyuz	by Volkan Akyuz	2	543
Pivot Table Help Debby Bunce	by Debby Bunce	0	372
Formula auditing inactive mthomas4	by mthomas4	0	586
Dropdown frustration Invoice	by Biff	1	533
counting unique items(values or text) guneet_ahuja	by guneet_ahuja	11	1,303
Index function and changing criteria help. [email protected]	by Max	5	714
Combining LOOKUP and COUNTIF functions kate_suzanne	by Leo Heuser	2	680
VLOOKUP over multiple sheets Jaisenm	by Biff	9	881
Auto Date in a cell if other cell is greater than 1 Shaggy	by Shaggy	7	509
excel formula question Mona	by tukjodjam	3	465
Formula Referencing data on multiple worksheets ChrisPrather	by BOBODD	6	676
Moving Rows to another sheet based on an entry Liketoknow	by Liketoknow	0	501
Paste Special SallyGirl	by Desert Piranha	2	378