Excel Worksheet Functions - Page 1150

Thread / Thread Starter	Last Post	Replies	Views
How to custom format a date shriil	by Ron Rosenfeld[_2_]	5	1,308
Conditional Formatting based on active Named Range; IF Function to VBA Todd[_4_]	by Don Guillett[_2_]	1	1,455
Shared workbook error message SteveR	by SteveR	8	6,142
IF Function error #VALUE Pat[_7_]	by Gord Dibben[_2_]	1	1,037
1st numer in string Jack Deuce	by Ron Rosenfeld[_2_]	4	613
Excel and Visual Basic Deb[_5_]	by Don Guillett[_2_]	2	751
grouping dates in a pivot table pat67	by trip_to_tokyo[_3_]	1	645
copy cell by command button kalpesh	by James Ravenswood	1	1,563
Need VB formula to retrieve data dave	by isabelle	1	656
copy cell range in other sheet kalpesh	by Gord Dibben[_2_]	1	1,014
Need VB formula to edit and save data dave	by dave	2	740
Formula Based on Values in Named Range Q Seanie	by Ron Rosenfeld[_2_]	5	1,068
Dates GB[_2_]	by GB[_2_]	0	658
Cell Range Split into Multiple Cells Willie	by Ron Rosenfeld[_2_]	6	1,219
Sort Issue Excel 2003 PagosaJoe	by Ron Rosenfeld[_2_]	1	710
Benefits of knowledge base software michael moody	by michael moody	0	716
Calculating what staff worked on which product DumDum	by GS[_2_]	3	889
URGENT HELP - SUM FORMULA Michelle	by Gord Dibben[_2_]	5	624
ANOTHER URGENT QUESTION - Sums and Ifs Michelle	by Michelle	4	633
Cell validation Sai Krishna[_2_]	by isabelle	29	2,695
Formulas Still Not Working Michelle	by joeu2004[_2_]	5	816
Show time as a bar graph Gadgetman[_2_]	by Gadgetman[_2_]	3	1,775
can you make a cell blink? pat67	by Rick Rothstein	4	956
Multiple Tables and Multiple Pivot Tables Help Catinalana	by Catinalana	0	746
Lookup cell next to data abetancur	by abetancur	2	742
Formula to match different ranges of time and prices santiag_dl	by santiag_dl	0	724
Transfer data from a cell to another workbook if certain criteria breezy	by mdrizwan81	15	3,333
How to automatically set print area in Excel template? JCMII	by Nate SixEight	6	2,200
vlookup and Sum unique values Diggsy	by Robinhoodz	3	1,781
open file with multiple types of delimiters tuli	by GS[_2_]	2	945
Extracting Data from Tables [email protected]	by Don Guillett[_2_]	1	611
N/A in pivot table become 0 Gaetan M	by isabelle	1	898
help with formula for last input in column mag	by mag	7	1,357
Two types of Data Validation in a cell? Lakeville	by sreenivas p	9	2,258
Tricky one LondonJames	by plinius	1	583
pivot table help pat67	by pat67	0	488
If statement checking list B Rucks	by GS[_2_]	4	799
Highlighting duplicates across many sheets jpeevy	by GS[_2_]	3	1,548
Present Value Uneven Cashflows jjones42	by joeu2004[_2_]	6	2,604
Index and Match John Smith[_17_]	by John Smith[_17_]	8	860
may need programming? csmock	by csmock	2	662
CALCULATE THE ACTUAL AGE IN TERMS OF YEARS, MONTHS AND DAYS jr	by nmorales	2	1,346
Help with a formula (calculating totals based on individual percentages jamesplaw	by Ron Rosenfeld[_2_]	7	1,140
Creating Palette Labels at work boorman	by boorman	2	1,060
2 criteria robzrob	by plinius	1	876
Need VB formula to execute form dave	by dave	2	612
Need VB formula to exit workbook dave	by Gord Dibben[_2_]	1	622
SUMPRODUCT help needed cupertino	by Vacuum Sealed	7	825
Screening through days of the week including time rhhince[_2_]	by Don Guillett[_2_]	1	568
formula displays as a formula, not as its result dido22	by GS[_2_]	1	509
COUNTIF - help please Amada	by Rick Rothstein	11	1,209
Large Data File Consolidation... divrdrew	by Don Guillett[_2_]	2	599
IF Function -- Return Null Value Help Amanda[_9_]	by joeu2004[_2_]	2	1,344
How to create a pivot table in a new worksheet by recording a macro razib	by isabelle	1	809
Can I VLOOKUP in 7 different worksheets in 1 formula? keithobro	by ayaz jafri	12	1,465
VLOOKUP source values are a formula result. Getting #N/A Pete[_25_]	by Pete[_25_]	7	1,182
using excel as a markbook rattlebee88	by GS[_2_]	2	1,354
hi al yngve	by yngve	2	575
Sliding Scale Cory Tilton	by Gord Dibben[_2_]	5	1,303
Cros referencing Data on Excel Rob Fairbrother	by Rob Fairbrother	0	598
function showing false result when it is not Amy-Marie	by Cimjet[_3_]	10	1,306
Sumif or vlookup dejavu34	by Gord Dibben[_2_]	1	1,115
Get Column Header if Condition is Met EE[_2_]	by EE[_2_]	0	625
Cross referencing data in Excel Rob Fairbrother	by Pete_UK[_8_]	4	741
Dynamically sized table compiled from unsorted rows with blank entries Ezra[_3_]	by Ezra[_3_]	2	598
formula to disperse data to several worksheets BabsCreates	by Gord Dibben[_2_]	3	961
Average If carl	by joeu2004[_2_]	3	671
Formula Question carl	by carl	4	600
Hide/Unhide with cell double click bones288	by GS[_2_]	3	1,501
Running Total Question Sam	by joeu2004[_2_]	2	660
Counting one Character as a String sidfictitious	by Don Guillett[_2_]	1	652
Keep original cell formatting when using transpose array formula Claire Charron	by GS[_2_]	1	1,249
If date in range is before today mjones	by CommonShiner	4	4,770
runtime error 9 subscript out of range Nastack628	by Gord Dibben[_2_]	1	1,927
Call a function within Excel VBA --- need help can't figure out syntax correctly [email protected]	by GS[_2_]	11	2,009