Lookup then sum

If your data starts on row 2 (with headers in row 1), put this in B2:

=IF(A2="individual",MAX(B$1:B1,"")

and in C2:

=IF(A2="company",MAX(C$1:C1,"")

Copy down as required.

Hope this helps.

Pete

While neither formula is wrong I think I've explained it badly, at least they're not quite showing the results I want.

A1=individual = 1
A2=individual = 2 {B1+1}
A3=company = 1
A4=individual = 3 {B2+1}
A5=company = 2 {C3+1}
A6=company = 3 {C5+1}

a	b	c
individual	1
individual	2
company		1
individual	3
company		2
company		3

I think I've just said the same thing twice so am not helping myself really.
You can pretty much ignore this next bit. Just trying to word it out, might spark an idea in my head as much as anyone elses.
IF A1 says "individual" then type number {next in sequence} else leave blank

After more trying am currently settled on a countif as I'll likely hide rows B&C in the examples given, the data is being used elsewhere via a concatenate.

Originally Posted by Bo_Ry

What's wrong with this?

Attachment 609550

It's working today?! Defo me being a complete idiot yesterday then. Cheers to everyone especially RO_Ry.
I'll try to be less dimwitted in future

Problem solved.