lane

Hello, How would I be able to clear the contents of adjacent cells based on the value in another? For instance if VDS column value is bigger than zero like 2, then cells B1 and B2 shall be cleared from their existing content that is currently "Good". If value is 4, then 1st 4 cells shall be...

Hi All, I have faced a big problem. I have huge data with name, address, email. I want to copy data between 2 email address to sheet2 & transpose. For example: Sheet 1: <tbody> Mr Karim 234, by lane abc@gmail.com Mr rashed 015987456 365 by lane mc road amik@yahoo.com Mr...

please help:rofl: i need a formula that will assign a id number if the 3 coloumns match i have 700 lines of data each week to sort INPUT <tbody> id customer area address bob 1 blue lane bob 1 blue lane bob 1 red lane peter 2 blue lane bob 1 blue lane...

I have a formula that indexes well but I need to take it to another level I have attached a link to the actual file What I would like to see happen is under the warehouse tab B3 that index formula works well but what I need to take it further is that the data its looking for right now looks...

So, I am working with a sheet that has a certain number in each column KL-LM, only if the number in JX is different from the one in the row above. So JX3 is 1850, that means KL to LM will have this number times a factor. In JX43 there is 1450. Now as you can see in the screenshot, KF3 is 6607...

I'm very new to using VBA so I'm sure this is a simple fix. I want a message box to display information when a defined item is picked from the validated drop down. I thought I had this all figured out when the message box started to haunt me. If I select the validated word all other drop down...

I'm looking for a formula to create a swimming league of 6, 7 or 8 teams (depending on how many enter) where each team has one home gala and plays away an even number of times against the other teams. With an even number of teams there were would and imbalance, say playing some teams twice and...

In column D I am needing a formula to give the rank of Column C as it relates to Column B. The Rank formula will reset when the Lane ID # switches. <tbody> Lane ID # Base Rate ($) Quote ($) Rank 1 10 15 1 10 10 1 10 20 2 20 25 2 20 30 2 20 35 </tbody>

Ok, last question for tonight ;) This one is about how to Auto sort a group of cells highest to lowest, by using a formula. is this even doable? Below is a list I need to auto sort. I'd like to sort it by Scale Speed, fastest to slowest AL AM AN AO AP AQ AR...