How to find the last non blank cell data

[Areif]

Hi Expert !!

I Have a data having details in row wise of particular service history looking for non blank cell data , i have attached file for reference .. please help me

 

[Deepak]

Array, So Pls press with Ctrl+Shift+Enter

AV3==INDIRECT(ADDRESS(ROW(),LARGE(IF(($B$2:$AQ$2="Actual Serv Done KM")*(LEN($B$3:$AQ$3)>0),COLUMN($B$2:$AQ$2),""),COLUMNS($AV:AV))))

 

[Areif]

Thanks deepak for your quick reply
but the formula its work only to fetch last data for second and third result its not working

 

[Deepak]

Hi,

You might did something wrong there!!

This is quite better than previous approach...

CSE

=INDEX($A:$AQ,ROW(),LARGE(IF(($B$2:$AQ$2="Actual Serv Done KM")*(LEN($B$3:$AQ$3)>0),COLUMN($B$2:$AQ$2),""),COLUMNS($AV:AX)))

Check attached xl.

Let me know if the data range is dynamic so that i will arrange needful in reagrd to that like as named range.

 

[Areif]

Know its working , thanks once again and about dynamic range
Yes i would apply it to the almost 10,000 rows

appreciate your work

 

[Deepak]

Know its working , thanks once again and about dynamic range
Yes i would apply it to the almost 10,000 rows

appreciate your work

Thnx.

I mean columns are dynamic or it will same what is has now ?

 

[Areif]

Column range increase upto "IT" , for eg: purpose we take as "AT"