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	369
Date Conversion mecca	by David Biddulph[_2_]	7	391
to separate date and time formula Soth	by Soth	2	1,104
can I define validation range by function? DPR	by JE McGimpsey	1	434
how can i use countif to count sundays in excel Reverend Ken	by Glenn	1	1,516
Not sure whether to use VLOOKUP or an IF statement Allison1962	by John[_22_]	2	465
Help with creating a function Craig	by Craig	4	455
Different answers when using cell references as opposed to actual leobensmom	by Glenn	4	496
How do I find dups across different columns Nyrubi	by Khoshravan	3	551
PASTE SPECIAL Indy-500	by Khoshravan	1	356
Hyperlink "friendly-name" won't preserve links in PDF publishing ExcelUser	by ExcelUser	0	582
convert text to hyperlink se7098	by se7098	2	1,762
time calculation Siteman	by Siteman	8	462
WorkBook Update NotGood@All	by Gord Dibben	4	391
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,185
IF Statments in Excel Valerie	by T. Valko	5	395
Please explain this formula Iriemon	by Max	2	554
How do I auto highlight a cell with the same data as another cell john talbot	by Pete_UK	11	1,224
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,947
Subtotal John	by Ashish Mathur[_2_]	4	542
how do you find many data? andrew	by Max	3	332
copy & paste andrew	by Max	1	301
COUNT COMMON DATA HARSHAWARDHAN. S .SHASTRI[_2_]	by Ashish Mathur[_2_]	3	503
Calculate AVERAGe with #MISSING! Arne Hegefors	by Ashish Mathur[_2_]	2	470
coditional Page Break j4m3sc	by Ashish Mathur[_2_]	3	401
V Lookup & IF Reenee	by Reenee	0	313
Reference to worksheets Thys	by Max	4	464
removing the "-" sign in a calucation gma	by Khoshravan	8	394
Copying data to summary sheet Max	by Max	2	417
Duplicates and unique values sragor	by muddan madhu	1	636
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	394
Triggering a Flag after 10 days that excludes weekends and holiday Danny Boy	by Stefi	3	463
Changing the colour of a range of cells, some with formulas. Champ	by Pete_UK	8	435
Pulling out values Emma Hope	by Emma Hope	2	405
How can I show a validity by a prompted symbol in colour? Maray	by Pete_UK	1	340
Excel 2007 problem nesting IF & AND Steve	by Steve	0	500
matching text to text in excel Ikepri	by Stefi	3	501
Help converting text to date & time? Jon M	by Stefi	2	594
Data Validation (copy paste error) Christoffer Bloch Andersen	by Christoffer Bloch Andersen	0	1,124
Average Jen_T	by Glenn	4	315
Looking up a row of data bfont	by Dave Curtis[_2_]	3	369
SUMPRODUCT OR COUNTIF chrisk	by chrisk	6	497
Auto populate cell with info on other cell (Sheet) Oscar	by Oscar	4	827
Creating calendar that autopopulates dates based on event date ent TxKarateMama	by Pete_UK	1	514
formula to add year to date figures Brian	by Brian	3	1,173
Query on Null (#n/a) Mr. Platypus	by John Bundy	1	448
V Lookup & IF Reenee	by Gary''s Student	3	339
Absolute Reference not working Iriemon	by Iriemon	3	364
VLOOKUP Flipper	by John Bundy	1	310
Worksheet Calculations not working KPA	by David Biddulph[_2_]	4	336
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	285
Count with 1 variable & 1 constant criteria formula Excel-User-RR	by Excel-User-RR	3	673
Formula Help Erika	by Khoshravan	9	406
Copy of a Worksheet Does Not Update Chart References HoboDan	by HoboDan	0	712
work sheet Busch Satellite	by JE McGimpsey	1	323
Excel formular to Count values in cells of rows that meet criteria LuvJ1s	by xlmate	7	914
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,121
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,336
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	287
strange time value andrew	by Ron Rosenfeld	5	406
I need to set pointer to change a cell(s)with 1 click mash	by mash	0	379
Sorting Heidi	by Heidi	2	297
Workdays collshops	by collshops	2	418