header column

  1. T

    Selecting Last Column Header of a Table to paste into

    Hi! i´ve been struggling with this one for a bit now. I want to paste something into the Last Column Header of a Table. I´ve tried with following code: ActiveSheet.ListObjects("TableName").HeaderRowRange(LastColumn).Select Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone...
  2. G

    Lookup column header based on row and table data

    Hello - looking for an Excel whizz. Trying to complete Cell J3 with a column header based on the player and their 'score' from the week. I have tried a combination of LOOKUP with INDEX MATCH but not quite getting it. Any help would be much appreciated. Many thanks!
  3. G

    Return Col/Row Header for multiple values without FILTER

    Hi folks, I have a few co-users of a worksheet that uses FILTER and SEQUENCE, but as they are on older versions of Excel they lose these results. The worksheet has something similar to below where, For a given array (B2:E13) of values Return a dynamic list of Column and Row "Header" Values...

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