Excel Worksheet Functions - Page 67

Thread / Thread Starter	Last Post	Replies	Views
Auto calculate Barb H	by Paul C	1	435
How to combine data from 2 separate workbooks onto 1 worksheet Kristen	by Iriemon	2	1,038
negative time summation calculation for a standard day Glamb	by Fred Smith[_4_]	2	695
leave sum of j7 at 40 or less put excess in k7 payroll function	by Fred Smith[_4_]	2	427
Access to a series, when it is assigned to an empty range Werner Rohrmoser	by Werner Rohrmoser	0	548
Add comment in protected worksheet Suju Thomas	by trip_to_tokyo[_3_]	3	6,599
Insert Picture McCBeth	by Gord Dibben	2	652
How do I recover the autosaved file? et	by Gord Dibben	1	761
How do you search within a document? Me2020	by Gord Dibben	2	461
Problem with subtotal function Constance	by Constance	0	749
Excel 2007: Conditional Formatting and Ribbon Data JJ[_4_]	by JJ[_4_]	0	461
Formulas B.G. - Canada[_2_]	by Pete_UK	2	454
text as value in pivot table Gerardo	by Gerardo	0	823
Summing Cells with Text and Numbers Trevor Little	by Max	11	1,008
Help needed with a formula for dates in excel 2007 dloc	by dloc	2	649
Auto filter sort ascending not working while sheet protected TommyB	by Dennis Tucker	6	3,289
placing people into age groups based on their DOB JSAUS	by JSAUS	3	1,624
i can't get this formula to work kyle	by kyle	3	419
The Tueday prior to a holiday... Steve	by Steve	10	742
implementing formulas in excel Ian	by Ian	0	489
How to replace formula with its result jclown	by jclown	2	1,366
actual row number climate	by climate	3	510
How can I test the text content of a cell catefaulkes	by macropod[_2_]	4	947
Importing cells frmom a calendar workbook AZSteve	by AZSteve	4	638
If and LOOKUP - results in multiple columns Joodle	by Teethless mama	6	560
Main Form - copy exact data from multiple worksheets with live lin uncreative	by IdiotZ42	1	1,269
SUMIF with multiple criteria GBExcel via OfficeKB.com	by T. Valko	5	547
find smallest positive number among datas Cerberus[_2_]	by Ashish Mathur[_2_]	6	3,027
Selecting rows with the same criteria Ruslan	by Ashish Mathur[_2_]	5	643
Cash Statement- Accruing balances cjarrar	by Fred Smith[_4_]	1	455
Help with formula: finding text Jonas Ornborg	by Gord Dibben	4	434
force alignment? Art	by Gord Dibben	7	509
return different values based on 4 criteria? Susie (SFAngelgirl)[_2_]	by Susan in Sacramento	4	522
don't want to have to change font in header and footer each time? rtur	by Gord Dibben	1	551
Using a cell's value to copy another cells info to another workshe badger2407	by Gord Dibben	1	524
formatting cells pat67	by Gord Dibben	1	489
vlookup(date, range,3) David	by T. Valko	3	3,978
Excel 2007 - worksheets macro version83	by Gord Dibben	1	570
Using spreadsheet to fill in forms Nicci	by Eva	2	2,195
Vlookup and Hlookup cadustin	by cadustin	4	936
Help: vlookup from multiple sheets and spreadhseets Mr Fujisawa[_2_]	by Herbert Seidenberg	1	451
auto populate unused rows from workbook to workbook JG	by JLatham	1	661
sorting grouped cells D$	by Bernie Deitrick	1	590
Excel Sorting Lori	by Gary Brown[_5_]	2	469
Looking for a Function? similar to LEFT KatieR	by Harlan Grove[_2_]	5	611
calculating % of a monthly budget on a daily basis DZ	by rzink	3	1,196
Copying values/formulas from only visable lines when filters are o excelchallenged	by excelchallenged	0	470
If function and a range mrsatroy	by Bob Phillips[_4_]	4	565
hiding/unhiding rows Art	by Paul C	1	595
Creating a Macro to autofill and save LauraB	by Gord Dibben	9	613
Need help with formulae comparing date-based numbers Dataslinger	by T. Valko	2	531
How do I turn off R1C1 reference type in Excel 2007? Mag	by Bob Phillips[_4_]	3	4,264
If Vlookup is error ( #NA) Steve	by T. Valko	5	2,396
Setting up a formula (when F2<11,000)=$25 Hawkeye	by trip_to_tokyo[_3_]	3	537
Delete Rows using If and Wildcard Max2073	by Don Guillett[_2_]	2	819
Vlookup-Doesn't return values under 1 Carolina	by Carolina	2	903
How to change numbers from positive to negative. tammy p[_2_]	by Luke M[_4_]	2	794
Delete Rows using Wildcard Max2073	by Luke M[_4_]	2	1,078
Yearly sum jam[_2_]	by Luke M[_4_]	3	820
autopopulate based on a cell value Art	by Art	2	1,075
delete columns in spreadsheet after data entered so it wont scroll Question	by Jacob Skaria	1	628
List top five Dazed&Confused	by Dazed&Confused	4	418
Vlookup-Doesn't return values under 1 Carolina	by Jacob Skaria	1	629
Help to create a formulae FredDave	by Don Guillett[_2_]	1	366
Sumproduct for Values over a certain Value eg 0.00 enna49	by Max	3	699
What-if-Analysis feature of spreadsheet LATA	by Jacob Skaria	1	592
How do I get drop-down list that includes, eg top10 RichardHouse	by trip_to_tokyo[_3_]	1	850
Macro Help Curtis[_2_]	by Jacob Skaria	1	460
excel sum values if cell matches a value Dennis	by Jacob Skaria	1	1,620
Help on percentages greater than 100 cil	by T. Valko	3	6,056
Calculating %'s with IF and Sum/SumIF Billy B	by Joe User[_2_]	12	963
Formula causing run-time error in Excel Programming cherman	by cherman	2	777
Is there a way to use a multiple column array in SUMPRODUCT? rk	by Teethless mama	2	1,305
Index/Lookup Function? jackie	by Max	4	503
Replace Function that uses lookup table? msnyc07	by Eva	1	4,684