car

Hi, I am new with Pivot Tables and I have a scenario that I can't seem to make work. Say I have the following data in a pivot table (Car Owner is in ROWS, Car Type is in both ROWS and VALUES): Car Owner Bob's Cars: 1) Honda (100%) Car Owner Jack's Cars: 1) Honda (33.3 %) 2) Ford...

Can someone help please? I have a list of boxes containing strings of text, I need to highlight any words appearing in these strings if they appear in my list... is this possible? For example: <tbody> Sentence List My motorbike is yellow yellow My car is red red car...

Dears, Another question... I've to collect 2 information that is CAR and TYPE, and the user can insert it in different ways, like: BMW BMW/SEDAN /SEDAN So, everything before the slash is the CAR and after the slash is the TYPE. I'm trying tho use the expression Split, but when there is...

Hello everyone, In my excel, I have some charts that have zeros in their values range. I would like to "hide" those datas. I've tried two methods but none works. First of all, go on my chart option, in design/select data/ hidden and empty cells / select either gaps or zeros. My zeros values...

Good Evening, today I came across the following problem: Say we have a table where the a-column is for example the color of a car, the b-column who sold the car and the c-column is the price it sold for.We now want to multiply the values of all red cars sold by Peter and here lies the problem...

There is a CTR-CAR (Customer Transaction report / Customer accrual report) excel file that has a "CTR" Tab and a "CAR" tab. The CTR tab has a "Rebate No" column and often we have to pull a list of 10 or more rebate ID sections from the CAR report into a blank excel sheet to provide sufficient...

Hi, I need to create a new column that will show the number of staff per vehicle in order to do further calculations. Generally if they had the same amount of staff regardless if another vehicle showed up to the incident I would use a vLookup table however there are two conditions to the number...

Hi, I'm working on a project relating to times that cars leave for a hub route. The cars are carrying ordered products from one store to the other within the route. I have data with the current times the cars leave, 6 times per day, and I have data of what time were ordered by the individual...

Need a Vba code to obtain the rank for the latest date and car type. EG find the latest date from today() for each car then obtain a rank. if the car changes the rank starts from 1 again. so In theory the latest 25 dates for each car. <tbody> Car Date Rank Volvo 01/01/2018 2 volvo...

Hi everyone, I have a tricky task :) Let me clarify that step by step below. Input table with 5 columns columns are: combination, place1, place2, place3, income column combination represents a number of each combination (combination of 3 places) place1, 2, 3 are basically points where a car...

Hi, I'm pretty novice in query design, I'm trying to figure out how to get a query that returns me error in data input, by that I mean the following (for example): I Have a table with the fields "Car maker", "Car model", "Car plate number" and "Car color". Basically the Car model should hold a...

I have The following in a table in Cell A1:B6 I have the Car (Audi BMW) listed in cell C1 and D1. And need to obtain all the names under each car. eg tom and tim would be under BMW. Need this in a VBA code please <tbody> NAme Car phil Audi andy Audi jack Audi tom BMW tim BMW </tbody>

Hi Everyone - I'm looking to create a sum formula to capture multiple criteria and I am open for suggestions. <tbody> Jan Feb Mar List: List: Car 1 1 2 Car Jan House 2 2 1 Airplane Mar Airplane 2 3 3 Boat Boat 5 5 3 Formula: XXXX </tbody>...

Hi! I have a situation where my Excel spreadsheet has become so large and unwieldy that I'd like to have some of its data in one sheet and some in a second sheet. The data can all be connected by a primary key, in this example the license plate of a car. The first sheet will list information...

A B C 1 Red Car Result#1 2 Blue Boat Result #2 3 Red Boat Result #3 4 Green Car Result #4 Say column E and Column F. when I enter Red in Column E and Boat in Column F it should give me Result #3 in Column G. Please help me with a formula without using VBA...

I have about 25 customers, some customers have just 1 vehicle, while others have 2, 3 or more. I maintain all of them, both the customer and their car collection. I used to keep one workbook per customer. I would like to use 1 workbook for all customers and their vehicles. This would allow me...

Hello Everyone, I am trying to count the no of items between two dates (say from 01/Oct/2017 to 31/Dec/2017) using criteria in column a. Each item has a date in a row in the format dd/mmm/yyyy. I'd rather not have to enter the dates in separate cells and rather have them in the formula so that...

Guys, im pretty sure this is not possible but wanted to check. I have a list of vehicles in column A and a list of 4 names in D1:D4 (dave, bob, jim and steve). I was wondering if it is possible to allocate the vehicles equally to the people named in D1:D4 so each person has an equal amount of...

Hello , i have 5 columns of data. A1 = "other" B1 = "other" C1 = "other" D1 = "taxi" E1 = "other" A2 = "other" B2 = "other" C2 = "other" D2 = "other" E2 = "car" A3 = "other" B3 = "other" C3 = "other" D3 = "other" E3 = "other" I am trying to work out a formula in F1, F2, F3 whereby if row...

Hi I am wondering if anyone knows the formula on this: If cell E2 says YES, add the information in A1 into sheet 2 - A1? That is probably not the easy part. But then it gets a bit tricky. If all answers were YES, then no problem. However, if i.e. E1-E2 is YES, E3 is NO, E4-E5 is YES. Is it...