Excel Worksheet Functions - Page 306

Thread / Thread Starter	Last Post	Replies	Views
Frequency Question Bigfoot17	by T. Valko	10	910
IF question or MACRO ? Which to use DMK	by DMK	2	441
Shading Cells based on Date Lee Quillen	by Teethless mama	1	1,220
Using Conditional Format/Icon Set With Dates Steve	by Steve	0	982
Formula Query Mark	by Teethless mama	1	351
Toggle Button Squeaky	by Squeaky	0	799
Create a drop down that adds up a price Dimmchip	by Spiky	1	377
Assigning a word to a number MJ	by MJ	4	559
Count values from Pivot Table lesg46	by Max	11	1,340
Find Feature with Macro Alexander	by Alexander	3	505
how do i convert a flat rate into a reducing rate? Sumit Shekhar	by Ashish Mathur[_2_]	1	3,839
Looking for alpha characters in a field fgwiii[_2_]	by Mike H	1	875
Pivot table Arne Hegefors	by sonal patel	5	477
Last closing stock number beatrice	by Mike H	1	724
IF and SUM functions Paul	by Ashish Mathur[_2_]	2	396
Lookup and copy multiple values vijaydsk1970	by Ashish Mathur[_2_]	7	606
Average formula Pyrite	by Pete_UK	4	655
URGENT: Can you insert a formula into a reference ie $B4:$C(row(x HenryB	by Niek Otten	1	487
MS Excel, Location: Defined Names RJ@truecos	by Ashish Mathur[_2_]	1	2,189
how to lookup a value in a list and return multiple corresponding Catalina	by Ashish Mathur[_2_]	2	848
Using LOOKUP without values in ascending order thscc1659	by T. Valko	2	1,602
counta and or if MB	by Ashish Mathur[_2_]	6	536
How can make a formula to add add the nominators and denominators thrower4life	by T. Valko	1	882
Match based on calculated value Tekhnikos	by T. Valko	5	454
Sum Indirect Using R1C1 Style Bam	by Harlan Grove[_2_]	17	4,886
looking a value in an array text values Francois	by Dave Peterson	2	910
Array Formulas Jon Dow[_2_]	by Harlan Grove[_2_]	3	406
Vlookup problem Alfredo_CPA	by T. Valko	1	494
VLOOKUP using FALSE returning blanks and #N/A dread	by T. Valko	1	786
Data Validation w/o Cell Content Deletion BJ	by Spiky	1	509
HLookup help Txlonghorn76	by Sheeloo[_2_]	1	481
Calculate days in a month N Harkawat	by Héctor Miguel	2	454
number Syl	by Teethless mama	2	369
Count/Sum based on mutiple criteria Jon Dow[_2_]	by RagDyer	4	470
Getting "Creat List" function on excel 2002 faiz	by Gord Dibben	1	476
Showing the cell to the Left when certain criteria are met cmatera	by Spiky	2	442
Setting Preferences for Multiple Worksheets Kansas City Kitty	by Gord Dibben	3	532
COUNTIF with OR giaraf	by T. Valko	1	404
Detailed Function (or Macro) Needed... Help akemeny	by Gaurav[_3_]	3	487
Update Source data in a formula akimballsmith	by akimballsmith	2	593
Conditional formula using MIN function doesn't work SCarroll	by T. Valko	5	2,447
Dividing multiple cells by 1000 Debbie	by Pred	4	2,270
Saving a value in another cell networkjoe	by Bernie Deitrick	1	414
VLookup help Office 2003 Professional Andy B.	by Andri	3	596
Compatibility Mode to Excel 2007 Jennifer	by Jennifer	4	769
named range and link na	by na	1	703
how do I lock the first tab of multiple worksheets cailasgramma	by Bernard Liengme	1	1,109
Match using array of column and row references to match with jkfin1	by Pete_UK	1	994
COUNTIF: 2 criteria: Date Range Column & Text Column MAC	by lilhoot	14	3,717
To list down all SN (Serial Number) Andri	by Andri	6	571
Function needed fgwiii[_2_]	by Pete_UK	3	523
Nested IF too long - other suggestions? ExchangeNewbie	by RagDyeR	7	814
Text Formula Christopher Naveen[_2_]	by Teethless mama	5	388
Financial Numbers not properly adding BrownsFan	by Teethless mama	1	426
Average formula limitation Karen	by Spiky	9	393
Worksheet Total and Macro RHoskins	by RHoskins	0	391
Hyperlink Relative Reference TKS_Mark	by TKS_Mark	2	459
Condtional formatting in Excel EÃ¡n[_2_]	by David Biddulph[_2_]	1	618
Rounding in Excel trichey	by Stefi	2	402
HEADER and FOOTER James8309	by Dave Peterson	3	385
Find and Replace one row only Nick Wakeham	by Nick Wakeham	2	6,125
Excel Warning Esradekan	by Esradekan	2	485
Assign a number to a word Noob McKnownowt	by Mike H	5	1,163
Vlookup - maybe?! Zak	by Zak	7	401
HOW DO I CREATE MULTIPLE LISTS wireman	by VISWANATHAN	2	392
Formula to sum up customers totals from other sheets Steve[_16_]	by Bob Phillips[_3_]	2	896
How to create multiple lists each comprising data from previous li wireman	by Gav123	1	418
allow a user to edit ranges in a protected worksheet McA	by McA	3	2,012
Excel - viewing hidden rows Brandy	by Stefi	11	1,172
Sorting and maintaining formula integrity Ed[_4_]	by Max	5	1,034
Text entry into excel tobypitblado	by Bob Bridges[_2_]	1	659
Display a cell to the left with some changes cmatera	by Bob Bridges[_2_]	1	416
cross referencing JockW	by T. Valko	4	430
Blocking/Disabling selected worksheet DJ Ghale	by Gord Dibben	1	490
if questions Mauro	by Ashish Mathur[_2_]	4	505