How do I extract lateat entry in a series of data

**Kjems** · 01-14-2020, 07:29 AM

Hi

I need to insert the "latest" entry of a column (the one furtest down in the a Column) in a formula. Is there anyway to do that?

As in =("highest cellnumber in B that has an entry")/((E7-A2)/100)

Thanks in advance

**shank_mis** · 01-14-2020, 07:39 AM

Care to elaborate a bit more mate ?

**Ron Coderre** · 01-14-2020, 07:41 AM

This regular formula uses the last numeric entry in Col_B

=LOOKUP(99^99,B:B)/((E7-A2)/100)

Is that something you can work with?

How do I extract lateat entry in a series of data

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

How do I extract lateat entry in a series of data

Re: How do I extract lateat entry in a series of data

Re: How do I extract lateat entry in a series of data

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Formula for data validation for entry series number only

Formula for data validation for entry series number only

Bypass "File has Macros" warning when opening a series of excel files to extract data?

Limit data entry in a series of cells if one cell has data entered.

[SOLVED] Data validation list tool in chart range treats each entry as a separate series.

VBA code to extract info from a series of URLs within a series of web pages

return previous entry if INDEX returns a blank entry (in a broken series of columns)

Bookmarks

Bookmarks

Posting Permissions