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	293
Run formula automatically kimmiesings	by Don Guillett	3	491
Extracting data amir2000	by amir2000	3	506
Excel problem - sumif with multiple parameters athletico	by Bernard Liengme	2	627
Unwanted Array Formula jolowe	by jolowe	0	358
excel Robyn	by Max	5	295
Text does not carries Over Godwin Chan	by Godwin Chan	3	481
How to calculate an average from various rows??? paulk2002	by Bob Phillips	3	434
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	414
SUMPRODUCT containing txt string search sideshowjack	by Stefi	6	601
Simple cell formating question Metafreak	by Metafreak	4	477
How to calculate avg from various rows paulk2002	by T. Valko	3	589
Counting repeated data in a column freeman	by freeman	3	517
sorting array formula driller	by Dave Peterson	2	671
Easy way to stack column data? colleen	by Don Guillett	1	2,897
How do I change date yyyymmdd to a Excel-supported date format? dan	by dan	4	2,228
If formula problem mrsmmm1000	by mrsmmm1000	8	525
problems with formating and concatonating time [hours] Bret Bernever	by Ron Rosenfeld	3	351
Text detector O2 andy[_2_]	by O2 andy[_2_]	3	425
need formula for finding opposite (trigo) jimE	by Bernie Deitrick	4	531
Wrong count of time H. Nissen[_2_]	by H. Nissen[_2_]	7	504
Trying to work out the difference in 2 cells. scary	by scary	4	750
Help with a bsic formula stevejeffries	by Pete_UK	6	428
Multiple Criteria to Classify groups Karoline	by Pete_UK	11	1,125
Worksheet Formula Returning Sum of a Series monir	by Dana DeLouis	26	2,179
How to get result by using CountIF, if there are 3 conditions to b Subbu	by Pete_UK	4	2,708
Searching from a table [email protected]	by Pete_UK	4	341
count uniques anomaly T. Valko	by Héctor Miguel	4	532
FINDING THE LAST ENTERED NUMBER IN A ROW OF DATA Morton Detwyler	by Rick Rothstein \(MVP - VB\)[_823_]	7	1,916
Protecting worksheet Kimti	by Kimti	1	462
Calculating of time H. Nissen	by H. Nissen[_2_]	18	1,399
the value should not be more than 0.8 srpavar	by Pete_UK	6	498
How I unprotect my workbook if I failed to remember my password ShaF Malik	by Gord Dibben	2	1,420
How can I activate spell check in a protected sheet CKBW	by Gord Dibben	3	1,118
If a date range contains a leap year (date) Rebecca_SUNY	by Ron Rosenfeld	14	3,259
#value! Error sony654	by T. Valko	3	375
COUNTIF: unique names and values accross several columns. SW	by ryguy7272	2	793
yes / no formulas into 1/0 The snow Queen	by Dave Peterson	3	418
Searching specific record using VLOOKUP function. dev	by Max	12	1,404
How to look up a value in a list and return multiple correspondingvalues [email protected]	by ryguy7272	2	821
Collapsing filtered macro DFrank	by ryguy7272	2	460
Vlookup Function with multiple worksheets Dahliahlu	by T. Valko	6	712
logic test with nested IF fuctions - help marla	by Teethless mama	2	615
Need to Count the number of times a value occurs within a dt range Gina[_2_]	by ryguy7272	9	1,875
Compiling to one sheet Ahern79	by ryguy7272	2	618
how to set data validation on cell that display a date in Excel? SBA22000	by SBA22000	2	708
Updating Imported Data (Excell 2003) lambchop	by Ragdyer	1	494
Filter latest date from multiple date entries [email protected]	by Fred Smith[_4_]	1	816
How would I attach or assign values to a trendline? williamk2v	by williamk2v	4	709
extract number from alphanumric Hardeep_kanwar[_2_]	by ryguy7272	3	393
Counting specific letters in multiple cells tohlz	by Mike H	4	674
Column to row Outlook, eh?	by Alan Beban[_2_]	2	429
YTD average cust calulation zy1972	by NoodNutt	3	689
Possible getpivotdata with offset? Sarah (OGI)	by ryguy7272	1	2,139
copying from pdf into excel ? Meenie	by ryguy7272	2	859
Wrap Text Problem + a little VB :) Fizban	by NoodNutt	1	500
Calculate and display year and month kenlo	by Teethless mama	1	555
Associate values in worksheet?? Jon M	by Pete_UK	1	575
Lookup where column data does not match NTK	by NTK	2	519
Pivot Tables & Conditional Formatting jbird	by Debra Dalgleish	2	797
IF and Betwwen - how to ? H. Nissen[_2_]	by H. Nissen[_2_]	2	295
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	881
Stop text carries over Godwin Chan	by Godwin Chan	3	540
Calendar or date formulas Lady P	by Nayab	2	512
Removing unwanted columns in a list PLJohnson	by PLJohnson	0	480
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	391
Protect columns with password Anders	by Anders	0	501
Count rows after filter Learn-more	by Learn-more	2	1,635
Restricting cell data amount NoodNutt	by Héctor Miguel	6	572
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	386