Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
community Alteryx IO MyAlteryx
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close
Start Free Trial

Alteryx Designer Desktop Discussions

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

Help Required to Build Excel Formula in Alteryx

Mzaheer24
7 - Meteor
‎04-30-2025 07:08 AM

Hello,

 

Could you please help me build MS excel formula in Alteryx. attached is a example 

Preview file
11 KB
Labels:
Reply
0 Likes
1 REPLY 1
davidskaife
14 - Magnetar
‎04-30-2025 07:26 AM

Hi @Mzaheer24 

 

Here you go, using a Multi-row tool to generate 'Item 2', and a Formula tool to generate 'Item 1' and 'Item 3'

 

Screenshot 2025-04-30 152437.png

 

Pay attention to the configuration for the Multi-row tool, as the standard config has row 13 being null so you need to change the behaviour for rows that don't exist to 'set to values of closest valid row'

Formula.yxmd
Reply
0 Likes
GenAI Contest Form
License admin COmmunity Live
Labels
Top Solution Authors
View All