0 votes

I have tried to find the location of the max value written between B4 and F11 using:

` =MATCH(MAX(B4:F11),B4:F11,0) `

Returns n/a. Can someone please help me with this?

Jan 7, 2023 in Others 266 views

## 1 answer to this question.

0 votes

For the cell address:

`=LET(ζ,B4:F11,BASE(MIN(IF(ζ=MAX(ζ),DECIMAL(ADDRESS(ROW(ζ),COLUMN(ζ),4),36))),36))`
answered Jan 7, 2023 by
• 63,700 points

0 votes
1 answer

## How can I find and replace text in Word using Excel VBA?

Try this code Option Explicit Const wdReplaceAll = 2 Sub ...READ MORE

0 votes
1 answer

## Excel - How can I get the average of cells where the value in one column is X and the value in another column is Y?

Use AVERAGEIFS ... =AVERAGEIFS(C2:C13,A2:A13,"Yellow Typ ...READ MORE

0 votes
1 answer

## How to find a value in an excel column by vba code Cells.Find

Just use: Dim Cell As Range Columns("B:B").Select Set cell = ...READ MORE

0 votes
1 answer

## How to insert a new row in the specified cell only, of Excel sheet using c#?

I have this worksheet with a matrix ...READ MORE

0 votes
1 answer

## Calculate Birthdate from an age using y,m,d in Excel

Hello, yes u can find your birthdate using ...READ MORE

0 votes
1 answer

## Calculate Birthdate from an age using y,m,d in Excel

Hi To Calculate the date, we can ...READ MORE

0 votes
0 answers

## Convert Rows to Columns with values in Excel using custom format

1 I having a Excel sheet with 1 ...READ MORE

0 votes
1 answer

## IF - ELSE IF - ELSE Structure in Excel

In this case, you can use nested ...READ MORE

0 votes
1 answer

## How can I use a command button in excel to set the value of multiple cells in one click?

Try this: Private Scan As Integer Private Sub CommandButton1_Click() ...READ MORE

0 votes
1 answer

## How can I store the data of an open excel workbook in a collection using BluePrism?

To do what you want is like ...READ MORE