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,604
"If" function and blank cells lisab	by David Biddulph[_2_]	4	905
Want to count all repeated number only once in Excel 2007. sierra spiegel	by T. Valko	2	2,088
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	937
Countif, plus ? ref at heart	by T. Valko	7	1,040
"IF" Question? Lime	by Glenn	4	323
Simple formula please? englishrose4719	by englishrose4719	6	401
Formula link in previous version not updated in Excel 2007 DH	by DH	0	537
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	590
formula to show time that data was entered on spreadsheet Irmatwit	by Mike H	1	2,430
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	437
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	458
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,635
LOOKUP Function gives wrong results AndreasW	by Ashish Mathur[_2_]	4	1,202
Add (sum) numbers within cells Clint	by Gord Dibben	7	582
Lookup with 2 criteria? KrisDHolm	by Ashish Mathur[_2_]	2	479
if or match hmmmmmm [email protected]	by [email protected]	3	323
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,269
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	838
count Mona	by Mona	7	416
Sumproduct blkane	by blkane	3	537
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	385
+1 only if there is a value [email protected]	by [email protected]	4	460
3D SUMIF BimboUK	by T. Valko	2	871
Counting Unique Values Karen	by ryguy7272	4	533
Formula EÃ¡n[_2_]	by Alan McQuaid via OfficeKB.com	2	433
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	609
The first 25 percent Rum	by Luke M	1	364
Finding employee absence history JohnPM	by JohnPM	8	819
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,457
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,746
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	881
Replace "Cell based" formulas with "word-based" formulas Brian	by Gord Dibben	3	1,122
Extract Cell Comments and Paste as text in a cell Goaliemenace	by Goaliemenace	3	2,978
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	646
validate time entries linked to each other matfis	by WallyWallWhackr	2	448
How to add values in one column based on values in another column KMA	by KMA	6	2,996
#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	444
Average formula only works partially..... acbel40	by acbel40	6	750
Calculating probabilities Raul Sousa	by Raul Sousa	9	926
Collate data from one spreadsheet into another spreadsheet Anthony	by Herbert Seidenberg	2	1,638
Emailing A Worksheet Trese	by Jacob Skaria	2	492
how can I find the first non-zero cell rebecca	by Jacob Skaria	4	1,462
sumproduct to obtain text output EricB	by Jacob Skaria	4	888
aauugghhh...#div/o problems & various average formula problems acbel40	by Dave Peterson	5	1,027
Average Ranges of Cells, Return Separate Value for Each Range Eric H	by Glenn	5	717
New Built in Functions 2007 Pepper	by Bernard Liengme[_3_]	6	651
"Cross"-Auto filling: consecutive columns into rows AndreasW	by Jacob Skaria	1	996
Dates Taezalium	by BSc Chem Eng Rick	4	372
Data validation Horacio[_2_]	by Jarek Kujawa[_2_]	3	442
Add 18 months Debbie[_4_]	by macropod[_2_]	3	423