Excel Worksheet Functions - Page 967

Thread / Thread Starter	Last Post	Replies	Views
concatenate strings Gary''s Student	by Bob Phillips	3	626
Columns Need help	by Gary''s Student	2	284
count unique phrases in a word table or spreadsheet SDB	by Domenic	1	919
Locking a table Ket	by Ian	3	278
output based on data in a graph Patrick C.	by MrShorty	1	452
Data Validation Al	by safflenow	6	440
select lines from multiple worksheets and write to new worksheet rem	by Bernie Deitrick	1	590
Getting the first 3 digits out of 6 digit cells? Darla	by Dana DeLouis	5	2,476
Formula to determine number of Standard Deviations based on % of population Paul D. Simon	by Paul D. Simon	8	1,264
Can I use Excel to create this text file? BigIan	by BigIan	4	773
lookup based on a row number chrisrowe_cr	by swatsp0p	2	745
Hiding a row if date is filled nkt122866	by Don Guillett	1	385
combining data Carmel R	by Carmel R	4	602
data validation list should have opt. to select based on criteria be	by Debra Dalgleish	1	1,111
how could I import a text file with comma separated values into ex Xavi	by Dayne Dillon	1	552
What is wrong on the fomular: Offset(MIN(A1:A10),,-1)? Alex_Werner	by Bob Phillips	4	510
Couple of hopefully easy questions TeddyTash	by TeddyTash	4	576
Adding Cells Kyle Sweeney	by dominicb	4	484
Formula error in merged cells librarynut	by Anirudh	1	457
combining 2 pieces of text from 2 columns alexy	by Bob Phillips	3	719
How do you add a-z (alphabetically) to your toolbar in micr works Granny Bev	by Bob Phillips	3	511
Arrays Dan	by D Hilberg	3	578
Linkage data between two spreadsheet vitality	by Max	2	1,072
Print only cells with values bruce2444	by bruce2444	0	879
Formula Assistance Required bruce2444	by bruce2444	4	483
Filtering Columns to Align Matching Data Casino Guy	by Max	4	1,237
Make boxes apear on paper? Alecia	by Anne Troy	1	390
Can't get list in Document Contents for workwheet Allan H.	by Gord Dibben	1	335
How do I define "contains' as the default custom filter? J Engineer	by Gord Dibben	2	532
Need to compare 2 tables to generate 3rd table Kevin	by southerntwangqt	1	447
change case in excel joe	by Gord Dibben	9	423
Search feature in workbook nkt122866	by nkt122866	0	568
how do I keep the dropdown list button visible continuously dfinke	by Cutter	2	1,702
how do i get this tankerman	by Ian	1	405
looping through a set of calculations Anand	by Anand	2	654
vlookup over 2 sheets? James	by Biff	12	2,021
Vlookup for data contained in a cell Garbunkel	by Biff	5	1,287
one formula to make a multiplication table work Paige	by Paige	3	1,154
Sales League table Dave Jarvis	by Bob Phillips	1	1,197
ranking Soz	by Bob Phillips	6	717
Complicated lookup/match fuction keysersoze	by keysersoze	0	489
Opening multiple Excel files that contain varied selected sheets MLBrownewell	by MLBrownewell	0	1,132
having a two tables on the same page with different widths southerntwangqt	by southerntwangqt	2	1,592
Help with formula scubagrl	by BenjieLop	1	313
=max(range includes #N/As) David	by kk	3	697
vlookup reverts to data from a previous report Preston Nuckols	by Preston Nuckols	2	434
Date functions excelpomoc	by Gary''s Student	2	577
Locking cells after one answer HuckinD	by Don Guillett	1	399
countif mike	by JE McGimpsey	1	468
Random Numbers ( 1 2) Steved	by RagDyeR	44	4,590
Help with formula please... neilcarden	by DCSwearingen	2	547
Using countif with 2 conditions Cheryl W	by Paul Sheppard	2	568
using linest to generate 3rd order polynomial coefficients Incoherent	by Incoherent	4	4,315
Matching data using date criteria... JoeZ	by JoeZ	1	531
Locking format Terry	by Terry	0	324
Avoiding #NUM! Bruno Campanini	by Domenic	9	733
What is the shortcut key for adding $ to a cell reference eg $c$3 Bryce	by Duke Carey	2	421
Multiple If Statements excelrookie05	by excelrookie05	2	452
matching numbers in col a and col b Jim	by Bob Phillips	1	461
numbers ceemo	by swatsp0p	4	315
Value of a Cell by Time Ken	by Ken	0	341
Forecasting weekday occupancy between two years titushanke	by titushanke	0	763
Preceding a number by zeros, that is still a number Michele	by Arvi Laanemets	1	935
Fill-in empty cells from SAP report Ilieski	by Markus L	3	836
drop_down_box cjjoo	by Bob Phillips	1	383
Lookup question. spartanmba	by Krishnakumar	1	304
I cannot convert using HEX2DEC formula? i need a plug in i think? Usman	by Gary''s Student	1	933
Calculating Month Average Exch Rate from Exchange Rates Calendar!!! StanUkr	by StanUkr	0	1,452
Count "how many in a row" TeddyTash	by TeddyTash	4	392
=CONCATENATE() help! shfcook	by shfcook	4	450
Conditionl Format TeddyTash	by TeddyTash	3	442
Changing positive figures to minus figures Louise	by Louise	2	1,204
using filters with the sum function justinelliott	by justinelliott	3	367
add a column only if 5 other cells on the row satisfy criteria zubin	by Bob Phillips	1	560
Optimizing mortage payback Hannes	by Hannes	0	477