Excel Worksheet Functions - Page 345

Thread / Thread Starter	Last Post	Replies	Views
Counting incidences of surname and date of birth and rearranging s Painless2	by sajay[_2_]	3	729
VBE "Help" Tia[_3_]	by Don Guillett	2	294
Run formula automatically kimmiesings	by Don Guillett	3	496
Extracting data amir2000	by amir2000	3	515
Excel problem - sumif with multiple parameters athletico	by Bernard Liengme	2	640
Unwanted Array Formula jolowe	by jolowe	0	369
excel Robyn	by Max	5	308
Text does not carries Over Godwin Chan	by Godwin Chan	3	485
How to calculate an average from various rows??? paulk2002	by Bob Phillips	3	446
How do I use the WORKDAY() for a 6days working wk excluding holida JP.F[_2_]	by JP.F[_2_]	5	520
Searcing foran Excel event fired. Dwipayan Das	by Bob Phillips	1	417
SUMPRODUCT containing txt string search sideshowjack	by Stefi	6	601
Simple cell formating question Metafreak	by Metafreak	4	489
How to calculate avg from various rows paulk2002	by T. Valko	3	604
Counting repeated data in a column freeman	by freeman	3	526
sorting array formula driller	by Dave Peterson	2	685
Easy way to stack column data? colleen	by Don Guillett	1	2,908
How do I change date yyyymmdd to a Excel-supported date format? dan	by dan	4	2,229
If formula problem mrsmmm1000	by mrsmmm1000	8	535
problems with formating and concatonating time [hours] Bret Bernever	by Ron Rosenfeld	3	361
Text detector O2 andy[_2_]	by O2 andy[_2_]	3	427
need formula for finding opposite (trigo) jimE	by Bernie Deitrick	4	532
Wrong count of time H. Nissen[_2_]	by H. Nissen[_2_]	7	514
Trying to work out the difference in 2 cells. scary	by scary	4	753
Help with a bsic formula stevejeffries	by Pete_UK	6	428
Multiple Criteria to Classify groups Karoline	by Pete_UK	11	1,136
Worksheet Formula Returning Sum of a Series monir	by Dana DeLouis	26	2,190
How to get result by using CountIF, if there are 3 conditions to b Subbu	by Pete_UK	4	2,722
Searching from a table [email protected]	by Pete_UK	4	354
count uniques anomaly T. Valko	by Héctor Miguel	4	546
FINDING THE LAST ENTERED NUMBER IN A ROW OF DATA Morton Detwyler	by Rick Rothstein \(MVP - VB\)[_823_]	7	1,925
Protecting worksheet Kimti	by Kimti	1	462
Calculating of time H. Nissen	by H. Nissen[_2_]	18	1,411
the value should not be more than 0.8 srpavar	by Pete_UK	6	510
How I unprotect my workbook if I failed to remember my password ShaF Malik	by Gord Dibben	2	1,425
How can I activate spell check in a protected sheet CKBW	by Gord Dibben	3	1,121
If a date range contains a leap year (date) Rebecca_SUNY	by Ron Rosenfeld	14	3,261
#value! Error sony654	by T. Valko	3	385
COUNTIF: unique names and values accross several columns. SW	by ryguy7272	2	798
yes / no formulas into 1/0 The snow Queen	by Dave Peterson	3	425
Searching specific record using VLOOKUP function. dev	by Max	12	1,410
How to look up a value in a list and return multiple correspondingvalues [email protected]	by ryguy7272	2	824
Collapsing filtered macro DFrank	by ryguy7272	2	474
Vlookup Function with multiple worksheets Dahliahlu	by T. Valko	6	721
logic test with nested IF fuctions - help marla	by Teethless mama	2	624
Need to Count the number of times a value occurs within a dt range Gina[_2_]	by ryguy7272	9	1,886
Compiling to one sheet Ahern79	by ryguy7272	2	629
how to set data validation on cell that display a date in Excel? SBA22000	by SBA22000	2	715
Updating Imported Data (Excell 2003) lambchop	by Ragdyer	1	506
Filter latest date from multiple date entries [email protected]	by Fred Smith[_4_]	1	819
How would I attach or assign values to a trendline? williamk2v	by williamk2v	4	717
extract number from alphanumric Hardeep_kanwar[_2_]	by ryguy7272	3	399
Counting specific letters in multiple cells tohlz	by Mike H	4	686
Column to row Outlook, eh?	by Alan Beban[_2_]	2	439
YTD average cust calulation zy1972	by NoodNutt	3	697
Possible getpivotdata with offset? Sarah (OGI)	by ryguy7272	1	2,150
copying from pdf into excel ? Meenie	by ryguy7272	2	871
Wrap Text Problem + a little VB :) Fizban	by NoodNutt	1	510
Calculate and display year and month kenlo	by Teethless mama	1	564
Associate values in worksheet?? Jon M	by Pete_UK	1	576
Lookup where column data does not match NTK	by NTK	2	529
Pivot Tables & Conditional Formatting jbird	by Debra Dalgleish	2	800
IF and Betwwen - how to ? H. Nissen[_2_]	by H. Nissen[_2_]	2	296
May be a long-shot, but..... [email protected]	by Dave Peterson	3	361
Import external data, data includes Excel function allen davidson	by allen davidson	0	890
Stop text carries over Godwin Chan	by Godwin Chan	3	541
Calendar or date formulas Lady P	by Nayab	2	525
Removing unwanted columns in a list PLJohnson	by PLJohnson	0	489
Advice on a couple of things if possible. Chiccada	by Chiccada	3	345
Copy from another sheet but spreading the data out down the col Peter	by Ragdyer	3	406
Protect columns with password Anders	by Anders	0	512
Count rows after filter Learn-more	by Learn-more	2	1,645
Restricting cell data amount NoodNutt	by Héctor Miguel	6	581
Worksheet design: How to allocate costs to plants? David3553	by David3553	0	830
drop info auto from sheet 1 to 2 rabbit	by sony654	1	389