vertical horizontal table

  1. M

    Searching a Table with a horizontal and vertical value

    Dear all, Currently im familiarizing myself more and more with excel. However I've run into a rather annoying problem. I have made a table which is rougly 60 vertical cells and 70 horizontal cells. Out of a prior calculation 2 keys are found. One horizontal value , one vertical value. Now I'd...
    • MarcoM12
    • Thread
    • horizontal lookup index match 2 criteria vertical horizontal table
    • Replies: 6
    • Forum: Excel Questions
  2. selant

    Vertical to horizontal, repeating 4 records in each group

    In my file, each data group consists of 4 members. There are lots of groups in my worksheet. Here is a demo data of first 3 group. "1" , "2" , "3" indicates unique flights. <tbody> 1 DATA1 MEMBER1 1 DATA1 MEMBER2 1 DATA1 MEMBER3 1 DATA1 MEMBER4 2 DATA2 MEMBER5 2 DATA2 MEMBER6 2...

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