Ignore Blank cells and jump to next non blank cell

Which version of Excel are you using?

Administrative Note:

Although we value your privacy as much you do, it could be important that members have a rough idea of your location as the solutions they offer may be affected by your locale. For instance, you might in the future post questions which are related to your regional settings.

With this in mind, please update your profile to something more precise (something such as UK, Europe, USA, UAE, etc. will suffice).

Thank you for helping us to help you.

Please update your user profile with your current version and your generic location, as requested in post #2. Thanks.

Please help friendss

B2:

Please Login or Register  to view this content.

**Array formulas are not entered in the same way as 'standard' formulas. Instead of pressing just ENTER, you first hold down CTRL and SHIFT, and only then press ENTER. If you've done it correctly, you'll notice Excel puts curly brackets {} around the formula (though do not attempt to manually insert these yourself).

What is the new range?

My formula is working with
"Sheet1!$B$3:$P$6": value data
"Sheet1!$A$3:$A$6": Employee name
"Sheet1!$B$1:$P$1": Header

Adapt to new range.

My note in #8 (at the bottom) for array formula (Ctrl-shift-enter), try to follow.

BTW, you need an IFERROR to avoid #NUM if not found

Please Login or Register  to view this content.

Array formula, confirmed with Ctrl-shift-enter combination.