Cell to populate if other column has any text [Closed]

Question

Cell to populate if other column has any text [Closed]

Report

therock90 - Updated by therock90 on 16/03/17 at 10:14 AM
Mazzaropi

Posts: 1921
Registration date: Monday August 16, 2010
Status: Contributor
Last seen: May 13, 2021

- Mar 16, 2017 at 10:57 AM

Hello,

I'm struggling to find a formula to populate one column's cell based on another column's cell having at least one character of text.

e.g. A1 would insert a "Y" if B1 has text

Any help would be most appreciated!

Cell to populate if other column has any text
Excel - Comparing cell A1 to entire A column in Sheet 2 - How-To - Excel
Change cell color based on another column ✓ - Forum - Excel
Populate data from a column in one worksheet to a cell in multiple other sheets ✓ - Forum - Excel
Merge adjacent cells in columns with same data/value in excel vba - Forum - Excel
Excel VBA – In a column, change only cells that - How-To - Excel

1 reply

Ask a question

Mazzaropi · Answer 1 · 2017-03-16T10:57:19-0400

Answer 1 / 1

Mazzaropi

Posts: 1921
Registration date: Monday August 16, 2010
Status: Contributor
Last seen: May 13, 2021

143
Mar 16, 2017 at 10:57 AM

therock90, Good morning.

Try to use:

=IF(ISTEXT(B1), "Y", "")

Is that what you want?
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão

Cell to populate if other column has any text [Closed]

1 reply

Your reply

Subscribe To Our Newsletter!