Excel issue on values

Help StudioX
,
1

Hi,
On StudioX, seeing this issue.
I extract data from RPA Market (rpachallenge.com)
Extract this table image

Used Write Range to write the table in Excel.
I’m trying to find max on the Futures column using Write Cell like this.
image

It shows error.

2

When you write a formula into a cell , you need to use the same text as in Excel: MAX(C:C)

image
image763×446 18.5 KB

image

3

@flavius my excel has other sheets. I need select one sheet. so specify sheet name

4

@Prinal_C - you have to specify the sheet name in the ‘where to write’… that is where you to point out where to put your output…

5

@prasath17 about ‘What to Write’ only. I take value from one sheet only. Ihavy 12 sheets.

6

@Prinal_C - I didn’t get you…

in the what to write …mention =Max(c:c) and where to write point out the sheet where you want to get the Max.

Is this what you are looking for right??

If not, provide your requirement and output you are looking for? if possible share the sample sheet too.

7

@prasath17 … I have 12 sheets. One ‘Overvew’ sheet. In the ‘Overview’ sheet, I want the max of column C from ‘Sheet1’. That’s why there’s ‘Sheet 1’ in the formula in ‘What to Write’. But ‘Sheet1’ in the formula is not working.

9

@Prinal_C - got it…Let me try something this afternoon and will share the results…

10

@Prinal_C - Please check this…

image
image614×620 20.5 KB

My Output

image
image659×763 16.8 KB

11

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