Excel Worksheet Functions - Page 322

Thread / Thread Starter	Last Post	Replies	Views
COUNT IF DUB	by T. Valko	3	324
Formatting an Excel number cell JOSEPH HAGGAR - SYDNEY , AUSTRALIA	by Héctor Miguel	3	600
VLOOKUP & non-contiguous table array Ruchi A.[_2_]	by T. Valko	3	5,226
Method to Capitalize Existing Data JerryS	by Rick Rothstein \(MVP - VB\)[_1134_]	2	665
instering rows in one worksheet that reflect another worksheet Tsato	by Otto Moehrbach[_2_]	1	481
macro - how to move to a specific cell and repeat andrea	by Otto Moehrbach[_2_]	7	607
Multiplying Arrays Phil H[_2_]	by Harlan Grove[_2_]	8	4,015
formatting text scott	by Rick Rothstein \(MVP - VB\)[_1132_]	3	368
Entering digits in a cell with numbers already inside cell [email protected]	by Rick Rothstein \(MVP - VB\)[_1131_]	4	788
coloring a cell if blank Karenobrn	by macropod[_2_]	5	1,222
Is there a way to sort worksheets within a folder? cb0727	by Peo Sjoblom[_2_]	1	388
Basic formula Mana	by Spiky	1	294
Updateable drop-down menu for an item database? phillr	by T. Valko	1	374
Coding for a specific day cmatera	by T. Valko	1	337
Need help adding hours exceeding 24 hours faerk	by faerk	7	919
Can I do this in Excel 2007? cyndiwise notsowise	by Ron Rosenfeld	4	414
'only created connection' grayed out wilson	by wilson	0	1,988
1 Shhet Roger	by Roger	0	334
Selecting Cells Terry	by Don Guillett	1	344
SUMPRODUCT - Using Month Phendrena	by Phendrena	15	1,506
Find data to the Right of... Mike R.	by Ron Rosenfeld	2	550
Product & Price lists Aimee UMS	by Peo Sjoblom[_2_]	1	295
Save Workshetts as Separate Files Elvis	by Roger Govier[_3_]	2	396
Multiple Sumif conditions Alcala	by Alcala	2	423
Split Alpha Field Dick W.	by Dick W.	2	908
Lookup best case based on varying input???? scottgorilla[_2_]	by scottgorilla[_2_]	9	716
VLOOKUP...help please! ClareMylrea	by ClareMylrea	4	295
Do not let a percentage be greater than 100 triplejay23	by triplejay23	2	649
Convert/rewrite SUMIFS formula to work in Excel 97 Karin	by Karin	3	3,050
circular reference Sasa Stankovic	by Spiky	3	935
count if for more than one criteria Gerardo	by Roger Govier[_3_]	5	684
Sumproduct gives #VALUE Phil_S	by Don Guillett	3	433
toolbuttons tjp	by tjp	0	324
in ms excel how to count the no of cells anji	by Dana DeLouis	3	404
Summing values, x rows deep, depending on a criterion klm[_2_]	by klm[_2_]	2	498
password protect certain cells change Miree	by Otto Moehrbach[_2_]	1	310
Login Name and now function saran	by saran	3	469
Database price updating chefdoug	by Max	3	525
Counting number of cells that match name AND number Ronster[_2_]	by Mike H	4	696
How do I use the excel function "funformula"? Ade	by Héctor Miguel	1	428
Macro Button or Auto Protect Formula enna49	by enna49	3	646
ColorIndexOfOneCell shank	by shank	8	1,303
help with formula so confused	by David Biddulph[_2_]	4	346
Average for times using minutes and seconds aj81a	by Sasa Stankovic	2	1,183
How to copy cells from one worksheet to another if the value in ra sgtpsychosis	by Otto Moehrbach[_2_]	4	537
Word size for each cell Lookup formula limitation?[_2_]	by Sasa Stankovic	1	320
Conditional Formatting Question pivot table	by [email protected]	1	372
Advanced Filter how to include columns V[_2_]	by Debra Dalgleish	1	363
Count occurrents based on criteria in different column Blueagm	by smartin	2	536
Conditional formatting & decimal part of a number in cell Mac	by Mac	4	840
tabs are missing even though 'tools-options-view-sheet tabs' ok? rgranell	by Gord Dibben	3	1,542
Summarising Data Murray	by Mike H	5	371
Sort Worksheets (without VB) Elgee	by Don Guillett	4	509
change data of entire column from small case to upper case Ann	by Dave Peterson	1	1,392
Take a 3 or for digit time and convet it to time in one cell Djbaker70	by Héctor Miguel	9	642
Sort by color: Is there an easy way to sort columns or rows in EX MGP	by Bob Phillips	5	883
countif on cells with formula's won't work correctly JusMe	by JusMe	21	2,724
Converting Millitary Time to Hours worked and OT hours Djbaker70	by Peo Sjoblom	3	642
Making a cell change time to hours Djbaker70	by Héctor Miguel	2	398
Deleting entire row if cell contains "value" - how to review everytime? V[_2_]	by smartin	1	3,035
Use the custom filter dialog in a macro KenInPortland	by Héctor Miguel	3	800
Formula - HHHHHEELLLPP K	by smartin	1	537
Visual Basic Erro 400 Minitman	by Minitman	2	447
How to schedule an auto "Save As" of an Excel spreadsheet daily... Turbine Mechanic	by NoodNutt	2	4,185
Help with UDF to search through a table [email protected]	by smartin	1	428
Linera fill formula Geoffric	by smartin	1	398
Changing text colors for editing Jalynno	by Gord Dibben	1	421
COUNTIF a cell value is between two numbers LAWNDALE	by T. Valko	3	4,184
EXCEL CELL MERGE Patricia	by Patricia	3	1,180
SUMPRODUCT formula compare then count Greg in CO[_2_]	by Greg in CO[_2_]	3	468
Eliminating Values from a worksheet Terry	by pshepard	4	489
How to reference or redirect a formula in a base row? Paul Schrum	by pshepard	3	2,463
Conditional arrays within SUMPRODUCT Phil H[_2_]	by Phil H[_2_]	0	648
today functions diggs	by Gord Dibben	4	369
SEARCH and IF Jorge	by T. Valko	3	284