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,813
frozen spreadsheet elsa	by Gord Dibben	4	943
Annual Wages Sheet to pick up info from Time Sheet stallence	by stallence	2	654
Formatting and adding cells formatted to 2 decimal places Colin	by Gord Dibben	3	594
Name Box MikeL	by Rick Rothstein $MVP - VB$[_396_]	4	605
Find matching data in two workbooks franklinbukoski	by Spiky	1	1,484
add a cell reference to the start of a formula h.	by T. Valko	3	325
How do I combine Exel workbooks? Kman	by Spiky	2	530
Count the number of values in a list that meet certain criteria Fudgy	by Peo Sjoblom	1	881
Picking up the latest text value in a column djmagcruznyc	by djmagcruznyc	5	734
Want blank cell displayed if indirectly referenced value is zero Pierre	by Pierre	3	701
Formula search Igor[_2_]	by Igor[_2_]	0	353
countif two columns two criteria Doris[_2_]	by Doris	6	514
Count and/or sum data within a date span. JM	by Spiky	5	696
Vlookup keydet1979	by T. Valko	1	374
Gridlines dissappeared behind formated cells. Get them back? fkruz	by Tom Hutchins	1	469
Extract Text Peanut	by Ron Rosenfeld	3	331
Help with IF function Nina	by Dave	3	338
Sumproduct #Value! Problem deeds	by deeds	8	439
Filter by Top 10 doesn't work Indiana Jones	by Peo Sjoblom	1	2,438
Project days allocation (better mail format) dumbaswood	by Tushar Mehta (Microsoft MVP Excel 2000-2008)	3	387
Cal Bal Hr & Min TSK	by Peo Sjoblom	1	404
Return Time for Duplicate Files & Times Mayte	by Mayte	4	464
How do I format cell to 0.25 resolution? Bugman	by David Biddulph[_2_]	3	373
Copy from another sheet cottage6	by cottage6	3	352
Project days allocation dumbaswood	by Tushar Mehta (Microsoft MVP Excel 2000-2008)	1	350
how do i round decimal if 2.3=2.5 2.7=2.5 & 2.8=3.0 tiffa	by MartinW	4	1,335
vlookup i think? jono	by Mike H	1	308
compare 2 spreadsheets jono	by jono	0	481
How to set minus value to 0 TSK	by Arvi Laanemets	9	773
How to set the value to zero if it negative after the substract TSK	by TSK	6	918
Set value to zero when result is 0 otherwise show actual value TSK	by Gary''s Student	5	673
Value look up Batshon	by Pete_UK	1	352
Finding & Replacing a list of Data in Multiple Columns Me	by Pete_UK	1	488
Need Help: Multiple Criteria Chris McKenzie	by Pete_UK	3	302
Total Dollar Amounts From Different Worksheet roy.okinawa	by roy.okinawa	5	844
If statement working only once Lime	by Lime	0	585
i just want to allocate $ by month, for many projects dumbaswood	by dumbaswood	0	595
Calculating STDEV and other Calcs based on another cells value Scott	by T. Valko	3	561
work only with value without updating mh_amri	by Jim Cone[_2_]	2	402
fill data automatically into another worksheet ema	by Gord Dibben	2	619
conditional statistics PeSt	by Bernard Liengme	3	484
Formula help Patrick C. Simonds	by Sandy Mann	2	433
Search Formula to collate BOM Data Peter C	by Herbert Seidenberg	3	751
username robzrob	by Gord Dibben	2	476
Standardizing Street Addresses in a Large Address Database [email protected]	by Ron Rosenfeld	1	2,135
Lookup order Nordic	by Gord Dibben	2	416
Adding Values Sandy	by Sandy	3	374
Comparing Data henriques	by Max	4	344
Concatenation JPS	by T. Valko	3	501
Copying formula to sum multiple columns Kathy	by T. Valko	3	1,114
basic opertors Tanya	by Héctor Miguel	10	655
string manipulation, pulling out last name from column [email protected]	by Ron Rosenfeld	7	895
I can't autofill cells in a column if blank cells in between SJ	by Ken Johnson	1	678
Certain Cells Appearing cts	by cts	4	336
Inserting blank rows for missing data in order to transpose [email protected]	by Otto Moehrbach[_2_]	3	749
Lookup text in 1 column and make notations in another Nordic	by Gord Dibben	1	587
strange happenings with move/copy worksheet Don	by Gord Dibben	1	460
pulling data in rows! via135	by via135	5	557
how to align text to 45 angle without angale boarders asa	by Gord Dibben	3	963
Lookup text in 1 column and note it in another Nordic	by Peo Sjoblom	1	474
Spreadsheet refresh time. . . Pierre	by Don Guillett	2	581
a few condition teratak	by BoniM	7	568
Average # in total group with multiple criteria? Jonathan	by Domenic[_2_]	8	881
Blinking text somaloft	by Gary''s Student	1	477
Guidance/Help to Highlight Cell contentts Based on Min/Max Vince[_2_]	by Tanya	2	635
Two subjects: Column sort and True/False in cell dilynn17	by Tanya	3	5,295
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,364
How do I past data into the Find and Replace box Excel 2003? Cpence	by Max	1	683
LOOKUP Connie Martin	by Pete_UK	5	278
lock cells John R	by Dave	5	502
extract data from one worksheet to another worksheet Jeff	by Teethless mama	5	2,100
count text entries pja	by Gord Dibben	4	482
transpoe with formulas dragomira	by Gord Dibben	4	592
changing date format Julie	by Gord Dibben	12	1,168