Two-Dimensional Pull The Amount It Will Payout (based On The Place And The # In Class)

Oct 11, 2008

I'm attaching a copy for verification. On the invoice sheet once the place and # in class are entered it needs to pull the amount it will payout (based on the place and the # in class). No matter what I do I can't seem to get the formula to work.

View 2 Replies


ADVERTISEMENT

Place / Pull Html Table Into Worksheet

Feb 29, 2008

I need to copy/cut and paste an Html table from a website into and Excel sheet without the data being transposed. See link for the table I need to get into Excel:

http://www.voedingswaardetabel.nl/voedingswaarde/?vw=vv

Then cut and paste it to Excel, you see the data is now vertical. I need the table horizontal as it appears on the website.

View 2 Replies View Related

Pull Data From Specified Place In Text File To Cell

Dec 25, 2009

i need away that will give me the way to pull data from specified place
in txt file to A1 cell in excel sheet3

View 9 Replies View Related

Formula- To Calculate The Amount Due Based On Cumulative Sales Once A Breakpoint Amount Is Reached

Jan 28, 2009

I need a formula to calculate the amount due based on cumulative sales once a breakpoint amount is reached.

Example:

Breakpoint:
cum sales are > 500 pay at 3%
cum sales are >1,000 pay at 2%

month/ sales/ cumul sales/ amount due
jan/ 100.00/ 100.00/ 0
feb/ 600.00/ 700.00/ 6.00
mar/ 600.00/ 1,300.00/ 18.00

and so on...until the end of year.

I tried using an if formula by could not get it to work.

View 9 Replies View Related

Formula To Pull Out Data From A List To Create Class Lists?

May 16, 2014

if there was a way to automatically add each student to a class list as their information is inputted. What i mean is, after input Sally Student in the main enrollment list she would automatically go to the class list for the class she has chosen.

I have attached a sample workbook with my desired results. Basically what i want to do is make this easier for those in charge to get the class lists from the main list without having to copy and past all the time.

The class lists are in the tabs in the workbook.

View 5 Replies View Related

Creating A 2-dimensional Array From A 1-dimensional List

Nov 27, 2008

I've been a lurker on this forum for a long while and it's always been able to provide me with lots of excel tips, and for that I am grateful! But this time I have a question that I can't find the answer to here, or anywhere else on the web after a few hours of looking. As a note, I'm not very experienced with Excel, probably somewhere between novice and intermediate.

What I need to create is a 2-dimensional array of data. The vertical (y-axis) are the tools, and the horizontal (x-axis) are the jobs. Where the y-axis and the x-axis intersect, will be the quantity of tools needed for that specific job. There are almost 1500 tools, and 100 jobs.

View 4 Replies View Related

Tournament Spreadsheet (flexible Number Of Players And Payout Percentages)

May 10, 2014

I'm trying to figure out a simple spreadsheet that can spit out tournament payouts based on a flexible number of players (we might have 55, 60, 100) and flexible percentages based on the pot size (if we have 100 players, we would like to pay more players than if we had 50).

Something like [input number of players] [input pot size] [input # of payouts] [input percentage of each payout] it would just save a ton of time as we're trying to calculate payouts on the go.

View 5 Replies View Related

Iteration Inconsistency: Allow For A Cost Being Added To Loan Amount Where The Cost Is Based On The Total Loan Amount

Mar 15, 2007

In a financial environment we have a calculator which uses iteration to allow for a cost being added to loan amount where the cost is based on the total loan amount. Iteration is set to 100 iterations with max change .001

On one PC the first time the calculator is opened it gives a particular (incorrect) result. If the input cells are cleared and the data re-entered, it gives the correct result. This only happens on one particular PC. Is there some other setting , other than the iteration setting, that would cause this?

View 5 Replies View Related

Macro To Copy And Place Data To Specific Place

Feb 22, 2007

I am after a macro to do the following, my visual basic skills are very limited (non existant):- Look at the date in cell A1 on Sheet 'Live Report' and err 'remember it' Copy a range of cells from A3 to A10 on 'Live Report' Go to sheet 'Monthly Summary' and find the date that had been remembered previously (this date will be in column A on 'Monthly Summary' which will probably be a mixture of values and formulas). After the date has been found paste special and transpose the 'values only' copied range from 'Live Report' (A3 to A10) in column B on 'Monthly Summary' next to the date that has been found in Column A.

View 2 Replies View Related

Class Modules: Class Object Can I Visually See It

Jul 23, 2009

i've reached a point where i would like to learn more about class modules but i have no resources. When i create a Class object can i visually see it? i want to know as i'm looking to use them within userforms if possible

View 4 Replies View Related

Discount Based On Amount?

Feb 6, 2009

I need to create a price list a we give a discount based on the price of the product for example:....

All products over £100 have a 10% Discount, how do this and also at the sametime round the value up to 0.99p. ie Product ZXY123 is £123.99 10% off is £111.59 we need the calculated price to be £111.99.

View 2 Replies View Related

Place Value In Multiple Cells Based On Cell Variable

Nov 26, 2009

I'm trying to place the value of "X" in multiple cells based on a cell variable (i). For example, if (i) is evaluates to 35, the following code ...

View 8 Replies View Related

Reference Cell & Add Amount If Positive & Subtract Amount If Negative

Jun 5, 2008

Im trying to set up an active running inventory sheet where: (A)the progressive daily sheet cells reference back to the corresponding master sheet cells fluctuating the master values, (B) the same progressive daily sheet cells reference back to a cummulative totals-cell based on whether I added or subtracted inventory. I want to make a copy of the blank "sheet 2" with all of the formulas and move it to the end of the workbook each day and enter new values which will reference back to the master sheet so that I can click on a date sheet and see an individual day's values or click on the master sheet to see the fluctuating inventory on-hand and the cummulative +/- totals of all days combined. I've got a couple hundred individual cells to reference. I've tried and tried but I can't make it work. Heres what I need to do:

I need to reference individual cells from "sheet 2,3,etc" back to a corresponding cell in a master sheet. But I need the values in each cell in "sheet 2,3,ETC" to increase or decrease the corresponding cell values in the master sheet. For example: If the value in the master sheet B5 is 200. Then in sheet 2, I enter +50 in B5, I need the master sheet cell B5 to increase by 50 to 250. I also need a way to decrease the cell value in the master sheet B5 if I enter a negative value -50 in sheet 2 B5. I also want to know if I can reference the same cell values entered in "sheet 2,3,etc cell B5" back to totals columns C5 for adding inventory or D5 for subtracting inventory in the master sheet where the master totals columns would reflect cummulative totals added or subtracted. For example: if the value in sheet 2 B5 is +50, then the value in Master sheet C5 would add 50 to a progressive total. But if the value in sheet 2 B5 is -50 then the value in master sheet D5 would add -50 to a progressive total.

View 4 Replies View Related

Looking To Assign Value Based Upon Amount Of Time

Nov 29, 2013

Essentially I have column A that has a result that is a sum of time, I'm looking to assign a value based upon # of minutes in violation.

So basically I want less than 0:15:00 to equal 1

0:15:00 to 0:59:59 to equal 2

1:00:00 to 2:59:59 to equal 3

and greater than 3:00:00 to equal 4.

My data looks like this:

0:00:24
0:00:56
0:45:33
0:18:36
0:36:43
0:25:15
0:17:14
0:29:21
0:49:34
0:05:28
0:04:19
0:09:08
0:29:06
0:05:39
0:02:53
1:16:18
0:14:06
0:08:01
1:01:46

View 1 Replies View Related

FORMULA TO ADD AMOUNT BASED ON TWO Or MORE CONDITIONS

May 17, 2009

i need a formula to add amount based on two or more conditons. From the drop down list on each change i want to do the sum to be displayed in C18; see the attached file for reference. i can do the same thing using pivot tables but i want to the same to be done using the array formulas. Also tell me any other array formulas like this which are useful.

View 5 Replies View Related

How To Segregate Amount Based On Validity

Apr 7, 2012

I have amount, Activation date & Validity in days. I want to segregate the amount on days wise.

E.g. acgtivation date is 1 mar, validity is 45 days and amount is 900 then it will show 2 in each day from 1st mar to 14 Apr and on 15 apr it will reflect 0.

View 1 Replies View Related

Identify Customer Based On $ Amount Purchased

Mar 7, 2014

Would like to enter a formula in column B of Table 1 (on attached file) that would identify if that customer spent $90 or more (on any one purchaese) for any of their 4-5 purchases from Table 2. Expected results have been entered in Column B of Table 1.

View 3 Replies View Related

Class With Property As Collection Of Another Class

Nov 25, 2008

I've created a class called CStock. It has 5 standard properties (with Get/Let methods) as explained in that article above. Nothing fancy here.

I also want to create a CPortfolio class that has 3 properties: pName, pNumberofPositions, and pHoldings. the first 2 are stardard, but the last one is different. I want it to somehow keep a collection of stocks.

View 10 Replies View Related

Class Module Is Collection Of Other Class

May 24, 2006

I've created two modules, card and pack. Card has three variables (value, name, suit) and pack is made up of an array of 52 cards. Referencing it from a test module (NOT a class module) I expected to be able to use debug.print pack.card(32).suit to return the suit of the 32nd card. Instead I get an error message "Object or With variable not set". What am I doing wrong

Private p_strSuit As String
Private p_strName As String
Private p_iValue As Integer
Public Property Let Suit(strSuit As String)
p_strSuit = strSuit
End Property

Public Property Get Suit() As String
Suit = p_strSuit
End Property

Public Property Let Name(strName As String)
p_strName = strName
End Property......................................

View 7 Replies View Related

Calculating Amount Owed Based On Current Date

Sep 1, 2013

I'm having trouble with a complex Excel formula. I'm calculating child support owed based on the current date coupled with future child support owed. My columns are as follows:

Debt / Future Amount Owed / Monthly Payment / Total Amount Paid
10,148.72 / 83312 / 508 / 1000

On the first of each new month, the Future Amount Owed should decrease by 508. Altering the Total Amount Paid should decrease the Debt column. Progressing another month without altering the Total Amount Paid column should add 508 to the Debt column while subtracting 508 from the Future Amount Owed column.

View 1 Replies View Related

Count The Amount Of Entries Based On The Date In A Column

Jan 17, 2009

I have a spreadsheet containing 10,000 + entries.

Each Entry is Dated within Column D2:D10786 in this format - 1-Nov-08 (example).

Lets say i have a cell on another sheet Cell A1 and in this Cell i want it to Count how many Cells contain the dates from Nov-08 in my Date column..

View 9 Replies View Related

Fill In The 3 Criteria Fields, Calculate The Result, Copy The Result, And Place It Into The Correct Place On The Table

Oct 19, 2006

I have a macro that imputs data from an external database and puts it into a temporary worksheet. This data has 3 columns (ID, Date, Amount). I am then making another sheet which has X number of tables (one for each ID), with the years being the column headings, and months being the row headings. ie.

| ID X
| +------+------+------+--->
| | 1999 | 2000 | 2001 |
+------+------+------+------+--->
| Jan | $100 | $250 | $300 |
+------+------+------+------+--->
| Feb | $200 | $300 | $200 |
+------+------+------+------+--->
| Mar | $300 | $250 | $100 |
+------+------+------+------+--->
| Sum | $600 | $800 | $600 |
| +------+------+------+--->

| ID Y
| +------+------+------+--->
| | 1999 | 2000 | 2001 |
+------+------+------+------+--->
| Jan | $100 | $250 | $300 |
+------+------+------+------+--->
| Feb | $200 | $300 | $200 |
+------+------+------+------+--->
| Mar | $300 | $250 | $100 |
+------+------+------+------+--->
| Sum | $600 | $800 | $600 |
| +------+------+------+--->

Currently I have a few hidden fields for the DSUM Criteria. I start making the tables. And then filling in table based off of the month and year. Doing so I need 3 criteria:
>= First Day of the Month
<= Last Day of the Month
= ID #

The problem is it takes Excel too long to fill in the 3 criteria fields, calculate the result, copy the result, and place it into the correct place on the table. Is there another way to get this data into the correct tables faster? Instead of using DSUM?

View 8 Replies View Related

Macro For Base Amount And Net Amount Calculation

Nov 20, 2012

For the below macro.

ABCDG
CodeTotalBaseNetA1 = 20%
A110083.3316.67A2 = 10%
A2350318.1831.82A3 = 7%
A3220205.6114.39A0 = 20%
A015015030

A1 is the code, take the total(B) and calculate the base(C) on the percentage given in the G, net = B-C. for A2 and A3 it is the same process.

For A0 the total (B) is equal to Base(C) and calculate the net on the given percentage in G.

View 1 Replies View Related

Split Equal Amount Across Months Based On Start And End Date?

Feb 6, 2014

I have contarct for amount $5000 with a start date of 1/1/2014 - 3/31/2014 (3 months). I would like to equally split my amount based on my number of months between 1/1/2014 and 3/31/2014 ie $1666.66/per month.

View 4 Replies View Related

Macro To Concatenate Variable Amount Of Columns Based On Cell Value

Jul 23, 2014

I have a table that looks like:

7300
3

7301
2

7302
5

And I am trying to make a macro that will go concatenate the first 3 columns of all rows in worksheet 7300, the first two columns of all rows in worksheets 7301, etc, and insert them into column A of each corresponding worksheet.

View 7 Replies View Related

Formula To Show A Date Range Based On The Amount Shown In Another Cell

Sep 11, 2009

Attached is a excel file that has a working formula for tracking cashier variances. I edited out names etc.

I added a new cell called Track Back on the employee search sheet.

What I want to do is only show variances for the amount of days back selected in the Track Back cell.

For example if I select the last 30 days, only the last 30 days would show up below in the sheet.

I am not sure if this is even possible based on the forumla that is already on the sheet. I couldn't figure out a way of doing it. But there are a lot of people on here much better with excel than me

View 14 Replies View Related

IF Formula - Calculate Subscription Amount Based On Capacity Of Wind Mill

Apr 5, 2014

I need to calculate the subscription amount based on the capacity of the wind mill.

The slab rates are as follows:
1. Up to 0.6 MW - Rs.3,000
2. more than 0.6 up to 3MW-Rs. 7,000
3. 3 MW up to 98MW -Rs. 7,000 for the first three MW and Rs.1,500 per MW in excess of 3 MW
4. Above 98 MW -Rs. 1,50,000

I had tried IF statement but was not successful.

View 1 Replies View Related

Pull Data Based On Two Criteria?

Nov 14, 2012

i have a sheet that i have been creating to pull information based on two things. The criteria is an emplyee # and the second is a date.

The data needs to be organized onto Sheet4. The Employee # will already be on Sheet4, so i have been trying to use that with Vlookup / hlookup with no success as i can't seem to get it to find the correct Date and place the data correctly.

Sheet4 layout:
Completed (with respective data from Sheet2)

A
B
C
D
E

1

[code]....

the data is located in Sheet2 (Emplyoee # is always in Column A, and the Date is always in Column B).

the data needs to be pulled into Sheet4. Essentially making the horizontal data of Sheet2, Vertical on Sheet4 under the respective date column.

Sheet2 Layout:

A
B
C
D
E
F
G
H
I
J

[code].....

View 3 Replies View Related

Pull In Median Based On Two Different Criteria

May 27, 2014

I'm trying to pull in the Median based on two different criteria, I've attempted to do so with the following formula:

{=MEDIAN(IF((($J$5:$J$2951=$AO3000)/($AP$5:$AP$2951=$AO$2998))*($AL$5:$AL$2951""),$AL$5:$AL$2951,""))}

This is only returning an error value, is there a discrepancy in this formula?

View 5 Replies View Related

Pull Value From Report Based On Two Criteria

May 31, 2014

I am trying to pull a value from a report based on two criteria. I want to get the most recent date that has a value in Col K

1
Col F
Col G
Col H
Col I
Col J
Col K

2
106
ET
Product A
14-May-2014

[Code] ........

I use

{=IF($K$2:$K$60000>0,(MAX(IF($F2:$F$60000=C2,$I$2:$I$60000))))}

On another sheet (I left the sheet names out of the formula to make it easier to read) with C2 as the matching Col F value and it will return the most recent date, May 19th, not the most recent date with a value in Col K, May 18th. The report itself is thousand of lines long and has a couple hundred unique values for Col F.

View 3 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved