Excel Worksheet Functions - Page 967

Thread / Thread Starter	Last Post	Replies	Views
concatenate strings Gary''s Student	by Bob Phillips	3	643
Columns Need help	by Gary''s Student	2	290
count unique phrases in a word table or spreadsheet SDB	by Domenic	1	934
Locking a table Ket	by Ian	3	299
output based on data in a graph Patrick C.	by MrShorty	1	475
Data Validation Al	by safflenow	6	449
select lines from multiple worksheets and write to new worksheet rem	by Bernie Deitrick	1	616
Getting the first 3 digits out of 6 digit cells? Darla	by Dana DeLouis	5	2,497
Formula to determine number of Standard Deviations based on % of population Paul D. Simon	by Paul D. Simon	8	1,294
Can I use Excel to create this text file? BigIan	by BigIan	4	801
lookup based on a row number chrisrowe_cr	by swatsp0p	2	761
Hiding a row if date is filled nkt122866	by Don Guillett	1	395
combining data Carmel R	by Carmel R	4	628
data validation list should have opt. to select based on criteria be	by Debra Dalgleish	1	1,136
how could I import a text file with comma separated values into ex Xavi	by Dayne Dillon	1	583
What is wrong on the fomular: Offset(MIN(A1:A10),,-1)? Alex_Werner	by Bob Phillips	4	517
Couple of hopefully easy questions TeddyTash	by TeddyTash	4	603
Adding Cells Kyle Sweeney	by dominicb	4	500
Formula error in merged cells librarynut	by Anirudh	1	470
combining 2 pieces of text from 2 columns alexy	by Bob Phillips	3	744
How do you add a-z (alphabetically) to your toolbar in micr works Granny Bev	by Bob Phillips	3	516
Arrays Dan	by D Hilberg	3	599
Linkage data between two spreadsheet vitality	by Max	2	1,115
Print only cells with values bruce2444	by bruce2444	0	892
Formula Assistance Required bruce2444	by bruce2444	4	497
Filtering Columns to Align Matching Data Casino Guy	by Max	4	1,256
Make boxes apear on paper? Alecia	by Anne Troy	1	407
Can't get list in Document Contents for workwheet Allan H.	by Gord Dibben	1	343
How do I define "contains' as the default custom filter? J Engineer	by Gord Dibben	2	557
Need to compare 2 tables to generate 3rd table Kevin	by southerntwangqt	1	476
change case in excel joe	by Gord Dibben	9	436
Search feature in workbook nkt122866	by nkt122866	0	604
how do I keep the dropdown list button visible continuously dfinke	by Cutter	2	1,765
how do i get this tankerman	by Ian	1	411
looping through a set of calculations Anand	by Anand	2	703
vlookup over 2 sheets? James	by Biff	12	2,072
Vlookup for data contained in a cell Garbunkel	by Biff	5	1,325
one formula to make a multiplication table work Paige	by Paige	3	1,174
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	497
Opening multiple Excel files that contain varied selected sheets MLBrownewell	by MLBrownewell	0	1,162
having a two tables on the same page with different widths southerntwangqt	by southerntwangqt	2	1,654
Help with formula scubagrl	by BenjieLop	1	319
=max(range includes #N/As) David	by kk	3	710
vlookup reverts to data from a previous report Preston Nuckols	by Preston Nuckols	2	453
Date functions excelpomoc	by Gary''s Student	2	595
Locking cells after one answer HuckinD	by Don Guillett	1	421
countif mike	by JE McGimpsey	1	474
Random Numbers Steved	by RagDyeR	44	4,746
Help with formula please... neilcarden	by DCSwearingen	2	561
Using countif with 2 conditions Cheryl W	by Paul Sheppard	2	579
using linest to generate 3rd order polynomial coefficients Incoherent	by Incoherent	4	4,396
Matching data using date criteria... JoeZ	by JoeZ	1	553
Locking format Terry	by Terry	0	341
Avoiding #NUM! Bruno Campanini	by Domenic	9	763
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	465
matching numbers in col a and col b Jim	by Bob Phillips	1	479
numbers ceemo	by swatsp0p	4	321
Value of a Cell by Time Ken	by Ken	0	348
Forecasting weekday occupancy between two years titushanke	by titushanke	0	788
Preceding a number by zeros, that is still a number Michele	by Arvi Laanemets	1	986
Fill-in empty cells from SAP report Ilieski	by Markus L	3	870
drop_down_box cjjoo	by Bob Phillips	1	393
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	949
Calculating Month Average Exch Rate from Exchange Rates Calendar!!! StanUkr	by StanUkr	0	1,500
Count "how many in a row" TeddyTash	by TeddyTash	4	401
=CONCATENATE() help! shfcook	by shfcook	4	476
Conditionl Format TeddyTash	by TeddyTash	3	460
Changing positive figures to minus figures Louise	by Louise	2	1,226
using filters with the sum function justinelliott	by justinelliott	3	380
add a column only if 5 other cells on the row satisfy criteria zubin	by Bob Phillips	1	593
Optimizing mortage payback Hannes	by Hannes	0	487