Functions

Updating data in one Worksheet and propagating it to others
HI I have a 3 page worksheet listing all the schemas I maintain, with each page representing a different view; by DB type, region, customer etc. Each sheet is exactly the same except for how the data is ordered (by DB, region etc). Is there a way that I can update the data in sheet #1 and then have it automa... 3 Jul 2008 20:44

if value is between two numbers
I have the following ranges: A B C D GENERAL 110 0.00 $0.21 GENERAL 125 0.22 $10.00 GENERAL 130 10.01 $50.00 GENERAL 140 50.01 $100.00 GENERAL 150 100.01 $500.00 GENERAL 160 500.01 GENERAL2 10 0.00 $0.21 GENERAL2 20 0.22 $10.00 GENERAL2 30 10.01 $50.00 GENERAL2 40 50.0... 3 Jul 2008 17:40

How do u sort many items out a spread sheet in excel
I get an excel spread sheet hundreds of thousands of accouts on it. I have a few thousand of the accouts myself i have to look at. I need a function or a table where i can put my accts numbers and can pull out the importation out i need. Any help on this would be a huge and i would greatly appericate. ple... 3 Jul 2008 16:38

Nested IF Function not working
This is the formula I put in: =if(L42<3,"$50",if(L42>2<5,"$100")). Instead of returning $50 or $100 it returns FALSE. What am I doing wrong? Thank You. ... 3 Jul 2008 22:47

EQUIVALENT for this FORMULA , please
HI eveybody I have this formula : =AND(COUNT(B1;B3;B5)<=1;COUNT(C1;C3;C3)<=1;COUNT(D1;D3;D5)<=1;COUNT(E1;E3;E­ 5)<=1;COUNT(F1;F3;F5)<=1) WHAT I NEED IS A PERFECT EQUIVALENT FOR THIS FORMULA ! This function let me to know if every one of the 5 COUNT functions have the result the value <=1; (this is w... 3 Jul 2008 17:40

Insert Copied Rows or Drag/Drop Formulas While Protected
I am working with a worksheet that has the cells with formulas protected, to prevent end users from modifying or overriding them (specifically column E). My problem is I need to be able to add rows (Say 3 new rows between rows 1 and 2-which will mirror rows 1 and 2 exactly), and have the formulas in those prote... 3 Jul 2008 16:38

Pivot Tables & Conditional Formatting
Can you use conditional formatting within pivot tables? I am trying to identify balances that exceed certain dollar values or percentages for variance analysis. ... 4 Jul 2008 10:00

FINDING THE DATE 75 DAYS AFTER A SPECIFIED DATE
I NEED TO KNOW HOW TO FIND THE DATE 75 DAYS AFTER A SPECIFIED DATE IN EXCEL. ... 3 Jul 2008 14:34

Isolate text immediately preceding "("
I tried unsuccessfully to isolate text immediately preceding the "(" from a text string into another cell using: =MID(A1,SEARCH("(",A1) -20) My text string contains a payee name followed by their date of birth like this: Smith, John (DOB: Dec 16/91) I want to put the name into cell A1 and the DOB into B... 3 Jul 2008 16:38

Sorting text and numbers from multiple tabs
I have a master file I am working on in which data on one tab is linked to other tabs. I have a macro for them to be sorted, but when I sort, only the numbers sort and then the words are bumped to the bottom of the sorting block. I end up with numbers sorted and then a huge gap with the words sorted at the bott... 3 Jul 2008 14:34