Find last column with value?

LORDMARKS

New Member
Joined
Jun 5, 2014
Messages
39
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
 

Excel Facts

Waterfall charts in Excel?
Office 365 customers have access to Waterfall charts since late 2016. They were added to Excel 2019.

Forum statistics

Threads
1,213,526
Messages
6,114,136
Members
448,551
Latest member
Sienna de Souza

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top