Excel column with 'if' condition

[venkatmalla6 (venkat malla)]

@new_user New folder.zip (7.6 KB) have a look at this buddy i just created a sample workflow which is related to your query.let me know if any thing goes wrong.

[vishnuvarthanp (vishnuvarthan)]

hi

since u r reading it from row 15, i have initiated it to 15,. can u change the counter to 14 and then try .plz

[new_user]

ERROR:

[venkatmalla6 (venkat malla)]

@new_user i just used cost as for reference plz check the column of your excel sheet how the column name and give the column name is and also check whether any spaces are there.

[new_user]

I have the same column “Cost” replaced it with capital “C”. it is still throwing the same error

[venkatmalla6 (venkat malla)]

@new_user have you checked whether any spaces are there in the column name before and after.

[new_user]

YES! There aren’t any

[venkatmalla6 (venkat malla)]

@new_user how come it possible it worked for me.if possible can you share your spread sheet or any duplicate values with the same columns in the spread sheet.

[new_user]

yes suredummy data.xlsx (11.8 KB)

[venkatmalla6 (venkat malla)]

@new_user DUMMY DATA.zip (11.2 KB) have a look buddy its is working now.

[new_user]

working now
did you change the range ?
or anything else?

[venkatmalla6 (venkat malla)]

@new_user yes i changed the range value and also sheet name.nothing more than that.if it resolves your query mark it as solution it could be helpful to others.

[new_user]

AWESOME! already marked Thank you so much !!! @venkatmalla6 can i get the horizontal value for say chemical management?

like the values beginning from 3.57,3.48 and so on…