Need formula to Calculate Column result

[Pankaj jaswani]

Hi, Hope you all are doing great and safe!

I have attached a stock coverage file in which I need to calculate the Column 'H' (SC Day-1). For this, I have applied two logic in Col J, K, and the combined result is matching with Col H but I am unable to combine this result through my formula. Need expert help for this. Excel Forum is the platform where we can solve our complex problems easily. Please help me with this.

[SAI80]

Sorry, don't really understand what you want..

[Pankaj jaswani]

@Saj80 Hi, This is an exported file and I need to calculate Col H value with the help of Col J, K. But the problem is that some results are matching with Col J and the rest unmatched results are matching with Col K. Now I have to combine this matched result in a single column through the single formula. But unable to find the unmatched condition so that I can set the False value as Col K.

[AliGW]

You need to manually add another column with at least 10-15 rows of manually calculated results to show what you want.

I can see no logic at all in what you have shared with us so far.

[Pankaj jaswani]

Hello Ma'am. I have attached new file with added some columns to get the logic behind the expected result. But there is only one problem we can't use Col H as helper to match the expected result as I want to calculate Col H. But once if we find the reason of false value of Col J then we can apply the K column by default replace of false values.

[AliGW]

Sorry - I have no idea what you are trying to do, much less what might or might not be a false value in column J. I hope someone gets it. Good luck!