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	297
Sumproduct "not equal" Terry	by David Biddulph[_2_]	4	2,577
"If" function and blank cells lisab	by David Biddulph[_2_]	4	886
Want to count all repeated number only once in Excel 2007. sierra spiegel	by T. Valko	2	2,070
format a column to show bars light_wt	by light_wt	1	435
How can I find out if numbers in one column are also in a secondcolumn please? RobertSE6[_2_]	by T. Valko	9	926
Countif, plus ? ref at heart	by T. Valko	7	1,023
"IF" Question? Lime	by Glenn	4	321
Simple formula please? englishrose4719	by englishrose4719	6	387
Formula link in previous version not updated in Excel 2007 DH	by DH	0	522
Increment invoice number suzi_75	by Jacob Skaria	1	883
The first 25 percent Rum	by David Biddulph[_2_]	2	462
Returning comlumn hearder uppon matching a text sting in a row Martin	by Martin	4	393
Holiday spreadsheet - SUMIF forumla no longer works? Custard Tart	by Custard Tart	2	559
formula to show time that data was entered on spreadsheet Irmatwit	by Mike H	1	2,254
maybe match, maybe sumproduct hmmmmmm [email protected]	by BSc Chem Eng Rick	3	349
Finding Unique/Duplicates IMS Lori	by BSc Chem Eng Rick	5	486
Naming Consectutive Excel Tabs mastermk	by Roger Govier[_3_]	2	547
Summing Data Ruth	by Ruth	3	489
How to match the same data hc	by Jacob Skaria	1	433
Count time formatted data within range Unique_Identifier	by Jacob Skaria	1	1,202
Pulling out lastest date in line of text Donna[_2_]	by Jacob Skaria	2	440
Visibility of newsgroup postings Weatherman	by Jon Peltier[_2_]	12	868
How do I change contents of a cell based on drop down list selecte yateswdy	by WallyWallWhackr	2	1,616
LOOKUP Function gives wrong results AndreasW	by Ashish Mathur[_2_]	4	1,185
Add (sum) numbers within cells Clint	by Gord Dibben	7	568
Lookup with 2 criteria? KrisDHolm	by Ashish Mathur[_2_]	2	454
if or match hmmmmmm [email protected]	by [email protected]	3	313
Pivot Table Janice	by ryguy7272	3	342
Excel 2007 Nested formulas Adam Stegeman	by muddan madhu	2	779
Width of DV drop down list changes DocBrown	by cm	1	1,255
Visibility of newsgroup postings [email protected]	by [email protected]	0	530
2007 Need macro to auto set option buttons all to "Yes" or "No" Paula	by Jacob Skaria	1	792
count Mona	by Mona	7	411
Sumproduct blkane	by blkane	3	502
Filtering Using Values In A Specific Cell Sarah	by Roger Govier[_3_]	3	919
summing multiple lines throughout spreadsheet Joshua	by Ashish Mathur[_2_]	2	374
+1 only if there is a value [email protected]	by [email protected]	4	449
3D SUMIF BimboUK	by T. Valko	2	866
Counting Unique Values Karen	by ryguy7272	4	515
Formula EÃ¡n[_2_]	by Alan McQuaid via OfficeKB.com	2	430
The first 25 percent Rum	by Luke M	1	367
The first 25 percent PAL	by David Biddulph[_2_]	3	500
debt owed/ how to calculate payments with in time frame? Marie[_2_]	by Bernard Liengme[_3_]	2	585
The first 25 percent Rum	by Luke M	1	348
Finding employee absence history JohnPM	by JohnPM	8	806
HOW DO I SELECT A RATE FROM A TABLE mdwgno	by Jacob Skaria	1	446
how do I set column headings up and down rather than across nanof5	by Jacob Skaria	1	1,442
Sum or Sumif BUT exclude duplicate records Tami	by Tami	0	1,329
Add cells on two adjacent rows but non-adjacent columns Eve	by Eve	14	1,700
Sum If Donna[_2_]	by Max	5	469
Sum of amount with corresponding dates Great13	by JBeaucaire[_130_]	2	389
Can Excel calculate CAD CAM cut outs? RichyDeeInUK	by John[_22_]	5	872
Replace "Cell based" formulas with "word-based" formulas Brian	by Gord Dibben	3	1,106
Extract Cell Comments and Paste as text in a cell Goaliemenace	by Goaliemenace	3	2,939
how do I open a file when the file format is not valid? Bob	by Gord Dibben	1	405
How to fill cell with data from a previous cell Ishi Elpitiya	by Gord Dibben	2	639
validate time entries linked to each other matfis	by WallyWallWhackr	2	429
How to add values in one column based on values in another column KMA	by KMA	6	2,971
#N/A via Vlookup to produce name from other worksheet Steve	by Steve	2	512
random numbers afdmello	by Bernd P	3	345
copy conditional formatting range Steven Leuck	by Jacob Skaria	3	428
Average formula only works partially..... acbel40	by acbel40	6	739
Calculating probabilities Raul Sousa	by Raul Sousa	9	908
Collate data from one spreadsheet into another spreadsheet Anthony	by Herbert Seidenberg	2	1,627
Emailing A Worksheet Trese	by Jacob Skaria	2	479
how can I find the first non-zero cell rebecca	by Jacob Skaria	4	1,430
sumproduct to obtain text output EricB	by Jacob Skaria	4	879
aauugghhh...#div/o problems & various average formula problems acbel40	by Dave Peterson	5	991
Average Ranges of Cells, Return Separate Value for Each Range Eric H	by Glenn	5	682
New Built in Functions 2007 Pepper	by Bernard Liengme[_3_]	6	630
"Cross"-Auto filling: consecutive columns into rows AndreasW	by Jacob Skaria	1	985
Dates Taezalium	by BSc Chem Eng Rick	4	362
Data validation Horacio[_2_]	by Jarek Kujawa[_2_]	3	429
Add 18 months Debbie[_4_]	by macropod[_2_]	3	419