taxi

I'm not sure how to fix this. I've copied my last years worth of credit card statements (2400 rows) into Excel so that I can analyse the data. In each cell in Column D there is text (the narration provided by the Bank) which could be say PAYPAL *NETFLIX.COM 402***** AU and what I would like to...

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...

<tbody> Basic Fare ($) Normal Medium Large Flag Down Fee (Inclusive of the first KM 3.00 3.90 5.00 Every 400m thereafter or less up to 10km 0.22 0.25 0.33 Every 350 metres thereafter or less after 10 km 0.18 0.20 0.28 Every 45 secs of waiting or less 0.20 0.20 0.20 </tbody> I am...

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...