Excel Worksheet Functions - Page 378

Thread / Thread Starter	Last Post	Replies	Views
can you anchor an image to a cell in excel? jy15bill	by Gord Dibben	4	3,789
frozen spreadsheet elsa	by Gord Dibben	4	927
Annual Wages Sheet to pick up info from Time Sheet stallence	by stallence	2	625
Formatting and adding cells formatted to 2 decimal places Colin	by Gord Dibben	3	578
Name Box MikeL	by Rick Rothstein $MVP - VB$[_396_]	4	595
Find matching data in two workbooks franklinbukoski	by Spiky	1	1,463
add a cell reference to the start of a formula h.	by T. Valko	3	308
How do I combine Exel workbooks? Kman	by Spiky	2	516
Count the number of values in a list that meet certain criteria Fudgy	by Peo Sjoblom	1	853
Picking up the latest text value in a column djmagcruznyc	by djmagcruznyc	5	725
Want blank cell displayed if indirectly referenced value is zero Pierre	by Pierre	3	691
Formula search Igor[_2_]	by Igor[_2_]	0	342
countif two columns two criteria Doris[_2_]	by Doris	6	489
Count and/or sum data within a date span. JM	by Spiky	5	673
Vlookup keydet1979	by T. Valko	1	367
Gridlines dissappeared behind formated cells. Get them back? fkruz	by Tom Hutchins	1	457
Extract Text Peanut	by Ron Rosenfeld	3	317
Help with IF function Nina	by Dave	3	323
Sumproduct #Value! Problem deeds	by deeds	8	424
Filter by Top 10 doesn't work Indiana Jones	by Peo Sjoblom	1	2,390
Project days allocation (better mail format) dumbaswood	by Tushar Mehta (Microsoft MVP Excel 2000-2008)	3	364
Cal Bal Hr & Min TSK	by Peo Sjoblom	1	400
Return Time for Duplicate Files & Times Mayte	by Mayte	4	445
How do I format cell to 0.25 resolution? Bugman	by David Biddulph[_2_]	3	368
Copy from another sheet cottage6	by cottage6	3	343
Project days allocation dumbaswood	by Tushar Mehta (Microsoft MVP Excel 2000-2008)	1	336
how do i round decimal if 2.3=2.5 2.7=2.5 & 2.8=3.0 tiffa	by MartinW	4	1,280
vlookup i think? jono	by Mike H	1	304
compare 2 spreadsheets jono	by jono	0	458
How to set minus value to 0 TSK	by Arvi Laanemets	9	749
How to set the value to zero if it negative after the substract TSK	by TSK	6	900
Set value to zero when result is 0 otherwise show actual value TSK	by Gary''s Student	5	657
Value look up Batshon	by Pete_UK	1	347
Finding & Replacing a list of Data in Multiple Columns Me	by Pete_UK	1	466
Need Help: Multiple Criteria Chris McKenzie	by Pete_UK	3	286
Total Dollar Amounts From Different Worksheet roy.okinawa	by roy.okinawa	5	821
If statement working only once Lime	by Lime	0	565
i just want to allocate $ by month, for many projects dumbaswood	by dumbaswood	0	576
Calculating STDEV and other Calcs based on another cells value Scott	by T. Valko	3	536
work only with value without updating mh_amri	by Jim Cone[_2_]	2	386
fill data automatically into another worksheet ema	by Gord Dibben	2	602
conditional statistics PeSt	by Bernard Liengme	3	465
Formula help Patrick C. Simonds	by Sandy Mann	2	426
Search Formula to collate BOM Data Peter C	by Herbert Seidenberg	3	737
username robzrob	by Gord Dibben	2	464
Standardizing Street Addresses in a Large Address Database [email protected]	by Ron Rosenfeld	1	2,118
Lookup order Nordic	by Gord Dibben	2	404
Adding Values Sandy	by Sandy	3	344
Comparing Data henriques	by Max	4	325
Concatenation JPS	by T. Valko	3	486
Copying formula to sum multiple columns Kathy	by T. Valko	3	1,095
basic opertors Tanya	by Héctor Miguel	10	650
string manipulation, pulling out last name from column [email protected]	by Ron Rosenfeld	7	877
I can't autofill cells in a column if blank cells in between SJ	by Ken Johnson	1	664
Certain Cells Appearing cts	by cts	4	321
Inserting blank rows for missing data in order to transpose [email protected]	by Otto Moehrbach[_2_]	3	732
Lookup text in 1 column and make notations in another Nordic	by Gord Dibben	1	560
strange happenings with move/copy worksheet Don	by Gord Dibben	1	449
pulling data in rows! via135	by via135	5	539
how to align text to 45 angle without angale boarders asa	by Gord Dibben	3	951
Lookup text in 1 column and note it in another Nordic	by Peo Sjoblom	1	455
Spreadsheet refresh time. . . Pierre	by Don Guillett	2	568
a few condition teratak	by BoniM	7	555
Average # in total group with multiple criteria? Jonathan	by Domenic[_2_]	8	848
Blinking text somaloft	by Gary''s Student	1	449
Guidance/Help to Highlight Cell contentts Based on Min/Max Vince[_2_]	by Tanya	2	612
Two subjects: Column sort and True/False in cell dilynn17	by Tanya	3	5,277
I tried to get around the problem of the pivot table field settingdefaulting to Count instead of Sum by running a macro of change the settingfrom Count to Sum. However, when I tried to run the Macro, I got error messageof run time error 1004, unable Enda80	by Fred Smith[_4_]	1	1,331
How do I past data into the Find and Replace box Excel 2003? Cpence	by Max	1	660
LOOKUP Connie Martin	by Pete_UK	5	271
lock cells John R	by Dave	5	491
extract data from one worksheet to another worksheet Jeff	by Teethless mama	5	2,084
count text entries pja	by Gord Dibben	4	456
transpoe with formulas dragomira	by Gord Dibben	4	572
changing date format Julie	by Gord Dibben	12	1,135