Excel Worksheet Functions - Page 967

Thread / Thread Starter	Last Post	Replies	Views
concatenate strings Gary''s Student	by Bob Phillips	3	658
Columns Need help	by Gary''s Student	2	302
count unique phrases in a word table or spreadsheet SDB	by Domenic	1	936
Locking a table Ket	by Ian	3	310
output based on data in a graph Patrick C.	by MrShorty	1	487
Data Validation Al	by safflenow	6	464
select lines from multiple worksheets and write to new worksheet rem	by Bernie Deitrick	1	620
Getting the first 3 digits out of 6 digit cells? Darla	by Dana DeLouis	5	2,504
Formula to determine number of Standard Deviations based on % of population Paul D. Simon	by Paul D. Simon	8	1,305
Can I use Excel to create this text file? BigIan	by BigIan	4	814
lookup based on a row number chrisrowe_cr	by swatsp0p	2	771
Hiding a row if date is filled nkt122866	by Don Guillett	1	398
combining data Carmel R	by Carmel R	4	635
data validation list should have opt. to select based on criteria be	by Debra Dalgleish	1	1,146
how could I import a text file with comma separated values into ex Xavi	by Dayne Dillon	1	598
What is wrong on the fomular: Offset(MIN(A1:A10),,-1)? Alex_Werner	by Bob Phillips	4	527
Couple of hopefully easy questions TeddyTash	by TeddyTash	4	603
Adding Cells Kyle Sweeney	by dominicb	4	512
Formula error in merged cells librarynut	by Anirudh	1	471
combining 2 pieces of text from 2 columns alexy	by Bob Phillips	3	756
How do you add a-z (alphabetically) to your toolbar in micr works Granny Bev	by Bob Phillips	3	521
Arrays Dan	by D Hilberg	3	608
Linkage data between two spreadsheet vitality	by Max	2	1,126
Print only cells with values bruce2444	by bruce2444	0	894
Formula Assistance Required bruce2444	by bruce2444	4	497
Filtering Columns to Align Matching Data Casino Guy	by Max	4	1,262
Make boxes apear on paper? Alecia	by Anne Troy	1	409
Can't get list in Document Contents for workwheet Allan H.	by Gord Dibben	1	358
How do I define "contains' as the default custom filter? J Engineer	by Gord Dibben	2	561
Need to compare 2 tables to generate 3rd table Kevin	by southerntwangqt	1	481
change case in excel joe	by Gord Dibben	9	438
Search feature in workbook nkt122866	by nkt122866	0	616
how do I keep the dropdown list button visible continuously dfinke	by Cutter	2	1,773
how do i get this tankerman	by Ian	1	414
looping through a set of calculations Anand	by Anand	2	714
vlookup over 2 sheets? James	by Biff	12	2,079
Vlookup for data contained in a cell Garbunkel	by Biff	5	1,333
one formula to make a multiplication table work Paige	by Paige	3	1,179
Sales League table Dave Jarvis	by Bob Phillips	1	1,207
ranking Soz	by Bob Phillips	6	728
Complicated lookup/match fuction keysersoze	by keysersoze	0	498
Opening multiple Excel files that contain varied selected sheets MLBrownewell	by MLBrownewell	0	1,167
having a two tables on the same page with different widths southerntwangqt	by southerntwangqt	2	1,658
Help with formula scubagrl	by BenjieLop	1	324
=max(range includes #N/As) David	by kk	3	722
vlookup reverts to data from a previous report Preston Nuckols	by Preston Nuckols	2	462
Date functions excelpomoc	by Gary''s Student	2	605
Locking cells after one answer HuckinD	by Don Guillett	1	423
countif mike	by JE McGimpsey	1	478
Random Numbers ( 1 2) Steved	by RagDyeR	44	4,754
Help with formula please... neilcarden	by DCSwearingen	2	566
Using countif with 2 conditions Cheryl W	by Paul Sheppard	2	589
using linest to generate 3rd order polynomial coefficients Incoherent	by Incoherent	4	4,399
Matching data using date criteria... JoeZ	by JoeZ	1	560
Locking format Terry	by Terry	0	349
Avoiding #NUM! Bruno Campanini	by Domenic	9	765
What is the shortcut key for adding $ to a cell reference eg $c$3 Bryce	by Duke Carey	2	447
Multiple If Statements excelrookie05	by excelrookie05	2	473
matching numbers in col a and col b Jim	by Bob Phillips	1	484
numbers ceemo	by swatsp0p	4	324
Value of a Cell by Time Ken	by Ken	0	355
Forecasting weekday occupancy between two years titushanke	by titushanke	0	789
Preceding a number by zeros, that is still a number Michele	by Arvi Laanemets	1	997
Fill-in empty cells from SAP report Ilieski	by Markus L	3	882
drop_down_box cjjoo	by Bob Phillips	1	394
Lookup question. spartanmba	by Krishnakumar	1	335
I cannot convert using HEX2DEC formula? i need a plug in i think? Usman	by Gary''s Student	1	958
Calculating Month Average Exch Rate from Exchange Rates Calendar!!! StanUkr	by StanUkr	0	1,504
Count "how many in a row" TeddyTash	by TeddyTash	4	411
=CONCATENATE() help! shfcook	by shfcook	4	486
Conditionl Format TeddyTash	by TeddyTash	3	467
Changing positive figures to minus figures Louise	by Louise	2	1,226
using filters with the sum function justinelliott	by justinelliott	3	387
add a column only if 5 other cells on the row satisfy criteria zubin	by Bob Phillips	1	608
Optimizing mortage payback Hannes	by Hannes	0	487