if column A contains "7" then in column B one cell down should update with some text.
Can one suggest multirow formula
@Neelima1 A quick sample
Here is a sample workflow to tackle this new query:
If your issue is resolved, please kindly mark helpful responses as Solution, to help others find the answers they are looking for.
Happy Solving!!!
@Neelima1 thanks for the request 😁I think the several queries from you are similar, invovling Regexand multi-row formula, and should get you familaried with them now.
Hi,
Thank you for the quick response. Please help with another multi row formula, refer New query sheet in attached the file
@Neelima1
I like the solution from @CoG 😁
Thank you 😄 its working.
Hi @Qiu
Please help me to write a multi row formula. I need to update the employee code to below rows where the below rows are related to same employee.
In the attached file... Column A is Actual data, I need the alteryx output like data in Column B.
Thank you @Qiu 😄
Hi @CoG
I struck up in writing multi row formula to calculate night shift allowance. Please help with a multirow formula
Problem statement:
1. If shift ends after 22.00 PM then only night shift allowance is given to employee
2. if shift and vacation are on the same day, but vacation ends later than shift end time i.e shift end time is 22.08 but vacation end time is 22.09, then allowance is not given
3. if shift and vacation are on the same day, but vacation was taken multiple times on the same day, however both shift end time and vacation end time are same i.e shift end time is 22.08 and vacation end time is 22.08, then allowance is not given
4. if shift and vacation are on same day, but shift end is later than vacation i.e shift end time is 22.08 but vacation end time is 22.05, then allowance should be given for 3 minutes.
Please find attached the file for example
