Excel Worksheet Functions - Page 113

Thread / Thread Starter	Last Post	Replies	Views
Old address information updated to current addressi Charles	by Eduardo	1	556
Calculate row/column number in reference formula mirin	by Jacob Skaria	2	2,786
Return matching value Gotroots	by gootroots	8	456
Hide Rows based on value, but not using autofilter Richhall[_2_]	by Tom Hutchins	2	1,230
How to Stop calculation on one specific sheets only Mouimet	by Charles Williams	7	1,844
Create Formula Using Select Values of a Cell Harpo	by Rick Rothstein	3	533
how many duplicates in the one column J Walia	by T. Valko	6	1,243
Operation requires the merged cells to be identically sized David	by FSt1	1	2,143
Function that will look at letter in a column and return a number locasciok1	by Jacob Skaria	4	674
SUMIF jmfozzybear	by Jacob Skaria	3	455
sumproduct with multiple variables sam	by Jacob Skaria	10	1,099
days calculations Kimti	by Jacob Skaria	1	360
Create One Formula for Entire Column Andrea from MN[_2_]	by Jacob Skaria	1	473
need help with a downloaded template that was shared by steve mohrbaskets	by Jacob Skaria	2	464
daverage worksheet function Dave	by Jacob Skaria	1	640
Conditional Formula w/Lists ncjelj	by T. Valko	2	346
formulas VancouverLady	by Jacob Skaria	1	423
Create Generic Formula for Entire Column Andrea from MN	by Jacob Skaria	1	1,858
lookups and sums? jb	by Jacob Skaria	1	406
Creating a formula GAW	by Jacob Skaria	1	496
Hyperlink to a specific worksheet in another workbook Romileyrunner1	by Jacob Skaria	5	3,415
i have a 2007 workbook that has a password i need to get it off. H AJ	by AJ	0	429
Multiple worksheets Heidi	by Heidi	0	533
Normal distribution curve Dave	by ryguy7272	2	831
NETWORKDAYS Formula LJ[_2_]	by Chip Pearson	1	491
Round dates to weekdays Nan	by T. Valko	8	6,572
Remove Text Brandon	by Gord Dibben	7	647
Protecting data after entering jimbo	by Otto Moehrbach[_2_]	1	420
Uneven column lookup brownti	by Ashish Mathur[_2_]	4	738
Formula to get number of days excluding Fridays in a given period Abdul[_2_]	by Bernd P	17	1,761
Error Message when I open Workbook Mouimet	by Mouimet	2	1,044
take some data column into next column ie ABC-DEF-GHI i want DEF Bernard	by Gord Dibben	6	521
Multiple IF/AND/OR statments Zakynthos	by Joe User[_2_]	12	930
Can you insert a shortcut to a different workbook? Sheila	by Jacob Skaria	1	434
Concatentate text and insert blank line Bethany	by Bethany	5	1,660
How to highlight what's different between two columns Cesar Urquidi[_2_]	by Cesar Urquidi[_2_]	0	765
HOW TOCREATE A DROP-DOWN MENU FOR MACROS grover740	by Dave Peterson	2	455
Compare List Summary of Results mikew	by mikew	3	411
Vlookup returns n/a for all lines - what am I missing? Lorina	by Jacob Skaria	3	531
Vlookup returning #N/A when it should not robs3131	by Niek Otten	10	1,688
Hyperlink to a specific worksheet in another workbook. Romileyrunner1	by Jacob Skaria	2	1,459
Adding cells with formulas Amy	by Tom Hutchins	2	615
percentage in brackets CIW	by Jacob Skaria	2	2,430
If then statement Anna McKenzie	by Mattlynn via OfficeKB.com	5	862
How do you combine a date field and a time field into one? Janet Kreinbrink[_2_]	by Janet Kreinbrink[_2_]	6	976
adding values lists CalvinFenny	by Jacob Skaria	1	375
Sumproduct igoring hidden value Edward Wang	by Edward Wang	3	830
average sum of 5rows bill gras	by Teethless mama	3	420
Working with Excel to control stock Natalia Kenny	by Otto Moehrbach[_2_]	1	608
Permanently link Col A edits, inc 'insert row' in multiple workshe Tchipu	by Squeaky	2	579
Formatting cell WLMPilot	by Eduardo	4	366
multiplying by variables based off original number jato	by Hans Terkelsen	3	497
Limit access to range of cells jvs	by Chaitanya Sagar[_2_]	1	917
12 dependent series Elton Law[_2_]	by Elton Law[_2_]	5	409
data entry needs to be changed in multiple files drrons	by ryguy7272	1	644
Workaround no COUNTIFS in 2003 fay	by Teethless mama	5	1,611
simple counting gone awry Nondisclosure007	by Joe User[_2_]	3	476
The ____ qualifier references the header row in the table. David Simmons	by Fred Smith[_4_]	2	1,354
Week ending calculation Michelle	by Ashish Mathur[_2_]	6	4,351
produce a criteria based list MarkN	by MarkN	5	824
Data validation error message not showing raphiel2063	by Tom Hutchins	1	1,516
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	579
Can Excel look thru column of text & derive most commone camsown	by ryguy7272	4	688
Converting Pounfs to US Dollars Tom	by Sean Timmons	3	472
Lookup a location # with multiple dates Andrea	by ryguy7272	2	521
Format dates from cvf file Janet Kreinbrink	by Janet Kreinbrink[_2_]	5	751
Product formula help txsharla	by txsharla	4	495
Compare 2 columns and align duplicates into same row AGOLFA	by Otto Moehrbach[_2_]	8	3,698
Account # is a known the description is not, need to create a look placerpone	by Daryl S	2	483
Long list into Table to contain only ten Chris Hough	by T. Valko	2	421
COUNTIF - across 2 columns Rebekah	by David Biddulph[_2_]	11	1,109
simple formula help Cheryl	by WKH8919	5	491
Running total for 2 columns IF column 3....... paulab	by Teethless mama	7	663
pivot table field structure! via135	by via135	0	434
simple sum unless blank Cheryl	by Eduardo	5	842