Excel Worksheet Functions - Page 806

Thread / Thread Starter	Last Post	Replies	Views
Concatenation JPS	by T. Valko	3	486
Comparing Data henriques	by Max	4	325
Adding Values Sandy	by Sandy	3	348
Lookup order Nordic	by Gord Dibben	2	404
Standardizing Street Addresses in a Large Address Database [email protected]	by Ron Rosenfeld	1	2,118
username robzrob	by Gord Dibben	2	466
Search Formula to collate BOM Data Peter C	by Herbert Seidenberg	3	741
Formula help Patrick C. Simonds	by Sandy Mann	2	429
conditional statistics PeSt	by Bernard Liengme	3	465
fill data automatically into another worksheet ema	by Gord Dibben	2	602
work only with value without updating mh_amri	by Jim Cone[_2_]	2	386
Calculating STDEV and other Calcs based on another cells value Scott	by T. Valko	3	536
i just want to allocate $ by month, for many projects dumbaswood	by dumbaswood	0	577
If statement working only once Lime	by Lime	0	567
Total Dollar Amounts From Different Worksheet roy.okinawa	by roy.okinawa	5	822
Need Help: Multiple Criteria Chris McKenzie	by Pete_UK	3	287
Finding & Replacing a list of Data in Multiple Columns Me	by Pete_UK	1	467
Value look up Batshon	by Pete_UK	1	347
Set value to zero when result is 0 otherwise show actual value TSK	by Gary''s Student	5	660
How to set the value to zero if it negative after the substract TSK	by TSK	6	900
How to set minus value to 0 TSK	by Arvi Laanemets	9	752
compare 2 spreadsheets jono	by jono	0	462
vlookup i think? jono	by Mike H	1	304
how do i round decimal if 2.3=2.5 2.7=2.5 & 2.8=3.0 tiffa	by MartinW	4	1,281
Project days allocation dumbaswood	by Tushar Mehta (Microsoft MVP Excel 2000-2008)	1	339
Copy from another sheet cottage6	by cottage6	3	344
How do I format cell to 0.25 resolution? Bugman	by David Biddulph[_2_]	3	368
Return Time for Duplicate Files & Times Mayte	by Mayte	4	448
Cal Bal Hr & Min TSK	by Peo Sjoblom	1	400
Project days allocation (better mail format) dumbaswood	by Tushar Mehta (Microsoft MVP Excel 2000-2008)	3	365
Filter by Top 10 doesn't work Indiana Jones	by Peo Sjoblom	1	2,399
Sumproduct #Value! Problem deeds	by deeds	8	428
Help with IF function Nina	by Dave	3	323
Extract Text Peanut	by Ron Rosenfeld	3	317
Gridlines dissappeared behind formated cells. Get them back? fkruz	by Tom Hutchins	1	458
Vlookup keydet1979	by T. Valko	1	367
Count and/or sum data within a date span. JM	by Spiky	5	674
countif two columns two criteria Doris[_2_]	by Doris	6	490
Formula search Igor[_2_]	by Igor[_2_]	0	342
Want blank cell displayed if indirectly referenced value is zero Pierre	by Pierre	3	694
Picking up the latest text value in a column djmagcruznyc	by djmagcruznyc	5	728
Count the number of values in a list that meet certain criteria Fudgy	by Peo Sjoblom	1	855
How do I combine Exel workbooks? Kman	by Spiky	2	517
add a cell reference to the start of a formula h.	by T. Valko	3	310
Find matching data in two workbooks franklinbukoski	by Spiky	1	1,467
Name Box MikeL	by Rick Rothstein $MVP - VB$[_396_]	4	595
Formatting and adding cells formatted to 2 decimal places Colin	by Gord Dibben	3	579
Annual Wages Sheet to pick up info from Time Sheet stallence	by stallence	2	632
frozen spreadsheet elsa	by Gord Dibben	4	933
can you anchor an image to a cell in excel? jy15bill	by Gord Dibben	4	3,790
How to set macro to Paste Special Value to next empty column [email protected]	by Max	9	1,381
how do I show the arrow for dropdown menu in excel? dorinc29	by Max	1	1,798
compare two lists lark	by Dave	3	585
Tracking cursor location JonStein	by Mike	1	813
"Labels as Names" stopped working [email protected]	by [email protected]	2	491
Meaning of $ in function or formula Kula	by David Biddulph[_2_]	2	565
Duplicating/Mirror Data into another worksheet within same workboo TJ	by Pete_UK	1	6,003
SUMIF with text bgkgmg	by Pete_UK	1	545
help with functions angel	by Arvi Laanemets	3	334
Pivot table - display all labels (i.e: do not summarise) how to? Martin	by Dave Peterson	1	520
2 Macros running on same module Travis	by Travis	2	448
Sumif multiple criteria? Alan	by Bob Phillips	3	379
count months between years dqm	by David Biddulph[_2_]	3	487
What is the formula to calculate electricity consumption TSK	by David Biddulph[_2_]	4	2,151
CountIF Help Glenn	by Glenn	3	362
cant insert column get error message sheppey	by Ken Johnson	2	392
Move to next line bgkgmg	by Max	1	607
Need VBA script to auto-insert value upon row insert Phil	by Otto Moehrbach[_2_]	4	966
Different Language Settings... Trevor Williams	by Trevor Williams	5	487
Finding entries across columns bollard	by Max	2	405
Upgrade from 2002 to 2007 W Wolfe[_2_]	by W Wolfe	4	845
IF Statement not working Barrett M	by Barrett M[_2_]	8	500
Macro To Remove Subtotals from ALL Worksheets vidguru	by vidguru	2	3,976
needing to calculate entries, but no the spaces in some cells joflo65	by joflo65	2	399
Percentage of the occurance of a word in a date range Art-SNL	by T. Valko	8	526