Excel Worksheet Functions - Page 1116

Thread / Thread Starter	Last Post	Replies	Views
How do I lock ONLY the formatting on an excel sheet? Court	by Dave	2	1,524
Consolidating Data Between Worksheets with Duplicates Removed JodySmithPharmD	by Dave	1	598
Possible problem with PMT and FV functions Keith	by Joe User[_2_]	2	1,778
Multiple IF function Anthony	by Bob Phillips[_4_]	5	534
Excel file size increased 3 times after saving!!!! Exceller	by marstinson	1	1,255
Percentages Don	by Dennis Tucker	2	370
Highlight cells Goyo	by Gord Dibben	1	437
Sumif Question stevestr	by Bob Phillips[_4_]	1	513
Info between worksheets Eileen	by Joe User[_2_]	1	428
hypothesis testing Jaybird	by Mike Middleton	1	377
Control On Cell Input Laura11	by Laura11	0	494
vlookup, concatenated named range patti	by T. Valko	4	830
Entering Values and Updating Next Empty Cell in a Range Stilltrader47	by Stilltrader47	2	756
Merging different sheets vassilis	by vassilis	5	654
SUMIF (SUMPRODUCT?) with two arguments Max	by Max	0	771
Formulas to reference range based on data in column Code Numpty	by Code Numpty	8	550
count nonblank cells Art	by Ashish Mathur[_2_]	3	1,253
Splitting Text from single cell in column across multiple Columns Harold	by Ashish Mathur[_2_]	3	4,566
concantenate then index match Robb27	by Ashish Mathur[_2_]	2	463
Creating a new table from another - filtering out unwanted data Kamalii	by Ashish Mathur[_2_]	8	611
Calculation Question Scott	by Ashish Mathur[_2_]	2	852
How to use the Stop If True Condition for highlight cells Fefe	by Bob Phillips[_4_]	1	3,446
converting an .xlsm file to .xml? Janis	by Chip Pearson	1	4,164
sumif Robb27	by Fred Smith[_4_]	1	402
Lookup for this? Zakynthos	by Zakynthos	2	382
Why does it display #### in my cell? Lindsey-Star	by Joe User[_2_]	14	2,392
Printing Worksheet GANTRYMAN	by Ashish Mathur[_2_]	1	445
Help with formula Corey[_4_]	by Corey[_4_]	0	340
Macro question Tina	by Corey[_4_]	2	414
slow worksheet rylie14	by Corey[_4_]	1	487
Compound Interest Rate or Growth Rate 1944-71222	by Fred Smith[_4_]	2	1,839
How to set a formula if the value is with #N/A lee-sc	by Ashish Mathur[_2_]	4	798
prevent div/0 error Austin[_2_]	by Héctor Miguel	2	695
Starting drop down lists at the top test123	by Héctor Miguel	1	2,275
Index from TM Dave	by T. Valko	8	531
ms excel vinay	by Mike H	1	395
Autofill from Data Validation JPDS	by JPDS	2	402
Determining number of entries in a table smaruzzi	by Ashish Mathur[_2_]	3	684
Problem with LARGE function mickjjuk	by Ashish Mathur[_2_]	3	1,157
Summarizing up cells based on two different criterias Ruslan	by Glenn	4	535
Setting special format for a cell Ruslan	by Gord Dibben	6	1,021
Cells Fill Automatically on Another Workbook BrazosJoe	by BrazosJoe	0	449
left/right or center ? Steve	by Steve	13	914
Get location of match in another worksheet AZSteve	by AZSteve	0	410
Dynamically Adding Textbox To Frame sarndt	by sarndt	0	653
Counting independent items in a list Brad E.	by Mike H	3	471
how to sum cells and ignore the #div/0! 's ? Bryan	by Teethless mama	3	3,056
OFFSET and LOOKUP Error Jim	by Glenn	2	637
cube functions Robert	by Robert	0	509
EXCEL COUNTING HELP EXCELably Challenged	by Bernd P	3	484
Replace Function that uses lookup table? msnyc07	by Eva	1	4,654
Index/Lookup Function? jackie	by Max	4	491
Is there a way to use a multiple column array in SUMPRODUCT? rk	by Teethless mama	2	1,292
Formula causing run-time error in Excel Programming cherman	by cherman	2	765
Calculating %'s with IF and Sum/SumIF Billy B	by Joe User[_2_]	12	953
Help on percentages greater than 100 cil	by T. Valko	3	6,035
excel sum values if cell matches a value Dennis	by Jacob Skaria	1	1,607
Macro Help Curtis[_2_]	by Jacob Skaria	1	444
How do I get drop-down list that includes, eg top10 RichardHouse	by trip_to_tokyo[_3_]	1	834
What-if-Analysis feature of spreadsheet LATA	by Jacob Skaria	1	583
Sumproduct for Values over a certain Value eg 0.00 enna49	by Max	3	687
Help to create a formulae FredDave	by Don Guillett[_2_]	1	358
Vlookup-Doesn't return values under 1 Carolina	by Jacob Skaria	1	611
List top five Dazed&Confused	by Dazed&Confused	4	405
delete columns in spreadsheet after data entered so it wont scroll Question	by Jacob Skaria	1	618
autopopulate based on a cell value Art	by Art	2	1,068
Yearly sum jam[_2_]	by Luke M[_4_]	3	781
Delete Rows using Wildcard Max2073	by Luke M[_4_]	2	1,064
How to change numbers from positive to negative. tammy p[_2_]	by Luke M[_4_]	2	786
Vlookup-Doesn't return values under 1 Carolina	by Carolina	2	885
Delete Rows using If and Wildcard Max2073	by Don Guillett[_2_]	2	812
Setting up a formula (when F2<11,000)=$25 Hawkeye	by trip_to_tokyo[_3_]	3	513
If Vlookup is error ( #NA) Steve	by T. Valko	5	2,380
How do I turn off R1C1 reference type in Excel 2007? Mag	by Bob Phillips[_4_]	3	4,249
Need help with formulae comparing date-based numbers Dataslinger	by T. Valko	2	517