Hello Excel Team
Need to capture the highest and lowest value either through a conditional formula or through VBA,The sample doc is attached for reference
The H column is open interest will be dynamic and the value keeps changing as the sheet is updated live for Ex currently the H2 value is 79000 if the value increases to 82000 in H2 col the value in column I2 increases to 82000 capturing the highest value and from there if the value drops to 74000 in H2 column the lowest value has to capture in J2,Now the J2 value will change to 74000 which is the lowest
Let me know if i am clear or needs further clarification
Narendra Kumar
Need to capture the highest and lowest value either through a conditional formula or through VBA,The sample doc is attached for reference
The H column is open interest will be dynamic and the value keeps changing as the sheet is updated live for Ex currently the H2 value is 79000 if the value increases to 82000 in H2 col the value in column I2 increases to 82000 capturing the highest value and from there if the value drops to 74000 in H2 column the lowest value has to capture in J2,Now the J2 value will change to 74000 which is the lowest
Let me know if i am clear or needs further clarification
Narendra Kumar