i have a excel file i need to markup by a 10% value. It is the L column starting at row 2 till a varying number of rows. i need to mark up all of the rows in the spreadsheet. i do not know how to make it repeat.
This is the formula =L2*1.1(i think its the right one) but i do not understand how to make it repeat. any help would be greatly appreciated.
I need the value to be replaced with the marked up value.
I have a spreadsheet that users update which I then want them to perform a number of checks on. At the bottom will be a button for them to click stating "Click here to confirm checks completed". When they click it I want it to put a flag somewhere that I can then use to prevent them from saving if they haven't clicked the button. I know how to do the saving but, but how do I get the button to put a flag somewhere?
I have many wordlists, which have multiple entries in one column. I would like to mark up entires which appear more then once with numbers 1,2,3....The number should be put at the end of the word or ath the beginning.
Love Love Long Lonely Lonely Living Living
After running the macro:
Love 1 Love 2 Long Lonely 1 Lonely 2 Living 1 Living 2
I am looking for a way to ease a 24,000 line duplicate list into showing just the files from a specific folder/subfolder and its dupes. I have marked the files that reside in that folder by adding a column and entering a "1" in it. What I am looking for is a way to add that "1" to the others of that unique numerical ID duplicates, so I can sort and trim the list to just those files. End result is to show files in one folder and the locations of duplicates of those files elsewhere for eventual cleanup.
Very loosely, if C2=C1 and B1=1, then make B2=1 (and so on) (A is blank and only there in case a formula needs input there)
A B C 110121 10121 118134 18134 18134 124232 24232
I have a goal set for the year. With conditional formatting, each month will be set to either red or yellow based on where it stands in relation to the goal. I would also like to show an increase or decrease in productivity for each month. I tried to use conditional formatting with the formula:
=IF(C2=D2, "", IF(C2<D2,"↗","↘")).
The formula works on its own without the conditional formatting so I am not sure what I am doing wrong. I've attached a sample with all the conditional formatting and formulas in place.
How do you drag down a column to auto complete the values but do it so it only changes one variable.For example, I am dragging down =IF(ROW()<=$B$5,MOD(E2*B1,B2),"") down my column.
However, I only want the "E2" value to change, and I want B1 and B2 to stay that way. Whenever I drag down, it keeps changing all three values. Is there a way to make it just so that the E2 value is the only one that changes?
I'm using a pre-made spreadsheet from my stock broker (Interactive Brokers) that retrieves and displays real-time quotes, and allows one to retrieve historical stock data, among other things. I've created a little macro within it to try and automate some common tasks I do everyday - basically I want to retrieve a year of daily stock quotes for "stock 1" from IB's servers, then have the macro wait for the retrieval to be done and written to the spreadsheet (takes anywhere between 10 and 30 secs). After that's all done, then I want to do the same for "stock 2". Then when that's done, the macro proceeds to go ahead and do some calcs on stock1 and stock2. The problem is after my stock1 data request, the macro just keep on trucking through to the next commands while stock1's data retrival is still going on.
so things are getting all balled up. How can I get my macro to wait until stock1's data retrieval is all done?
I've created a search box for a price list, but some of the values come up with #REF. After many attempts I noticed that each of the formulas I created on the price list page came up with a different result for the values highlighted in each column. The formula is the same for each column, the column numbers being the
only difference - for instance: Column A = code - the formula is =OFFSET(Pricelist!$A$3,0,0,COUNTA(Pricelist!$A:$A)-1). Column D = colour - the formula is the same, but reads $D$3 and $D:$D.
When I go to Name Manager and check this formula, it only selects the first 105 entries in the column. There are about 380 entries and more may be added at various stages.
I have formulas for five other columns and they do exactly the same thing, but each column stops at a different entry. I'm working in Excel 2007, but it's a 2003 document.
i have a project and i am making a spreadsheet for a make believe green grocers. i have a retail price and a whole sale price
to work out the retail price i need to sue this forumula
retail price = wholesaleprice + x% of wholesale price
im stuck, what i have done is declared the percent value on the page, which can be changed at any time, how do i then substitue this value in to the formula (and most importantly, what is the formula!)
I have to manually enter the code nos. of the hard copy to find the code in the soft copy. After finding the number, I wish to mark it as so that double work should not be done or to find which code's hard copy is not with me.
I am using Find and Replace to find the number and after it is found I have to click the replace tab to enter colour in it.
Is there any auto function to mark as soon as I find the required number instead of clicking the replace tab to save my time.
I am making a rough gantt chart in excel for a project schedule. Japanese at work love excel fro some reason that is why I am trying to do this. I have column headings for days ( 3/3, 3/4, 3/5, etc) and I want to find a way to mark the intersection when a date is input in another row. I tried to do some conditional formatting using symbols, but couldn't get anything to work.
see picture. I want to mark at correct date according to column headings when date is placed in column E or F. This example shows column E with 3/10 so I want to make a value appear at intersection AS and the row 3/10 is on. Would like to get a symbol to appear there if possible.
Is there a way to set a cell so if you click it, an "X" will be in the cell and if you click it again it will clear? Specifically I am looking to do this in the "1st Trip" column on the attached. I was going to use a check box but the appear to small and it does seems as though in Excel 2003 the size can be adjusted?
I have a list of energy consumption records by address. The utility that supplied the data had to manually pull each record one by one from their 'database'. If two individuals shared one account, the record is repeated.
So, I have a 500,000 row table with some records with identical addresses and identical consumption amounts. How would I go about separating the duplicates (to then delete them)?
It's sorted by address then consumption. The logic is...
if the address value in column A repeats and the consumption field in column B also repeats, then...(place a marker in column C so I can sort and delete)