Extract Value from Sheet

Hello Team ,

We have a spreadsheet in the format attached

1)Contains column for months in Repeated manner

Example : how can we find CountryCode IN
What is its Sales Value For Current Quarter

(present in September Column)

So the output that we get should be 8000

Have attached file as well as Screenshot for reference
Test Value.xlsx (5.6 KB)

Thanks in advance

Hi,

Can you try the following sample?

This modifies the datatable as “result.xlsx” then extract necessary data.

Sample20230810-7L.zip (8.6 KB)

Regards,

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.