jarrodexcel
New Member
- Joined
- Dec 14, 2022
- Messages
- 23
- Office Version
- 365
- Platform
- Windows
Good Afternoon All, I have an automatic system that downloads data to excel online, as you can see below in the table this is how the downloaded data comes.
I am trying to either make a formula or something that can sort the "null" changed column to only include data with No selected as an option, the thing is the stock changed data is linked. So On team A where they have clicked No,Yes. Stock 1234-Football has not been changed hence the No. and 1566-Tennis Ball was changed. hence the YES.
What i am after is finding a way to automatically delete the stock that is connected with any YES changed data.
The data is in order so the first response in null changed matches the first data from stock and so on.
Any help or ideas would be grand !
Thank you
J
I am trying to either make a formula or something that can sort the "null" changed column to only include data with No selected as an option, the thing is the stock changed data is linked. So On team A where they have clicked No,Yes. Stock 1234-Football has not been changed hence the No. and 1566-Tennis Ball was changed. hence the YES.
What i am after is finding a way to automatically delete the stock that is connected with any YES changed data.
The data is in order so the first response in null changed matches the first data from stock and so on.
Any help or ideas would be grand !
Thank you
J
Team | Time | "Null" Changed | Stock | Coach | Comments |
A | 10:00 | No, Yes | 1234-Football, 1566-Tennis ball | Tom | Good |
B | 12:00 | No, Yes, No, No | 1234-Football, 1677-basketball, 1500-Golf Ball, 2000-hockey | Mike | Good |