Excel Worksheet Functions - Page 237

Thread / Thread Starter	Last Post	Replies	Views
Query on Null (#n/a) Mr. Platypus	by John Bundy	1	448
formula to add year to date figures Brian	by Brian	3	1,173
Creating calendar that autopopulates dates based on event date ent TxKarateMama	by Pete_UK	1	514
Auto populate cell with info on other cell (Sheet) Oscar	by Oscar	4	827
SUMPRODUCT OR COUNTIF chrisk	by chrisk	6	497
Looking up a row of data bfont	by Dave Curtis[_2_]	3	369
Average Jen_T	by Glenn	4	315
Data Validation (copy paste error) Christoffer Bloch Andersen	by Christoffer Bloch Andersen	0	1,124
Help converting text to date & time? Jon M	by Stefi	2	593
matching text to text in excel Ikepri	by Stefi	3	501
Excel 2007 problem nesting IF & AND Steve	by Steve	0	500
How can I show a validity by a prompted symbol in colour? Maray	by Pete_UK	1	340
Pulling out values Emma Hope	by Emma Hope	2	405
Changing the colour of a range of cells, some with formulas. Champ	by Pete_UK	8	435
Triggering a Flag after 10 days that excludes weekends and holiday Danny Boy	by Stefi	3	463
cumprinc, not sure how to use it, someone please show me steps ple GACKT	by GACKT	0	394
sumif and complex sum_range formulae caro	by caro	2	479
Duplicates and unique values sragor	by muddan madhu	1	636
Copying data to summary sheet Max	by Max	2	417
removing the "-" sign in a calucation gma	by Khoshravan	8	394
Reference to worksheets Thys	by Max	4	464
V Lookup & IF Reenee	by Reenee	0	313
coditional Page Break j4m3sc	by Ashish Mathur[_2_]	3	401
Calculate AVERAGe with #MISSING! Arne Hegefors	by Ashish Mathur[_2_]	2	470
COUNT COMMON DATA HARSHAWARDHAN. S .SHASTRI[_2_]	by Ashish Mathur[_2_]	3	503
copy & paste andrew	by Max	1	301
how do you find many data? andrew	by Max	3	332
Subtotal John	by Ashish Mathur[_2_]	4	542
Fill series of dates across worksheets in excel Valhumf	by Gord Dibben	1	1,947
How do you insert & delete rows in a protected worksheet? Tiffany G.	by Gord Dibben	1	791
How do I auto highlight a cell with the same data as another cell john talbot	by Pete_UK	11	1,224
Please explain this formula Iriemon	by Max	2	554
IF Statments in Excel Valerie	by T. Valko	5	395
show all characters in a cell tinks	by Gord Dibben	1	1,185
how do I click on a drop down list and go to that data Donna	by Gord Dibben	1	332
WorkBook Update NotGood@All	by Gord Dibben	4	391
time calculation Siteman	by Siteman	8	462
convert text to hyperlink se7098	by se7098	2	1,762
Hyperlink "friendly-name" won't preserve links in PDF publishing ExcelUser	by ExcelUser	0	582
PASTE SPECIAL Indy-500	by Khoshravan	1	356
How do I find dups across different columns Nyrubi	by Khoshravan	3	550
Different answers when using cell references as opposed to actual leobensmom	by Glenn	4	496
Help with creating a function Craig	by Craig	4	455
Not sure whether to use VLOOKUP or an IF statement Allison1962	by John[_22_]	2	465
how can i use countif to count sundays in excel Reverend Ken	by Glenn	1	1,516
can I define validation range by function? DPR	by JE McGimpsey	1	434
to separate date and time formula Soth	by Soth	2	1,104
Date Conversion mecca	by David Biddulph[_2_]	7	391
Multi IF function not working IT1Navy	by Bernard Liengme	3	369
worksheet function... SteveDB1	by Pete_UK	7	397
formula to add year to date figures Brian	by Brian	0	464
Can anyone explain why my excel file won't scroll downwards? HappyHeartMonth	by Max	1	4,056
Excel 2003 using a list from another workbook Kimberly	by Roger Govier[_3_]	1	372
Conditional Formatting based on a vertical Array. cp37	by Gord Dibben	2	962
IF statements help Mandy J.S.	by Roger Govier[_3_]	1	315
Help with IF Statemet CM	by David Biddulph[_2_]	3	322
Yes or No Value if Dollar amount between two numbers Jerry B Smith	by John[_22_]	1	902
how to Calculate the discount ex. 9-63%=3.33 in excell michiganguy	by David Biddulph[_2_]	1	486
Quartiles Mike Dobony	by Bernie Deitrick	1	546
Cell referncing heather	by heather	20	1,409
Numbering cells that have been filtered Matt Pennington	by Matt Pennington[_2_]	2	440
default font color in excel Saladin Andreas	by Suleman Peerzade[_2_]	1	504
VLOOKUP, MATCH or something else entirely? Rebekah	by Pete_UK	3	467
IF FUNCTION? Reenee	by muddan madhu	6	356
Count Annie	by Chris Bode[_3_]	7	597
array search Luke	by Max	8	484
Running totals when letters entered. IF statement Peta	by Peta	0	612
Function Arguments dialog vanishes when clicked an inserted shape RK	by RK	2	625
textbox autosum Woodi2	by Chris Bode	6	1,153
countif HRM Hawaii	by Shane Devenshire[_2_]	4	472
sumif from multiple columns dcoxdcox	by Shane Devenshire[_2_]	6	1,120
Conditional Format Pat	by Shane Devenshire[_2_]	2	335
FORMULA FOR TABLE NARSARIA_RAJ KUMAR	by NARSARIA_RAJ KUMAR[_2_]	4	424
SUMIF no longer working Monish	by T. Valko	4	522
Format changes in a merged cell P_Kellogg	by P_Kellogg[_2_]	2	437