boat

  1. J

    Transpose and group? How do i transpose one column into multiple rows base on value in another column

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

    How to shift rows without copy paste

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

    Matching two different columns to receive the result

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

    Vlookup in if statement?

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

    Formula help for text string data

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

    Using VLOOKUP and SUMIFS at the same time

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

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top