Excel Worksheet Functions - Page 778

Thread / Thread Starter	Last Post	Replies	Views
vlookup with variable col_index_num 0-0 Wai Wai ^-^	by Bob Phillips	2	1,594
Format new Lines into Columns efenili	by Peo Sjoblom	1	491
"000" + number + "." 0-0 Wai Wai ^-^	by 0-0 Wai Wai ^-^	4	430
check boxes from the forms tool bar heatmatt	by Peo Sjoblom	1	477
In Office 2000, How do I delete multiple blank rows at one time? gisieber	by Edwin	2	794
Can a VLOOKUP use two items to search Natalie	by johamshason via OfficeKB.com	2	574
pattern matching possible? vito	by Bob Phillips	1	369
Conditional formatting based upon array RocketMan	by Bob Phillips	1	694
Range Name C SanctifiedRock	by Bob Phillips	3	309
date function Hervinder	by David Biddulph	5	342
Dynamic reference to another sheet? Mitch	by Bob Phillips	3	1,044
strange behaviour with matrix formulas kayard	by Miguel Zapico	3	497
Excel functions names should be in English for all Localized versi furia	by furia	0	539
Help with time formats [email protected]	by [email protected]	3	596
Microsoft Excel Laurie	by CLR	1	380
error message: merged cells must be same size Buckskin	by Buckskin	2	1,051
Removing Spaces from string katmando	by katmando	4	557
Is conditional formatting only blank, unused cells possible? Cond. formatting blank cells	by Bob Phillips	1	462
If question I think kelljeff	by Beege	2	425
Automatically Refreshing Data at 12am [email protected]	by [email protected]	0	445
subtracting (extracting non-duplicate items)HELP!! rtek	by broro183	2	555
July - UK Excel User Conference Damon Longworth	by Damon Longworth	0	467
Lookup using more than one criteria Beccy	by Pete_UK	7	503
Countif with range name gabch	by CLR	1	598
Data Filter and AutoSum Ket	by broro183	4	941
VLOOKUP problem fastballfreddy	by Domenic	3	464
how to name the selected cells in a sheet? Landa	by Max	4	340
sort and return column numbers [email protected]	by Domenic	5	587
How to simplify "multiple if" formula markx	by Pete_UK	4	547
Count Specific word in specific range [email protected]	by Bob Phillips	2	809
NUMBER OF YEARS BETWEEN TWO DATES - HOW TO GET AJAY KUMAR DIXIT	by Ardus Petus	2	1,132
How do I find the earliest dates in a range of dates? JJ	by Pete_UK	3	2,608
Compare 4 columns? Deb	by Max	1	1,418
Graph orientation CJ	by Andy Pope	3	1,099
Splitting cells using formula; RIGHT/LEFT not applicable Mitch	by Toppers	6	839
How do I autofill conditional formatting? JesiR	by Rich Mcc	6	588
Refreshing when opening a file from the "File" Menu [email protected]	by [email protected]	0	613
Averaging Golf Scores Jerry	by Fred Smith	3	528
Conditional sum Monkandy	by JMB	1	366
checkbox event handling function nevwalters	by Biff	2	875
How Do I Combine Rankings for Multiple Categories? Howard	by Miguel Zapico	1	1,271
shortcut to insert cells salisshe	by Dave Peterson	3	1,034
History worksheet - can it remain viewable after saving? plngarbage	by plngarbage	0	597
Counting são paulo	by davesexcel	1	563
Manual AutoFilter - Vlookup, Index, Match, Array??? TEAM	by Max	4	944
combining two formulas edwardpestian	by edwardpestian	1	545
running total by date (not sorted by date though...) rainxking	by rainxking	4	891
How can I change the color of the comment indicators? azveteran	by Kevin Vaughn	15	1,404
vlookup display Mark	by Ashish Mathur	2	343
How can I bring forward formats with Vlookup? candycasey	by Pete_UK	1	691
Merging a full column into a single cell Gmoney	by Gmoney	3	527
How do I convert run time(45,502h 30m) to number 45,502.5 ?? mgonzo	by daddylonglegs	1	610
If then statements? Hickeym	by Niek Otten	3	470
Combining Ranges Luke Bailey	by Bob Umlas, Excel MVP	1	434
Lines around cells librarygirl	by librarygirl	4	553
Automatically Refreshing Data at 12am [email protected]	by [email protected]	2	448
Between Function techiemom60	by techiemom60	2	370
Sumproduct Question Barb Reinhardt	by Domenic	2	483
Macro or function MIchel Khennafi	by Gary''s Student	2	509
Excel In-cell Enhancements silverliningboy	by Miguel Zapico	4	330
How do i retreive data from another worksheet to a current one? dphi201	by Duke Carey	4	463
vlookup and subscript text formatting red maple 98	by Miguel Zapico	2	656
Moving Data Question Skip	by pdberger	1	408
How can I isolate a lookup vectors but not values from autofill? rjpeltz	by rjpeltz	2	640
data validation: formula for validating only multiples of 10 Excelnovice	by Alan	3	649
HELP WITH FORMULA Soth	by Soth	2	290
Excel Grouping Enhancement silverliningboy	by silverliningboy	0	482
How can I save xls files to 'E:\'? I have no floppy disc zayda mickey	by CLR	2	382
function question Cletus Stripling	by Cletus Stripling	3	342
Recalculation workerboy	by Kevin Vaughn	3	429
if/and statements BobVA	by BobVA	6	427
I want to add up the amounts from 1 cell in a folder of files Betsy	by Ron de Bruin	6	543
aa ab ac....ax ay az....ba bb bc....zx zy zz ? JethroUK©	by JethroUK©	6	1,534
=TEXT(I21,"MMYY") Thank you, Heath	by Kevin Vaughn	10	754
Function that returns the page number a cell falls on Don-in-Kent-UK	by Peo Sjoblom	1	944