Column formula - for increasing same value in array

Paul Westerink

Hi, I would like to see if it is possible to change the below FirstInstance formula into a column formula as I am using Data Shuttle to import new/revised data into the grid.

FirstInstance Formula: =COUNTIF([Request Id]$1:[Request Id]1, [Request Id]1 = [Request Id]@row) + 0

DaystoClose2 col Formula: =IF(FirstInstance@row = 1, [Status Date]@row - [Request Date]@row)

Mark Cronk

Hi,

Try adding an autonumbering column. Use it to determine the newest entry using the formula:

=IF([Auto Num]@row=MIN(COLLECT([Auto Num]:[auto num], [request ID]:[request ID], [request ID]@row)), 1, 0)

The 1st instance will have the lowest autonumber and will return a 1 in the first instance column.

Work?

Mark

Mark Cronk

Hi,

Try adding an autonumbering column. Use it to determine the newest entry using the formula:

=IF([Auto Num]@row=MIN(COLLECT([Auto Num]:[auto num], [request ID]:[request ID], [request ID]@row)), 1, 0)

The 1st instance will have the lowest autonumber and will return a 1 in the first instance column.

Work?

Mark

Paul Westerink

Mark,

Thank you! That worked perfectly.

Paul

Mark Cronk

Excellent. Glad you found a solution. Thank you for contributing to the Community.

Mark