Excel Worksheet Functions - Page 507

Thread / Thread Starter	Last Post	Replies	Views
can I sort names in a column by the last name if it is typed last lanajv	by Tieske	1	424
Hide Rows shail	by Teethless mama	2	430
Rearranging cells into certain columns thelinds	by Tieske	1	690
Link multiple worksheets while extracting data aj9000	by aj9000	0	433
calculate count on 2006 total, 2005 total, etc... Amanda Deshotel	by Don Guillett	6	933
Dropdown box [email protected]	by Tieske	1	322
Multiple lists with repeated values for dependet drop down lists mcmanusb	by Tieske	1	1,332
name an active worksheet djshides via OfficeKB.com	by Tieske	1	444
converting hours to minutes w/o VBA herosuper	by Tieske	3	1,586
array manipulation pete	by JMB	1	599
Conditional Underline John C	by bpeltzer	5	679
Dynamically Changing HLOOKUP table PatK	by PatK	4	778
array functions Barak	by RagDyeR	5	396
SUMIF Function Freshman	by Biff	2	473
How do I get labels to repeat in a pivot table? snmcpa	by Debra Dalgleish	3	740
RAND FUNCTION NADTARVIN	by Biff	1	627
Custom Validation Not Accepting Valid Data Revision [email protected]	by Debra Dalgleish	1	613
Combining multiple worksheets tina	by tina	0	449
Disable Search Function In Excel Worksheet Dileep	by Dileep	0	1,687
Add VLOOKUP Nakia Allen	by Pete_UK	1	399
Issue with a formula to help generate a report. BillOSull	by BillOSull	0	404
How do I convert dates (09/15/06 or 09/20/06) to month (Sept 06)? Kwalityguy	by David Biddulph	3	499
Large excel file [email protected]	by Ronald Dodge	1	374
Flaging Dates Paul	by Marcelo	1	382
SUMIF with external data tina	by Dave F	1	484
array function birdsting	by Dave F	1	405
need help with MY FORMULA [email protected]	by Dave F	1	390
Naming same cell in different worksheet with 2 value changing on e Yan	by Yan	0	405
Need blank formula cells rather than 0's Carl	by Sloth	3	692
Array Formula with Concatenate and If Kris_Wright_77	by Kris_Wright_77	2	957
If Function Assistance Chris B.	by Sloth	3	523
Using VLOOKUP, IF and RIGHT functions together Alicia	by Alicia	3	4,025
SUMPRODUCT - Count Previous Month HearSay	by Dave Peterson	3	506
macros for autofill klafert	by klafert	0	424
Vlookup not working SMRE	by Dave Peterson	1	632
sorting a column with numbers and text Ford35	by Jim Cone	5	538
AVERAGE(with complicated range -blanks..) excelent	by excelent	7	617
Edit Drop Down List Lynn S	by MartinW	1	2,518
Copying figures from Access to Excel dalymjl	by dalymjl	0	445
Converting text to formulas Eutrapelia	by Gord Dibben	7	726
SMALL function if 0 Louis	by Louis	5	3,065
Counting rows based on multiple columns Doyle	by Biff	1	649
Want average sales numbers for last 12 months. Pierre	by Pierre	2	555
Help with complex average/if statement [email protected]	by Domenic	1	530
Lookup Closest Value chad	by Herbert Seidenberg	3	1,230
Formula Christine Haines	by Christine Haines	3	336
table lookup Jhill	by Jhill	3	358
=ROUNDUP(INT(0.xxx)) Dave F	by Epinn	7	743
need formula for % of times text appears in row. sunslight	by Marcelo	2	352
Shortened formula Rob	by Ron Coderre	1	419
Pulling multiple values from a list based on a wildcard search value? [email protected]	by Biff	4	1,151
Exporting data (Data Table) to Excel Vlash	by Ronald Dodge	3	991
lost the ability to bracket negative numbers sjtbean	by Gord Dibben	3	1,778
hyperlink Grasshopper	by Grasshopper	0	331
Adding VLOOKUP Nakia Allen	by RagDyeR	4	795
VLOOKUP MULTIPALS Johnny	by JMB	4	425
count text in column a if column b = 25 jettp	by Biff	1	483
Freqencies over Time, in Columns -- Easy Question Rothman	by Rothman	0	371
Display Month - 1 HearSay	by Epinn	10	997
Search / Mid function Landa	by RagDyeR	4	552
Can columns be hidden accross multiple sheets in an Excel workboo Ray Naylor	by RagDyeR	11	1,013
Range of Values Returns One Result Rif	by Roger Govier	2	457
Hide rows shail	by shail	3	368
how do i get exact matches in a vlookup fomrula shark1966	by Dave Peterson	3	792
How to add previous sums in a column to current sums in a column? TD	by JLatham	1	746
EXCEL Books Joe	by JLatham	1	483
how do i get exact matches in a vlookup fomrula shark1966	by excelent	1	622
How can I set up names to automatically copy from a spreadsheet? John S.	by Gord Dibben	2	457
Search Column Data and Return Multiple Values across Row Sam via OfficeKB.com	by JMB	3	838
Trig functions Kokopeelle	by Dana DeLouis	3	556
Day of the week Negin	by Epinn	5	540
Average Function and dynamic cell address spartanmba	by Biff	2	618
PRINTING NILELATOR	by NILELATOR	4	721
help with calculating 3 part function in excel monkeytrader	by Dana DeLouis	1	492
VLOOKUP function returning data from ranges rayteach	by Biff	5	803