Excel Worksheet Functions - Page 206

Thread / Thread Starter	Last Post	Replies	Views
If statement needed Patsy	by JulieD	1	1,111
How do I create a random sample from a list? swrath	by RagDyeR	1	1,111
Match Index cjjoo	by Bob Phillips	3	1,111
Re Change 5 week days to 7 days in this formula pano	by Bob Phillips	7	1,111
How to create filter using criteria from other cells. JLewis	by Peo Sjoblom	18	1,111
California rollover Paid Time Off tracking - any templates availa. gsmith	by gsmith	0	1,111
Why do my dates change when I copy them between Excel worksheets? rrjohnsonia	by Peo Sjoblom	6	1,111
Remove Numbers from text David	by David McRitchie	6	1,111
Conditional formatting - source data from another sheet AT	by Ashish Mathur[_2_]	4	1,111
Is there a keyboard shortcut to center data in a cell? Phil_K	by David McRitchie	1	1,111
Select from a list frisbee_train	by Teethless mama	2	1,111
calculating a formula for a service level Andy B	by David Biddulph[_2_]	1	1,111
how to create sequential invoice numbers from a saved template Sean	by JE McGimpsey	1	1,111
adding if statement results Robb27	by Biff	3	1,111
SUMIF across a range of worksheets Mike@Q	by Domenic	3	1,111
Dynamic Year-To-Date Formula snax500	by snax500	3	1,111
Sum results of VLOOKUP Dewayne	by RagDyeR	7	1,111
Protected sheet, On Enter moves next. Can I stop this? misseill	by www.exciter.gr	3	1,111
Routine with fuzzy logic to determine the relative comparison of two strings? Elmer Smurdley	by Elmer Smurdley	7	1,111
How can I combine text and a function in a single cell slot guy	by slot guy	3	1,111
searching for values and summing the corresponding values Simon	by Biff	1	1,111
min in a subgroup SteveC	by T. Valko	9	1,110
Count Duplicate Numbers farid2001	by Stefi	4	1,110
how do I do this: today minus hire date equals how many years mo. btaylor1990	by Gary''s Student	1	1,110
Conditional Formatting based on text? KarenH	by Joerg	4	1,110
counting blocks of 1's Bryan De-Lara	by Bryan De-Lara	10	1,110
To find Multiple values in column B for a unique value in column A kishdaba	by shail	2	1,110
How do I to refer to a (named) cell in Excel header/footer? Ton[_2_]	by Gary''s Student	1	1,110
Help with SUMIF or array function to ignore #VALUE! Nelly[_2_]	by Max	2	1,110
Automatically change case is Excel when typed harwookf	by harwookf	8	1,110
Disabling click and right-click on the Picture I inserted in an Excel document [email protected]	by Marcelo	1	1,110
Combining IF OR and AND functions andyp161	by Toppers	3	1,110
Using SUMPRODUCT, 3 variables, 2 types of data in 1 column Dana M	by Pete_UK	3	1,110
Format cells with 0 as the tenth digit PointerMan	by PointerMan	14	1,110
converting email address names in a range of cells to real names John	by T. Valko	1	1,110
Enable Macro Alert Box Mattlynn via OfficeKB.com	by Mattlynn via OfficeKB.com	9	1,110
Adding Value within a single cell... Brian	by Brian	4	1,110
Weighted Averages PhilF	by PhilF	7	1,110
How do I enter a date before 1900 in excel? woodrat	by Norman Jones	1	1,110
paste special values jenn	by Dave Peterson	2	1,110
Consolidate data from several worksheets via pivot table mthatt	by mthatt	0	1,110
EXCEL 2003: Apply Conditional Formatting to COLUMNS HWDFWXCLGuru	by HWDFWXCLGuru	3	1,110
Sorting data in a workbook across multple worksheets Phil	by Phil	7	1,110
Working time and days Nortos	by Bob Phillips	5	1,110
Array formula not working Alex	by terabar	3	1,110
toolbar for "standard tickmarks" mark kubicki	by mark kubicki	0	1,110
how can i rank a column in excel David B.	by Max	4	1,110
How to sum data that is only within a specific number range? ryesworld	by ryesworld	3	1,110
Using dropdown in protected sheet veggies27	by Dave Peterson	2	1,110
Rounding to nearest 250 by 125s tcek	by Fred Smith[_4_]	3	1,110
how to convert decimal numbers to words Akbar	by ElisabethD	2	1,110
sumproduct formula too long, & how to use make an 'OR' statement w creativeops	by creativeops	11	1,110
Median in pivot tables SB Lee[_2_]	by Herbert Seidenberg	5	1,109
Hyperlinks to show on top left corner of screen Elisabeth	by Gary''s Student	4	1,109
how do i set up a 'rolling shift pattern' worksheet? rednip	by rednip	0	1,109
countif column d equals x and column a noblank Willie Wilson	by Willie Wilson[_2_]	4	1,109
IF/ LOOKUP FUNCTION - Excel 2000 Chandrashekhar	by Ken Wright	3	1,109
How do I set up a drop down menu for a validation list? UisNike	by Peo Sjoblom	2	1,109
Multiple Criteria IF Nesting BethB	by BethB	2	1,109
How to save the current worksheet as JPEG, TIFF or DICOM? DORI	by DORI	2	1,109
Does SUMIF in Excel, take multiple criteria input? Xray_Dave	by navychef	5	1,109
Trending Formula Results by Date sony654	by sony654	0	1,109
multiple conditional formatting Robin Krupp	by Robin Krupp	0	1,109
Need Formula Help kidd	by kidd	4	1,109
sumproduct not working Tester	by Ron Coderre	10	1,109
pop up calendar using MS DateTime Picker andy62	by andy62	4	1,109
Copy cells in a specific pattern Cornelius	by Cornelius	3	1,109
Need 3D formula for a range of numbers across several worksheets WAGg	by JLatham	2	1,108
Stripping text before a number (alpha or numeric) data_mattress	by CLR	10	1,108
How to auto-return to next cell that accepts data. [email protected]	by R1C1	4	1,108
Worksheet does not open in the last place it was saved LDurham	by LDurham	3	1,108
Military Time & Colon cottage6	by Gord Dibben	3	1,108
Finding the earliest date from a range of cells [email protected]	by T. Valko	1	1,108
sumproduct formula to slow Todd	by Todd	4	1,108
Import external data nordiyu	by FSt1	6	1,108