Excel Worksheet Functions - Page 115

Thread / Thread Starter	Last Post	Replies	Views
blanks in data validation list dropdown confused	by confused	7	1,553
Excel'de metin iÃ§inden kelime alma GÃ¼rcan CAVLAK	by Shane Devenshire	1	1,553
YTD Calculation using SUM and OFFSET dallen917	by T. Valko	4	1,552
How do I insert a counter? DianeBrew	by Michael.Tarnowski	3	1,552
Insert a standard character in a cell of excel. JulieD	by Tammy Singer	5	1,552
What does Show Ink in Excel, Review Tab, comment, do? E. Duke 462	by E. Duke 462	0	1,552
Display missing Part Number if Column A does not match column B Erik T	by L. Howard Kittle	2	1,552
find and replace - replace data in rows to separated by commas msdker	by Gord Dibben	1	1,552
Errors in COUNT, COUNTA, COUNTIF when counting merged cells Outback	by Dave Peterson	1	1,552
Sorting Parent Child kcmtnbiker	by David McRitchie	2	1,551
R1C1 Formula in Excel Barb Reinhardt	by Sloth	2	1,551
How to calculate with #div/0! error? nagje	by nagje	12	1,551
Any formula to count number of cells with a specific color pattern Stu	by ryguy7272	2	1,551
Drop Down List choice selecting another drop down list CVD0722	by CVD0722	3	1,551
conditional cell format based on cell in same row, previous column tamiluchi	by Dav	7	1,551
VIN Number sorting HRassist	by Gord Dibben	10	1,551
auto updating list Larry	by Larry	8	1,551
How do I count nonblank cells that meet criteria in another cell? jimswinder	by David Biddulph	13	1,551
Excel should be able to compute the MOD of large numbers. Gold Fish	by Frank Kabel	5	1,551
Counting the number of cells meeting conditional formating criteria Jeff	by Jeff	4	1,551
PMT 30/365 vs 30/360 Will	by Fred Smith	1	1,551
Why doesn't "Replace" function find value I know exists? UHAAdminAsst	by Gord Dibben	4	1,551
CountIf Function - require range of criterea John F	by Biff	10	1,551
Sum value between two dates and copy to new cell dave	by dave	6	1,551
SUMIF using value from MOD function Steve Vincent	by T. Valko	2	1,551
How do I insert the directory path in my Excel file? Insert a Directory Path in Header/Footer	by Nicole L.	2	1,550
VLOOKUP and DGET to find a value with multiple criterion jaybird2307	by jaybird2307	8	1,550
APR - Annual Percentage Rate marlia	by N Harkawat	2	1,550
Rounding a number to a multiple quantity that adds to a fixed total number wjlo	by JE McGimpsey	1	1,550
Displaying percentage sign in cell Feather 52	by Roger Govier	3	1,550
VBA code to copy cell contents from one sheet to another Gimp	by Gimp	0	1,550
Excel problem: Cant hide column. Sorcerdon	by Sorcerdon	4	1,550
How do I sum increments of minutes and seconds SandyMichalski	by Bernard Liengme	5	1,550
copy data of two cells from Sheet 2 into one cell in Sheet 1 cahabbinga	by Pete_UK	6	1,550
Opposite of Concatenate shane24	by Ron Rosenfeld	6	1,550
Counting items in one column based on criteria in another column luttona	by luttona	3	1,550
Rolling date looking 30 Days past Chris	by Max	2	1,550
Excel 2007 - copying filtered data to another workbook texansgal	by Bassman62	1	1,550
Can I mail merge filtered data on an Excel spreadsheet to a word d Matt Squires	by Frank Kabel	1	1,549
COUNTIF across multiple tabs in Google Sheets Victoria Emory	by Wilbur Chua	3	1,549
Combining SUMPRODUCT with IF - help! John Elford	by John Elford	1	1,549
How to sum by month Charles	by Roger Govier[_8_]	8	1,549
Dificulty in copy and paste when items is filtered in excel 2007 henksa	by [email protected]	2	1,549
WEEKNUM function not working Cam	by Dave Peterson	4	1,549
Text Function 2nd argument Gene	by ShaneDevenshire	10	1,549
Help!: lead sheet data needs to fill appropriate subject sheets carebear	by Frank Kabel	1	1,549
Deleting rows with blank cells Batman	by Gord Dibben	10	1,549
Excel formula-cell reference not working pbog	by pbog	3	1,549
offset every nth column Sampson	by Sampson	2	1,549
if data in one cell, then date in adjacent cell Jane	by Max	8	1,549
Excel 2002 "Protect Sheet", but Allow "Insert Comments"? VP Safe	by VP Safe	2	1,549
Which is faster? SUMPRODUCT or VLOOKUP, or another alternative? SteveC	by Aladin Akyurek	6	1,548
Representing letters (and symbol) to different numbers bunalz	by joeu2004[_2_]	6	1,548
Highlighting duplicates across many sheets jpeevy	by GS[_2_]	3	1,548
Sum function not working correctly in Excel (Skips Cell) Tony	by Gord Dibben	5	1,548
Macro - Skipping a line PaulPoll	by Dave Peterson	4	1,548
Auto update entire columns / rows??? Kcurtis	by IC	3	1,548
Finding Specific Text in a Text String Peter Gundrum	by Aladin Akyurek	9	1,548
significant figures Crystal	by Ron Rosenfeld	14	1,548
Filter Data From Master Sheet Into Other Worksheets Michelle	by Max	1	1,548
better way to write a count if statement? luscioussarita	by JP[_4_]	3	1,548
Standard Deviation Carlos	by Carlos	10	1,548
keyboard shortcut for zoom Henrik	by David McRitchie	2	1,548
sum cells based on criteria in first set of cells summernight	by summernight	3	1,548
Arithmetical Mode of Criteria in Multiple Non-Adjacent columns Sam via OfficeKB.com	by Sam via OfficeKB.com	4	1,547
drop-down list validation won't allow a different worksheet justmetn	by Ken Wright	4	1,547
find and replace links in Excel 2003 MAndrews	by MAndrews	2	1,547
Excluding 0s and blanks from a LINEST function Disco	by [email protected]	4	1,547
Clear Cell Without Removing Formula Scott	by Sloth	4	1,547
VLookup returns #VALUE! BEEJAY	by BEEJAY	2	1,546
INDIRECT formula Ken[_2_]	by Sandy Mann	12	1,546
Round time to nearest quarter hr John	by John	2	1,546
Find last name in multi-part name? Eric	by Ron Rosenfeld	4	1,546
Formula = Today's date + 1 month jermsalerms	by daddylonglegs	5	1,546
How do I use LOOKUP to return a range of values, then SUM values? irvine79	by Fred Smith	5	1,546