Hi all
I am looking fo a way to find the last entry accross in a large data set, excluding heading etc.
data is all numbers within the range AU100:YT10000. I already have a countA to validate a columns with data, returning (1 or 0), but I would like to have a row above that looks at the validation to return 1 if the value below is the last one and a one to the left as well as i am looking for the last two results even if one is 0.
I like to use use this format, as i use alot of VBA filters and SUMIFs which work well together. I was looking at something like the example below, but failing.
=IF(SUM(BR2:CK2)=1,0,IF(SUM(BR2:CK2)=2,1,0))
any help would be great.
thanks
I am looking fo a way to find the last entry accross in a large data set, excluding heading etc.
data is all numbers within the range AU100:YT10000. I already have a countA to validate a columns with data, returning (1 or 0), but I would like to have a row above that looks at the validation to return 1 if the value below is the last one and a one to the left as well as i am looking for the last two results even if one is 0.
I like to use use this format, as i use alot of VBA filters and SUMIFs which work well together. I was looking at something like the example below, but failing.
=IF(SUM(BR2:CK2)=1,0,IF(SUM(BR2:CK2)=2,1,0))
any help would be great.
thanks
