Excel Worksheet Functions - Page 1117

Thread / Thread Starter	Last Post	Replies	Views
Creating a Macro to autofill and save LauraB	by Gord Dibben	9	605
hiding/unhiding rows Art	by Paul C	1	586
If function and a range mrsatroy	by Bob Phillips[_4_]	4	544
Copying values/formulas from only visable lines when filters are o excelchallenged	by excelchallenged	0	459
calculating % of a monthly budget on a daily basis DZ	by rzink	3	1,187
Looking for a Function? similar to LEFT KatieR	by Harlan Grove[_2_]	5	598
Excel Sorting Lori	by Gary Brown[_5_]	2	452
sorting grouped cells D$	by Bernie Deitrick	1	579
auto populate unused rows from workbook to workbook JG	by JLatham	1	655
Help: vlookup from multiple sheets and spreadhseets Mr Fujisawa[_2_]	by Herbert Seidenberg	1	444
Vlookup and Hlookup cadustin	by cadustin	4	915
Using spreadsheet to fill in forms Nicci	by Eva	2	2,180
Excel 2007 - worksheets macro version83	by Gord Dibben	1	563
vlookup(date, range,3) David	by T. Valko	3	3,933
formatting cells pat67	by Gord Dibben	1	469
Using a cell's value to copy another cells info to another workshe badger2407	by Gord Dibben	1	512
don't want to have to change font in header and footer each time? rtur	by Gord Dibben	1	538
return different values based on 4 criteria? Susie (SFAngelgirl)[_2_]	by Susan in Sacramento	4	512
force alignment? Art	by Gord Dibben	7	507
Help with formula: finding text Jonas Ornborg	by Gord Dibben	4	428
Cash Statement- Accruing balances cjarrar	by Fred Smith[_4_]	1	444
Selecting rows with the same criteria Ruslan	by Ashish Mathur[_2_]	5	635
find smallest positive number among datas Cerberus[_2_]	by Ashish Mathur[_2_]	6	3,020
SUMIF with multiple criteria GBExcel via OfficeKB.com	by T. Valko	5	544
Main Form - copy exact data from multiple worksheets with live lin uncreative	by IdiotZ42	1	1,256
If and LOOKUP - results in multiple columns Joodle	by Teethless mama	6	554
Importing cells frmom a calendar workbook AZSteve	by AZSteve	4	629
How can I test the text content of a cell catefaulkes	by macropod[_2_]	4	937
actual row number climate	by climate	3	502
How to replace formula with its result jclown	by jclown	2	1,361
implementing formulas in excel Ian	by Ian	0	482
The Tueday prior to a holiday... Steve	by Steve	10	733
i can't get this formula to work kyle	by kyle	3	390
placing people into age groups based on their DOB JSAUS	by JSAUS	3	1,603
Auto filter sort ascending not working while sheet protected TommyB	by Dennis Tucker	6	3,265
Help needed with a formula for dates in excel 2007 dloc	by dloc	2	634
Summing Cells with Text and Numbers Trevor Little	by Max	11	1,000
text as value in pivot table Gerardo	by Gerardo	0	811
Formulas B.G. - Canada[_2_]	by Pete_UK	2	448
Excel 2007: Conditional Formatting and Ribbon Data JJ[_4_]	by JJ[_4_]	0	448
Problem with subtotal function Constance	by Constance	0	744
How do you search within a document? Me2020	by Gord Dibben	2	457
How do I recover the autosaved file? et	by Gord Dibben	1	751
Insert Picture McCBeth	by Gord Dibben	2	646
Add comment in protected worksheet Suju Thomas	by trip_to_tokyo[_3_]	3	6,586
Access to a series, when it is assigned to an empty range Werner Rohrmoser	by Werner Rohrmoser	0	537
leave sum of j7 at 40 or less put excess in k7 payroll function	by Fred Smith[_4_]	2	423
negative time summation calculation for a standard day Glamb	by Fred Smith[_4_]	2	679
How to combine data from 2 separate workbooks onto 1 worksheet Kristen	by Iriemon	2	1,032
Auto calculate Barb H	by Paul C	1	429
Need transpose? help.... Jethro Bodeene	by Jethro Bodeene[_2_]	9	636
Excel merging and automatic edit of worksheets Moonie66	by Moonie66	0	412
Print to file DavidA	by Billns	5	577
Microsoft Excel Total Values gp	by Ashish Mathur[_2_]	2	472
Replace Cells with Column names in functions? msnyc07	by Ashish Mathur[_2_]	4	1,077
Help with SumProduct Ayo	by T. Valko	7	461
combine vlookup and match help cadustin	by Jacob Skaria	6	901
Formulas that recognise data from two worksheets Kimbeau	by Fred Smith[_4_]	1	447
column corresponding to row number climate	by climate	0	424
Summing a crosstab dysolomon	by minyeh	7	3,282
How do I find a value in a table without using the labels? BobbyR	by Dennis Tucker	1	502
SumProduct not Working in a Macro Booey	by Bob Phillips[_4_]	6	524
countif with a condition and contains @ Pete_UK	by whyrajesh	1	425
Changing Defined Names Lelethu	by Jacob Skaria	2	487
Degrees Minutes Decimal Minutes to Decimal Degrees. Al[_5_]	by Ron Rosenfeld	3	1,863
I think I need a multiple IF statement, or is there another way? Carl Waring	by Jacob Skaria	5	534
lookup second / last match with two conditions Billy Leung[_2_]	by Gary''s Student	1	705
Search Entire Sheet instead of 1? msnyc07	by Glenn	4	644
Hide formula in list Errko	by Errko	1	435
How to enable auto height with merged cells? lgreggs	by lgreggs	0	671
Formula Result is different from the shown result DanWebster24	by Fred Smith[_4_]	2	688
Microsoft 2007 christie	by Fred Smith[_4_]	4	488
Sharing Violation Carolan	by Squeaky	1	575
=AND($B$12<"",$B$12<TODAY()+60) What does the < mean in this? Cbeckwith	by Bob Phillips[_4_]	3	2,025
Links do not recognize .xlsm extension BadBoy	by Squeaky	1	1,235