car

When using the VLOOKUP function for something where there are multiple of the same result, is it possible to add them together? For example, using VLOOKUP to find "Car 25S" and find the corresponding column value, but on my sheets occasionally "Car 25S" can appear multiple times in different...

I am mapping my car mileages. The car was first registered in late 2011 but the chart is showing from the start of 2011. Any ideas how I can fix it?

Hi, I have searched and searched for a solution to my problem but couldn t find any... So here it goes I have cells aranged in a kind of calendar style, now, in the first column i have names, then in the following columns(that represent the days of the year) i bring data that coresponds to...

Hi there. I am trying to delete any rows that have specific texts such as "car", "labor", "bat" for one of the sheet say sheet2 but my macro doesn't seem to work right. appreciate your help. Sub deleterow() For i = last To 1 Step -1 If (Cells(i, "A").Value) = "Labor" Then...

Hi, Not sure if my last post worked or not but: Sorry for my newbie question but I am trying to write a code to copy data over from one worksheet to another but what is copied over is dependant on certain there being data in firstly column B and then Column D (once the ISEMPTY function...

Hi All, I've been trying to work out a formula that will count a column if the criteria is matched and I've using SUMPRODUCT, COUNTIF functions without much success. What I'm after is if range A1:A3 matches cell D1 then COUNTA column B is basically what I need to work. I don't want column A to...

For example in an already created table with table headers, on row number 1, I have: Car | Nissan | Japan (same) on row number 2, I have: Car | Ford | United States on row number 3, I have: Car | Nissan | Japan (same) on row number 4, I have: Car | Fiat | Italy How do I create the code...

ok so im looking for help on create a formula on the following setup i currently have keywords that are hypen seperated and then there is a space and then the next keyword begins - example below and lets say i place all of these keywords on cell a2 big-car rainy-day giant-woods big-car...

working on a very large spreadsheet that has the details of lots of employees and their mode of travel to work. I need to be able to a countif on the company name based on the criteria in another column <tbody> A B C 1 Mode of transport Company Name 2 Bike Test Company 1 3 Car Test...

I am currently working on a big project, and need to fill in the pricing schedule. In table 1, I would like an easy way to fill in the question marks. I have over 150 "cars" to fill in, so I am looking for the best solution to get this automated. I am used to work with Vlookup, but I have over...

Hello everyone I am looking for some assistance from someone more experienced than I am in Excel. I have a massive database that contains the car registration no. for all employees. The database is on 2 different sheets, one covering single drivers and the other one car sharing drivers. The 2...

Hi! First time posting but I've read millions of your brilliant messages some! I'm trying to work on a scenario and not sure how best to go about scenarios in Excel. Problem: Driver has a leased car that gets 28 MPG, and has 170 days left on his lease. He is 2000 miles before he hits his...

Hi All, I was wondering if i could get some help. I need a formula to find a certain % rate based on car emissions range. So for example if a car is 115g CO2 it means if diesel its taxed at 25%. See below: <tbody> 2016/17 BIK% 2017/18 BIK% CO2 g/km petrol diesel petrol diesel 0 (EV) 7...

Hello, <o:p></o:p> I need a VBA for the following process please. Thanks. If we have 2 tables in excel. each table has diffrent number ofrows, they have 2 columns including car nembers and car names. the macrofirst look at the car number at table 1 then goes through table 2, if finds asame car...

Hello guys so I have this formula on say A2. =IFERROR(IF(INDIRECT("'CAR 002'!G25")="x","Employer's Request",IF(INDIRECT("'CAR 002'!L25")="x","Contractor Request",IF(INDIRECT("'CAR 002'!R25")="x","Consultant Request"))),"") How can i copy this formula on A3 but changing CAR 002 to CAR 003 and...

Hey guys and gals, I have a question about a formula im trying to build. I'll type an example below because im as bad at explaining as I am at writing formulas apparently...So, on Sheet1 I have the following In example data in rows: A1 B1 C1 D1 car RV boat plane boat car...

I'm trying to set a personal budget, but I'm having a hard time wrapping my head around how to determine the average monthly mileage and miles per gallon. I suppose it's mainly because the days in between fill-ups vary so much. Maybe I'm just being dense, but nevertheless, I'm struggling. Given...