adding a letter in cells

[lateef]

i have 1500 rows. I want to add the letter x in column B if the cell is blank in the same row data is available in column A

 

[rahulshewale1]

Hi @lateef ,

Please upload file with desire output result manually.

 

[AlanSidman]

In the attached, I have created a sample of data as described in your Post. I have employed Power Query to complete the task.

Mcode:

let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Column2", type text}}),
    #"Replaced Value" = Table.ReplaceValue(#"Changed Type",null,"x",Replacer.ReplaceValue,{"Column2"})
in
    #"Replaced Value"

Review PQ
In the attached file
Click on any cell in the new table
On the Data Tab, click on Queries & Connections
In the right window, double click to open Query
Review PQ steps
M-code basics:
- "let" is the start of a query
- "in" is the closing of a query
- each transformation step sits in between those 2 lines
- each step line is ended by a comma, except the last one
- "Source" is always the first step (Source Data)
- After "in" you have the last step referenced

 

[AliGW]

1. Select B2:B16.
2. Find & Replace > Find: leave empty; Replace with: x

 

[lateef]

Thanks for the replies. I have got the solution
=IF(AND(A1="",B1=""),"",IF(AND(A1<>"",B1=""),"x",B1))

 

[lateef]

sample data


need to add x in B116 and B125

 

[Peter Bartholomew]

The formula that produces the "X" is actually in column B. The column is 1 pixel wide, so the text is displayed in the empty column C.



Note: the "@" is present because I use MS365. Older versions of Excel will reference columns A and C by implicit intersection.