Solved How do i write a formula to skip to the first filled in cell

Microsoft ★ microsoft office 365 home...
August 22, 2019 at 04:58:33
Specs: Windows 10
Basically I have a set of data for multiple clients separated by months. I need to make a formula that uses the data from the first month of each particular client.

So in the below example (sorry for the dodgy looking table), it would use the data from january for bob, march for tim and february for dave. The problem is we have far too many clients to do this individually, and each clients' data is on a different worksheet, so i'm hoping there is a formula that can do this for me.

____Jan__Feb__Mar__Apr
Bob__1___ 3__ 3___2
Tim__ - ___- __4___ 8
Dave_ -___2___7__ 9

Any help or input would be appreciated!

Thanks

message edited by MattAH321


See More: How do i write a formula to skip to the first filled in cell

Reply ↓  Report •

#1
August 22, 2019 at 08:00:37
re: "sorry for the dodgy looking table"

First, a posting tip:

Please click on the How-To link at the end of this post and read the instructions on how to format example data so that it is easier for us to read. Then edit/repost your data so that the columns line up correctly. Don't forget to use Column letters and Row numbers as shown in the example.

How To Post Data or Code ---> Click Here Before Posting Data or VBA Code


Reply ↓  Report •

#2
August 22, 2019 at 08:07:55
✔ Best Answer
If you can eliminate the dashes and leave the "non-data" cells blank, this should work:

=INDEX(B2:E2,MATCH(TRUE,INDEX(B2:E2<>0,),0))

If you need the dashes, try this:

=INDEX(B2:E2,MATCH(TRUE,INDEX(B2:E2<>"-",),0))

Drag it down...

How To Post Data or Code ---> Click Here Before Posting Data or VBA Code

message edited by DerbyDad03


Reply ↓  Report •
Related Solutions


Ask Question