I have tried different formula involving with decimal places.
If A1 has a whole number like 5141234 then the result would come out as a whole number =(A1-5148000)*1.000440935+48000
If A1 has three decimal places like 5142356.654 then the result would out as three decimal places
Is It Possible to use VBA Coding to Display An Image (Object),
And Un-Display or Remove that Same Image (Object) using a VBA Code?
Example:
I have a Mailbox Picture that I would Like to Show, but only when a cell's
value = 5. If the Cell's Value is not 5, then don't display the mailbox.
I was looking to have a Word for example 'Apple' but want it as a number e.g '10'. I want to use it so that I can add up the prices of items by just clicking on the name of the item. So If I want to add up 3 items e.g. an apple , a banana and a pear which all cost £10 each I want to be able to click all three items and get the total of £30 displayed in a certain box.
View 1 Replies View RelatedI'm working with a worksheet with one sheet per day of the month (we use a master, copy/paste, change the copy to the current month, and go from there). I've already got it to figure the dates based off (really difficult).
View 3 Replies View RelatedI have an XML file which I can open in Excel as an XML table. When I try to insert a chart from any of the data, a chart appears but the data appears as the legend but not as any lines on the chart. The column headings, which would normally appear as the legend, do not appear. The chart itself is blank. Does anyone have any ideas of a way to solve this?
View 10 Replies View RelatedRefer to the attached worksheet. On entering a value into cell C7, I'd like the value of the adjacent column D7 to be displayed in F6. Then when a value is entered in manually into C8, it will then update and put the value of D8 into F6. The idea is an individual will enter a value each week, updating that value. I intend to hide column D.
View 2 Replies View RelatedI cant see my A B C D bar in a spreadsheet page. I can see it in the same book different sheet though.
Excel options/advanced/display options for worksheet/ show row and column is ticked
And also tried simply Unhide on the vertical column 1 2 3 4
I have an excel sheet which contains details of quantities supplied of a particular party by an agent! It ranges from a period of April to March In Some places the agent has supplied a party's material only from april to december and jan,feb , march is supplied by a different agent for the same party.
I want to create a report which is as follows: When i choose an agents name, It should show me all the parties to which he has supplied the material and all the months from april to march. If he has not supplied in a particular month then show zero. Same should be for all the agents.
I need to create this report and i was trying with pivot tables but that didnt work!
I guess it can be done using vba code!
I have attached a sample file : Data Filtering VBA.xlsx
I'm looking for a better/faster way to display the entirety of an array (dimensions like 10 by 10, mixes of strings and integers), besides assigning all of the values to cells in a worksheet. A pop-up window or form would be stellar, but I don't know how to work with forms so well.
View 14 Replies View RelatedIs there anyway I would be able to display the current age of majority (19 here at home) in a cell or userform? This would have to be current each day the form or sheet was opened.
View 5 Replies View Related1. What is the maximum characters an Excel cell can take?
I try to import a very large text string into an Excel cell. I notice that
it's truncated to a certain maximum length.
When I set the cell type to be TEXT it displays #########################
But when I set cell type to GENERAL then it displays ok.
I just did a Len() on my text cell and it appears the maximum characters
allowed is 330. Is it possible to extend this?
I have two columns in my spreadsheet, and both are dates. Using a calculation (one date minus the other) I get the duration (in days) between the two.
I also apply color coding to say if the duration is > X, then color code as red, etc.
All the color coding is working fine for values that are either > or < 0, but anything where the two dates are the same (date 1 - date 2 = 0), the value shows as blank.
When I click on the cell, the value "0" is actually IN the cell, but it's now showing, as if the font was colored white or something, but it hasn't.
I don't have anything in the code telling the worksheet not to display "0" values, so I don't know where to go...
I have a bunch of cells that are only displaying ########## (they contain strings of text, and the actual text can be seen in the formula bar).
I know for a fact that the cells do not exceed the character limit for a cell and other cells in the same column are being displayed just fine. I've also tried adjusting the row height and column width but it doesn't seem to be working.
I want to have a function that finds the largest number in a selection range. However, i want it to display what's in the cell beside it! Example:
Say the largest value is in B6 well I was wondering how you would go about displaying the value in C6.
I have a spreadsheet and am in the middle of creating a userform to display the results of data over a given period (period selected by user).
In that userform I would like to display a graph (the graph will be created behind the scene once the date range has been selected). Is there any way that the graph can be displayed on the userform? If so, how?
check the table in the attachment.
I only want the top row / filters (A1 - H1) to be displayed on Table 1 but keep the functionality of it.
Is it somehow possible to hide all the information below A1-H1 or put it on another table and let Table 1 refer to it?
The table is mostly in German but it shouldn't matter.
So i'm receiving a web query on a sheet that is taken from a table off the web. When this data gets extracted into the sheet, it populates as "$xxxM" in order to show that it is a certain million dollars. The problem is, I need to total all these numbers to display at the bottom of my report. So essentially, I am trying to configure web query to display as "number" as opposed to "$numberM" so it is easier to total.
View 1 Replies View RelatedI'm putting the finishing touches to a grade sheet for the new academic year. I have one column that calculates a grade using the OFFSET function from a given number of points. However, I only want this cell to show a grade when the nine individual unit columns have been populated. If fewer than 9 columns have been populated, the cell in question needs to be blank. I've tried using COUNTA to count the number of populated cells and then linking that cell to an =IF(Q5=9... formula, but haven't been able to crack it yet. I'm probably missing something obvious...
View 8 Replies View RelatedI'm trying to display a value both numerical and also in english (e.g display both 200 and two hundred, 259 and two hundred and fifty-nine and so on.)
View 3 Replies View RelatedI created a pivot chart and am utulising the report filter. Is there a way to display multiple charts on the same worksheet (or even another worksheet) for the purpose of comparison?
View 4 Replies View RelatedThe first being that when the first if condition is not met, it is displaying false. The formula should be set up with multiple if statements and then display 0 if all conditions are false. What am I missing? Why won't it work for all the conditions or display a 0?
Second problem is that when I try to add the last if formula to accommodate the drop down option of 60 months (5) excel is giving me an error in the formula. It doesn't matter if I type in the if statement or cut and paste. Why won't it work for this option. A sample spreadsheet is attached. The formula is cell F6 highlighted in yellow.
I am using the following math formula in cell C12:
=IF(B12="","",IF(B12<2,-1,INT(B12/5)))
What I want to do is if cell B3 equals a text value of the word "All" then cell B12 would display nothing. If B3 equals any other value then the math formula above be used.
I have been trying to get this formula to work, and it appears it only works when it wants to and I cannot figure out why. What I'm trying to do: I have a spreadsheet with several columns of data, but I want the formula to read only two entire columns for a specific criteria for each column, then display the most recent date based off the criteria. I do not need to total up the criteria, just display the last date. This is what I have so far: =IF((AND(Sheet2!A:A=B2,Sheet2!B:B="Game: Counter Strike - Source")),MAX(Sheet2!C:C)).
I have this in a table, header as "last date" which is (C2), the B2 in my table would be where criteria would be typed in. So basically, my table should pull the last date from based off the criteria from raw data in sheet2, that is entered in to B2 on sheet1 and is "Game: Counter Strike - Source".
I have a data in excel sheet in Table format, in the first column i have added a unique Prod_ID. In form there is a search text box by entering the Prod ID & click of search button i need to display the respective row along with the Headers.
View 1 Replies View RelatedI have created a macro 'uid' and rename the module to 'profession'. In the list of macro 'alt + f8' the name displays 'profession.uid' which confuse me. I want to display the name 'uid' and not 'profession.uid'. I select the macro by pressing the first letter of it as in this case 'u' and reach that macro and click it to run.
View 4 Replies View RelatedI have some code which i would like to search a range of cells to see if a value is already used in this range. if it finds the value it will return a message box saying 'value found' and exit the sub, but when it doesn't find the value it will run extra code using "else" function. The code does what i want it to do, but it still returns the msgbox even if the the code in the "else" section runs.
View 2 Replies View RelatedI think I'm getting a grasp of the userform thingie, however, thins one will not work:
View 7 Replies View RelatedI have built a UserForm (Excel 2003) that looks up a Row dependant on Criteria and displays the values on the User Form.
View 9 Replies View RelatedI want to use this code to display only the filename + extension in the TextBox1. It currently shows the full path
View 8 Replies View RelatedI have the attached workbook. I have one sheet (materials) using Vlookup onto a second sheet (price list). If I put in a qty against 2 or more items with the same part code on the price list only the first item is displayed. It does get shown multiple times.
I need to try and get all items displayed, even if the part code is the same.