Excel Worksheet Functions - Page 122

Thread / Thread Starter	Last Post	Replies	Views
Increase cell B by one for every 3 in cell A up to 50? Frustrated	by David Biddulph[_2_]	3	311
Sumproduct "not equal" Terry	by David Biddulph[_2_]	4	2,601
"If" function and blank cells lisab	by David Biddulph[_2_]	4	904
Want to count all repeated number only once in Excel 2007. sierra spiegel	by T. Valko	2	2,087
format a column to show bars light_wt	by light_wt	1	440
How can I find out if numbers in one column are also in a secondcolumn please? RobertSE6[_2_]	by T. Valko	9	937
Countif, plus ? ref at heart	by T. Valko	7	1,038
"IF" Question? Lime	by Glenn	4	322
Simple formula please? englishrose4719	by englishrose4719	6	397
Formula link in previous version not updated in Excel 2007 DH	by DH	0	535
Increment invoice number suzi_75	by Jacob Skaria	1	892
The first 25 percent Rum	by David Biddulph[_2_]	2	481
Returning comlumn hearder uppon matching a text sting in a row Martin	by Martin	4	404
Holiday spreadsheet - SUMIF forumla no longer works? Custard Tart	by Custard Tart	2	589
formula to show time that data was entered on spreadsheet Irmatwit	by Mike H	1	2,429
maybe match, maybe sumproduct hmmmmmm [email protected]	by BSc Chem Eng Rick	3	386
Finding Unique/Duplicates IMS Lori	by BSc Chem Eng Rick	5	495
Naming Consectutive Excel Tabs mastermk	by Roger Govier[_3_]	2	561
Summing Data Ruth	by Ruth	3	499
How to match the same data hc	by Jacob Skaria	1	435
Count time formatted data within range Unique_Identifier	by Jacob Skaria	1	1,211
Pulling out lastest date in line of text Donna[_2_]	by Jacob Skaria	2	452
Visibility of newsgroup postings Weatherman	by Jon Peltier[_2_]	12	881
How do I change contents of a cell based on drop down list selecte yateswdy	by WallyWallWhackr	2	1,633
LOOKUP Function gives wrong results AndreasW	by Ashish Mathur[_2_]	4	1,200
Add (sum) numbers within cells Clint	by Gord Dibben	7	581
Lookup with 2 criteria? KrisDHolm	by Ashish Mathur[_2_]	2	476
if or match hmmmmmm [email protected]	by [email protected]	3	322
Pivot Table Janice	by ryguy7272	3	347
Excel 2007 Nested formulas Adam Stegeman	by muddan madhu	2	784
Width of DV drop down list changes DocBrown	by cm	1	1,268
Visibility of newsgroup postings [email protected]	by [email protected]	0	536
2007 Need macro to auto set option buttons all to "Yes" or "No" Paula	by Jacob Skaria	1	806
count Mona	by Mona	7	416
Sumproduct blkane	by blkane	3	528
Filtering Using Values In A Specific Cell Sarah	by Roger Govier[_3_]	3	926
summing multiple lines throughout spreadsheet Joshua	by Ashish Mathur[_2_]	2	383
+1 only if there is a value [email protected]	by [email protected]	4	459
3D SUMIF BimboUK	by T. Valko	2	871
Counting Unique Values Karen	by ryguy7272	4	529
Formula EÃ¡n[_2_]	by Alan McQuaid via OfficeKB.com	2	432
The first 25 percent Rum	by Luke M	1	372
The first 25 percent PAL	by David Biddulph[_2_]	3	508
debt owed/ how to calculate payments with in time frame? Marie[_2_]	by Bernard Liengme[_3_]	2	600
The first 25 percent Rum	by Luke M	1	361
Finding employee absence history JohnPM	by JohnPM	8	818
HOW DO I SELECT A RATE FROM A TABLE mdwgno	by Jacob Skaria	1	451
how do I set column headings up and down rather than across nanof5	by Jacob Skaria	1	1,456
Sum or Sumif BUT exclude duplicate records Tami	by Tami	0	1,335
Add cells on two adjacent rows but non-adjacent columns Eve	by Eve	14	1,735
Sum If Donna[_2_]	by Max	5	477
Sum of amount with corresponding dates Great13	by JBeaucaire[_130_]	2	395
Can Excel calculate CAD CAM cut outs? RichyDeeInUK	by John[_22_]	5	880
Replace "Cell based" formulas with "word-based" formulas Brian	by Gord Dibben	3	1,121
Extract Cell Comments and Paste as text in a cell Goaliemenace	by Goaliemenace	3	2,976
how do I open a file when the file format is not valid? Bob	by Gord Dibben	1	419
How to fill cell with data from a previous cell Ishi Elpitiya	by Gord Dibben	2	645
validate time entries linked to each other matfis	by WallyWallWhackr	2	447
How to add values in one column based on values in another column KMA	by KMA	6	2,993
#N/A via Vlookup to produce name from other worksheet Steve	by Steve	2	519
random numbers afdmello	by Bernd P	3	350
copy conditional formatting range Steven Leuck	by Jacob Skaria	3	437
Average formula only works partially..... acbel40	by acbel40	6	749
Calculating probabilities Raul Sousa	by Raul Sousa	9	925
Collate data from one spreadsheet into another spreadsheet Anthony	by Herbert Seidenberg	2	1,637
Emailing A Worksheet Trese	by Jacob Skaria	2	492
how can I find the first non-zero cell rebecca	by Jacob Skaria	4	1,459
sumproduct to obtain text output EricB	by Jacob Skaria	4	884
aauugghhh...#div/o problems & various average formula problems acbel40	by Dave Peterson	5	1,019
Average Ranges of Cells, Return Separate Value for Each Range Eric H	by Glenn	5	714
New Built in Functions 2007 Pepper	by Bernard Liengme[_3_]	6	647
"Cross"-Auto filling: consecutive columns into rows AndreasW	by Jacob Skaria	1	994
Dates Taezalium	by BSc Chem Eng Rick	4	369
Data validation Horacio[_2_]	by Jarek Kujawa[_2_]	3	442
Add 18 months Debbie[_4_]	by macropod[_2_]	3	422