apply

Bonjour, I have a spreadsheet at the moment for pricing up jobs for different contracts. Each contract has its own mark up. I was wondering if there was a formula I could put into 1 cell (and then used for the rest of the column) so it could simplify the process. For example, if A1 contains...

Using Excel2000 Hi, I want tocheck row 10 data and find match, comparing with Row 6 & 7 Examplebelow shows 10 matches found in the row 10 what formula could be to apply tofind match in the cell R10? Book1ABCDEFGHIJKLMNOPQRS1234562111XX1XX1112X7X2122X112221118910211X211X2X222X101112Sheet1...

Would like to apply a table style to a range of worksheets, I get a "Compile error: no sub or function not defined." error when I run this code. The tables have identical number of columns with varying rows. The all start at A1. Sub ChangeStyle() Dim x As Integer For x = 6 To...

Hi everyone, I use this index function to create a list of unique items taken from list of data. The problem here is that every time I want to do this I have to manually stack up all my data and then apply this formula. I have a situation now that I have to look at two columns in two different...

Hi I have a table like the one below. I want to apply filter so I can find empty cells and then delete them. When I apply filter on Name column, the filter give me only 2 names, Mary1 and Jack1. I do not see David1 in the list. I think because of the empty Row (row #3 , I put dot so you can see...

Hello, Can you help me with the following. In excel I need to calculate how long somebody stays and a apply a different fee. between 1 and 7 nights 1,5 euro between 8 and 14 nights 2,1euro longer then 15 nights longer no extra charge. do you have an idea? please no vsb.. thanks alot

Hi, Please solve this query i want to only apply vlookup of when starting number of 80 and remaining number show as NA. Example 8097914598 1233 9800001223 NA 8096542545 6398 9812121123 NA 8063545445 1213

I am trying to write a formula that will apply different rates if a certain cell is a Y or a N -----the 2 rates to apply are: *Focus Funds = 55% of AMF OR **Architecture Funds = ("A std") + ( "A mgmt fee" x 20%)

I wrote a macro to do a certain task whenever I receive an email. So how should I apply that in outlook to fulfill the purpose of the macro ? Thank You.

I download data from our Jets and one of the fields I see is the fuel pressure, the fuel pressure sensor has a signal voltage between 1-5 v. With the flight data depending on how long the flight was it could be any where between a few thousand data points to several 100k data points. The formula...

Hi, I'm completely new to using macros/VBA. I've been already looking through several posts/forums/tutorials but so far I haven't succeeded. I've found similar posts, but I haven't managed to apply it to my case. In Excel I've got a very long column (approx. 16000 cells) containing web...

I seem to recall an excel formula that would allow me to take a direct labor cost, apply a fringe rate, apply an overhead rate, apply a general & administrative rate, and finally apply a profit rate, in one fell swoop. I thought it was the [ =schedule ] function, but that doesn't seem to exist...

Hey, guys I'm trying to understand the difference between these structures: Do until...loop; Do...loop until; do while...loop and do...loop while Is it just the fact that "do...loop until" and "do...loop while" perform the action on the first cell/row/column and only afterward apply the...

Hi There, I have question regarding weighted percentages. Apologies in advance if this isn't in the correct thread. We currently mark our employees from 0 - 100 in what we call there quality score we then apply a weighting to get our new score: Currently the weighting for quality 25 so we...

Hi, Struggling to get my head around how to create this formula. I need a formula that will only apply a 10% discount if the item was purchased before a specific date. Any ideas? Thanks,

Hi, Column A1:A10 which contains text and numbers with duplicate entry. How to apply conditional formatting for numbers not text. If cells contain duplicate numbers then CF indicate red colors. I am apply the following formula in A1=ISNUMBER(COUNTIF($A1:$A10,$A1))>1 but its not working...

All, I downloaded a prepackaged template off the office 365 site and am having some trouble modifying the macro to apply the color shade formatting and text formatting associated with the userforms "Toggle Task Complete" & "Select Task Priority" Ideally i would like to be able to apply the...

HI, forgive what may be a stupid question, but I have a supplier that sends me a massive sheet with one particular column that contains the following type entry. 2 / 9 or 4 / 11 etc with value on either side of the slash varying. I need to apply a formula the can differentiate and interpret the...

I have code which needs to be executed when a user copies a worksheet into the workbook where the code exists. I can include a shape and apply the code/macro to, however how would the reference to the sheet be. The sheets copied into the workbook all have different names.

Hi everyone I want to add a text 's' to column G if the value of cell in column J is 'New'. And I want to apply the vba across the entire workbook. I have done the code below but I have no idea how to apply it to the whole workbook. Also I may have done the code wrong as there is nothing...