How to Select Different Cell Values from an Excel sheet

Help Activities
,
1

Hi I wanted to select the highlighted sheet first then select the highlighted cell values based on the components, The excel headers are merged that’s why i am ubable.

image
image914×572 44 KB

2

@connect360

Welcome to the community

For any merged cell the value when reading will be present in the first cell of the meeged cells…

Eg: Components value will be in C5

Using this try to identify and read the values

Cheers

3

Hi The values location might be change in future so i want the values for the highlighted components. Is there any other way to get the values of components.

4

@connect360

Use a lookup activity and look up for the names in the left part and get the corresponding values

cheers

5

The values will be change after every week, we want to select the data on current week base that if the value between current week then get the current week selected values/

6

@connect360

  1. Use find/Replace first on the date to get the required column for the current week…this will give you the column name or index you need
  2. Use lookup value to look for the values on left and the column index can be passed from the output of step 1

cheers

7

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