table headers

I have a list of values in Table column B with each value corresponding to one of the headers in the table (I attached a sample of the file below). What I'm looking for is a formula or macro that will take the value in column B, determine the corresponding value in the column with the header of...

Hi Members, I have a table named "Books". My table is very simple with 3 columns. Book.ID, Book.Name, Book.Author All i want to do is to avoid duplicate values in Book.ID column of a table using data validation. I simply used the formula "=COUNTIF(Books[Book.ID],Books[@[Book.ID]])=1". But it...

I am a student in Excel with limited knowledge. I was trying to do one project and while creating a table I choose "my table has Headers". My question is; how can I remove Filters arrows from the header?

Using Excel 2016 I have a dataset which has dates in row 1. when the range is converted into a Table, row 1 becomes my table headers and excel treats all column headers as Text regardless of the previous data type. I have the following formula which when the dataset is stored as a range, and...

I have an Excel table with rows of monthly data, and one of my fields is the Purchasing Managers Index (PMI). I want to show in a clear and concise manner that this column's data comes from https://research.stlouisfed.org/fred2/series/NAPM. Ideally I would have the column labeled "PMI [source]"...

Hello you Wonderful People, Can somebody please tell me (the VBA) how I could remove/hide some of the filter/sort arrows in the header of an excel table while keeping others - so users would still be able to sort the whole data range within the table using only the visible arrows? My table...

Hi guys, Im getting crazy trying the whole weekend to solve this issue. Hope somebody may help! 1) I have a TABLE in which I have 3 main headers: [ID]: Numeric field from 1 to n [CONCEPT]: Text field with the description of each ID [CODE]: Text field with initials that represent each CONCEPT...