boat

Hello, this seems like it should be easy but I can't find ananswer. I have tried the native pivot function,transpose, etc. I have two columns likethis: (sorry for the bad formatting) Column 1 / Column 2 A / Apple B / Banana C / Carrot A / Airplane B / Boat C / Car A / Anything So I need...

I have a large no. of entries in excel like below: <colgroup><col span="2"><col><col span="5"></colgroup><tbody> <colgroup><col span="2"><col><col span="5"></colgroup><tbody> BOAT NO LOT NO Density STATUS F2/146 5820 10.48 10.49 10.48 10.5 10.49 ACC 10.49 10.49 10.49...

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

Hi Guys, let´s imagine this. In first sheet I have in these three columns A, B, C these values: Column A: car boat Column B: red green Column C: automatic manual How the statement will look like if I need to get respective value into second sheet to the cell D2 and E2? If I write to the C2...

Hi, Please could I get some help for this formula? I have this formula that matches a text cell, to a text range, and then provides the value of a new cell. Like below. =INDEX($B$2:$B$6,MATCH(1,COUNTIF(C4,"*"&$A$2:$A$6&"*"),0)) A B C...

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