Welcome & Introductions

Get to know the people behind the avatar! Introduce yourself, welcome peers, build connections & extend your network.

Take a moment to introduce yourself to the Community. We'd love to get to know you!

Learn More

need help :How find a specific string in the all the column of excel and return that clmn

sahasanb
7 - Meteor

PFB the attached excel.

I want to return F4 as its contain Units. If "units" in Column F2 then Column F2 will return.

That means "Units" position is not specific.



1 REPLY 1
IraWatt
16 - Nebula

Hey @sahasanb,

Here is one way to do this:

IraWatt_0-1658133575273.png

The transpose lets you search all the columns at once for the word "Units" Then once found I convert it all back using the cross tab tool. 

 

Any questions or issues please ask :)
HTH!
Ira

 

Labels