Excel Worksheet Functions - Page 113

Thread / Thread Starter	Last Post	Replies	Views
Old address information updated to current addressi Charles	by Eduardo	1	551
Calculate row/column number in reference formula mirin	by Jacob Skaria	2	2,774
Return matching value Gotroots	by gootroots	8	445
Hide Rows based on value, but not using autofilter Richhall[_2_]	by Tom Hutchins	2	1,219
How to Stop calculation on one specific sheets only Mouimet	by Charles Williams	7	1,832
Create Formula Using Select Values of a Cell Harpo	by Rick Rothstein	3	532
how many duplicates in the one column J Walia	by T. Valko	6	1,234
Operation requires the merged cells to be identically sized David	by FSt1	1	2,134
Function that will look at letter in a column and return a number locasciok1	by Jacob Skaria	4	667
SUMIF jmfozzybear	by Jacob Skaria	3	453
sumproduct with multiple variables sam	by Jacob Skaria	10	1,090
days calculations Kimti	by Jacob Skaria	1	360
Create One Formula for Entire Column Andrea from MN[_2_]	by Jacob Skaria	1	469
need help with a downloaded template that was shared by steve mohrbaskets	by Jacob Skaria	2	457
daverage worksheet function Dave	by Jacob Skaria	1	638
Conditional Formula w/Lists ncjelj	by T. Valko	2	334
formulas VancouverLady	by Jacob Skaria	1	420
Create Generic Formula for Entire Column Andrea from MN	by Jacob Skaria	1	1,846
lookups and sums? jb	by Jacob Skaria	1	402
Creating a formula GAW	by Jacob Skaria	1	485
Hyperlink to a specific worksheet in another workbook Romileyrunner1	by Jacob Skaria	5	3,340
i have a 2007 workbook that has a password i need to get it off. H AJ	by AJ	0	428
Multiple worksheets Heidi	by Heidi	0	530
Normal distribution curve Dave	by ryguy7272	2	815
NETWORKDAYS Formula LJ[_2_]	by Chip Pearson	1	487
Round dates to weekdays Nan	by T. Valko	8	6,569
Remove Text Brandon	by Gord Dibben	7	644
Protecting data after entering jimbo	by Otto Moehrbach[_2_]	1	413
Uneven column lookup brownti	by Ashish Mathur[_2_]	4	736
Formula to get number of days excluding Fridays in a given period Abdul[_2_]	by Bernd P	17	1,754
Error Message when I open Workbook Mouimet	by Mouimet	2	1,031
take some data column into next column ie ABC-DEF-GHI i want DEF Bernard	by Gord Dibben	6	519
Multiple IF/AND/OR statments Zakynthos	by Joe User[_2_]	12	928
Can you insert a shortcut to a different workbook? Sheila	by Jacob Skaria	1	431
Concatentate text and insert blank line Bethany	by Bethany	5	1,646
How to highlight what's different between two columns Cesar Urquidi[_2_]	by Cesar Urquidi[_2_]	0	754
HOW TOCREATE A DROP-DOWN MENU FOR MACROS grover740	by Dave Peterson	2	452
Compare List Summary of Results mikew	by mikew	3	404
Vlookup returns n/a for all lines - what am I missing? Lorina	by Jacob Skaria	3	527
Vlookup returning #N/A when it should not robs3131	by Niek Otten	10	1,677
Hyperlink to a specific worksheet in another workbook. Romileyrunner1	by Jacob Skaria	2	1,447
Adding cells with formulas Amy	by Tom Hutchins	2	608
percentage in brackets CIW	by Jacob Skaria	2	2,426
If then statement Anna McKenzie	by Mattlynn via OfficeKB.com	5	859
How do you combine a date field and a time field into one? Janet Kreinbrink[_2_]	by Janet Kreinbrink[_2_]	6	969
adding values lists CalvinFenny	by Jacob Skaria	1	372
Sumproduct igoring hidden value Edward Wang	by Edward Wang	3	828
average sum of 5rows bill gras	by Teethless mama	3	418
Working with Excel to control stock Natalia Kenny	by Otto Moehrbach[_2_]	1	601
Permanently link Col A edits, inc 'insert row' in multiple workshe Tchipu	by Squeaky	2	573
Formatting cell WLMPilot	by Eduardo	4	364
multiplying by variables based off original number jato	by Hans Terkelsen	3	490
Limit access to range of cells jvs	by Chaitanya Sagar[_2_]	1	902
12 dependent series Elton Law[_2_]	by Elton Law[_2_]	5	407
data entry needs to be changed in multiple files drrons	by ryguy7272	1	630
Workaround no COUNTIFS in 2003 fay	by Teethless mama	5	1,608
simple counting gone awry Nondisclosure007	by Joe User[_2_]	3	472
The ____ qualifier references the header row in the table. David Simmons	by Fred Smith[_4_]	2	1,353
Week ending calculation Michelle	by Ashish Mathur[_2_]	6	4,348
produce a criteria based list MarkN	by MarkN	5	821
Data validation error message not showing raphiel2063	by Tom Hutchins	1	1,503
Summing values within a matrix who are both in a column where theheaders are within a certain numerical range and in a row where the rowheaders are specified. Andy	by Andy	4	567
Can Excel look thru column of text & derive most commone camsown	by ryguy7272	4	677
Converting Pounfs to US Dollars Tom	by Sean Timmons	3	470
Lookup a location # with multiple dates Andrea	by ryguy7272	2	508
Format dates from cvf file Janet Kreinbrink	by Janet Kreinbrink[_2_]	5	727
Product formula help txsharla	by txsharla	4	489
Compare 2 columns and align duplicates into same row AGOLFA	by Otto Moehrbach[_2_]	8	3,694
Account # is a known the description is not, need to create a look placerpone	by Daryl S	2	478
Long list into Table to contain only ten Chris Hough	by T. Valko	2	419
COUNTIF - across 2 columns Rebekah	by David Biddulph[_2_]	11	1,105
simple formula help Cheryl	by WKH8919	5	483
Running total for 2 columns IF column 3....... paulab	by Teethless mama	7	652
pivot table field structure! via135	by via135	0	421
simple sum unless blank Cheryl	by Eduardo	5	834