Excel Worksheet Functions - Page 516

Thread / Thread Starter	Last Post	Replies	Views
Dynamic name reference in SUMPRODUCT MIKWIN	by MIKWIN	5	627
How can I create one column (stacked) from a large table of data.. Jacko	by [email protected]	1	627
copy&paste 28 individual files into one file/28 work sheets Yvez T.T. Constance	by Ron de Bruin	1	627
converting text strings into dates via135	by Pete_UK	6	627
Lookup and return value 12 rows below HA14	by HA14	5	627
counting x instances of a string across columns... [email protected]	by Ron Rosenfeld	9	627
Return an absolutely empty cell ... but not "" Billy Leung	by Billy Leung[_2_]	3	627
XLS to CSV Code Problem carl	by carl	0	627
Formula for producing one list from another ! Chuckee	by Chuckee	2	627
Help with array lookup and max DavidFarnsworth	by Roger Govier	1	627
Excell functions for converting column data MegM	by Pete_UK	7	627
moving part of information from one cell to another... auntwanette	by tim m	1	627
Dates, Years and Seasons Graham Haughs	by Graham Haughs	7	627
and < for Array Sumif ({}) Kiwi Matt	by Bernie Deitrick	6	627
Sorting UK Postcodes Aristobulus	by Richard Buttrey	4	627
sparklines for excel Andreas Flockermann [BonaVista Systems]	by S Davis	1	627
Insert Footer into Cells Lonewolf	by Gord Dibben	1	627
% query wally	by Biff	11	627
calculating average with blank cells marvinks	by marvinks	3	627
Date Formulas kaz	by muddan madhu	7	627
Extracting Address data from single cells Terry Bennett	by Terry Bennett	2	627
How to not get '0' or '#DIV/0!' in a cell with a percentage formul Rum	by Jacob Skaria	7	627
Find and copy for inventory MB_HCAthleticTrainer[_2_]	by MB_HCAthleticTrainer[_2_]	2	627
"Now" Function Kenneth	by Michael.Tarnowski	6	627
Question related to "Can you help me to solve the below K Lee	by Rick Rothstein	3	627
sumproduct with varying column ranges rami	by Bernie Deitrick	1	627
IF, AND, OR Function Tracey	by Pete_UK	9	627
Dates from Text cloudyMalta	by T. Valko	4	627
Number of Weekend Days between 2 Dates Q Seanie	by Alan Moseley	1	627
Count unique records... with a twist... Need help! [email protected]	by [email protected]	4	627
averages for cells jatman	by Glenn	6	627
How do I delete existing data from a drop down menu list? Tasneen	by Max	1	627
count number of instances a number occurs mark (plymouth)	by Teethless mama	5	627
Pivot Table - How to exclude info without showing? cware	by ryguy7272	1	627
How can I conditionally hide or display data in a cell? mrsphyl	by Spiky	2	627
conditional change to absolute COB	by COB	2	627
Sum of Vlookup Patrick C. Simonds	by Gaurav[_3_]	3	627
is it possible to email just one worksheet from an excel document Alyces	by Ron de Bruin	1	627
I can't get the forecast formula to work? Andy G	by Dana DeLouis	1	627
Match/Index return #N/A DHS64	by Roger Govier	2	627
tab scrolling buttons missdona	by missdona	0	627
#div/0! how do i supress? vipa2000	by KL	5	627
filedialog Norm	by Norm	0	627
Summarising data from several tables Zakynthos	by Zakynthos	0	627
Open as read only Problem Dave	by Dave	0	627
datevalue LarryTheK	by Piranha	8	627
Absolute Reference Alain	by Bob Phillips	3	627
convert numbers to words prags	by Gord Dibben	2	627
Get Past the 7 Nested IF limit Palencia1978	by Ron Moore	2	627
Filling an array with data Dongle	by Dongle	2	627
Selecting ALL names when using Insert/Names/Apply Mike	by Gord Dibben	3	627
How can I make a checkbox create a value? cookin_dad	by PCLIVE	3	627
Multilevel Sorting? Mike	by Peo Sjoblom	4	627
calculating SUM with two conditions Alex	by Gary Brown	1	627
MSExcel--words in a cell separated by comma need to be moved into. Gary in Alaska	by Erin	2	627
Formatting a worksheet for data entry DV in Texas	by Gord Dibben	2	627
Frank, Sumproduct, it works but I am confused Danny J	by Danny J	7	627
chart types chrisk	by Mike Middleton	1	627
Display multiple tabs in current worksheet MLK	by MLK	0	627
Simultaneous entry of data between 2 different worksheets [email protected]	by Toppers	1	627
how 2sum values in column C, IF 'X' & 'Y' in colums A & B =TRUE JW in Dubai	by Kishor	2	627
Change fmt of a cell if number matches any in a range of cells? SteveR	by Ardus Petus	2	627
how do i use import to consolidate data from multiple sheets Naveen	by Otto Moehrbach	1	627
How can I create an AutoFormat row color change for a value in a c Shane Rary	by	1	627
update prices in inventory based on downloaded price list?? Wilk	by CLR	1	627
mdv mdv	by EdMac	1	627
Appl need that VLOOKUP will not handle Wayne G. Dengel	by Aladin Akyurek	6	627
vlookup:same lookup_value, different returns Biff	by javino	2	627
Can you use the validate function in a data form in Excel? Jolly	by Jolly	0	627
Restricting entry in B1 on the basis of entry in A1 Stilla	by Stilla	7	627
How do I change data spacing in a column Manthelan	by JE McGimpsey	1	627
vlookup on a cell with a formula Minos	by Bruno Campanini	3	627
Last cell used in SUM IF formula GerryK	by Aladin Akyurek	4	627
Moved data to new sheet based on list selection scronk	by Max	1	627
Several function questions (nested functions) miller	by Biff	6	627