Excel Worksheet Functions - Page 322

Thread / Thread Starter	Last Post	Replies	Views
COUNT IF DUB	by T. Valko	3	337
Formatting an Excel number cell JOSEPH HAGGAR - SYDNEY , AUSTRALIA	by Héctor Miguel	3	616
VLOOKUP & non-contiguous table array Ruchi A.[_2_]	by T. Valko	3	5,285
Method to Capitalize Existing Data JerryS	by Rick Rothstein \(MVP - VB\)[_1134_]	2	693
instering rows in one worksheet that reflect another worksheet Tsato	by Otto Moehrbach[_2_]	1	493
macro - how to move to a specific cell and repeat andrea	by Otto Moehrbach[_2_]	7	616
Multiplying Arrays Phil H[_2_]	by Harlan Grove[_2_]	8	4,037
formatting text scott	by Rick Rothstein \(MVP - VB\)[_1132_]	3	383
Entering digits in a cell with numbers already inside cell [email protected]	by Rick Rothstein \(MVP - VB\)[_1131_]	4	813
coloring a cell if blank Karenobrn	by macropod[_2_]	5	1,241
Is there a way to sort worksheets within a folder? cb0727	by Peo Sjoblom[_2_]	1	390
Basic formula Mana	by Spiky	1	309
Updateable drop-down menu for an item database? phillr	by T. Valko	1	390
Coding for a specific day cmatera	by T. Valko	1	343
Need help adding hours exceeding 24 hours faerk	by faerk	7	948
Can I do this in Excel 2007? cyndiwise notsowise	by Ron Rosenfeld	4	425
'only created connection' grayed out wilson	by wilson	0	1,996
1 Shhet Roger	by Roger	0	343
Selecting Cells Terry	by Don Guillett	1	354
SUMPRODUCT - Using Month Phendrena	by Phendrena	15	1,533
Find data to the Right of... Mike R.	by Ron Rosenfeld	2	569
Product & Price lists Aimee UMS	by Peo Sjoblom[_2_]	1	318
Save Workshetts as Separate Files Elvis	by Roger Govier[_3_]	2	417
Multiple Sumif conditions Alcala	by Alcala	2	448
Split Alpha Field Dick W.	by Dick W.	2	920
Lookup best case based on varying input???? scottgorilla[_2_]	by scottgorilla[_2_]	9	726
VLOOKUP...help please! ClareMylrea	by ClareMylrea	4	309
Do not let a percentage be greater than 100 triplejay23	by triplejay23	2	660
Convert/rewrite SUMIFS formula to work in Excel 97 Karin	by Karin	3	3,121
circular reference Sasa Stankovic	by Spiky	3	954
count if for more than one criteria Gerardo	by Roger Govier[_3_]	5	693
Sumproduct gives #VALUE Phil_S	by Don Guillett	3	436
toolbuttons tjp	by tjp	0	335
in ms excel how to count the no of cells anji	by Dana DeLouis	3	408
Summing values, x rows deep, depending on a criterion klm[_2_]	by klm[_2_]	2	513
password protect certain cells change Miree	by Otto Moehrbach[_2_]	1	324
Login Name and now function saran	by saran	3	490
Database price updating chefdoug	by Max	3	550
Counting number of cells that match name AND number Ronster[_2_]	by Mike H	4	704
How do I use the excel function "funformula"? Ade	by Héctor Miguel	1	444
Macro Button or Auto Protect Formula enna49	by enna49	3	660
ColorIndexOfOneCell shank	by shank	8	1,310
help with formula so confused	by David Biddulph[_2_]	4	357
Average for times using minutes and seconds aj81a	by Sasa Stankovic	2	1,198
How to copy cells from one worksheet to another if the value in ra sgtpsychosis	by Otto Moehrbach[_2_]	4	545
Word size for each cell Lookup formula limitation?[_2_]	by Sasa Stankovic	1	328
Conditional Formatting Question pivot table	by [email protected]	1	382
Advanced Filter how to include columns V[_2_]	by Debra Dalgleish	1	377
Count occurrents based on criteria in different column Blueagm	by smartin	2	547
Conditional formatting & decimal part of a number in cell Mac	by Mac	4	858
tabs are missing even though 'tools-options-view-sheet tabs' ok? rgranell	by Gord Dibben	3	1,624
Summarising Data Murray	by Mike H	5	386
Sort Worksheets (without VB) Elgee	by Don Guillett	4	521
change data of entire column from small case to upper case Ann	by Dave Peterson	1	1,412
Take a 3 or for digit time and convet it to time in one cell Djbaker70	by Héctor Miguel	9	646
Sort by color: Is there an easy way to sort columns or rows in EX MGP	by Bob Phillips	5	910
countif on cells with formula's won't work correctly JusMe	by JusMe	21	2,748
Converting Millitary Time to Hours worked and OT hours Djbaker70	by Peo Sjoblom	3	662
Making a cell change time to hours Djbaker70	by Héctor Miguel	2	403
Deleting entire row if cell contains "value" - how to review everytime? V[_2_]	by smartin	1	3,060
Use the custom filter dialog in a macro KenInPortland	by Héctor Miguel	3	818
Formula - HHHHHEELLLPP K	by smartin	1	542
Visual Basic Erro 400 Minitman	by Minitman	2	468
How to schedule an auto "Save As" of an Excel spreadsheet daily... Turbine Mechanic	by NoodNutt	2	4,212
Help with UDF to search through a table [email protected]	by smartin	1	445
Linera fill formula Geoffric	by smartin	1	408
Changing text colors for editing Jalynno	by Gord Dibben	1	432
COUNTIF a cell value is between two numbers LAWNDALE	by T. Valko	3	4,220
EXCEL CELL MERGE Patricia	by Patricia	3	1,213
SUMPRODUCT formula compare then count Greg in CO[_2_]	by Greg in CO[_2_]	3	480
Eliminating Values from a worksheet Terry	by pshepard	4	511
How to reference or redirect a formula in a base row? Paul Schrum	by pshepard	3	2,486
Conditional arrays within SUMPRODUCT Phil H[_2_]	by Phil H[_2_]	0	655
today functions diggs	by Gord Dibben	4	378
SEARCH and IF Jorge	by T. Valko	3	286