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,624
Format new Lines into Columns efenili	by Peo Sjoblom	1	512
"000" + number + "." 0-0 Wai Wai ^-^	by 0-0 Wai Wai ^-^	4	440
check boxes from the forms tool bar heatmatt	by Peo Sjoblom	1	491
In Office 2000, How do I delete multiple blank rows at one time? gisieber	by Edwin	2	833
Can a VLOOKUP use two items to search Natalie	by johamshason via OfficeKB.com	2	592
pattern matching possible? vito	by Bob Phillips	1	393
Conditional formatting based upon array RocketMan	by Bob Phillips	1	714
Range Name C SanctifiedRock	by Bob Phillips	3	321
date function Hervinder	by David Biddulph	5	374
Dynamic reference to another sheet? Mitch	by Bob Phillips	3	1,074
strange behaviour with matrix formulas kayard	by Miguel Zapico	3	525
Excel functions names should be in English for all Localized versi furia	by furia	0	565
Help with time formats [email protected]	by [email protected]	3	614
Microsoft Excel Laurie	by CLR	1	396
error message: merged cells must be same size Buckskin	by Buckskin	2	1,081
Removing Spaces from string katmando	by katmando	4	640
Is conditional formatting only blank, unused cells possible? Cond. formatting blank cells	by Bob Phillips	1	493
If question I think kelljeff	by Beege	2	449
Automatically Refreshing Data at 12am [email protected]	by [email protected]	0	462
subtracting (extracting non-duplicate items)HELP!! rtek	by broro183	2	577
July - UK Excel User Conference Damon Longworth	by Damon Longworth	0	481
Lookup using more than one criteria Beccy	by Pete_UK	7	523
Countif with range name gabch	by CLR	1	617
Data Filter and AutoSum Ket	by broro183	4	971
VLOOKUP problem fastballfreddy	by Domenic	3	494
how to name the selected cells in a sheet? Landa	by Max	4	356
sort and return column numbers [email protected]	by Domenic	5	612
How to simplify "multiple if" formula markx	by Pete_UK	4	567
Count Specific word in specific range [email protected]	by Bob Phillips	2	859
NUMBER OF YEARS BETWEEN TWO DATES - HOW TO GET AJAY KUMAR DIXIT	by Ardus Petus	2	1,144
How do I find the earliest dates in a range of dates? JJ	by Pete_UK	3	2,666
Compare 4 columns? Deb	by Max	1	1,438
Graph orientation CJ	by Andy Pope	3	1,122
Splitting cells using formula; RIGHT/LEFT not applicable Mitch	by Toppers	6	864
How do I autofill conditional formatting? JesiR	by Rich Mcc	6	604
Refreshing when opening a file from the "File" Menu [email protected]	by [email protected]	0	674
Averaging Golf Scores Jerry	by Fred Smith	3	537
Conditional sum Monkandy	by JMB	1	386
checkbox event handling function nevwalters	by Biff	2	904
How Do I Combine Rankings for Multiple Categories? Howard	by Miguel Zapico	1	1,283
shortcut to insert cells salisshe	by Dave Peterson	3	1,059
History worksheet - can it remain viewable after saving? plngarbage	by plngarbage	0	646
Counting são paulo	by davesexcel	1	581
Manual AutoFilter - Vlookup, Index, Match, Array??? TEAM	by Max	4	972
combining two formulas edwardpestian	by edwardpestian	1	563
running total by date (not sorted by date though...) rainxking	by rainxking	4	918
How can I change the color of the comment indicators? azveteran	by Kevin Vaughn	15	1,426
vlookup display Mark	by Ashish Mathur	2	362
How can I bring forward formats with Vlookup? candycasey	by Pete_UK	1	718
Merging a full column into a single cell Gmoney	by Gmoney	3	537
How do I convert run time(45,502h 30m) to number 45,502.5 ?? mgonzo	by daddylonglegs	1	620
If then statements? Hickeym	by Niek Otten	3	491
Combining Ranges Luke Bailey	by Bob Umlas, Excel MVP	1	465
Lines around cells librarygirl	by librarygirl	4	563
Automatically Refreshing Data at 12am [email protected]	by [email protected]	2	472
Between Function techiemom60	by techiemom60	2	382
Sumproduct Question Barb Reinhardt	by Domenic	2	499
Macro or function MIchel Khennafi	by Gary''s Student	2	527
Excel In-cell Enhancements silverliningboy	by Miguel Zapico	4	345
How do i retreive data from another worksheet to a current one? dphi201	by Duke Carey	4	482
vlookup and subscript text formatting red maple 98	by Miguel Zapico	2	676
Moving Data Question Skip	by pdberger	1	425
How can I isolate a lookup vectors but not values from autofill? rjpeltz	by rjpeltz	2	664
data validation: formula for validating only multiples of 10 Excelnovice	by Alan	3	675
HELP WITH FORMULA Soth	by Soth	2	297
Excel Grouping Enhancement silverliningboy	by silverliningboy	0	502
How can I save xls files to 'E:\'? I have no floppy disc zayda mickey	by CLR	2	404
function question Cletus Stripling	by Cletus Stripling	3	361
Recalculation workerboy	by Kevin Vaughn	3	448
if/and statements BobVA	by BobVA	6	437
I want to add up the amounts from 1 cell in a folder of files Betsy	by Ron de Bruin	6	568
aa ab ac....ax ay az....ba bb bc....zx zy zz ? JethroUK©	by JethroUK©	6	1,544
=TEXT(I21,"MMYY") Thank you, Heath	by Kevin Vaughn	10	772
Function that returns the page number a cell falls on Don-in-Kent-UK	by Peo Sjoblom	1	984