Hariom Singh
Reputation: 3632
Excel marking row text to column
I have a excel sheet
I want to mark the defects individually .For which I am currently creating column and marking "X" for the text present in column B
Expected sheet
Currently I am doing it manually any formula suggestion. Tried find and replace
Upvotes: 0
Views: 25
Answers (1)
user4039065
Reputation:
In C2 use,
=if(isnumber(search(c$1, $b2)), "X", "")
Fill right and down.
Upvotes: 1
Related Questions
- how can i convert data from row to column in excel?
- Create a text cell value based on row entries and corresponding columns
- Excel Text to column
- Referencing values in rows, base on column
- Google sheet formula that finds row name and returns column headers based on marked cells
- Excel mapping from column to column
- Excel Text to Columns Formula
- Replace text marker with column text
- Copy values from specific cells in rows to a column in MS Excel
- excel table row column lookup