Excel Worksheet Functions - Page 237

Thread / Thread Starter	Last Post	Replies	Views
Query on Null (#n/a) Mr. Platypus	by John Bundy	1	458
formula to add year to date figures Brian	by Brian	3	1,181
Creating calendar that autopopulates dates based on event date ent TxKarateMama	by Pete_UK	1	537
Auto populate cell with info on other cell (Sheet) Oscar	by Oscar	4	864
SUMPRODUCT OR COUNTIF chrisk	by chrisk	6	506
Looking up a row of data bfont	by Dave Curtis[_2_]	3	380
Average Jen_T	by Glenn	4	322
Data Validation (copy paste error) Christoffer Bloch Andersen	by Christoffer Bloch Andersen	0	1,139
Help converting text to date & time? Jon M	by Stefi	2	634
matching text to text in excel Ikepri	by Stefi	3	508
Excel 2007 problem nesting IF & AND Steve	by Steve	0	512
How can I show a validity by a prompted symbol in colour? Maray	by Pete_UK	1	357
Pulling out values Emma Hope	by Emma Hope	2	414
Changing the colour of a range of cells, some with formulas. Champ	by Pete_UK	8	450
Triggering a Flag after 10 days that excludes weekends and holiday Danny Boy	by Stefi	3	474
cumprinc, not sure how to use it, someone please show me steps ple GACKT	by GACKT	0	411
sumif and complex sum_range formulae caro	by caro	2	498
Duplicates and unique values sragor	by muddan madhu	1	654
Copying data to summary sheet Max	by Max	2	433
removing the "-" sign in a calucation gma	by Khoshravan	8	407
Reference to worksheets Thys	by Max	4	474
V Lookup & IF Reenee	by Reenee	0	320
coditional Page Break j4m3sc	by Ashish Mathur[_2_]	3	418
Calculate AVERAGe with #MISSING! Arne Hegefors	by Ashish Mathur[_2_]	2	502
COUNT COMMON DATA HARSHAWARDHAN. S .SHASTRI[_2_]	by Ashish Mathur[_2_]	3	518
copy & paste andrew	by Max	1	316
how do you find many data? andrew	by Max	3	348
Subtotal John	by Ashish Mathur[_2_]	4	562
Fill series of dates across worksheets in excel Valhumf	by Gord Dibben	1	1,962
How do you insert & delete rows in a protected worksheet? Tiffany G.	by Gord Dibben	1	805
How do I auto highlight a cell with the same data as another cell john talbot	by Pete_UK	11	1,238
Please explain this formula Iriemon	by Max	2	569
IF Statments in Excel Valerie	by T. Valko	5	411
show all characters in a cell tinks	by Gord Dibben	1	1,200
how do I click on a drop down list and go to that data Donna	by Gord Dibben	1	344
WorkBook Update NotGood@All	by Gord Dibben	4	405
time calculation Siteman	by Siteman	8	474
convert text to hyperlink se7098	by se7098	2	1,774
Hyperlink "friendly-name" won't preserve links in PDF publishing ExcelUser	by ExcelUser	0	598
PASTE SPECIAL Indy-500	by Khoshravan	1	365
How do I find dups across different columns Nyrubi	by Khoshravan	3	584
Different answers when using cell references as opposed to actual leobensmom	by Glenn	4	514
Help with creating a function Craig	by Craig	4	470
Not sure whether to use VLOOKUP or an IF statement Allison1962	by John[_22_]	2	500
how can i use countif to count sundays in excel Reverend Ken	by Glenn	1	1,524
can I define validation range by function? DPR	by JE McGimpsey	1	451
to separate date and time formula Soth	by Soth	2	1,116
Date Conversion mecca	by David Biddulph[_2_]	7	409
Multi IF function not working IT1Navy	by Bernard Liengme	3	384
worksheet function... SteveDB1	by Pete_UK	7	408
formula to add year to date figures Brian	by Brian	0	480
Can anyone explain why my excel file won't scroll downwards? HappyHeartMonth	by Max	1	4,070
Excel 2003 using a list from another workbook Kimberly	by Roger Govier[_3_]	1	378
Conditional Formatting based on a vertical Array. cp37	by Gord Dibben	2	972
IF statements help Mandy J.S.	by Roger Govier[_3_]	1	355
Help with IF Statemet CM	by David Biddulph[_2_]	3	337
Yes or No Value if Dollar amount between two numbers Jerry B Smith	by John[_22_]	1	924
how to Calculate the discount ex. 9-63%=3.33 in excell michiganguy	by David Biddulph[_2_]	1	495
Quartiles Mike Dobony	by Bernie Deitrick	1	567
Cell referncing heather	by heather	20	1,427
Numbering cells that have been filtered Matt Pennington	by Matt Pennington[_2_]	2	457
default font color in excel Saladin Andreas	by Suleman Peerzade[_2_]	1	521
VLOOKUP, MATCH or something else entirely? Rebekah	by Pete_UK	3	470
IF FUNCTION? Reenee	by muddan madhu	6	366
Count Annie	by Chris Bode[_3_]	7	613
array search Luke	by Max	8	536
Running totals when letters entered. IF statement Peta	by Peta	0	629
Function Arguments dialog vanishes when clicked an inserted shape RK	by RK	2	637
textbox autosum Woodi2	by Chris Bode	6	1,165
countif HRM Hawaii	by Shane Devenshire[_2_]	4	486
sumif from multiple columns dcoxdcox	by Shane Devenshire[_2_]	6	1,140
Conditional Format Pat	by Shane Devenshire[_2_]	2	347
FORMULA FOR TABLE NARSARIA_RAJ KUMAR	by NARSARIA_RAJ KUMAR[_2_]	4	432
SUMIF no longer working Monish	by T. Valko	4	550
Format changes in a merged cell P_Kellogg	by P_Kellogg[_2_]	2	444