Siddhu11011
Board Regular
- Joined
- Jun 22, 2022
- Messages
- 56
- Office Version
- 365
- Platform
- Windows
Hello There...
Need a VBA code to get the result. Please check the below conditions:
1. Column C = Blank & column D > 100,00
2. Column D = Blank & column C > 50,000
3. Column F < -95 & Sort column D in descending order ( Largest to smallest)
Now select first 25 records
4. Column G > 1,000,000 & column H >= 4
5. Column H should be greater than 1,000 but lesser than 10,000 & column G > 100,000
My spread sheet contains only numeric value. I just need to put "Yes" in column M based on above conditions in sequence wise.
Ex. Take 1st condition.... Based on that I just want "Yes" value in column M. Now remove filter and pick 2nd condition. Base on available result, just put "Yes" in column M. Likewise, use all above 5 conditions and at the end just apply filter on column M and show me "Yes" output only.
Let me know if you need further explanation and thank you for reading my query.
Need a VBA code to get the result. Please check the below conditions:
1. Column C = Blank & column D > 100,00
2. Column D = Blank & column C > 50,000
3. Column F < -95 & Sort column D in descending order ( Largest to smallest)
Now select first 25 records
4. Column G > 1,000,000 & column H >= 4
5. Column H should be greater than 1,000 but lesser than 10,000 & column G > 100,000
My spread sheet contains only numeric value. I just need to put "Yes" in column M based on above conditions in sequence wise.
Ex. Take 1st condition.... Based on that I just want "Yes" value in column M. Now remove filter and pick 2nd condition. Base on available result, just put "Yes" in column M. Likewise, use all above 5 conditions and at the end just apply filter on column M and show me "Yes" output only.
Let me know if you need further explanation and thank you for reading my query.
