Excel Worksheet Functions - Page 113

Thread / Thread Starter	Last Post	Replies	Views
Old address information updated to current addressi Charles	by Eduardo	1	534
Calculate row/column number in reference formula mirin	by Jacob Skaria	2	2,756
Return matching value Gotroots	by gootroots	8	428
Hide Rows based on value, but not using autofilter Richhall[_2_]	by Tom Hutchins	2	1,195
How to Stop calculation on one specific sheets only Mouimet	by Charles Williams	7	1,804
Create Formula Using Select Values of a Cell Harpo	by Rick Rothstein	3	519
how many duplicates in the one column J Walia	by T. Valko	6	1,221
Operation requires the merged cells to be identically sized David	by FSt1	1	2,120
Function that will look at letter in a column and return a number locasciok1	by Jacob Skaria	4	650
SUMIF jmfozzybear	by Jacob Skaria	3	443
sumproduct with multiple variables sam	by Jacob Skaria	10	1,074
days calculations Kimti	by Jacob Skaria	1	352
Create One Formula for Entire Column Andrea from MN[_2_]	by Jacob Skaria	1	454
need help with a downloaded template that was shared by steve mohrbaskets	by Jacob Skaria	2	436
daverage worksheet function Dave	by Jacob Skaria	1	624
Conditional Formula w/Lists ncjelj	by T. Valko	2	320
formulas VancouverLady	by Jacob Skaria	1	411
Create Generic Formula for Entire Column Andrea from MN	by Jacob Skaria	1	1,831
lookups and sums? jb	by Jacob Skaria	1	385
Creating a formula GAW	by Jacob Skaria	1	478
Hyperlink to a specific worksheet in another workbook Romileyrunner1	by Jacob Skaria	5	3,324
i have a 2007 workbook that has a password i need to get it off. H AJ	by AJ	0	413
Multiple worksheets Heidi	by Heidi	0	522
Normal distribution curve Dave	by ryguy7272	2	803
NETWORKDAYS Formula LJ[_2_]	by Chip Pearson	1	474
Round dates to weekdays Nan	by T. Valko	8	6,523
Remove Text Brandon	by Gord Dibben	7	632
Protecting data after entering jimbo	by Otto Moehrbach[_2_]	1	400
Uneven column lookup brownti	by Ashish Mathur[_2_]	4	722
Formula to get number of days excluding Fridays in a given period Abdul[_2_]	by Bernd P	17	1,737
Error Message when I open Workbook Mouimet	by Mouimet	2	1,008
take some data column into next column ie ABC-DEF-GHI i want DEF Bernard	by Gord Dibben	6	505
Multiple IF/AND/OR statments Zakynthos	by Joe User[_2_]	12	913
Can you insert a shortcut to a different workbook? Sheila	by Jacob Skaria	1	397
Concatentate text and insert blank line Bethany	by Bethany	5	1,637
How to highlight what's different between two columns Cesar Urquidi[_2_]	by Cesar Urquidi[_2_]	0	738
HOW TOCREATE A DROP-DOWN MENU FOR MACROS grover740	by Dave Peterson	2	434
Compare List Summary of Results mikew	by mikew	3	395
Vlookup returns n/a for all lines - what am I missing? Lorina	by Jacob Skaria	3	514
Vlookup returning #N/A when it should not robs3131	by Niek Otten	10	1,652
Hyperlink to a specific worksheet in another workbook. Romileyrunner1	by Jacob Skaria	2	1,434
Adding cells with formulas Amy	by Tom Hutchins	2	562
percentage in brackets CIW	by Jacob Skaria	2	2,413
If then statement Anna McKenzie	by Mattlynn via OfficeKB.com	5	844
How do you combine a date field and a time field into one? Janet Kreinbrink[_2_]	by Janet Kreinbrink[_2_]	6	954
adding values lists CalvinFenny	by Jacob Skaria	1	351
Sumproduct igoring hidden value Edward Wang	by Edward Wang	3	813
average sum of 5rows bill gras	by Teethless mama	3	402
Working with Excel to control stock Natalia Kenny	by Otto Moehrbach[_2_]	1	585
Permanently link Col A edits, inc 'insert row' in multiple workshe Tchipu	by Squeaky	2	551
Formatting cell WLMPilot	by Eduardo	4	357
multiplying by variables based off original number jato	by Hans Terkelsen	3	476
Limit access to range of cells jvs	by Chaitanya Sagar[_2_]	1	889
12 dependent series Elton Law[_2_]	by Elton Law[_2_]	5	385
data entry needs to be changed in multiple files drrons	by ryguy7272	1	606
Workaround no COUNTIFS in 2003 fay	by Teethless mama	5	1,596
simple counting gone awry Nondisclosure007	by Joe User[_2_]	3	462
The ____ qualifier references the header row in the table. David Simmons	by Fred Smith[_4_]	2	1,344
Week ending calculation Michelle	by Ashish Mathur[_2_]	6	4,262
produce a criteria based list MarkN	by MarkN	5	810
Data validation error message not showing raphiel2063	by Tom Hutchins	1	1,482
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	554
Can Excel look thru column of text & derive most commone camsown	by ryguy7272	4	656
Converting Pounfs to US Dollars Tom	by Sean Timmons	3	458
Lookup a location # with multiple dates Andrea	by ryguy7272	2	494
Format dates from cvf file Janet Kreinbrink	by Janet Kreinbrink[_2_]	5	715
Product formula help txsharla	by txsharla	4	471
Compare 2 columns and align duplicates into same row AGOLFA	by Otto Moehrbach[_2_]	8	3,672
Account # is a known the description is not, need to create a look placerpone	by Daryl S	2	469
Long list into Table to contain only ten Chris Hough	by T. Valko	2	403
COUNTIF - across 2 columns Rebekah	by David Biddulph[_2_]	11	1,092
simple formula help Cheryl	by WKH8919	5	467
Running total for 2 columns IF column 3....... paulab	by Teethless mama	7	639
pivot table field structure! via135	by via135	0	406
simple sum unless blank Cheryl	by Eduardo	5	820