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	312
Sumproduct "not equal" Terry	by David Biddulph[_2_]	4	2,612
"If" function and blank cells lisab	by David Biddulph[_2_]	4	916
Want to count all repeated number only once in Excel 2007. sierra spiegel	by T. Valko	2	2,104
format a column to show bars light_wt	by light_wt	1	442
How can I find out if numbers in one column are also in a secondcolumn please? RobertSE6[_2_]	by T. Valko	9	951
Countif, plus ? ref at heart	by T. Valko	7	1,051
"IF" Question? Lime	by Glenn	4	331
Simple formula please? englishrose4719	by englishrose4719	6	414
Formula link in previous version not updated in Excel 2007 DH	by DH	0	546
Increment invoice number suzi_75	by Jacob Skaria	1	903
The first 25 percent Rum	by David Biddulph[_2_]	2	482
Returning comlumn hearder uppon matching a text sting in a row Martin	by Martin	4	414
Holiday spreadsheet - SUMIF forumla no longer works? Custard Tart	by Custard Tart	2	590
formula to show time that data was entered on spreadsheet Irmatwit	by Mike H	1	2,435
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	506
Naming Consectutive Excel Tabs mastermk	by Roger Govier[_3_]	2	577
Summing Data Ruth	by Ruth	3	511
How to match the same data hc	by Jacob Skaria	1	449
Count time formatted data within range Unique_Identifier	by Jacob Skaria	1	1,219
Pulling out lastest date in line of text Donna[_2_]	by Jacob Skaria	2	472
Visibility of newsgroup postings Weatherman	by Jon Peltier[_2_]	12	886
How do I change contents of a cell based on drop down list selecte yateswdy	by WallyWallWhackr	2	1,647
LOOKUP Function gives wrong results AndreasW	by Ashish Mathur[_2_]	4	1,212
Add (sum) numbers within cells Clint	by Gord Dibben	7	591
Lookup with 2 criteria? KrisDHolm	by Ashish Mathur[_2_]	2	479
if or match hmmmmmm [email protected]	by [email protected]	3	324
Pivot Table Janice	by ryguy7272	3	352
Excel 2007 Nested formulas Adam Stegeman	by muddan madhu	2	794
Width of DV drop down list changes DocBrown	by cm	1	1,282
Visibility of newsgroup postings [email protected]	by [email protected]	0	537
2007 Need macro to auto set option buttons all to "Yes" or "No" Paula	by Jacob Skaria	1	851
count Mona	by Mona	7	425
Sumproduct blkane	by blkane	3	541
Filtering Using Values In A Specific Cell Sarah	by Roger Govier[_3_]	3	940
summing multiple lines throughout spreadsheet Joshua	by Ashish Mathur[_2_]	2	397
+1 only if there is a value [email protected]	by [email protected]	4	469
3D SUMIF BimboUK	by T. Valko	2	879
Counting Unique Values Karen	by ryguy7272	4	544
Formula EÃ¡n[_2_]	by Alan McQuaid via OfficeKB.com	2	436
The first 25 percent Rum	by Luke M	1	372
The first 25 percent PAL	by David Biddulph[_2_]	3	514
debt owed/ how to calculate payments with in time frame? Marie[_2_]	by Bernard Liengme[_3_]	2	611
The first 25 percent Rum	by Luke M	1	365
Finding employee absence history JohnPM	by JohnPM	8	822
HOW DO I SELECT A RATE FROM A TABLE mdwgno	by Jacob Skaria	1	460
how do I set column headings up and down rather than across nanof5	by Jacob Skaria	1	1,464
Sum or Sumif BUT exclude duplicate records Tami	by Tami	0	1,340
Add cells on two adjacent rows but non-adjacent columns Eve	by Eve	14	1,753
Sum If Donna[_2_]	by Max	5	489
Sum of amount with corresponding dates Great13	by JBeaucaire[_130_]	2	407
Can Excel calculate CAD CAM cut outs? RichyDeeInUK	by John[_22_]	5	885
Replace "Cell based" formulas with "word-based" formulas Brian	by Gord Dibben	3	1,132
Extract Cell Comments and Paste as text in a cell Goaliemenace	by Goaliemenace	3	2,990
how do I open a file when the file format is not valid? Bob	by Gord Dibben	1	433
How to fill cell with data from a previous cell Ishi Elpitiya	by Gord Dibben	2	658
validate time entries linked to each other matfis	by WallyWallWhackr	2	461
How to add values in one column based on values in another column KMA	by KMA	6	3,006
#N/A via Vlookup to produce name from other worksheet Steve	by Steve	2	522
random numbers afdmello	by Bernd P	3	361
copy conditional formatting range Steven Leuck	by Jacob Skaria	3	459
Average formula only works partially..... acbel40	by acbel40	6	763
Calculating probabilities Raul Sousa	by Raul Sousa	9	938
Collate data from one spreadsheet into another spreadsheet Anthony	by Herbert Seidenberg	2	1,650
Emailing A Worksheet Trese	by Jacob Skaria	2	493
how can I find the first non-zero cell rebecca	by Jacob Skaria	4	1,473
sumproduct to obtain text output EricB	by Jacob Skaria	4	898
aauugghhh...#div/o problems & various average formula problems acbel40	by Dave Peterson	5	1,041
Average Ranges of Cells, Return Separate Value for Each Range Eric H	by Glenn	5	731
New Built in Functions 2007 Pepper	by Bernard Liengme[_3_]	6	663
"Cross"-Auto filling: consecutive columns into rows AndreasW	by Jacob Skaria	1	1,005
Dates Taezalium	by BSc Chem Eng Rick	4	381
Data validation Horacio[_2_]	by Jarek Kujawa[_2_]	3	454
Add 18 months Debbie[_4_]	by macropod[_2_]	3	424