Formula to enter the number of the last row with data

[esmarques]

Hello,
Would anybody know, if this is even possible, a formula to enter the number of the last row with data in the file attached, so I don't need to updated the formulas every time we add rows ?

Any help is welcomed.

Thank you

Number of distinct people.xlsx
	A	B	C	D	E	F	G
1	name	artist	staff		Distinct People	5	missing data from rolls 12 to 16
2	Mike	TRUE			Distinct Artists	2	missing data from rolls 12 to 16
3	John		TRUE		Distinct Staff	3	missing data from rolls 12 to 16
4	Amanda		TRUE
5	Mike	TRUE
6	Mike	TRUE
7	Holly	TRUE
8	John		TRUE
9	Mike	TRUE
10	Holly	TRUE
11	Dan		TRUE
12	Freya	TRUE		roll added
13	John		TRUE	roll added
14	Freya	TRUE		roll added
15	Holly	TRUE		roll added
16	Leon		TRUE	roll added
Sheet1

Cell Formulas
Range	Formula
F1	F1	=SUM(IF(ISTEXT(A2:A11),1/ COUNTIF(A2:A11,A2:A11),””))
F2	F2	=ROWS(UNIQUE(FILTER(A2:A11,B2:B11=TRUE)))
F3	F3	=ROWS(UNIQUE(FILTER(A2:A11,C2:C11=TRUE)))

 

[Fluff]

Easiest option is to use ranges that you are unlikely to exceed, like

Fluff.xlsm
	A	B	C	D	E	F
1	name	artist	staff		Distinct People	7
2	Mike	TRUE			Distinct Artists	3
3	John		TRUE		Distinct Staff	4
4	Amanda		TRUE
5	Mike	TRUE
6	Mike	TRUE
7	Holly	TRUE
8	John		TRUE
9	Mike	TRUE
10	Holly	TRUE
11	Dan		TRUE
12	Freya	TRUE		roll added
13	John		TRUE	roll added
14	Freya	TRUE		roll added
15	Holly	TRUE		roll added
16	Leon		TRUE	roll added
Sheet7

Cell Formulas
Range	Formula
F1	F1	=ROWS(UNIQUE(FILTER(A2:A10000,A2:A10000<>"")))
F2	F2	=ROWS(UNIQUE(FILTER(A2:A10000,B2:B10000=TRUE)))
F3	F3	=ROWS(UNIQUE(FILTER(A2:A10000,C2:C10000=TRUE)))

 

[esmarques]

Easiest option is to use ranges that you are unlikely to exceed, like

Fluff.xlsm
	A	B	C	D	E	F
1	name	artist	staff		Distinct People	7
2	Mike	TRUE			Distinct Artists	3
3	John		TRUE		Distinct Staff	4
4	Amanda		TRUE
5	Mike	TRUE
6	Mike	TRUE
7	Holly	TRUE
8	John		TRUE
9	Mike	TRUE
10	Holly	TRUE
11	Dan		TRUE
12	Freya	TRUE		roll added
13	John		TRUE	roll added
14	Freya	TRUE		roll added
15	Holly	TRUE		roll added
16	Leon		TRUE	roll added
Sheet7

Cell Formulas
Range	Formula
F1	F1	=ROWS(UNIQUE(FILTER(A2:A10000,A2:A10000<>"")))
F2	F2	=ROWS(UNIQUE(FILTER(A2:A10000,B2:B10000=TRUE)))
F3	F3	=ROWS(UNIQUE(FILTER(A2:A10000,C2:C10000=TRUE)))

Of course,.... sorry, and thank you very very much.

 

[Fluff]

Glad to help & thanks for the feedback.