Excel Worksheet Functions - Page 947

Thread / Thread Starter	Last Post	Replies	Views
worksheet function... SteveDB1	by Pete_UK	7	397
Multi IF function not working IT1Navy	by Bernard Liengme	3	368
Date Conversion mecca	by David Biddulph[_2_]	7	391
to separate date and time formula Soth	by Soth	2	1,103
can I define validation range by function? DPR	by JE McGimpsey	1	430
how can i use countif to count sundays in excel Reverend Ken	by Glenn	1	1,515
Not sure whether to use VLOOKUP or an IF statement Allison1962	by John[_22_]	2	463
Help with creating a function Craig	by Craig	4	454
Different answers when using cell references as opposed to actual leobensmom	by Glenn	4	495
How do I find dups across different columns Nyrubi	by Khoshravan	3	543
PASTE SPECIAL Indy-500	by Khoshravan	1	355
Hyperlink "friendly-name" won't preserve links in PDF publishing ExcelUser	by ExcelUser	0	581
convert text to hyperlink se7098	by se7098	2	1,761
time calculation Siteman	by Siteman	8	462
WorkBook Update NotGood@All	by Gord Dibben	4	390
how do I click on a drop down list and go to that data Donna	by Gord Dibben	1	332
show all characters in a cell tinks	by Gord Dibben	1	1,184
IF Statments in Excel Valerie	by T. Valko	5	394
Please explain this formula Iriemon	by Max	2	552
How do I auto highlight a cell with the same data as another cell john talbot	by Pete_UK	11	1,223
How do you insert & delete rows in a protected worksheet? Tiffany G.	by Gord Dibben	1	791
Fill series of dates across worksheets in excel Valhumf	by Gord Dibben	1	1,946
Subtotal John	by Ashish Mathur[_2_]	4	541
how do you find many data? andrew	by Max	3	332
copy & paste andrew	by Max	1	300
COUNT COMMON DATA HARSHAWARDHAN. S .SHASTRI[_2_]	by Ashish Mathur[_2_]	3	503
Calculate AVERAGe with #MISSING! Arne Hegefors	by Ashish Mathur[_2_]	2	460
coditional Page Break j4m3sc	by Ashish Mathur[_2_]	3	400
V Lookup & IF Reenee	by Reenee	0	313
Reference to worksheets Thys	by Max	4	463
removing the "-" sign in a calucation gma	by Khoshravan	8	391
Copying data to summary sheet Max	by Max	2	409
Duplicates and unique values sragor	by muddan madhu	1	632
sumif and complex sum_range formulae caro	by caro	2	479
cumprinc, not sure how to use it, someone please show me steps ple GACKT	by GACKT	0	391
Triggering a Flag after 10 days that excludes weekends and holiday Danny Boy	by Stefi	3	462
Changing the colour of a range of cells, some with formulas. Champ	by Pete_UK	8	434
Pulling out values Emma Hope	by Emma Hope	2	401
How can I show a validity by a prompted symbol in colour? Maray	by Pete_UK	1	339
Excel 2007 problem nesting IF & AND Steve	by Steve	0	499
matching text to text in excel Ikepri	by Stefi	3	500
Help converting text to date & time? Jon M	by Stefi	2	588
Data Validation (copy paste error) Christoffer Bloch Andersen	by Christoffer Bloch Andersen	0	1,120
Average Jen_T	by Glenn	4	314
Looking up a row of data bfont	by Dave Curtis[_2_]	3	368
SUMPRODUCT OR COUNTIF chrisk	by chrisk	6	497
Auto populate cell with info on other cell (Sheet) Oscar	by Oscar	4	822
Creating calendar that autopopulates dates based on event date ent TxKarateMama	by Pete_UK	1	509
formula to add year to date figures Brian	by Brian	3	1,172
Query on Null (#n/a) Mr. Platypus	by John Bundy	1	447
V Lookup & IF Reenee	by Gary''s Student	3	338
Absolute Reference not working Iriemon	by Iriemon	3	362
VLOOKUP Flipper	by John Bundy	1	310
Worksheet Calculations not working KPA	by David Biddulph[_2_]	4	335
Can i run 2 IF statements in one formula? zak	by David Biddulph[_2_]	3	309
Count subset-totals in column Pluggie	by Domenic[_2_]	4	617
if condition and locking cells kashvii	by JE McGimpsey	1	284
Count with 1 variable & 1 constant criteria formula Excel-User-RR	by Excel-User-RR	3	673
Formula Help Erika	by Khoshravan	9	404
Copy of a Worksheet Does Not Update Chart References HoboDan	by HoboDan	0	710
work sheet Busch Satellite	by JE McGimpsey	1	322
Excel formular to Count values in cells of rows that meet criteria LuvJ1s	by xlmate	7	913
Matrix Inversion by Gaussian Reduction David C	by Dana DeLouis	16	1,706
How to I set a limit on the value returned by a cell WavMaster	by JE McGimpsey	3	1,120
Numbering after using autofilter Matt Pennington[_2_]	by T. Valko	10	871
Index & Match Question Iriemon	by T. Valko	2	480
calculating a value if adjacent cell has value Matt Stayton[_2_]	by JE McGimpsey	3	1,334
Character search and replace jkollenbroich	by Elkar	1	563
Rank using two different categories within a multiple time period Mimi	by Mimi	4	1,114
Excel Formula Question Donald	by muddan madhu	3	455
help with spreadsheet CL	by Pete_UK	1	286
strange time value andrew	by Ron Rosenfeld	5	405
I need to set pointer to change a cell(s)with 1 click mash	by mash	0	377
Sorting Heidi	by Heidi	2	297
Workdays collshops	by collshops	2	418