place

How do I get the right function to pick up 0 as the second decimal place? I'm trying to get zero from =RIGHT(A1) where A1 is 2,366,125.60 but excel is picking up the 6 since it drops the last zero. Thanks

I just put in VBA for 'ThisWorkbook: Private Sub Workbook_Open() OpenWHSE.Show Sheet2.Protect Password:=True, UserinterfaceOnly:=False End Sub After running it, it protected the stuff I want. I want to do some more editing and go to unprotect, and says I didn't put in the correct...

Help Please! I am trying to populate column F based of the information in columns A-E. The cells I have labeled as Yes/No will initially be blank and will have a data validation to be either Yes or No. An ideas are most appreciated! <tbody> A B C D E F 1 Build Yes/No...

I am sorry if this has been asked before. I tried to search but did not have any luck. I am looking to have placeholders in an excel spreadsheet for multiple cells and on multiple sheets. I would like to see the very simple thing to help accomplish this. What I am needing is for any cell I...

I'm imagining/hoping this is a stupid question, but here goes... I have a large table of sports data including, among others, the following columns: DATE | YEAR | NAME | GOALS | ASSISTS I've created a pivot table using NAME and YEAR as the Rows and Assists as the Value. I've been able to sort...

Hi all Every week i get a new report with over 600 employees. Each of them are asigned to a coach. (Column I) I have to select them and make a new worksheet per coach. So that every coach has a clear list. How can i automate this so that i can put the report on sheet 1 and that it...

I have a worksheet that lists a baseball schedule. I'm trying to find a way where I can enter W or L (win/loss) in a column on the schedule and it will update another worksheet with the total W/L record. Ultimately I would like to have a pivot table that sorts the records from first place to...

Row 1 is header Like m , n, o, p, q Then A2:A6 has the labels A, B, C, D, E which means that the table is A1:F6 So inside cell G3, I will place either m, n, o, p, q. So when I place m into cell G3 then I want the source data for the chart be col A and B. If n then select Col A and...

Hi dears, I would like to know the easiest way to do this in excel and I will really appreciate your help. If the third decimal place is 1 or 2 or 6 or 7 round down to nearest 5. If the third decimal place is 3 or 4 or 8 or 9 round up to nearest 5...

Hello All, Can someone please help me on a sheet that i am working on for a headcount, i have several arguments like Present, Local Leave, not reachable etc and i am using if function e.g: "=IF(C2="On Way xxxxx",1,"") and "=IF(C2="On Site XXXX",1,"") whereas "XXXX" is a different place and same...

My spreadsheet has rows that have strikethroughs for the formatting. I need t do some sort of macro or formula that says something like, if the formatting in A1 is strike through, place an "X" in column Z. How can I accomplish this? Thank You!

I wish to create a dynamic range that works backwards from the last row of the data to a place higher up that is 36 whole weeks long. The table is made up of stock counts done on different dates. The dates are in ascending order however they are not done every week. Is it possible to create a...

OK ... I searched before posting ... and almost had it. I simply want to list the date a file was last modified in a spreadsheet. There are several files listed. Here is the thread I found ...

My destination cell is U9. Users have an option to place an x in P9, Q9, R9 and/or S9. The can select as many or as few as they wish. If they place an x in P9 I want the value in U9 to include the value in D10. If there is an x in Q9, include/add the value in G10. If there is an x in R9...

How do I use vba to refer to a sheet with a date of "july xxxx"? The x is in place of a number. Therefore, it could be july 2018 or july 2019 etc?

I’m trying to use a bunch of if / and statements to work on the following problem but it isn’t really getting me anywhere. The premise of what I’m working on is that certain things have taken place in the past, and depending on how long ago it happened, it gets a certain score. - If it...

I wish to programatically to add a connector in the center of the cells in range B5:B11. I do have the following code below, but how to place the connector in the center (not left)? Sub AddArrow() Dim shp As Shape Set shp = ActiveSheet.Shapes.AddConnector(msoConnectorStraight...

Hello, I have a work book that has 20 different sheets in it - all with the same data - except for one column which is the variable. In this case column f contains the name of the wine supplier for a wine. column g contains the wine name for a wine column h - the year (vintage) i - the price...

Hello All, I have a task pertaining to getting a value into a cell using XLUP. What I'm trying to do is column B contains a list of items. Using XLUP id like to find the last value in column B and place it in D2. Then in D3 that value would be the second value up from the first value found in...

Hey guys, I need some help. So right now I have a drop down list in place in cell A39. It contains 5 options (credit card, line of credit, loan, car rental, other) I'm trying to set up a formula in cell F39 so that when "credit card" or "line of credit" is chosen in cell A39, it will take 3%...