Remove All Bracket & Data.answer
Oct 26, 2009i need to remove this all bracket & data.answer should like this.
ex-
column "A"
AS-18881(C-8567)
SP-25768(G-856)
AS-25687(C-687)
ex-
column "A"
AS-18881
SP-25768
AS-25687
ADVERTISEMENT
Bracket Tax Formula
Dec 12, 2007I am working with a income statement in excel, and I need to calculate the tax rate on Net Income. I have to calculate this with both positive and negative net income, and insert this into the cell below net income. I also have to account for different tax rates.
$0–$7,500 10.0%
7,500-30,650 15.0
30,650 –74,200 25.0
74,200–154,800 28.0
154,800–336,500 33.0
336,500 and up 35.0
Meaning Of Bracket Notation
Feb 9, 2007The following code was posted in another thread:
Private Sub UserForm_Initialize()
Dim a, v, x, ws As Worksheet
Set ws = Sheets("Scheduled Courses")
a = ws. Range("a2", ws.[a65536].End(xlUp)).Value
With CreateObject("scripting.dictionary")
For Each v In a
If Not IsEmpty(v) And Not .exists(v) Then
.Add v, Nothing
End If
Next
x = .keys
End With
With Me.ComboBox1
.Clear ' clear the listbox content
.List = x
.ListIndex = 0 ' select the first item
End With
End Sub
How are the brackets used in the 4th line? I have not seen this notation before. Is this some kind of a shorthand for a Range("A65536") reference?
Calculate Bracket Commission
Sep 5, 2007I have been thinking about this for a few days and have no idea where to start.
The commission scheme pays like this:
upto $40,000 in sales pays 30%
$40,001 to $80,000 pays 40%
$80,001 + pays 50%
Also, the sales person will only earn commission once they have invoiced 1/3 of their basic salary. Example
$60,000 must invoice $20,000 per month, therefore commission is actually 30% of the remaining $20,000.
I want to create a spreadsheet that allows me to enter the basic salary for individual sales persons and their individual sales figures to calculate their gross commission and also their gross basic salary if I can.
Determine Hours Per Time Bracket
Nov 3, 2013I am trying to create a spreadsheet to determine hrs per time interval
i.e
06:00 - 14:00
14:00 - 22:00
22:00 - 06:00
So a start time of 06:00 and finish time of 14:00 would show 8hrs in first interval and 0 in the other 2 and a start time of 10:00 and a finish time of 18:00 would show 4hrs in first interval and 6 in second and 0 in last
I've currently got start time in A1 , finish time in B1 and want hours for interval 1 in D1 , interval 2 in E1 and interval 3 in F1.
Salary Bracket Returns Employees Corresponding Contribution For Health
Jun 17, 2013I have this table which has employees names with basic pay and contribution.
I was tasked to create a excel sheet where in if the employees basic pay is input, the corresponding contribution for the employee will show depending on which salary bracket he/she is on.
I am not allowed to know what my workmates salaries are since im just an associate, so i just have to leave em blank and wait for my manager to input their salary.
See attached file for the workbook : PHEALTHWORKBOOK.xlsx‎
Excel 2010 :: Creating Bracket For Video Game Tournament
Nov 11, 2013I'm trying to create a bracket for video game tournaments and I'm having trouble with some of the functionality I want it to have.
Right now, I have cells B7 and B9 that will pull player names from another check in sheet. I have another cell, D8, that I would like to have a drop down list in containing the contents of B7 and B9. Everything I see online says to use Data Validation, but apparently that tool can't make a list using cells that aren't next to each other, so that won't work. How else can I tell excel how to populate this list? It is vital that the cells be apart from each other because the visual formatting is necessary for displaying the bracket on a projector so that the players can see their match assignments.
In addition, I would like to have another drop down menu in another cell with a list of valid bracket sizes (4, 8, 16, 32, etc.), and have the cells of the sheet either be visible or invisible depending on how many max players can enter. In other words, if columns B, D, F, and H correspond to the number of rounds it will take to finish the tournament (3, 2, 1, and 0, respectively), I would like the sheet to display only the cells necessary for the tournament, pull player names into the left most cells needed from another worksheet used for sign ups, and auto populate all of the columns to the right of the column for first round with drop down lists for the players who could have won that match in the previous round.
Excel 2010 :: SUMPRODUCT Answer To Return Blank When No Data In Specific Cells
May 12, 2013I am using Excel 2010 and I am trying to average the amount of days in a month to a daily average per person in my worksheet.
Total sales per person
A5 = 10 - This is the Grand total per person for column A
A6 =4
A7=6
Daily average per person
C5=2.6 - Average for all persons here
C6=2.0
C7=3.0
The formula I am using is:
=(SUMPRODUCT($A$6:$A$15,C6:C15))/$A5
Which gives me an answer of 2.6 in cell C5 as shown above which is what I am wanting.
Please note that my cell range for my staff goes from 6-15 for both Column A and C where the other cells are blank in both columns.
My question is, If I was to clear all the data in both Columns A6:A15 and C:6:C15, cell C5 would return to a #VALUE. How to I change the formula so that if the cells were Blank, cell C5 would also be blank until I enter data for each person again?
Lookup Comma Separated Data And Return Comma Separated Answer
Mar 19, 2014Comma separated data on sheet 2, look up info on sheet 1, return comma separated data on sheet 2.
Sample file attached : Book1.xlsx
Remove Data From Custom For Fast And Keep The Needed Data?
Apr 7, 2014We have our system set up with 2 folders one with blank forms and the other with these forms filled out and completed (records), is their a trick to removing the data from a completed form fast with out removing tables and text used to make the forms questions? If I could do this it would save time from opening in the blank forms folder then saving in the records folder.
View 4 Replies View RelatedVBA Code To Extract Data And Remove Unwanted Data In Row
Dec 15, 2013I have a workbook that has ben imported into excel and I need to extract the Cabinet sizes (red text) from ColumnC On Sheet2 leaving out the rest of the info. I have a button on the home sheet that has the code that I am running to generate this report it will do most of what I want but I am stuck at extracting the cabinet sizes.
The data is coming from the SheetComponetListing worksheet and going to Sheet2. I have manually created the end result that I am looking for on the CabinetSize worksheet. [URL]....
Same Formula, Why Can't Get The Same Answer??
Jun 4, 2009in the "Order for EMS" and "Order for FEDEX" there have 1 product exist, now the customer need to type the country in the "F35", and the Price of weight will look back to the sheet "EMS Weight" and "FEDEX Weight" but for example, if i type Japan in both sheet, the EMS that one is correct 1kg to Japan is $168 but in FEDEX that one is not correct 1kg to Japan is $169 but now show $342, the formula in "G36" should be correct, what's wrong of my formula????
View 3 Replies View RelatedIF Argument Need With Yes/no Answer
Nov 11, 2009I have a sheet that has 2 fields that i need a yes/no answer from. Basically if b = "P1" then a should be less than or equal to 4 to reply good otherwise it should reply no. but if b isnt "P1" but instead is P2 P3 or P4 then it should => 10, 30, 40 respectively.
View 8 Replies View RelatedGet An Answer Based On A Value?
Jan 1, 2010I want to tell Excel that, if a cell value is between 1 and 100, to enter one result in another cell. If the value is between 101 and 250, enter another result in that same cell. If the value is between 251 and 500 enter another result in that same cell and so on about another 12 times.
View 5 Replies View RelatedOpen PoP Up With Answer
Oct 14, 2009i just wanted to know if we can open a pop up which will give us answers. i have attached a example work sheet of what i require
View 3 Replies View RelatedAutoSum: The Answer Should Be 8
Jul 3, 2009I have a formula that is in ColF Row4, and it is copied down to ColF Row 13. But trouble is that when I autosum this column I get 6, but the answer should be 8.
The data in Rows A-E are extracted from an external data source. I've attached the spreadsheet. =IF((AND(A4=7,D4="")),1,(IF((OR(A4=7,D4>=2)),D4,0)))
Text Box For Other Answer
May 24, 2008I have to following code. I have an issue now where I have to Pop a textbox from based on the answer to one of my questions.
If cboProjOffset = "Other" Then
userSalOther.Show
Problem is I actually want the text box to populate on the same line of the range answer in column m. At present it doesnt seem to be doing this. Can anyone help?
Public gintEditMode As Boolean
Public gintTotalEntries As Integer
Public gintLineNumber As Integer
Private Sub cboProjOffset_Change()
If cboProjOffset = "Other" Then
userSalOther.Show
End If
End Sub
How To Remove Data Connection But Preserve Data
Jul 24, 2013If I run this vba it removes the external data connection to the pivot table:
ActiveWorkbook.Connections("EXAMPLE").Delete
When I attempt to drill down into the pivot table it states the data connection was removed.
Is there a way to remove the data connection but preserve the data in the pivot cache?
It's probably possible to store the data somewhere else in the document and link the pivot table up to it but that seems cumbersome.
Return Answer Dependant On /
Apr 5, 2009in cell d1 i have
hk/q46559
in cell i1 i need to return whatever is before the "/"
in this case hk
and in cell i2 i need to return the number after the q
in this case 46559
VBA To Automatically Answer Pop Up On Open.
Jan 11, 2010I have a few 2007 workbooks that are set up to track and compare individual budgets over time. The majority of the cells are referencing workbooks that have yet to be created.
On opening these workbooks the users are confronted with an informational window informing them that "This workbook contains one or more links that cannot be updated", to which they are instructed to choose "Continue". Is there code I can add to these workbooks that would automatically choose "Continue" once a user enables the security warning for Automatic updates of links? I believe this would be the same as an On Open event.
Answer Only If Greater Than A Number
Apr 12, 2013How do you put an answer in a cell after subtracting 2 numbers and if greater than a number put that answer in. This isnt right just an example
=IF(a1-a2 is greater than 10 then put that answer in the cell if not just leave it blank?
Add Dropdown That Pops Up Only When Certain Answer Is Given?
Nov 20, 2013I would like to add a drop down that pops up only when a certain answer is given in a previous cell. For instance, if the user picks "Single Door" in cell E2, then in cell E6, I would like a box to pop up that says "HL/HR?" so that in cell E7, they have a drop down & can select either HL or HR. But, if they pick anything other than "Single Door" in cell E2, I don't want a box to pop up in cell E6 to prompt them to do anything else.
View 2 Replies View RelatedVlookup Or ? (Get Answer In B Column)
Oct 4, 2009I have data in A column.
I want to Get anser in B Column.
Sheet1 ABC1S.NoCountryCode2E8481234567CroatiaE8483E8351234568SloveniaE835472123456900Ireland725JM123457000LuxembourgJM Excel tables to the web >> Excel Jeanie HTML 4
Answer Based on C Column....
Determine MsgBox Answer
Dec 15, 2006The macro I am working on will ask the user if they wish to transfer data to one of two Forms, held in two separate worksheets. The worksheet names are Record Form Games 3583 & Record Form PE 3581. The msgbox will ask "Is the data being transferred to Record Form 3583?" If Yes the sheet "Record Form Games 3583" will be set as the sheet as the one to transfer data to. If no "Record Form PE 3581" will be the destination sheet. This is what I have so far:
Sub Do_Admin()
Dim Record_Form As Worksheet
Msg = "Is the data being transferred to Record Form 3583?"
ans = MsgBox(Msg, vbYesNo)
If ans = vbYes Then Set Record_Form =
Sheets(Sheet"Record Form Games 3583")
End Sub
Automatically Answer YES To Alert
Jan 6, 2007My macro cuts and pastes a section of one sheet over the top of each remaining sheet in the workbook. It pauses before each paste and presents a message box (relating to copying over a named range) requiring the user to manually click on "Yes" in response to the question before continuing on. How can I modify my macro so that it finishes without requiring the user to click on "yes" for each sheet. In other words, how do I get the macro to automatically answer "Yes" to the message box ??
View 2 Replies View RelatedRemove Data
Jul 20, 2009I Want to Delete Data.
Filter I Column And Delted "N" ....
IF Formula Returning Wrong Answer
May 1, 2014I am trying to determine if I can write a formula that will read text in one cell, such as insurance and if true enter the amount from another cell and if false then 0. I have tried a IF statement by add the text to name manager. However, the answer is 0 rather than the amount in the selected cell. I might need to use a different formula or function.
View 10 Replies View RelatedChanging Sum Of Two Cells To Equal -4 If Answer Is Zero
Dec 8, 2013I wish to be able to add adjacent cells as follows, assuming I have a number in a1. (in B1) =a1-4.
If the answer is zero I would like to change it to -4 and then continue the process for more cells to read 16 ; 12 ; 8 ; 4 ; -4 ; -8 ; -16 etc.
Sum And Divide Three Different Sets Of Numbers To Get One Answer
Dec 16, 2013I have three different sets of numbers on a r12m that I have to add and divide by different numbers and not quite sure I have the formula right as when I do it manually on a calculator it comes out different.
The formula I have put together is
=sum(O4:z4)/10)+(sum(o5:z5)/200)+(sum(06:z6)/1000)
This is the three rows of data
221121
2333443201142
402448314034292331351663
Using the formula above the result is 0.81 but if I do it manually on a calculator it is 1.6 (by doing each line individually and adding results)
Selecting Answer From Multiple Cell
Dec 27, 2013So I am creating a board game in excel. I currently have a draw card feature to draw random cards. I also have section above where you can fill in the answer to the question and another 2 sections that flip to correct or incorrect. Those formulas work as =IF(AND(Sheet1!J6="When resubmitting the claim to another insurance should you be voiding an adjustment to the S code if one is posted?",Sheet1!I2="Yes"),"That is Correct!"," "). I have another for if Sheet1!i2="no" then it flips to that is incorrect. I want an OR formula that will be like if multiple cells have any text in them it will display them but only one cell at a time. So essentially a way for multiple questions to be able to be drawn and you can answer those questions and be told if they are correct or not.
View 14 Replies View Related