Functions
in [Excel]
|
vlook up w- multiple variables For my vlook up in excel 2007, I want to return data to populate cell B2 (xxxx) from column 3 ($21,745) of a data set when the value in cell A2 (360 19318) AND B1 (200801) match from the original data set. DATA SET 1 2 3 Dosfrom OP_Combined Claimed_Avg 200801 360... 14 Apr 2010 14:28
Date Diff - excluding working days Hi all, Does anyone know how i can return the difference between two dates that across weeks, months and years and only count working days? ... 13 Apr 2010 12:50
stock control template does anyone have a stock control template i can download ... 13 Apr 2010 10:36
Adding totals from different columns Hi I have a column called year group, one called total attendance and one called possible total. I would like to create the total % attendance for the group year 7 by adding up the total attendances and making this a % of the possible total: e.g. Year 7, 213, 290 Year 8, 214, 290 Year 7, 203, 270 Year ... 13 Apr 2010 11:43
Hyperlink won't open in excel I get a message in excel when I try to open hyperlink in excel that says "This operation has been cancelled due to restrictions in affect on this computer. Please contact your system administrator" I am the administrator what must I do???? ... 13 Apr 2010 10:36
Array Formula Help Needed Hi Guys I need an array formula which counts the number of instances range Comp1 has a value greater then zero AND Range Comp2 has a blank value. Sounds simple but I just can't figure it out. Also would be helpfull would the same criterior but instead of counting the instances sums the vales in range Comp... 13 Apr 2010 08:22
updating cell range depending on input value I'm creating a spreadsheet to process golf scores and calculate handicaps. I've identified the best 10 (AD4:AD13)scores from the past 20 (AB4:AB23). What I now need to do is cater for the next score input which will be in AB24 and move the range to account for the new score (AB5:AB24). I also need to tell ... 17 Apr 2010 01:04
Help with formula I want to return the first date in which the sum of the previous columns first exceeds inventory on hand (total). Should return 4/5 on this example. Total Due Date 3/24 3/30 4/5 4/7 4/7 68 #N/A 10 50 20 30 30 I am using nested if's, but need to expand to more than 7 columns, using excel 2003. Thanks ... 13 Apr 2010 06:12
Conditional formatting with expired dates after current I am trying to get a cell to turn Red if the date that is in the cell is less than or equal to the current date. The formula I have in it already is: =EDATE(D2, 12) This takes the date that I plug into the column before it and just adds 12 months to it. Thanks for any help you can offer. V/R ... 12 Apr 2010 23:41 |