Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Need to pick specific value from from 4 cells in excel sheet

Meghnagupta
8 - Asteroid

Hello, I have a huge excel data from which i have a very small part in attached sheet

I have to pick yellow highlighted value from the excel and paste it to another sheet. 

If anyone can help me with some formula that can be used to fetch only these highlighted value in excel. This one is little urgent 

 

3 REPLIES 3
binuacs
20 - Arcturus

@Meghnagupta One way of doing this

image.png

Meghnagupta
8 - Asteroid

Thanks mate, but could please elaborate this one.. since you are using latest version of the tool and i am unable to see workflow in my alteryx desktop.

binuacs
20 - Arcturus

@Meghnagupta attaching the workflow

 

also, you can follow the below steps to degrade the workflow

 

https://community.alteryx.com/t5/Engine-Works/Making-Workflows-Apps-amp-Macros-Backwards-Compatible/...

Labels