last number in row

[Mamdouh Elfors]

i want last number in row

thanks

 

[bobhc]

I want 20 year old single malt whisky, I want a new range rover, I want a new four bed three bath house, I want to win the lottery I want.........

You have said nothing about your problem or what you are trying to achieve. The members are bloody good at helping but they do tend to need a bit more information than you are giving.

The last number in the row is 27, or it might be 3, could even be 10 or..........

 

[Mamdouh Elfors]

Brother
You have a sample file. I want an equation given the last number in each row

 

[NARAYANK991]

Hi ,

The last number in each row can be found out by this formula :

=LOOKUP(9999999999 , $D3:$J3)

entered in say A3 , where the first number 9999999999 is a number bigger than the biggest number in your data range.

Copying this down will return the last number in the other rows.

Narayan

 

[Mamdouh Elfors]

thanks Narayan

 

[Hui]

Mamdouh

As you have been a member for just under 4 years you should be aware of how this forum works

Simply give us as much information as is possible to describe the problem and the more targeted, specific and quicker the response will be

Please take a moment to read: https://chandoo.org/forum/link-forums/new-users-please-read.17/