car

Hi please can you help I have a command button1 with s list for example: shop, car, home. If home is selected then what I type into the text box I want this copied into sheet2 A2:A5. If car is selected I want the text in the textbox copied into sheet2 B2:B5 hope this makes sense please can you...

<tbody> Car Bus Train Result 1 1 Car, Bus 2 2 Bus, Train 1 No Car, Train 7 3 Car, Bus 10 Yes Car, Train </tbody> Request your help to have a formula in excel to get a result as shown above. Cells could have numbers or blanks or text. if there is any number/text in any cell(s)the...

Hello, Dropdown cars: car1, car2, car3, car4, car5.... (selected car1) A.) <tbody> Car 1 Test2 4.000 Car 1 Test3 8.000 Car 2... Car 3... Etc Etc </tbody> B.) <tbody> A B C D E Test1 100.000 97000 167.000 Formula: B1+C1-D1 => 30.000 Test2 200.000 99.000...

Hello everyone I have a problem: I have to calculate how much each car contributes as a percentage to give me a total spending balance in $, in a given rental period calculated as a percentage. For example: Car 1: spending balance 1000 $, on 75% of the time of which it was rented; Car 2...

Hi, I have loaded a table (named "Data") into Powerpivot and would like a measure to rank by Product in each city using a ref number. I also want this rank to stay even if I filter later. <tbody> City Product Ref RANK I want Sydney Bike 100 1 Sydney Bike 102 2 Sydney Bike 105 3...

<tbody> A B C D E F G H I J K L M N O Company Location Payroll Number Title Firstname Lastname Gender Job Title Car or Cash Cash Amount Hours per week Salary Age Start Date Years Service ABC Ltd Site 1 010 Mr Paul Smith M IT Director Car 40 £52,000...

I have out grown my current excel method and I have started to think a little more long term in the next phase. I now manage a number of customer's car collections, each with at least 6 or more cars. I currently keep a separate spreadsheet for each customer. When I make an improvement to a...

My first post. I have two tabs, Assets and Fuel. On the Asset tab I want to total the miles for my three vehicles, Jeep 1, Jeep 2 and Car 1. There are multiple columns on both tabs in addition to the ones I listed; I included only the bare necessities in this example. I have tried vlookup...

Can somebody help with macro for automated paragraph numbering in my document? In column "A" I need to have paragraph numbers. I have three different types of numbering. They are "1", "1.1" and "1.11.1". In column "B" I have text and in column "C" I will insert corresponding text for macro to...

Hello, I am attempting to replace text using a conditional format in a cell that is using a formula to generate a text string. Here is my formula: =IF(A1>"",B1&" "&LEFT(C1,2),"") Basically it combines text from B1 with the number value from the first part of C1 to create results like "Car 01"...

So I ahve made some progress with the ballot for this coming Saturdays car show. Problem is the formula I use lists the word Tie when there is a tie. I just want it to list the top finisher (30 to be exact) even if ther are ties. Here is the formula...

Hi, It's been a while and I haven't used excel a lot of late so I'm more than a little rusty (although I still code) and now I'm trying to help automate a process for my father. Each year he holds a car hill climb event, with 4 timed runs per competitor. What I would like to do is analyse all...

hi all - Thanks ahead of time if you can help me ! I am trying to create the formula to count cells if there are values but it has to meet certain criteria. I need to count how many laps a car makes a lap around the track. The only data points I have are the laps and the speed in which each...

Hi guys, I need help on this. I would like to tie and record the car's plate number and turn-around-time for each stage but there's a catch. Read on please. For example: 3 person brings their car in for cleaning and drying. Cleaning stage: <tbody> Name Number Plate Time of entry Car 1...

I help with local Boy scout troop that does a car show every year. I am looking for a spreadsheet that can tabulate the winners as we input the ballots. we expect upwards of 200 entries. The categories are. 1) Top 30. (30 trophies will be awarded) Note this category often has ties. 2) Best...

Hello I want to use a collection that contains different car objects. I'm familiar to do this in Java but I don't find the solution in VBA. I want to create a class car where I can create my car object with contains the following parameters make model year therefore I have to make a class...

Greetings, I am trying put together an userform that will open a PDF file from a folder location dependent on 2 comboboxes. The first combobox gives the user a choice of 3 types, and then the second combobox will provide the user the choice of files to open. I want the user to be able to choose...

Hi, I have a large list in excel that contains diesel and petrol cars. I have to verify if there is an alternative petrol car for each available diesel car. Therefore I first filtered the basic list with all vehicles and made 2 tabs (1 with diesel and another with petrol). afterwards I take the...

Actually I am working on a model of charging load of electric vehicle. I am attaching a link to an excel workbook for your better understanding. Column B contains random time values, these time values can vary in number and depend on total number of cars. So e.g. total number of cars are 40...

Hello In folder "C:\Pictures" from my pc I Have 3 pictures (first pictures it's called "car" // 2nd pictures "dog" // 3rd pictures "horse") all in format .jpg In an active workbook in sheet1 I have in Cell A1 inserted word car...