Excel Worksheet Functions - Page 237

Thread / Thread Starter	Last Post	Replies	Views
Sum function which ignores hidden rows bucketheaduk	by Bob Phillips	2	638
how can I extend the condictional format to nine conditions? Jaime Z Prat Ramon	by Bob Phillips	1	366
Adjusting prizes to cater for ties Max	by Max	2	386
How do I download a personal blank wage deduction sheet bruno	by bruno	0	543
Finding MACROs and FUNCTIONs Tom	by Tom	0	327
Does Ctrl + F works in protected file with formulas? shida	by shida	0	489
Negative Number put in a certain column in a different sheet. naiveprogrammer	by Peo Sjoblom	2	646
Using a range as value_if_true in IF function Dmitry Kopnichev	by Dmitry Kopnichev	14	755
Get Vlookup to look at multiple Rows for the answer KDuxbury	by bpeltzer	1	530
Formula for "highlighting" data John	by John	3	388
Find an empty cell and put a dash in it? markexcel	by markexcel	5	1,805
Advanced Transposing? SHexceluser	by SHexceluser	0	387
IF function and speech recognition slcbabe	by slcbabe	0	394
Dynamic range for Table_array in a VLOOKUP. DaveO	by RagDyeR	8	773
autosum on the taskbar? paul	by paul	3	1,406
Create Excel Log automatically from Template CaymanCarrie	by CaymanCarrie	0	507
finding values and displaying adjacent values willy3211	by Faz	1	553
Multiple Column AutoFiltering Peter Crickman	by Alok	1	340
DUPLICATE VALUES Saintsman	by Saintsman	2	482
Multiple Columns & VLookup?? Tara C.	by Alok	1	564
how do I convert a number to number of years, months and days because	by Ron Rosenfeld	2	2,201
preserving format in a formula exceldoofus	by exceldoofus	3	446
HELP!! nick	by xlarch	11	586
Countif ? Walker	by Walker	2	412
how can i stop excel from automatically creating copies of workbo. Automac Parking	by Automac Parking	0	1,121
=IF Jim	by bj	1	293
Transpose Color Formatting to Seperate Worksheet Bryan	by DTB	2	1,255
How do I share my auto correct file with other users? kasbury	by Dave Peterson	2	402
prtect linked worksheet Debi	by Debi	0	327
IF function....testing against values in multiple cells racmb1975	by Shatin	2	1,132
Check for duplicates in excel file Dee	by JE McGimpsey	1	477
Percentage of amounts and profits of individual sales lulubelleshell	by JE McGimpsey	1	738
Combine multiple cells into one cell range. grady88	by Don Guillett	1	851
Link in the same w/s is pulling a different number. Joanna	by Dave Peterson	5	389
how do i automatically change the day and date Caveman	by swatsp0p	3	392
How to make LOOKUP give zero if it can't find the lookup_value? Dmitry Kopnichev	by Aladin Akyurek	3	515
SUMIF CCTD via OfficeKB.com	by Domenic	2	333
How do you count (not sum) cells containing special formatting? tbank	by Richard Buttrey	1	447
Convert Formula Result Christina	by Christina	2	373
Using MAX with OFFSET and MATCH Joe Gieder	by Domenic	3	523
how to delete duplicated content from 2 cells lucent88	by Richard Buttrey	2	563
Multiply one value by many factors ghofferbert	by ghofferbert	2	1,027
Excel subtotal group sort rick@bcbsne	by Dave Peterson	4	1,122
identify duplicate enteries Debi	by Bob Phillips	5	482
SUM C IF B=Cap... Till Next B=Cap... cradino	by cradino	6	621
How do I create a worksheet function for polynomial data fit me	by me	2	394
Help .... sum function tallboy755	by tallboy755	3	336
How do I NOT round off in a formula Sierra_07	by Chris Lavender	4	603
Compounding payments Nick	by Fred Smith	3	760
Crystal & Excel Jock W	by Fred Smith	1	744
formula that gives me a random number less than other number janiladewilly	by Barb Reinhardt	1	576
Excel and ranges Jason	by Jason	3	447
cannot open files ton	by RWN	3	445
Match Each Numeric occurrence and Return Individual Rows of Data Sam via OfficeKB.com	by Sam via OfficeKB.com	4	1,189
Trying to plot two lines onto a single graph in excel [email protected]	by [email protected]	3	2,567
combining countif with AND function Daesthai	by Biff	3	461
Date-orientated update of cells in different spreadsheets omb	by ScottO	1	520
get all row nos TUNGANA KURMA RAJU	by Bob Phillips	1	460
value lookup help elitewolverine	by elitewolverine	2	395
How to replace column letter in refferences with a function using the old column letter? Dmitry Kopnichev	by Dmitry Kopnichev	6	1,217
Asking for user input if there is no data for the function elitewolverine	by elitewolverine	0	460
Two columns BPR	by Harald Staff	1	368
Can a macro erase it's self after a set criteria? Jeff	by Richard Buttrey	3	420
Format cell window size KHall1968	by KHall1968	2	481
How to replace a function with its result or resulting reference in a formula? Dmitry Kopnichev	by Dmitry Kopnichev	5	720
VLOOKUP not returning correct value leigh	by Roger Govier	6	1,701
How do I centre rows top to bottom? Centre top to bottom excel	by DrProctor	1	461
Days Within Months Rayco	by Rayco	6	339
Sorting not getting what I want reades	by Faz	1	395
formula for putting points into groups grime	by grime	0	531
Relative Ranges in excel macro edself	by Richard Buttrey	6	1,005
Can Solver solve this? nirani	by bpeltzer	3	616
Compound array question - what am I doing wrong? Daesthai	by Ron Rosenfeld	4	577
Date Count shoulders	by Jon Quixley	4	403
Subtotal function for hidden row [email protected]	by topola	10	1,094