# Excel formula Edit

I have the below code with groups the previous column by a number.

``````=IF(COUNTIF(\$D\$1:\$D2,\$D2)=1,MAX(\$E\$1:E1)+1,INDEX(\$E\$1:E1,MATCH(\$D2,\$D\$1:\$D1,0),1))
``````

Currently is starts to with "1". How do I change it to another number?
###### Who is Participating?

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Commented:
Hi,

without data I suppose by changing the bold ones

IF(COUNTIF(\$D\$1:\$D2,\$D2)=1,MAX(\$E\$1:E1)+1,INDEX(\$E\$1:E1,MATCH(\$D2,\$D\$1:\$D1,0),1))

and maybe the +1 after MAX

Regards
Author Commented:
Thanks, but that gives me a #N/A error. Do you need to see the data?
Commented:
Yes could you send a dummy no real data
Author Commented:
Dummy data attached.
Author Commented:
Dummy data attached.
Dummy-Data.xls
Commented:
then try change the bold one to change first number

=IF(COUNTIF(\$D\$1:\$D2,\$D2)=1,MAX(3-1,MAX(\$E\$1:E1))+1,INDEX(\$E\$1:E1,MATCH(\$D2,\$D\$1:\$D1,0),1))

Experts Exchange Solution brought to you by