Excel Worksheet Functions - Page 237

Thread / Thread Starter	Last Post	Replies	Views
Query on Null (#n/a) Mr. Platypus	by John Bundy	1	471
formula to add year to date figures Brian	by Brian	3	1,183
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	867
SUMPRODUCT OR COUNTIF chrisk	by chrisk	6	508
Looking up a row of data bfont	by Dave Curtis[_2_]	3	393
Average Jen_T	by Glenn	4	329
Data Validation (copy paste error) Christoffer Bloch Andersen	by Christoffer Bloch Andersen	0	1,147
Help converting text to date & time? Jon M	by Stefi	2	648
matching text to text in excel Ikepri	by Stefi	3	518
Excel 2007 problem nesting IF & AND Steve	by Steve	0	522
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	420
Changing the colour of a range of cells, some with formulas. Champ	by Pete_UK	8	463
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	507
Duplicates and unique values sragor	by muddan madhu	1	670
Copying data to summary sheet Max	by Max	2	441
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	321
coditional Page Break j4m3sc	by Ashish Mathur[_2_]	3	430
Calculate AVERAGe with #MISSING! Arne Hegefors	by Ashish Mathur[_2_]	2	515
COUNT COMMON DATA HARSHAWARDHAN. S .SHASTRI[_2_]	by Ashish Mathur[_2_]	3	530
copy & paste andrew	by Max	1	321
how do you find many data? andrew	by Max	3	356
Subtotal John	by Ashish Mathur[_2_]	4	567
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	820
How do I auto highlight a cell with the same data as another cell john talbot	by Pete_UK	11	1,251
Please explain this formula Iriemon	by Max	2	576
IF Statments in Excel Valerie	by T. Valko	5	414
show all characters in a cell tinks	by Gord Dibben	1	1,202
how do I click on a drop down list and go to that data Donna	by Gord Dibben	1	359
WorkBook Update NotGood@All	by Gord Dibben	4	408
time calculation Siteman	by Siteman	8	480
convert text to hyperlink se7098	by se7098	2	1,786
Hyperlink "friendly-name" won't preserve links in PDF publishing ExcelUser	by ExcelUser	0	600
PASTE SPECIAL Indy-500	by Khoshravan	1	368
How do I find dups across different columns Nyrubi	by Khoshravan	3	592
Different answers when using cell references as opposed to actual leobensmom	by Glenn	4	520
Help with creating a function Craig	by Craig	4	483
Not sure whether to use VLOOKUP or an IF statement Allison1962	by John[_22_]	2	506
how can i use countif to count sundays in excel Reverend Ken	by Glenn	1	1,536
can I define validation range by function? DPR	by JE McGimpsey	1	467
to separate date and time formula Soth	by Soth	2	1,123
Date Conversion mecca	by David Biddulph[_2_]	7	411
Multi IF function not working IT1Navy	by Bernard Liengme	3	398
worksheet function... SteveDB1	by Pete_UK	7	410
formula to add year to date figures Brian	by Brian	0	482
Can anyone explain why my excel file won't scroll downwards? HappyHeartMonth	by Max	1	4,079
Excel 2003 using a list from another workbook Kimberly	by Roger Govier[_3_]	1	388
Conditional Formatting based on a vertical Array. cp37	by Gord Dibben	2	985
IF statements help Mandy J.S.	by Roger Govier[_3_]	1	362
Help with IF Statemet CM	by David Biddulph[_2_]	3	343
Yes or No Value if Dollar amount between two numbers Jerry B Smith	by John[_22_]	1	935
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	569
Cell referncing heather	by heather	20	1,428
Numbering cells that have been filtered Matt Pennington	by Matt Pennington[_2_]	2	460
default font color in excel Saladin Andreas	by Suleman Peerzade[_2_]	1	532
VLOOKUP, MATCH or something else entirely? Rebekah	by Pete_UK	3	476
IF FUNCTION? Reenee	by muddan madhu	6	376
Count Annie	by Chris Bode[_3_]	7	621
array search Luke	by Max	8	547
Running totals when letters entered. IF statement Peta	by Peta	0	637
Function Arguments dialog vanishes when clicked an inserted shape RK	by RK	2	647
textbox autosum Woodi2	by Chris Bode	6	1,173
countif HRM Hawaii	by Shane Devenshire[_2_]	4	494
sumif from multiple columns dcoxdcox	by Shane Devenshire[_2_]	6	1,153
Conditional Format Pat	by Shane Devenshire[_2_]	2	360
FORMULA FOR TABLE NARSARIA_RAJ KUMAR	by NARSARIA_RAJ KUMAR[_2_]	4	435
SUMIF no longer working Monish	by T. Valko	4	557
Format changes in a merged cell P_Kellogg	by P_Kellogg[_2_]	2	449