CODEWITHSUNDEEP
excelexcel-formula
mcseay
mcseay

Reputation: 43

Plot intersection of row and colum values

I feel like there is a simple solution to this that I am overlooking? I have column headers with unique values and a single column (A) with rows of data. I am looking for a way to mark the cell in the corresponding column for the value found in the column A of the row. See screenshot for example. I don't care what it is marked with (X in screenshot example). A solution that would easily executable against 30+ columns and thousands of rows would be preferable. enter image description here

Upvotes: 0

Views: 60

Answers (1)

user14618570
user14618570

Reputation: 89

Type the following in B2: =IF(B$1=$A2,"X","") Drag this to the right and down. But using vba would be better.

Upvotes: 1

Related Questions