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,808
frozen spreadsheet elsa	by Gord Dibben	4	942
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	586
Name Box MikeL	by Rick Rothstein $MVP - VB$[_396_]	4	596
Find matching data in two workbooks franklinbukoski	by Spiky	1	1,474
add a cell reference to the start of a formula h.	by T. Valko	3	314
How do I combine Exel workbooks? Kman	by Spiky	2	527
Count the number of values in a list that meet certain criteria Fudgy	by Peo Sjoblom	1	869
Picking up the latest text value in a column djmagcruznyc	by djmagcruznyc	5	732
Want blank cell displayed if indirectly referenced value is zero Pierre	by Pierre	3	700
Formula search Igor[_2_]	by Igor[_2_]	0	350
countif two columns two criteria Doris[_2_]	by Doris	6	508
Count and/or sum data within a date span. JM	by Spiky	5	689
Vlookup keydet1979	by T. Valko	1	374
Gridlines dissappeared behind formated cells. Get them back? fkruz	by Tom Hutchins	1	463
Extract Text Peanut	by Ron Rosenfeld	3	322
Help with IF function Nina	by Dave	3	330
Sumproduct #Value! Problem deeds	by deeds	8	435
Filter by Top 10 doesn't work Indiana Jones	by Peo Sjoblom	1	2,429
Project days allocation (better mail format) dumbaswood	by Tushar Mehta (Microsoft MVP Excel 2000-2008)	3	379
Cal Bal Hr & Min TSK	by Peo Sjoblom	1	404
Return Time for Duplicate Files & Times Mayte	by Mayte	4	456
How do I format cell to 0.25 resolution? Bugman	by David Biddulph[_2_]	3	372
Copy from another sheet cottage6	by cottage6	3	350
Project days allocation dumbaswood	by Tushar Mehta (Microsoft MVP Excel 2000-2008)	1	343
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	307
compare 2 spreadsheets jono	by jono	0	476
How to set minus value to 0 TSK	by Arvi Laanemets	9	766
How to set the value to zero if it negative after the substract TSK	by TSK	6	906
Set value to zero when result is 0 otherwise show actual value TSK	by Gary''s Student	5	663
Value look up Batshon	by Pete_UK	1	348
Finding & Replacing a list of Data in Multiple Columns Me	by Pete_UK	1	485
Need Help: Multiple Criteria Chris McKenzie	by Pete_UK	3	291
Total Dollar Amounts From Different Worksheet roy.okinawa	by roy.okinawa	5	841
If statement working only once Lime	by Lime	0	576
i just want to allocate $ by month, for many projects dumbaswood	by dumbaswood	0	587
Calculating STDEV and other Calcs based on another cells value Scott	by T. Valko	3	558
work only with value without updating mh_amri	by Jim Cone[_2_]	2	389
fill data automatically into another worksheet ema	by Gord Dibben	2	609
conditional statistics PeSt	by Bernard Liengme	3	470
Formula help Patrick C. Simonds	by Sandy Mann	2	432
Search Formula to collate BOM Data Peter C	by Herbert Seidenberg	3	749
username robzrob	by Gord Dibben	2	476
Standardizing Street Addresses in a Large Address Database [email protected]	by Ron Rosenfeld	1	2,130
Lookup order Nordic	by Gord Dibben	2	413
Adding Values Sandy	by Sandy	3	371
Comparing Data henriques	by Max	4	331
Concatenation JPS	by T. Valko	3	492
Copying formula to sum multiple columns Kathy	by T. Valko	3	1,103
basic opertors Tanya	by Héctor Miguel	10	654
string manipulation, pulling out last name from column [email protected]	by Ron Rosenfeld	7	892
I can't autofill cells in a column if blank cells in between SJ	by Ken Johnson	1	677
Certain Cells Appearing cts	by cts	4	326
Inserting blank rows for missing data in order to transpose [email protected]	by Otto Moehrbach[_2_]	3	743
Lookup text in 1 column and make notations in another Nordic	by Gord Dibben	1	585
strange happenings with move/copy worksheet Don	by Gord Dibben	1	459
pulling data in rows! via135	by via135	5	548
how to align text to 45 angle without angale boarders asa	by Gord Dibben	3	960
Lookup text in 1 column and note it in another Nordic	by Peo Sjoblom	1	474
Spreadsheet refresh time. . . Pierre	by Don Guillett	2	573
a few condition teratak	by BoniM	7	565
Average # in total group with multiple criteria? Jonathan	by Domenic[_2_]	8	868
Blinking text somaloft	by Gary''s Student	1	465
Guidance/Help to Highlight Cell contentts Based on Min/Max Vince[_2_]	by Tanya	2	622
Two subjects: Column sort and True/False in cell dilynn17	by Tanya	3	5,294
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,355
How do I past data into the Find and Replace box Excel 2003? Cpence	by Max	1	667
LOOKUP Connie Martin	by Pete_UK	5	275
lock cells John R	by Dave	5	501
extract data from one worksheet to another worksheet Jeff	by Teethless mama	5	2,099
count text entries pja	by Gord Dibben	4	471
transpoe with formulas dragomira	by Gord Dibben	4	579
changing date format Julie	by Gord Dibben	12	1,159