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	725
VBE "Help" Tia[_3_]	by Don Guillett	2	283
Run formula automatically kimmiesings	by Don Guillett	3	486
Extracting data amir2000	by amir2000	3	499
Excel problem - sumif with multiple parameters athletico	by Bernard Liengme	2	617
Unwanted Array Formula jolowe	by jolowe	0	349
excel Robyn	by Max	5	286
Text does not carries Over Godwin Chan	by Godwin Chan	3	473
How to calculate an average from various rows??? paulk2002	by Bob Phillips	3	426
How do I use the WORKDAY() for a 6days working wk excluding holida JP.F[_2_]	by JP.F[_2_]	5	511
Searcing foran Excel event fired. Dwipayan Das	by Bob Phillips	1	395
SUMPRODUCT containing txt string search sideshowjack	by Stefi	6	583
Simple cell formating question Metafreak	by Metafreak	4	469
How to calculate avg from various rows paulk2002	by T. Valko	3	582
Counting repeated data in a column freeman	by freeman	3	510
sorting array formula driller	by Dave Peterson	2	646
Easy way to stack column data? colleen	by Don Guillett	1	2,884
How do I change date yyyymmdd to a Excel-supported date format? dan	by dan	4	2,177
If formula problem mrsmmm1000	by mrsmmm1000	8	516
problems with formating and concatonating time [hours] Bret Bernever	by Ron Rosenfeld	3	339
Text detector O2 andy[_2_]	by O2 andy[_2_]	3	421
need formula for finding opposite (trigo) jimE	by Bernie Deitrick	4	521
Wrong count of time H. Nissen[_2_]	by H. Nissen[_2_]	7	499
Trying to work out the difference in 2 cells. scary	by scary	4	729
Help with a bsic formula stevejeffries	by Pete_UK	6	424
Multiple Criteria to Classify groups Karoline	by Pete_UK	11	1,114
Worksheet Formula Returning Sum of a Series monir	by Dana DeLouis	26	2,169
How to get result by using CountIF, if there are 3 conditions to b Subbu	by Pete_UK	4	2,702
Searching from a table [email protected]	by Pete_UK	4	329
count uniques anomaly T. Valko	by Héctor Miguel	4	523
FINDING THE LAST ENTERED NUMBER IN A ROW OF DATA Morton Detwyler	by Rick Rothstein \(MVP - VB\)[_823_]	7	1,885
Protecting worksheet Kimti	by Kimti	1	455
Calculating of time H. Nissen	by H. Nissen[_2_]	18	1,390
the value should not be more than 0.8 srpavar	by Pete_UK	6	494
How I unprotect my workbook if I failed to remember my password ShaF Malik	by Gord Dibben	2	1,407
How can I activate spell check in a protected sheet CKBW	by Gord Dibben	3	1,103
If a date range contains a leap year (date) Rebecca_SUNY	by Ron Rosenfeld	14	3,145
#value! Error sony654	by T. Valko	3	369
COUNTIF: unique names and values accross several columns. SW	by ryguy7272	2	779
yes / no formulas into 1/0 The snow Queen	by Dave Peterson	3	409
Searching specific record using VLOOKUP function. dev	by Max	12	1,348
How to look up a value in a list and return multiple correspondingvalues [email protected]	by ryguy7272	2	814
Collapsing filtered macro DFrank	by ryguy7272	2	448
Vlookup Function with multiple worksheets Dahliahlu	by T. Valko	6	699
logic test with nested IF fuctions - help marla	by Teethless mama	2	614
Need to Count the number of times a value occurs within a dt range Gina[_2_]	by ryguy7272	9	1,857
Compiling to one sheet Ahern79	by ryguy7272	2	458
how to set data validation on cell that display a date in Excel? SBA22000	by SBA22000	2	702
Updating Imported Data (Excell 2003) lambchop	by Ragdyer	1	472
Filter latest date from multiple date entries [email protected]	by Fred Smith[_4_]	1	787
How would I attach or assign values to a trendline? williamk2v	by williamk2v	4	687
extract number from alphanumric Hardeep_kanwar[_2_]	by ryguy7272	3	388
Counting specific letters in multiple cells tohlz	by Mike H	4	666
Column to row Outlook, eh?	by Alan Beban[_2_]	2	414
YTD average cust calulation zy1972	by NoodNutt	3	683
Possible getpivotdata with offset? Sarah (OGI)	by ryguy7272	1	2,125
copying from pdf into excel ? Meenie	by ryguy7272	2	856
Wrap Text Problem + a little VB :) Fizban	by NoodNutt	1	498
Calculate and display year and month kenlo	by Teethless mama	1	549
Associate values in worksheet?? Jon M	by Pete_UK	1	550
Lookup where column data does not match NTK	by NTK	2	513
Pivot Tables & Conditional Formatting jbird	by Debra Dalgleish	2	753
IF and Betwwen - how to ? H. Nissen[_2_]	by H. Nissen[_2_]	2	294
May be a long-shot, but..... [email protected]	by Dave Peterson	3	355
Import external data, data includes Excel function allen davidson	by allen davidson	0	822
Stop text carries over Godwin Chan	by Godwin Chan	3	532
Calendar or date formulas Lady P	by Nayab	2	505
Removing unwanted columns in a list PLJohnson	by PLJohnson	0	464
Advice on a couple of things if possible. Chiccada	by Chiccada	3	338
Copy from another sheet but spreading the data out down the col Peter	by Ragdyer	3	381
Protect columns with password Anders	by Anders	0	494
Count rows after filter Learn-more	by Learn-more	2	1,630
Restricting cell data amount NoodNutt	by Héctor Miguel	6	550
Worksheet design: How to allocate costs to plants? David3553	by David3553	0	819
drop info auto from sheet 1 to 2 rabbit	by sony654	1	384