Formula returning the only non blank text result

Geraldina

New Member
Joined
Feb 14, 2018
Messages
3
Hello,

How to I write the formula in order to return the only non blank data per line:
For example, F2 result => check all cells (A2:E2) and return text "7-2018"
Thank you
ABCDEF
1SB w1SB w2SB w3SB w4SB w5SN month start
27-20187-2018
34-20184-2018
46-20186-2018
58-20188-2018
62-20182-2018

<tbody>
</tbody>
 

Excel Facts

Add Bullets to Range
Select range. Press Ctrl+1. On Number tab, choose Custom. Type Alt+7 then space then @ sign (using 7 on numeric keypad)

steve the fish

Well-known Member
Joined
Oct 20, 2009
Messages
8,644
Office Version
  1. 365
Platform
  1. Windows
As you say its the only non blank you could use this:

=LOOKUP(2,1/(A2:E2<>""),A2:E2)
 

njimack

Well-known Member
Joined
Jun 17, 2005
Messages
7,764
If they've been entered as dates, you can use:
=MAX(A2:E2)

If they're text values, try:
=INDEX(A2:E2,MATCH(REPT("z",255),A2:E2))
 

Forum statistics

Threads
1,148,293
Messages
5,745,912
Members
423,983
Latest member
blackworx

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
Top