Excel Worksheet Functions - Page 322

Thread / Thread Starter	Last Post	Replies	Views
COUNT IF DUB	by T. Valko	3	327
Formatting an Excel number cell JOSEPH HAGGAR - SYDNEY , AUSTRALIA	by Héctor Miguel	3	609
VLOOKUP & non-contiguous table array Ruchi A.[_2_]	by T. Valko	3	5,276
Method to Capitalize Existing Data JerryS	by Rick Rothstein \(MVP - VB\)[_1134_]	2	683
instering rows in one worksheet that reflect another worksheet Tsato	by Otto Moehrbach[_2_]	1	492
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	375
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,238
Is there a way to sort worksheets within a folder? cb0727	by Peo Sjoblom[_2_]	1	390
Basic formula Mana	by Spiky	1	303
Updateable drop-down menu for an item database? phillr	by T. Valko	1	381
Coding for a specific day cmatera	by T. Valko	1	343
Need help adding hours exceeding 24 hours faerk	by faerk	7	943
Can I do this in Excel 2007? cyndiwise notsowise	by Ron Rosenfeld	4	417
'only created connection' grayed out wilson	by wilson	0	1,989
1 Shhet Roger	by Roger	0	340
Selecting Cells Terry	by Don Guillett	1	351
SUMPRODUCT - Using Month Phendrena	by Phendrena	15	1,526
Find data to the Right of... Mike R.	by Ron Rosenfeld	2	559
Product & Price lists Aimee UMS	by Peo Sjoblom[_2_]	1	314
Save Workshetts as Separate Files Elvis	by Roger Govier[_3_]	2	407
Multiple Sumif conditions Alcala	by Alcala	2	439
Split Alpha Field Dick W.	by Dick W.	2	911
Lookup best case based on varying input???? scottgorilla[_2_]	by scottgorilla[_2_]	9	726
VLOOKUP...help please! ClareMylrea	by ClareMylrea	4	308
Do not let a percentage be greater than 100 triplejay23	by triplejay23	2	659
Convert/rewrite SUMIFS formula to work in Excel 97 Karin	by Karin	3	3,110
circular reference Sasa Stankovic	by Spiky	3	945
count if for more than one criteria Gerardo	by Roger Govier[_3_]	5	686
Sumproduct gives #VALUE Phil_S	by Don Guillett	3	436
toolbuttons tjp	by tjp	0	325
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	506
password protect certain cells change Miree	by Otto Moehrbach[_2_]	1	316
Login Name and now function saran	by saran	3	479
Database price updating chefdoug	by Max	3	543
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	436
Macro Button or Auto Protect Formula enna49	by enna49	3	653
ColorIndexOfOneCell shank	by shank	8	1,310
help with formula so confused	by David Biddulph[_2_]	4	352
Average for times using minutes and seconds aj81a	by Sasa Stankovic	2	1,195
How to copy cells from one worksheet to another if the value in ra sgtpsychosis	by Otto Moehrbach[_2_]	4	544
Word size for each cell Lookup formula limitation?[_2_]	by Sasa Stankovic	1	322
Conditional Formatting Question pivot table	by [email protected]	1	382
Advanced Filter how to include columns V[_2_]	by Debra Dalgleish	1	366
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,623
Summarising Data Murray	by Mike H	5	377
Sort Worksheets (without VB) Elgee	by Don Guillett	4	518
change data of entire column from small case to upper case Ann	by Dave Peterson	1	1,406
Take a 3 or for digit time and convet it to time in one cell Djbaker70	by Héctor Miguel	9	645
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,744
Converting Millitary Time to Hours worked and OT hours Djbaker70	by Peo Sjoblom	3	653
Making a cell change time to hours Djbaker70	by Héctor Miguel	2	400
Deleting entire row if cell contains "value" - how to review everytime? V[_2_]	by smartin	1	3,050
Use the custom filter dialog in a macro KenInPortland	by Héctor Miguel	3	818
Formula - HHHHHEELLLPP K	by smartin	1	539
Visual Basic Erro 400 Minitman	by Minitman	2	458
How to schedule an auto "Save As" of an Excel spreadsheet daily... Turbine Mechanic	by NoodNutt	2	4,206
Help with UDF to search through a table [email protected]	by smartin	1	440
Linera fill formula Geoffric	by smartin	1	405
Changing text colors for editing Jalynno	by Gord Dibben	1	427
COUNTIF a cell value is between two numbers LAWNDALE	by T. Valko	3	4,209
EXCEL CELL MERGE Patricia	by Patricia	3	1,213
SUMPRODUCT formula compare then count Greg in CO[_2_]	by Greg in CO[_2_]	3	476
Eliminating Values from a worksheet Terry	by pshepard	4	500
How to reference or redirect a formula in a base row? Paul Schrum	by pshepard	3	2,476
Conditional arrays within SUMPRODUCT Phil H[_2_]	by Phil H[_2_]	0	655
today functions diggs	by Gord Dibben	4	375
SEARCH and IF Jorge	by T. Valko	3	286