Forum Discussion
sherikhan88
Nov 18, 2021Copper Contributor
Formula/VBA Help
Please assist me in below situation In A column, I have a Quantity which are required to fill "X" store, but this should be fetch from other Stores lets say 1,2,3,4,5,6 Condition is if my store...
- Nov 23, 2021
sherikhan88 Quite some logic but I think I got it. See attached. It's an ugly formula and probably can be optimized.
Riny_van_Eekelen
Nov 23, 2021Platinum Contributor
sherikhan88 Quite some logic but I think I got it. See attached. It's an ugly formula and probably can be optimized.
sherikhan88
Nov 23, 2021Copper Contributor
Riny_van_Eekelen You're Awesome!!! Not only you understand and solved my issue. But gave your valuable time to me.
I kept thinking about the solution for entire day, when i posted it but unable to put the logic into formulas.
You will be remembered by rest of my generation ! Thank you for all you help.
- Riny_van_EekelenNov 23, 2021Platinum Contributor
sherikhan88 Glad it worked!!
- sherikhan88Nov 23, 2021Copper ContributorI didnt even know, if we can use Max function like this 😞
Genius