Finding entries across columns

  • Thread starter Thread starter bollard
  • Start date Start date
B

bollard

Hello

I have a spreadsheet which has names in Column B.

In the next 6 or 7 columns, from Column C onwards, there are psoradic
entries. There may be an entry in Column C or D or E etc. There may also be
more than one entry.

I just want some way of returning only the first entry that occurs to the
right of the Name in Column B.

Can anyone help, plase?

Thank you.

Keith
 
If looking for the next text. copy down
=INDEX(C1:H1,1,MATCH("zzzz",C1:H1))
or a number larger than possible
=INDEX(C1:H1,1,MATCH(999999,C1:H1))
 
One way, assuming names in B2 down
Put in A2, array-enter the formula by pressing CTRL+SHIFT+ENTER:
=IF(COUNTA(C2:IV2)=0,"",INDEX(C2:IV2,MATCH(TRUE,C2:IV2<>"",0)))
Copy A2 down as far as required
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Multiple List Analysis 0
Can I find the last value in a column of cells? 4
Count entries in the column translating to minutes. 5
counting entries 4
How do I count instances of a reference? 1
SUM - IF - AND 7
Force entry in one cell due to the value in the other 4
comparing columns in two spreadsheets 1

Back
Top